Databases

Next

Collections of data

Reasons for a DBMS

Reasons for a DBMS (cont'd)

Database organization

Flat databases

6 of 46

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)

Hierarchical example (cont'd)

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 databases

Hierarchical relationships among different types of data.

can be very easy to answer some questions, but very difficult to answer others
if one-to-many relationship is violated (e.g., a patient can have more than one physician) then the hierarchy becomes a network

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