Basic Computer Notions 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) 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 35 of 46 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

Examples of class hierarchies

Person IDNum
Physician IDNum, Name
Patient IDNum
Mother IDNum, DateBirth, Height
Baby IDNum, WeightB
Event DateEvent, Physician, Patient
Ultrasound DateEvent, Physician, Patient, CRL, BPD, GestUS
Delivery DateEvent, Physician, Mother, Baby, WeightM
Numeric_value (range)
Height (range,arith_ops)
Weight (range,arith_ops)
WeightM (range, arith_ops)
WeightB (range, arith_ops)
Date (range date_ops)
DateBirth (range, date_ops)
DateEvent (range, date_ops)
ID_num (range)
String_value (char_coding, sort_ops)
Name (char_coding, sort_ops, name_ops)


Start Next
Bacon home page
R. Funnell
Last modified: Wed, 2007 Mar 21 17:29:21

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