Copyright © 2001 Per Kraulis, Stockholm Bioinformatics Center, SBC

Intro to programming for persistence: database systems

This seminar takes a look at the different properties of mechanisms for data persistence. The goal is to give some hints on how to choose which mechanism to use for solving different problems.

• What is persistence?
• The main mechanisms for persistence
• Files
  • Serializing objects
  • Serialization example
  • XML
  • XML example
• DBM databases
  • DBM example
• Relational Database Management Systems, RDBMS
  • Table examples
  • SQL examples
    • INSERT
    • SELECT
    • UPDATE
    • DELETE
    • join
  • Normalization
  • Data integrity
  • RDBMS architecture
  • RDBMS systems
• Object-oriented Database Management Systems