Welcome!
What is ORM? ORM stands for "Object-Role Modeling". You use ORM to build information models that are consistent and unambiguous because ORM is based on first order predicate logic.
First order predicate logic has evolved from the works of people like George Boole who showed how to answer questions about logic using mathematical means. George Boole is regarded as one of the founders of the field of computer science.
However, Boole's 1854 book was about the "Laws of Thought" and whilst most people know how to use a digital computer, few people understand that the principles of Boole's "Laws of thought" apply to all kinds of reasoning - including day-to-day decisions by individuals.
ORM helps to clarify meaning When you create an object-role model you are creating a precise and meaningful description of your information domain. So ORM tools provide a means for people to agree on exactly what they mean.
ORM's power to clarify meaning has many potential uses. However, so far, the main use of ORM has been to help computer application developers to design databases. For example, from an object-role model, you can automatically derive a fully normalised relational data model. You can also derive other artefacts such as a class model and an entity relationship diagram. These artefacts can then be transformed into usable artefacts such as a physical database.
Easy to use ORM has only one data structure - the fact type. This simplicity is supported by a comprehensive set of constraint types that allow you to create complex information models.
Validating your model. One of the biggest problems in data modeling is making sure that the data model is understood and approved by "domain experts". ORM tools support this process because they have built in "verbalizers" that generate easy-to-understand natural language from the object-role model. Using natural language makes it easy for a non-technical person to validate the content of the model. In contrast, if a non-technical person wants to understand a UML or entity-relationship (ER) model, the person must first learn the UML or ER language.
Thus, ORM provides a simpler, more accurate and more powerful approach to information modeling than other approaches such as Entity-Relationship modeling and UML.
What is the history of ORM? The roots of ORM can be traced to research into semantic modeling for information systems in Europe during the 1970's. There were many pioneers and this short summary does not mention them all. An early contribution came in 1973 when M Senko wrote about "data structuring" in the IBM Systems Journal. In 1974 JR Abrial contributed an article about "Data Semantics". In June 1975, Eckhard Falkenberg's doctoral thesis was published and in 1976 one of Falkenberg's papers mentioned the term "object-role model".
Other contributors in continental Europe introduced the "circle-box" notation and an early version of the conceptual schema design procedure. Other people added subtyping, and conceptual query ideas.
The first full formalization came in 1989 when Terry Halpin completed his PhD thesis on ORM. Terry also introduced extensions. In 1989, Terry Halpin and GM Nijssen co-authored the book "Conceptual Schema and Relational Database Design".
How can I learn more? The authoritative book on ORM is Terry Halpin's 2008 "Big Brown Book" entitled "Information Modeling and Relational Databases - Second Edition". (The first edition was published in 2001). You can order the Big Brown Book by clicking on the "Second Edition" image (see sidebar - Books). You can read about ORM from the documents in the Library. You can also participate in the Forum.
Are there any ORM Tools? The growth of ORM has followed the availability of a series of steadily improving ORM tools. The early ORM tools such as IAST (Control Data) and RIDL* were followed by InfoDesigner, InfoModeler and VisioModeler.
When Microsoft bought the Visio Corporation, Microsoft extended VisioModeler and made it a component of Microsoft Visual Studio. This was Microsoft's first ORM implementation and it was published in the 2003 Enterprise Architects release of Visual Studio as a component of the tool called called "Microsoft Visio for Enterprise Architects".
In the same year, a companion "how to" book was published by Morgan Kaufmann entitled "Database Modeling with Microsoft Visio for Enterprise Architects". (see sidebar) Microsoft has retained the ORM functionality in the high-end version of Visual Studio and the Morgan Kaufmann book remains a suitable user guide for both versions.
The next "in the works" ORM tool is an open source tool called NORMA (Natural ORM Architect for Visual Studio). You can download the latest release of NORMA from the tools section in the Library.
Forum The Forum is for discussing ORM related topics. Vistors can see most of the discussions but to participate you have to register on the site. Not all discussions are visible to all registered members because they are for specialised sub-groups. However, if you don't see a topic that you feel should be given its own Forum, please post a message in the "Request a Topic" Forum. Your post should include a title, a description of the scope, how it relates to ORM and why you think that the ORM community will find it of interest.
Library You can download ORM software, ORM tutorials and ORM related documents from the Library. Most documents are in PDF format but there are also multimedia file types.
Research The research page supports ORM research. You can see the experimental material that I used in my 2008 MSc dissertation project. This experiment was designed to test the hypothesis that “ORM based methods require at least 25% less effort than alternative methods such as UML and ER.”
Visitors may browse the Library and Forum. Registered members can download documents and participate in the forum discussions. Registration is free - just click on the "Join" button at the top right of the screen and follow the instructions. If you experience a problem, please send a description of the problem to admin@ormfoundation.org.
Thank you for visiting The ORM Foundation website.
Ken Evans
What's New
-
Hi Matt, Thanks for all your hard work. I posted your latest release to the Library at 0815 GMT on 12 March 2010. Ken
-
Peter, If you still have your cat model, you might want to try opening it again with the latest NORMA version. It looks like all of your join paths will have automatic join path generation support, so we'll generate join paths in the model, and these will verbalize with no missing parts. Note that the tool has internal verbalization and definition...
-
Steve, Happy to clarify. Note that the constraint being discussed here is one that we generate an automatic join path for in the latest NORMA release. If you open this model again you should see the correct verbalization. -Matt
-
Hi All, I released the February 2010 CTP version of NORMA late last night (around 8:00GMT), and Ken wrote a nice summary and posted it to ORM foundation a few hours later (check the library for details). Unfortunately, we found a serialization bug this morning that hampers the value constraint international portability feature, so I've slipstreamed...
-
John, Thanks for the offer, I'll take you up on it when the time comes. I did some investigations on the VS2010 changes about a month ago, but have been totally engaged in join paths and verbalization issues since then (there are a lot of things going on behind the scenes that haven't been posted yet). The code looks like it will port reasonably...