Object Relationship Notation (ORN) for Database Applications

Enhancing the Modeling and Implementation of Associations

By Bryon K. Ehlmann

Object Relationship Notation (ORN) for Database Applications Cover Image

This unique book shows how ORN can be used in UML class diagrams and database definition languages (DDLs). This will allow the reader to better model and implement relationships and thus more productively develop database applications.

Full Description

  • ISBN13: 978-0-3870-9553-0
  • 272 Pages
  • User Level: Science
  • Publication Date: June 5, 2009
  • Available eBook Formats: PDF
  • eBook Price: $119.00
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description
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.
Table of Contents

Table of Contents

  1. Preface.
  2. About Relationships and ORN.
  3. Introduction.
  4. Object Relationship Notation (ORN).
  5. ORN Simulator: A Modeling Tool Where Associations Come Alive.
  6. Association Patterns: Emerging from a Variety of Associations.
  7. Comparing ORN to Similar Declarative Schemes.
  8. Using ORN to Develop a Database.
  9. ORN Additive: A Tool for Extending SQL Server with ORN.
  10. Object Relater Plus (OR+): An ORN
  11. Extended Object DBMS.
  12. Mapping Database Models to DDLs: From ORN
  13. Extended Class Diagrams to ORN
  14. Extended DBMSs.
  15. Association Semantics: Dealing with the Subtleties, Inconsistencies, and Ambiguities.
  16. Adding ORN to the DBMS.
  17. A Conceptual Implementation of ORN: Exploring Semantic Circularity and Ambiguity.
  18. Adding ORN to the SQL Standard for RDBMSs.
  19. Adding ORN to the ODMG Standard for ODMSs.
  20. Bibliography.
  21. Index.
Errata

Please Login to submit errata.

No errata are currently published