This section provides a basic overview of Object Role Modeling (ORM), through white papers, articles and a slide presentation. The relationship between ORM and the Entity Relationship (ER) approach is also discussed. To view a PDF file you may need to install an additional piece of software called Adobe Acrobat Reader from the Adobe site. For an in-depth treatment of ORM, see Halpin, T. & Morgan T. 2008, Information
Modeling and Relational Databases, Second Edition, published by Morgan Kaufmann Publishers (ISBN: 978-0-12-373568-3).
Details on this book are available on the
Resources page. Object-Role Modeling version 2 (ORM 2)
pdf file (123K)
This entry on Object-Role Modeling will soon be published in the Encyclopedia of Database Systems by Springer. The Encyclopedia, under the editorial guidance of Ling Liu and M. Tamer Özsu, will be a multiple volume, comprehensive, and authoritative reference on databases, data management, and database systems. Since it will be available in both print and online formats, researchers, students, and practitioners will benefit from advanced search functionality and convenient interlinking possibilities with related online content. The Encyclopedia’s online version will be accessible on the SpringerLink platform. ORM 2
pdf file (165K)
Object-role Modeling (ORM) is a fact-oriented modeling approach for specifying, transforming, and querying information at a conceptual level. Unlike Entity-Relationship modeling and Unified Modeling Language class diagrams, fact-oriented modeling is attribute-free, treating all elementary facts as relationships. For information modeling, fact-oriented graphical notations are typically far more expressive than other notations. Introduced 30 years ago, ORM has evolved into closely related dialects, and is supported by industrial and academic tools. Industrial experience has identified ways to improve cur-rent ORM languages (graphical and textual) and associated tools. A project is now under way to provide tool support for a second generation ORM (called ORM 2), that has significant advances over current ORM technology. This paper provides an overview of, and motivation for, the enhancements introduced by ORM 2, and discusses an open-source ORM 2 tool under development. Object Role Modeling: An Overview pdf file (405K) This white paper provides an overview of Object Role Modeling (ORM), using a case study to illustrate the main ideas. The steps used to design a conceptual schema for an information system are first explained in some detail. To help communicate the ideas, some mistakes are deliberately made. Checking procedures within the design method are later used to remove these errors. A simple example is included to show how the conceptual design may be “optimized” for relational database systems by applying a transformation. An algorithm for mapping this design to a normalized, relational database schema is then outlined. Finally, the paper gives a brief sketch of how ORM can be used as a sound basis for conceptual queries, object oriented modeling, and process/event modeling. Microsoft has also published a Revised version of the above ORM overview. Object Role Modeling (ORM/NIAM)
pdf file (125K)
Object Role Modeling (ORM) is a method for modeling and querying an
information system at the conceptual level, and mapping between conceptual
and logical (e.g. relational) levels. ORM comes in various flavors,
including NIAM (Natural language Information Analysis Method). This
article provides an overview of ORM, and notes its advantages over entity
relationship and traditional object oriented modeling. Business Rules and Object Role Modeling
pdf file (407K)
This article provides a gentle introduction to Object Role Modeling (ORM), explaining its advantages over entity relationship and object oriented approaches for capturing and validating business rules with subject matter experts. The ORM attribute-free, mixfix predicate approach simplifies verbalization, multiple instantiation and schema evolution, and its rich constraint language enables many rules to be captured graphically and easily validated. The article includes simple examples to illustrate these advantages. Entity Relationship modeling from an ORM perspective:
Part 1
pdf file (80K)
This paper is the first in a series of articles examining data modeling in the Entity relationship (ER) approach from the perspective of Object Role Modeing (ORM). After a brief historical introduction, this article examines basic aspects of the Barker notation for ER. Entity Relationship modeling from an ORM perspective:
Part 2
pdf file (58K)
This is the second in a series of articles examining data modeling in the Entity relationship (ER) approach from the perspective of Object Role Modeing (ORM). This paper completes a basic review of the Barker notation for ER. Entity Relationship modeling from an ORM perspective:
Part 3
pdf file (55K)
This is the third in a series of articles examining data modeling in the Entity relationship (ER) approach from the perspective of Object Role Modeing (ORM). This paper discusses the Information Engineering (IE) notation for ER. Modeling business rules using fact-orientation and
object-orientation DRMA99 slide presentation (798k) ORM Home ORM in Detail Modeling Issues Conceptual Queries UML and ORM Resources All diagrams on this site were created with Microsoft Visio. |