Databases

Next

Collections of data

Reasons for a DBMS

Reasons for a DBMS (cont'd)

Database organization

Flat databases

Hierarchical databases

Hierarchical example

Hierarchical example (cont'd)

Hierarchical example (cont'd)

Hierarchical example (cont'd)

Hierarchical example (cont'd)

Hierarchical example (cont'd)

Hierarchical example (cont'd)

14 of 46

Hierarchical example (cont'd)

Hierarchical example (cont'd)

Hierarchical example (cont'd)

Hierarchical example (cont'd)

Relational databases

Operations on tables

Relational examples

Relational examples (cont'd)

Relational examples (cont'd)

Relational examples (cont'd)

Relational examples (cont'd)

Relational examples (cont'd)

Relational examples (cont'd)

Relational implementation

Relational software

Object-oriented databases

Abstraction

Encapsulation

Modularity

Hierarchy

Examples of class hierarchies

Example of object hierarchy

Events

Object-oriented implementation

Centralized databases

Centralized databases (cont'd)

Electronic Medical Records

Electronic Medical Records (cont'd)

Current efforts

Current efforts (cont'd)

Oacis

DRG system

Hierarchical example (cont'd)

Sample hierarchical database

Question #2: How many babies with birth weights > 2.5 kg have been delivered by each physician?

To get at the weights in all the baby records, we have to first read each physician record ...

Start

Next

Bacon home page

Last modified: Wed, 2007 Mar 21 17:29:21

Slide show generated from dbms.html by Weasel 2007 Mar 21