Skip to main content
  • Book
  • © 2009

Object Relationship Notation (ORN) for Database Applications

Enhancing the Modeling and Implementation of Associations

Authors:

  • Provides unique association patterns that help make database modeling easier and more exact
  • Unique ORN notation closes the gap between database modeling and definition, thus improving database development productivity
  • Describes Web-accessible tools that 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
  • Includes supplementary material: sn.pub/extras

Part of the book series: Advances in Database Systems (ADBS, volume 39)

Buy it now

Buying options

eBook USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book USD 109.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (12 chapters)

  1. Front Matter

    Pages i-xvii
  2. About Relationships and ORN

    1. Front Matter

      Pages 1-1
  3. Part I About Relationships and ORN

    1. Introduction

      • Bryon K. Ehlmann
      Pages 3-37
    2. Object Relationship Notation (ORN)

      • Bryon K. Ehlmann
      Pages 39-52
    3. ORN Simulator

      • Bryon K. Ehlmann
      Pages 53-67
    4. Association Patterns

      • Bryon K. Ehlmann
      Pages 69-96
    5. Comparing ORN to Similar Declarative Schemes

      • Bryon K. Ehlmann
      Pages 97-114
  4. Using ORN to Develop a Database System

    1. Front Matter

      Pages 115-115
  5. Part II Using ORN to Develop a Database System

    1. ORN Additive

      • Bryon K. Ehlmann
      Pages 117-132
    2. Object Relater Plus (OR+)

      • Bryon K. Ehlmann
      Pages 133-148
    3. Mapping Database Models to DDLs

      • Bryon K. Ehlmann
      Pages 149-164
    4. Association Semantics

      • Bryon K. Ehlmann
      Pages 165-177
  6. Adding ORN to a DBMS

    1. Front Matter

      Pages 179-179
  7. Part III Adding ORN to a DBMS

    1. A Conceptual Implementation of ORN

      • Bryon K. Ehlmann
      Pages 181-203
    2. Adding ORN to the SQL Standard for RDBMSs

      • Bryon K. Ehlmann
      Pages 205-214
    3. Adding ORN to the ODMG Standard for ODMSs

      • Bryon K. Ehlmann
      Pages 215-235
  8. Back Matter

    Pages 1-10

About this book

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.

 

Reviews

From the reviews:

“This book provides a comprehensive reference for Object Relationship Notation (ORN), a declarative extension that adds referential actions to UML multiplicities for the conceptual modeling of relationships in database applications. The book is intended as a text for a broad audience including researchers, developers of DBMSs and data modeling tools, database practitioners, and students. … Throughout this book many examples are provided and allow for a very good understanding of the covered material. … To summarize, I recommend this book as a reference for ORN.” (Gottfried Vossen, Zentralblatt MATH, Vol. 1185, 2010)

Bibliographic Information

Buy it now

Buying options

eBook USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book USD 109.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access