Databases

Next

Collections of data

2 of 46

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)

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

Reasons for a DBMS

A DBMS is a software package for defining and managing a database.

A ‘real’ database includes

definitions of
- field names
- data formats (text? binary? integer? etc.)
- record structures (fixed-length? pointers? field order, etc.)
- file structures (sequential? indexed? etc.)
rules for validating and manipulating data
data

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