ebook ebooks e-book e-books downloaden bei MyEbooks.ch downloaden

Object Relationship Notation (ORN) for Database Applications Enhancing the Modeling and Implementation of Associations

:	Bryon K. Ehlmann
:	Object Relationship Notation (ORN) for Database Applications Enhancing the Modeling and Implementation of Associations
:	Springer-Verlag
:	9780387095547
:	1
:	CHF 85.40
:

:	Informatik
:	English

:	246
:	Wasserzeichen/DRM
:	PC/MAC/eReader/Tablet
:	PDF

Conceptuall , 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.

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