Database Design &Implementation

Table of Contents

Database Design &Implementation

Relational Databases

Composite pkeys in RDB’s

Composite Pkeys (Example)

Surrogate Keys in RDB’s

RDB with Surrogate pkeys:

Surrogate Keys in COOL/GEN

Persistent Object Identifiers

Persistent Databases

Referential Integrity

N-ary Relation (ERD Styles)

Extended ER Diagrams

Multiple Inheritance on EERD’s

ORDB via Prototype Delegation

GEN Database: Persistence

GEN Database: Schema Constraints

GEN Database: External Format

GEN Database: Internal Format

GEN Database: Import/Export

Importing RDB’s to C++/Java

Object-Relational Databases - Prototypes and Delegation

Divergent Hierarchies

OLC’s with Concurent Sub-states

Merging OLC Behaviors of Concurrent Subclases:

Divergent Hierarchies - revisited (1)

Divergent Hierarchies - revisited (2)

Composition or Implementation Inheritance

References

Email: lechner@cs.uml.edu

Home Page: http://www.cs.uml.edu/~lechner

Best experienced with

Click here to start.

Download presentation source