Preface |
Motivation |
Purpose |
Readers |
Structure |
Downloads |
Acknowledgments |
About the Author |
Contents |
List of Abbreviations |
About Relationships and ORN / Part I: |
Introduction Including a Brief History of Relationships / Chapter I: |
Relationships / 1.1: |
A Brief History of Relationships / 1.2: |
The paper-based system / 1.2.1: |
The computerized file-based system / 1.2.2: |
Early data models and DBMSs / 1.2.3: |
The relational model and RDBMS / 1.2.4: |
The entity-relationship model and database / 1.2.5: |
Semantic models, the object model, and the ODBMS / 1.2.6: |
The object-relational DBMS / 1.2.7: |
Problems in Modeling and Implementing Relationships / 1.3: |
Preview of a Solution / 1.4: |
Object Relationship Notation (ORN) / Chapter 2: |
Syntax / 2.1: |
Graphical Representation / 2.2: |
Semantics / 2.3: |
Examples / 2.4: |
<*-to-*> / 2.4.1: |
<1-to-*>|- / 2.4.2: |
<0..1-to-*>|- / 2.4.3: |
<0..1-to*>|-X- / 2.4.4: |
<0..1-to-1..*>? / 2.4.5: |
!<0..1-to-*> / 2.4.6: |
'<*-to-1..*> / 2.4.7: |
Flashback to the Company Database / 2.5: |
ORN Simulator A Modeling Tool Where Associations Come Alive / Chapter 3: |
Creating a Database Model and a Database / 3.1: |
Verifying Association Semantics / 3.2: |
Architecture / 3.3: |
Benefits / 3.4: |
Association Patterns Emerging from a Variety of Association Types / Chapter 4: |
Context / 4.1: |
Pattern Descriptions / 4.2: |
"is defined by" pattern / 4.2.1: |
"is recorded for" pattern / 4.2.2: |
"is a realization of" pattern / 4.2.3: |
"is associated by" pattern / 4.2.4: |
"is an update of" pattern / 4.2.5: |
"is a part of" pattern / 4.2.6: |
"is a" pattern / 4.2.7: |
Patterns in Database Modeling and Implementation / 4.3: |
Associations That Don't Conform to a Pattern / 4.4: |
Conclusion / 4.5: |
Comparing ORN to Similar Declarative Schemes / Chapter 5: |
Schemes for Relational Databases and Object Relations / 5.1: |
Null constraint / 5.1.1: |
Key constraints / 5.1.2: |
Referential integrity rules / 5.1.3: |
Subjectivity constraints / 5.1.4: |
Additional relationship semantics / 5.1.5: |
Schemes for the ER model / 5.2: |
Schemes in ODBMSs / 5.3: |
Whole-Part Properties and Dimensions for Class Diagrams / 5.4: |
Proposed association dimensions for Class diagrams / 5.4.1: |
Primary characteristics for whole-part relationships / 5.4.2: |
Secondary characteristics for whole-part relationships / 5.4.3: |
Using ORN to Develop a Database System / 5.5: |
ORN Additive A Tool for Extending SQL Server with ORN / Chapter 6: |
Capabilities, Operations, and Architecture / 6.1: |
Capabilities / 6.1.1: |
Operations and architecture / 6.1.2: |
The +ornddl command / 6.1.3: |
The +orndml command / 6.1.4: |
ORN Additive DDL Statements / 6.2: |
USE statement / 6.2.1: |
Constraint statement / 6.2.2: |
Delete statement / 6.2.3: |
Set Orn_Message_Number_Base statement / 6.2.4: |
Example of a query file with ORN Additive DDL statements / 6.2.5: |
ORN Additive DML Statements / 6.3: |
Use statement / 6.3.1: |
Begin Transaction statement / 6.3.2: |
Save Transaction statement / 6.3.3: |
Commit Transaction statement / 6.3.4: |
Rollback Transaction statement / 6.3.5: |
Set Rxc_Mode statement / 6.3.6: |
Enable/Disable Orn_Triggers statement / 6.3.7: |
Example of query file with ORN Additive DML statements / 6.3.8: |
Object Relater Plus (OR+) An ORN-extended Object DBMS / 6.4: |
Capabilities and Compatibilities / 7.1: |
ODDL / 7.2: |
ODDL specification / 7.2.1: |
/ 7.2.2: |
Control commands / 7.2.3: |
ODML / 7.3: |
Architecture, Implementation, and Extensibility / 7.4: |
Implementation / 7.4.1: |
Extensibility / 7.4.3: |
Mapping Database Models to DDLs From ORN-Extended Class Diagrams to ORN-Extended DBMSs / 7.5: |
Mapping an ORN-Extended Model to an ORN-Extended SQL / 8.1: |
Transformating the model for a relational database / 8.1.1: |
Mapping classes to tables / 8.1.2: |
Mapping associations to foreign keys / 8.1.3: |
Mapping an ORN-Extended Model to an Object DDL / 8.2: |
Transforming the model for an object database / 8.2.1: |
Mapping classes to class definitions and extents / 8.2.2: |
Mapping associations to object-based attributes / 8.2.3: |
Association Semantics Dealing with the Subtleties, Inconsistencies, and Ambiguities / 8.3: |
Inconsistencies / 9.1: |
Within an / 9.1.1: |
Involving combinations / 9.1.2: |
Inconsistency Detection / 9.2: |
Ambiguities / 9.3: |
Associations as Functions / 9.4: |
Adding ORN to a DBMS / 9.5: |
A Conceptual Implementation of ORN Exploring Semantic Circularity and Ambiguity / Chapter 10: |
Algorithms / 10.1: |
Algorithm CreateObject / 10.1.1: |
Transaction operations / 10.1.2: |
Supporting pseudocode for complex object operations / 10.1.3: |
Algorithm CreateLink / 10.1.4: |
Algorithm DeleteObject / 10.1.5: |
Algorithm DestroyLink / 10.1.6: |
Algorithm ChangeLink / 10.1.7: |
Link Cycles / 10.2: |
Circularity / 10.2.1: |
The Theorem for ORN Semantic Clarity and its proof / 10.2.2: |
Adding ORN to the SQL Standard for RDBMSs / 10.3: |
Overview of SQL Association Capabilities / 11.1: |
Proposed ORN Extension to SQL / 11.3: |
Adding ORN to the ODMG Standard for ODMSs / 11.4: |
Adding ORN to ODL / 12.1: |
Associations in ODL / 12.2.1: |
Adding ORN syntax / 12.2.2: |
Adapting ORN semantics to ODL / 12.2.3: |
Class Transaction / 12.3: |
Method new() / 12.3.2: |
Method delete() / 12.3.3: |
Method _enforce_binding() / 12.3.4: |
Method form_tpR() / 12.3.5: |
Method drop_tpR() / 12.3.6: |
Method_enforce_explicit_binding() / 12.3.7: |
Method change_tpR() |
Example / 12.3.9: |
Bibliography / 12.4: |
Index |