Content deleted Content added
m add words to improve readability |
clean up, remove excessive and redundant ELs, fix caps (common noun), WP:CAPSACRS, remove links for downloading software |
||
Line 3:
[[File:ORM-diagram-tkz-orm.png|406px|thumb|example of an ORM2 diagram]]
'''Object-
An object-role model uses graphical symbols that are based on first order predicate logic and set theory to enable the modeler to create an unambiguous definition of an arbitrary universe of discourse.
Line 19:
In 1989 [[Terry Halpin]] completed his PhD thesis on ORM, providing the first full formalization of the approach and incorporating several extensions.
Also in 1989, [[Terry Halpin]] and [[G.M. Nijssen]] co-authored the book "Conceptual Schema and Relational Database Design" and several joint papers, providing the first formalization of
A graphical NIAM design tool which included the ability to generate database-creation scripts for Oracle, DB2 and DBQ was developed in the early 1990s in Paris. It was originally named Genesys and was marketed successfully in France and later Canada. It could also handle ER diagram design. It was ported to SCO Unix, SunOs, DEC 3151's and Windows 3.0 platforms, and was later migrated to succeeding [[Microsoft]] operating systems, utilising XVT for cross operating system graphical portability. The tool was renamed OORIANE and is currently being used for large data warehouse and SOA projects.
Line 27:
Another recent development is the use of ORM in combination with standardised relation types with associated roles and a standard [[machine-readable dictionary]] and [[Taxonomy (general)|taxonomy]] of concepts as are provided in the [[Gellish English]] dictionary. Standardisation of relation types (fact types), roles and concepts enables increased possibilities for model integration and model reuse.
== Concepts ==
[[File:Object-Role Model Overview.jpg|thumb|240px|right|Overview of
=== Facts ===
Line 37:
=== Attribute-free ===
ORM is attribute-free : unlike models in the [[Entity-relationship model|
ORM treats all elementary facts as relationships and so treats decisions for grouping facts into structures (e.g. attribute-based entity types, classes, relation schemes, XML schemas) as implementation concerns irrelevant to semantics. By avoiding attributes in the base model, ORM
improves semantic stability and enables verbalization into natural language.
Line 44:
Fact-based modeling includes procedures for mapping facts to attribute-based structures, such as those of ER or UML.<ref name="orm.net"/>
Fact-based textual representations are based on formal subsets of native languages. ORM proponents argue that ORM models are easier to understand by people without a technical education. For example, proponents argue that
=== ORM 2 graphical notation ===
ORM2 is the latest generation of
* More compact display of ORM models without compromising clarity
* Improved internationalization (e.g. avoid English language symbols)
Line 73:
=== ORMLite ===
ORMLite is a free, open-source modeling tool that supports ORM 2 notation. It was created as a self-learning environment to help popularize ORM. It can verbalize facts and generate relational models. It is written in Python and so it is multi-platform. Version 0.13b was released in November 2012.
=== NORMA ===
Dr. [[Terry Halpin]] led the initial development of the [[NORMA (software modeling tool)|NORMA]] ORM modeling tool whilst he was a Professor at [[Neumont University]]. This is now supported via The ORM Foundation,
[[NORMA (software modeling tool)|NORMA]] (Natural ORM Architect for Visual Studio)
{| class="wikitable" border="1" margin
Line 115 ⟶ 114:
{{As of|2009|4}}, the NORMA project<ref name="SFORM">NORMA - [http://sourceforge.net/projects/orm The ORM Project at Sourceforge]</ref> delivers frequent releases.
Each new NORMA Community Technical Preview (CTP) is published in the library of The ORM Foundation website.<ref>[https://www.ormfoundation.org/files/folders/norma_the_software/default.aspx library of The ORM Foundation website]
=== DogmaModeler ===
[[File:DogmaModeler1.jpg|thumb|320px|DogmaModeler
[[DogmaModeler]] is a free [[Ontology (computer science)|ontology]] modeling tool based on Object role modeling. The philosophy of DogmaModeler is to enable non-IT experts to model ontologies with a little or no involvement of an ontology engineer.
This challenge is tackled in [[DogmaModeler]] through well-defined methodological principles. The first version of DogmaModeler was developed at the [[Vrije Universiteit Brussel]].
The DogmaModeler Project<ref>[http://sourceforge.net/projects/dogmamodeler/ The DogmaModeler project at SourceForge]</ref> shows no activity since its creation in 2006, and the source code for the project is not available through that site. The latest version of the program, available at the
Since then the project seems to have been continued and expanded into several other tools at the [[Vrije Universiteit Brussel]]'s Semantics Technology and Applications Research Laboratory (VUB STARLab).<ref>http://www.starlab.vub.ac.be/website/research</ref>
▲The DogmaModeler Project<ref>[http://sourceforge.net/projects/dogmamodeler/ The DogmaModeler project at SourceForge]</ref> shows no activity since its creation in 2006, and the source code for the project is not available through that site. The latest version of the program, available at the http://jarrar.info/Dogmamodeler website is dated on October 27, 2006.
▲Since then the project seems to have been continued and expanded into several other tools at the [[Vrije Universiteit Brussel]]'s Semantics Technology and Applications Research Laboratory (VUB STARLab).<ref>http://www.starlab.vub.ac.be/website/research</ref> A note on that site states "Users who only use DOGMAModeler for their own researches can contact (author's email) for the free download."<ref>http://www.starlab.vub.ac.be/website/tools</ref>
=== VisioModeler ===
The former ORM tool known as VisioModeler is
The early ORM tools such as IAST (Control Data) and RIDL* were followed by InfoDesigner, InfoModeler and [[#VisioModeler|VisioModeler]].
Line 152 ⟶ 149:
=== CaseTalk ===
A modeling tool called CaseTalk<ref>http://www.casetalk.com/ The CaseTalk website</ref> based on the ORM-dialect known as Fully Communication Oriented Information Modeling ([[FCO-IM]]) is developed and maintained by Oelan in the Netherlands
=== Infagon ===
A freeware ORM tool known as Infagon is available from Mattic software. Infagon is also based on the [[FCO-IM]] dialect.
=== Other tools ===
Line 176 ⟶ 173:
== Further reading ==
* FCO-IM Publications, [http://fco-im.nl fco-im.nl]
* {{Citation
| last = Halpin | first = Terry
Line 218 ⟶ 213:
* [http://www.ormfoundation.org/ The ORM Foundation]
* [http://www.orm.net Terry Halpin's ORM site]
{{DEFAULTSORT:Object Role Modeling}}
|