Summary

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. Object Relationship Notation (ORN) for Database Applications: Enhancing the Modeling and Implementation of Associations shows how ORN can be used in UML class diagrams & database definition languages (DDLs) to better model & implement relationships & thus more productively develop database applications. For the database developer, it presents many examples of relationships modeled using ORN-extended class diagrams & shows how these relationships are easily mapped to an ORN-extended SQL or Object DDL. For the DBMS developer, it presents the specifications & 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.