By Topic

ORN Additive: Shrinking the Gap between Database Modeling and Implementation

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$31 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

1 Author(s)
Ehlmann, B.K. ; Southern Illinois Univ., Edwardsville

ORN Additive is a prototype tool that was developed to show how the gap between database modeling and implementation can be reduced - more specifically, to show how associations defined in data models can be more directly mapped to and better supported by a relational database management system (DBMS) and done so in a powerful way. The "additive, " object relationship notation (ORN), allows database developers to extend the multiplicities given in UML class diagrams with "bindings " to model the semantics of a wide variety of association types. The tool, ORN Additive, lets them add this ORN to the foreign key constraints given for a Microsoft SQL Server database. This allows simple to complex association semantics to be included in the database's metadata and supported by the enhanced DBMS. Such support means that associations are implemented as modeled without DBMS users having to develop and maintain complex constraints, triggers, and/or procedural code.

Published in:

Computer and Information Science, 2007. ICIS 2007. 6th IEEE/ACIS International Conference on

Date of Conference:

11-13 July 2007