Ehlmann Object Relationship Notation (ORN) for Database Applications

Enhancing the Modeling and Implementation of Associations
1. Auflage 2009
ISBN: 978-0-387-09554-7
Verlag: Springer
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, Band 39, 246 Seiten

Reihe: Advances in Database Systems

Conceptually, a database consists of objects and relationships. Object Relationship Notation (ORN) is a simple notation that more precisely defines relationships by combining UML multiplicities with uniquely defined referential actions. This book shows how ORN can be used in UML class diagrams and database definition languages (DDLs) to better model and implement relationships and thus more productively develop database applications. For the database developer, it presents many examples of relationships modeled using ORN-extended class diagrams and shows how these relationships are easily mapped to an ORN-extended SQL or Object DDL. For the DBMS developer, it presents the specifications and algorithms needed to implement ORN in a relational and object DBMS.  This book also describes tools that can be downloaded or accessed via the Web.  These tools allow databases to be modeled using ORN and implemented using automatic code generation that adds ORN support to Microsoft SQL Server and Progress Object Store. Object Relationship Notation (ORN) for Database Applications:  Enhancing the Modeling and Implementation of Associations is written for research scientists, research libraries, professionals, and advanced-level students in computer science.  

Autoren/Hrsg.

Ehlmann, Bryon K.

Inhaltsverzeichnis

1;Preface;6
1.1;Motivation;6
1.2;Purpose;7
1.3;Readers;8
1.4;Structure;8
1.5;Downloads;10
1.6;Acknowledgments;10
2;About the Author;12
3;Contents;13
4;List of Abbreviations;18
5;Part I About Relationships and ORN;19
5.1;Chapter 1 Introduction;20
5.1.1;Including a Brief History of Relationships;20
5.1.2;1.1 Relationships;20
5.1.3;1.2 A Brief History of Relationships;21
5.1.4;1.3 Problems in Modeling and Implementing Relationships;49
5.1.5;1.4 Preview of a Solution;52
5.2;Chapter 2 Object Relationship Notation (ORN);55
5.2.1;2.1 Syntax;55
5.2.2;2.2 Graphical Representation;56
5.2.3;2.3 Semantics;57
5.2.4;2.4 Examples;58
5.2.5;2.5 Flashback to the Company Database;67
5.3;Chapter 3 ORN Simulator;69
5.3.1;A Modeling Tool Where Associations Come Alive;69
5.3.2;3.1 Creating a Database Model and a Database;69
5.3.3;3.2 Verifying Association Semantics;76
5.3.4;3.3 Architecture;82
5.3.5;3.4 Benefits;83
5.4;Chapter 4 Association Patterns;84
5.4.1;Emerging from a Variety of Association Types;84
5.4.2;4.1 Context;84
5.4.3;4.2 Pattern Descriptions;86
5.4.4;4.3 Patterns in Database Modeling and Implementation;105
5.4.5;4.4 Associations That Don’t Conform to a Pattern;110
5.4.6;4.5 Conclusion;111
5.5;Chapter 5 Comparing ORN to Similar Declarative Schemes;112
5.5.1;5.1 Schemes for Relational Databases and Object Relations;113
5.5.2;5.2 Schemes for the ER model;120
5.5.3;5.3 Schemes in ODBMSs;120
5.5.4;5.4 Whole-Part Properties and Dimensions for Class Diagrams;122
5.5.5;5.5 Conclusion;128
6;Part II Using ORN to Develop a Database System;130
6.1;Chapter 6 ORN Additive;131
6.1.1;A Tool for Extending SQL Server with ORN;131
6.1.2;6.1 Capabilities, Operation, and Architecture;131
6.1.3;6.2 ORN Additive DDL Statements;136
6.1.4;6.3 ORN Additive DML Statements;139
6.1.5;6.4 Conclusion;146
6.2;Chapter 7 Object Relater Plus (OR+);147
6.2.1;An ORN-Extended Object DBMS;147
6.2.2;7.1 Capabilities and Compatibilities;147
6.2.3;7.2 ODDL;149
6.2.4;7.3 ODML;155
6.2.5;7.4 Architecture, Implementation, and Extensibility;157
6.2.6;7.5 Conclusion;161
6.3;Chapter 8 Mapping Database Models to DDLs;163
6.3.1;From ORN-Extended Class Diagrams to ORN-Extended DBMSs;163
6.3.2;8.1 Mapping an ORN-Extended Model to an ORN-Extended SQL;163
6.3.3;8.2 Mapping an ORN-Extended Model to an Object DDL;171
6.3.4;8.3 Conclusion;177
6.4;Chapter 9 Association Semantics;179
6.4.1;Dealing with the Subtleties, Inconsistencies, and Ambiguities;179
6.4.2;9.1 Inconsistencies;179
6.4.3;9.2 Inconsistency Detection;185
6.4.4;9.3 Ambiguities;186
6.4.5;9.4 Associations as Functions;188
6.4.6;9.5 Conclusion;191
7;Part III Adding ORN to a DBMS;192
7.1;Chapter 10 A Conceptual Implementation of ORN;193
7.1.1;Exploring Semantic Circularity and Ambiguity;193
7.1.2;10.1 Algorithms;194
7.1.3;10.2 Link Cycles;200
7.1.4;10.3 Conclusion;215
7.2;Chapter 11 Adding ORN to the SQL Standard for RDBMSs;216
7.2.1;11.1 Motivation;216
7.2.2;11.2 Overview of SQL Association Capabilities;217
7.2.3;11.3 Proposed ORN Extension to SQL;220
7.2.4;11.4 Conclusion;224
7.3;Chapter 12 Adding ORN to the ODMG Standard for ODMSs;226
7.3.1;12.1 Motivation;226
7.3.2;12.2 Adding ORN to ODL;228
7.3.3;12.3 Algorithms;232
7.3.4;12.4 Conclusion;245
8;Bibliography;247
9;Index;251