Database Systems

1
Database Systems

• Dr. Don Goelman

2
Some History

• Early Systems
• 1960s ad-hoc programs give way to DBMSs (IDS
  C.W. Bachman)
• 1970s two big developments
• Systematization of the network model
  (CODASYL/DBTG)
• Introduction of relational model (E.F. Codd,
  CACM)

3
Three classical Record BasedModels

• Hierarchical
• IMS
• S2K
• Network
• IDS
• IDMS
• Total
• Adabas
• DMS2

• Relational
• System R
• Ingres
• QBE
• Oracle
• Access
• Sybase
• Foxpro
• DB2
• Informix

4
Two Modern Models

• Object
• ObjectStore
• Objectivity
• O2
• Versant

• Object-Relational
• UniSQL
• Oracle8
• Informix Univ. Server
• Illustra
• PostGRES

5
Current Areas of Exploration

• ODBs and Object/Relational DBs
• Distributed Databases
• Client Server Architecure
• GUIs
• Data Warehouses
• Data Mining
• DB over the Web

6
Literature

• ACM TODS
• ACM SIGMOD Record
• IEEE Transactions on Knowledge and Data
  Engineering
• Intelligent Enterprise

7
DB Systems A Brief Time Line Pre 1960s
8
The 1960s
9
1960s continued
10
The 1970s
11
1970s continued
12
More 1970s