Object-Relational .Database Development
Overview
Design Objectives
Development Road-map
Outline of Procedure: 3 Tier Model
Conceptual Modeling
Example of High-Level EER
Reading E-ER Diagrams
Modeling Entities
Using E-ER Modeling
The ‘Object’ Concept
Cataloging the Kinds of Data
UML Class Diagrams for each Kind of Data
Minimal Set of Object Classes
Workload and Common Queries
Implementation Options
Implementation Tip # 1
Creating the Tables
A Note on Keys
Example Schema (1/3)
Example Schema (2/3)
Example Schema (3/3)
Implementation Tip # 2
Performance & Flexibility Example
‘Organic’ Applications
Summary and Conclusions
Email: paul.brown@informix.com