Here you'll find news about ORM tools and courses as well as links to other web resources featuring ORM-related material.
ORM 2 Graphical Notation Summary
A 6-page summary of the ORM 2 Graphical Notation, including examples, may be downloaded from here (429K).
The ORM Foundation
The ORM Foundation is a non-profit organization dedicated to the promotion of the fact-oriented approach to information modeling, and is a major resource site for ORM as well as other fact-oriented modeling approaches.
Fact-Orientation and Conceptual Logic
This is a video of a keynote presentation by Dr Halpin at the EDOC2011 Conference in Helsinki, on 2011 September 1. This presentation provides a state-of-the-art overview of fact-orientation in general and second-generation Object-Role Modeling (ORM) in particular, highlighting its conceptual and visual support for logic-based modeling. To view the video, click here.
.NET Show on ORM
The 25th episode of the .NET Show focused on ORM, including an interview with Terry Halpin, Pat Hallock and Dick Barden, and demonstrations of the ORM and database modeling features of Microsoft Visio for Enterprise Architects.
Fact-based Database Design
This one hour webcast by Dr. Halpin summarizes the benefits of the fact-based, ORM approach to database design. To view the webcast, go to searchdatabase.com, go to the Expert Technical Advice section, choose the webcast, and enter your details.
(1) NORMA (Natural ORM Architect) is a new modeling tool under development that supports the next generation of ORM (ORM 2). Implemented as an open-source plug-in to Microsoft's Visual Studio .NET, NORMA requires either the free Visual Studio 2103 or 2015 Community Edition or at least the standard version of Visual Studio (2005 or later). For further details on the ORM 2 graphical notation, see ORM 2 Technical Report 1. A technical preview of NORMA is available on The ORM Foundation as well as SourceForge. A series of laboratory tutorials on NORMA are also downloadable as Microsoft Powerpoint files using the links below, or from the ORM Foundation library. Here is an ORM Foundation link to NORMA, and here is a SourceForge link to NORMA.
(2) ORM2_Draw2 Visio stencil and template for drawing ORM 2 schemas. These files are accessible from the ORM Foundation Library. The stencil has recently been significantly upgraded by Andy Carver. See the ReadMe file for instructions. This stencil requires Visio standard edition (or higher), and is for drawing only, not code generation. It is completely separate from the NORMA tool.
(3) Microsoft includes a powerful ORM and logical database modeling solution within its Visio for Enterprise Architects (VEA) product. The 2005 release of of VEA includes some minor upgrades (e.g. a driver for SQL Server 2005 is now included). Visio for Enterprise Architects appears to be included in MSDN Premium subscriptions. The least expensive way to get an MSDN Premium subscription appears to be through a purchase of “Visual Studio Professional Edition with MSDN Premium Subscription.” Click here for MSDN subscription information and purchase details.
Details on a COM API to the database modeling engine for this tool are accessible at websites maintained by John Miller (see below), and a free add-on that uses this API to expose data model details in the form of an XML document has been released by Scot Becker (see below).
The first eight of a series of articles on how to use the database modeling solution within Visio for Enterprise Architects were first published in the Journal of Conceptual Modeling (see InConcept entry below). Here are slightly revised versions of these articles:
database modeling tool: Part 1 (598K)
Microsoft has also published revised versions of five of these articles on its MSDN website: Visio-Based Database Modeling in Visual Studio .NET Enterprise Architect: Part 1; Part 2; Part 3; Part 4; Part 5.
A free Visio Viewer to enable users who have not purchased Visio to view Visio files is now available for download.
(4) The former ORM tool known as VisioModeler is freely available as an unsupported product from Microsoft Corporation (as a 25 MB download). The Microsoft download site no longer includes this program, but we are exploring other options to make it available. Models developed in VisioModeler may be exported to Microsoft's current and future ORM solutions. VisioModeler includes an online manual to explain its use. In addition, you may download this basic tutorial on how to use VisioModeler (312k).
(5) A modeling tool caled CaseTalk based on the ORM-dialect known as Fully Communication Oriented Information Modeling (FCO-IM) is available from Bommeljé Crompvoets en partners b.v., headquartered in Utrecht, The Netherlands. To find out more about this tool, click this CaseTalk website or e-mail BCP Software at email@example.com (e.g. for a free, one year licence to use CaseTalk for educational purposes).
(6) A freeware ORM tool known as Infagon is now available from Mattic software. Infagon is based on the same dialect as CaseTalk. To download or obtain more details about this tool, click the Infagon home page.
(7) ActiveFacts is a semantic modeling toolkit under development by Clifford Heath for constructing and querying ORM models. To download or obtain more details about this tool, click the Data Constellation home page.
(8) A Community Edition of the ORM Studio tool developed by Viev Pty Ltd was released on July 1, 2015. To download or obtain more details about this tool, click ORM Studio.
The first printing of the book included a number of errors, as detailed in the Book Errata.
The following book provides a detailed coverage of how to use Microsoft's high end Visio tool to design databases.
Halpin, T., Evans, K., Hallock, P. & MacLean B. 2003, Database Modeling with Microsoft Visio for Enterprise Architects, Morgan Kaufmann Publishers: San Francisco, ISBN 1-55860-919-9.
The first printing of the book included a number of errors, as detailed in the Book Errata.
For a discussion of research topics on UML, see Siau, K. & Halpin, T.A. (eds), UML: Systems Analysis, Design and Development Issues published by Idea Group Publishing. This book includes a chapter providing an in-depth comparision of ORM and UML. Details on this book are available at the book's website.
If you are interested in an early formalization of ORM, and can handle large downloads (18 MB pdf file -- Warning: this takes several minutes to download even on a fast connection), here is a bitmap copy of my PhD thesis. Unfortunately, it was impractical to make this available in text form, as I wrote the thesis in 1989 using good old WordStar and a tailor-made driver to print all the symbols on an old dot matrix printer.
Microsoft added Course 2090 to its official curriculum. This 3-day, instructor-led course is titled “Modeling Business Requirements to Create a Database Using Microsoft Visual Studio .NET Enterprise Architect”. It focuses on the use of ORM and Visio for Enterprise Architects to perform database modeling -- see Course 2090 details. Instruction for this course is available from various qualified ORM instructors and Microsoft Certified Trainers.
Before its acquisition by Microsoft Corporation, Visio certified a number of consulting partners to offer training courses in ORM. One of these partners, InConcept Inc., offers 5-day ORM course in Minneapolis (for details, e-mail firstname.lastname@example.org).
InConcept, Inc. is a database consulting firm dedicated to excellence in data modeling. Emphasis is placed on the conceptual model using Object Role Modeling (ORM). This higher level design is more suitable for review with customers while the logical and physical models, derived from the conceptual model, are more suited to the technical staff. Modeling a database at the conceptual level significantly reduces design errors, thus reducing overall cost. Using ORM enables the designer and the business user to communicate and capture business rules more readily and easily.
The Journal of Conceptual Modeling is a free journal produced by InConcept and dedicated to data modeling, design, and implementation issues. The goal of this publication is to promote communication between professionals, share knowledge, and to educate our readers. The target audience is large: database professionals and developers, end users and business professionals, students and teachers, and anyone else using, developing, or considering development of a database system.
The Business Rules Community is an online vertical community for business rules professionals. Membership is free, and includes access to the Business Rules Journal, which includes regular columns by renowned experts in the business rules movement, as well as feature articles by leading industry professionals.
This journal now includes a regular column by Terry Halpin. This column includes articles on topics such as verbalization of business rules, temporal modeling, and ontology modeling. Some weeks after the publication of one of these articles on the business rules community website, a pdf version of the article is typically made available below. If available, you may download the pdf version. Otherwise, click the Business Rules Community (BRC) website link to view it there.
Setting the Scene
Professor Sjir Nijssen
Professor Sjir Nijssen is one of the original pioneers of fact-oriented modeling, and in particular the NIAM, and later CogNIAM, versions of this approach. He has been active in conceptual modeling since the mid-1970s,when he led a group of researchers at Control Data in Belgium to develop fact-oriented technology, and has wide experience in both industry and academia. Sjir's major contributions to fact-orientation include introducing the circle-box notation for object types and roles, and adding a linguistic orientation and design procedure for specifying conceptual schemas. He is currently Chief Technical Officer for PNA Group, a consultancy company based in The Netherlands.
Professor Robert Meersman
Professor Robert Meersman is one of the original ORM pioneers, introducing subtyping to the methodology when it was first developed in the Control Data research institute at the Free University of Brussels (VUB). He has been an active researcher in information system semantics and conceptual query technology ever since, and is currently exploring the use of ORM as an ontological basis for the semantic web. He is emeritus professor in the department of computer science at the Free University of Brussels, and director of its STARlab research laboratory. His home page includes teaching and research information.
Dr Arthur ter Hofstede
Dr Arthur ter Hofstede, a prominent ORM researcher, is an Associate Professor and Leader of the Cooperative Information Systems Special Interest Group within the Faculty of Information Technology at the Queensland University of Technology in Brisbane, Australia. His home page includes teaching and research information, as well as an extensive list of publications, most of which address data modeling issues.
Dr Erik Proper
Dr H. A. (Erik) Proper, holds a research position at the Public Research Centre Henri Tudor, Luxembourg, as well as academic post at the Radboud University of Nijmegen, The Netherlands. His theoretical and industrial research covers many information systems topics, including schema evolution, schema optimization and conceptual query technology. His website includes an extensive list of downloadable research publications, many of them directly related to ORM.
Dr Andy Carver
Dr Andy Carver is an ORM consultant and experienced educator, currently teaching at INTI International University, Malaysia. He recently made substantial upgrades to the ORM 2 Draw stencil for drawing ORM 2 diagrams in Visio.
Ken Evans, MSc
Ken Evans is the Director of The ORM Foundation, a Visiting Senior Research Fellow at the University of Lincoln and a UK based independent consultant. In 2003, Ken co-authored the book Database Modeling with Microsoft Visio for Enterprise Architects. In 2008, Ken completed his Master’s Degree in Information Systems Management with Liverpool University. His dissertation work included an experiment on the relative effectiveness of ORM based application development vis-à-vis other methods such as UML and ER.
John Miller is the principal of Perpetual Data Systems, a consultancy based in California. John maintains “Wikis” with details about the unsupported COM API to the database modeling solution in Microsoft Visio for Enterprise Architects. Here is his ORM Wiki, and here is his Viso Modeling Engine Wiki.
Scot Becker is the principal of Orthogonal Software, a consultancy based in Minneapolis. Scot has released Orthogonal Toolbox, a free add-on to Visio for Enterprise Architects that exposes most of the model details stored in an ORM source model or a logical database model as an XML document. This information is extracted using the COM API to the modeling engine mentioned above.
Scot has now added an informative blog site ObjectRoleModeling.com that includes lots of useful tips and news about ORM and related database modeling topics.
Ken North is a database practitioner and author of several publications on databases, including the following articles that discuss ORM: ‘Modeling, metadata and XML’, ‘Modeling, data semantics and natural language’ and ‘Database design for prime time’.
The Data Modeling Zone Australia conference to be held in Sydney, Australia, May 13-14, 2015, includes two presentations on fact-oriented modeling, one by Clifford Heath and one by myself. The full program is accessible from the Data Modeling Zone Australia website. If you regsiter online for the conference, you can receive a $100 discount off the normal registration fee by entering my promotion code "HALPIN".
The Data Modeling Zone conference held in Portland, Oregon, October 20-22, 2014, included three presentations on fact-oriented modeling. Two of these were 3 hour workshops, one by Dr Gordon Everest and one by myself, and the other was a one hour presentation by myself. The full program is accessible online from the Data Modeling Zone website.
The ORM 2014 International Workshop was held this year in the beautiful town of Bolzano, Italy. Hosted by Enrico Franconi and the KRDB centre at the Free University of Bozen/Bolzano, the successful workshop was attended by academic and industrial experts from several countries.
The 9th International Workshop on Fact-Oriented Modeling (ORM2013) was held September 11-13, 2013 in Graz, Austria in conjunction with the On The Move Conferences. The Final Call for Papers for ORM2013 may be found here. The slides of the presentations are accessible in the ORM Foundation Library.
The 8th International Workshop on Fact-Oriented Modeling (ORM2012) was held September 12-14, 2012 in Rome in conjunction with the On The Move Conferences. The Final Call For Papers for ORM2012 may be found here. Slides for the presentations are accessible in the ORM Foundation Library.
The Exploring Modeling Methods in Systems Analysis and Design (EMMSAD) series of annual conferences provide a forum to discuss the latest advances in information systems modeling. The EMMSAD2012/EuroSymposium2012 Conference was held June 25-26 in Gdansk, Poland in conjunction with CAiSE 2012. The first Call For Papers for EMMSAD2012 may be found here. Details about this EMMSAD conference as well as resources from past EMMSAD presentations may be found here.
The 7th International Workshop on Fact-Oriented Modeling (ORM2011) was held October 19-21, 2011 in Hersonissou, Crete, Greece in conjunction with the On The Move Conferences. Slides for the presentations are accessible in the ORM Foundation Library.
The ORM2010 Workshop was held October 27-29, 2010 in Hersonissou, Crete, Greece. Slides for the presentations are accessible in the ORM Foundation Library.
The Data Management Association is an international body of professionals dedicated to improving the management of data. The Enterprise Data World Conference for 2009 was held in Tampa, Florida on April 5-9.
The International Business Rules Forum for 2009 was held in Las Vegas, November 1-5.
The Entity Relationship Conference series addresses all forms of
conceptual modeling (ER, ORM, UML). The ER-2009 conference was held in Gramado, Brazil on November 9-12, 2009.
ORM Home ORM in Detail Modeling Issues
Conceptual Queries UML and ORM Resources
All diagrams on this site were created with Microsoft Visio