Object–role modeling

Example of an ORM2 diagram

Object–role modeling (ORM) is used to model the semantics of a universe of discourse. ORM is often used for data modeling and software engineering.

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. Attribute free, the predicates of an ORM Model lend themselves to the analysis and design of graph database models in as much as ORM was originally conceived to benefit relational database design.

The term "object–role model" was coined in the 1970s and ORM based tools have been used for more than 30 years – principally for data modeling. More recently ORM has been used to model business rules, XML-Schemas, data warehouses, requirements engineering and web forms.[1]

History

The roots of ORM can be traced to research into semantic modeling for information systems in Europe during the 1970s. There were many pioneers and this short summary does not by any means mention them all. An early contribution came in 1973 when Michael Senko wrote about "data structuring" in the IBM Systems Journal. In 1974 Jean-Raymond 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 mentions the term "object–role model".

G.M. Nijssen made fundamental contributions by introducing the "circle-box" notation for object types and roles, and by formulating the first version of the conceptual schema design procedure. Robert Meersman extended the approach by adding subtyping, and introducing the first truly conceptual query language.

Object role modeling also evolved from the Natural language Information Analysis Method, a methodology that was initially developed by the academic researcher, G.M. Nijssen in the Netherlands (Europe) in the mid-1970s and his research team at the Control Data Corporation Research Laboratory in Belgium, and later at the University of Queensland, Australia in the 1980s. The acronym NIAM originally stood for "Nijssen's Information Analysis Methodology", and later generalised to "Natural language Information Analysis Methodology" and Binary Relationship Modeling since G. M. Nijssen was only one of many people involved in the development of the method.[2]

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 object–role modeling.

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.

Also evolving from NIAM is "Fully Communication Oriented Information Modeling" FCO-IM (1992). It distinguishes itself from traditional ORM in that it takes a strict communication-oriented perspective. Rather than attempting to model the domain and its essential concepts, it models the communication in this domain (universe of discourse). Another important difference is that it does this on instance level, deriving type level and object/fact level during analysis.

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 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

Overview of object–role model notation, Stephen M. Richard (1999).[3]

Facts

Object–role models are based on elementary facts, and expressed in diagrams that can be verbalised into natural language. A fact is a proposition such as "John Smith was hired on 5 January 1995" or "Mary Jones was hired on 3 March 2010".

With ORM, propositions such as these, are abstracted into "fact types" for example "Person was hired on Date" and the individual propositions are regarded as sample data. The difference between a "fact" and an "elementary fact" is that an elementary fact cannot be simplified without loss of meaning. This "fact-based" approach facilitates modeling, transforming, and querying information from any domain.[4]

Attribute-free

ORM is attribute-free: unlike models in the entity–relationship (ER) and Unified Modeling Language (UML) methods, 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, ORM improves semantic stability and enables verbalization into natural language.

Fact-based modeling

Fact-based modeling includes procedures for mapping facts to attribute-based structures, such as those of ER or UML.[4]

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 object–role models are easier to understand than declarative languages such as Object Constraint Language (OCL) and other graphical languages such as UML class models.[4] Fact-based graphical notations are more expressive than those of ER and UML. An object–role model can be automatically mapped to relational and deductive databases (such as datalog).[5]

ORM 2 graphical notation

ORM2 is the latest generation of object–role modeling. The main objectives for the ORM 2 graphical notation are:[6]

  • More compact display of ORM models without compromising clarity
  • Improved internationalization (e.g. avoid English language symbols)
  • Simplified drawing rules to facilitate creation of a graphical editor
  • Extended use of views for selectively displaying/suppressing detail
  • Support for new features (e.g. role path delineation, closure aspects, modalities)

Design procedure

Example of the application of Object Role Modeling in a "Schema for Geologic Surface", Stephen M. Richard (1999).[3]

System development typically involves several stages such as: feasibility study; requirements analysis; conceptual design of data and operations; logical design; external design; prototyping; internal design and implementation; testing and validation; and maintenance. The seven steps of the conceptual schema design procedure are:[7]

  1. Transform familiar information examples into elementary facts, and apply quality checks
  2. Draw the fact types, and apply a population check
  3. Check for entity types that should be combined, and note any arithmetic derivations
  4. Add uniqueness constraints, and check arity of fact types
  5. Add mandatory role constraints, and check for logical derivations
  6. Add value, set comparison and subtyping constraints
  7. Add other constraints and perform final checks

ORM's conceptual schema design procedure (CSDP) focuses on the analysis and design of data.

See also

References

  1. ^ Jarrar, M. (2007). "Towards Automated Reasoning on ORM Schemes". Conceptual Modeling - ER 2007. Lecture Notes in Computer Science. Vol. 4801. pp. 181–197. Bibcode:2007LNCS.4801..181J. CiteSeerX 10.1.1.148.6251. doi:10.1007/978-3-540-75563-0_14. ISBN 978-3-540-75562-3.
  2. ^ Wintraecken, J. J. V. R. (1990) [1987]. The NIAM information analysis method: theory and practice. Translation of: Informatie-analyse volgens NIAM. Dordrecht; Boston: Kluwer Academic Publishers. doi:10.1007/978-94-009-0451-4. ISBN 079230263X. OCLC 19554537. S2CID 30209824.
  3. ^ a b Stephen M. Richard (1999). Geologic Concept Modeling. U.S. Geological Survey Open-File Report 99-386.
  4. ^ a b c "ORM 2 Graphical Notation" (PDF). Retrieved 2024-05-19.
  5. ^ "P:11 Mapping ORM To Datalog - an Overview - The ORM Foundation". www.ormfoundation.org. Retrieved May 31, 2020.
  6. ^ "ORM 2" (PDF). Archived from the original (PDF) on February 19, 2009. Retrieved April 22, 2009. Halpin, T. 2005, 'ORM 2', On the Move to Meaningful Internet Systems 2005: OTM 2005 Workshops, eds R. Meersman, Z. Tari, P. Herrero et al., Cyprus. Springer LNCS 3762, pp. 676–87.
  7. ^ Terry Halpin (2001). "Object-Role Modeling: an overview"

Further reading

Read other articles:

Daftar tokoh Maluku berikut ini memuat nama tokoh-tokoh yang berasal dari Kepulauan Maluku atau secara keturunan (genetis) berdarah Maluku, dari pihak ayah maupun ibu yang berdarah Maluku baik bagi para pendatang dari beberapa daerah di Indonesia yang lahir besar di Maluku, maupun bagi mereka yang berdarah Maluku yang lahir di perantauan.[1] Thomas MatulessyMartha Christina TiahahuJohannes LeimenaJohannes LatuharharyPeter M. C. SouissaJacob Elfinus SahetapyBahlil LahadaliaSaadiah Ulup...

 

Este artículo o sección necesita referencias que aparezcan en una publicación acreditada.Este aviso fue puesto el 28 de junio de 2018. Campeonato de Europa de MontañaCategoría MontañaFundación 1930Temporada inicial 1930Ámbito ContinentalSitio oficial[editar datos en Wikidata] El Campeonato de Europa de Montaña[1]​[2]​[3]​ es un competición automovilística de montaña, organizada por la FIA en diferentes países de Europa. A diferencia de los circuitos de...

 

الضريح الملكي الموريتاني   تقديم البلد  الجزائر مدينة تيبازة إحداثيات 36°34′29″N 2°33′12″E / 36.574722222222°N 2.5533333333333°E / 36.574722222222; 2.5533333333333  نوع موقع أثري المهندس المعماري نوميديا الارتفاع 32.4 متر  الموقع الجغرافي تعديل مصدري - تعديل   الضريح الملكي الموريتان...

Surface Laptop StudioSurface Laptop Studio研發商微软產品系列Microsoft Surface类型筆記型電腦产品世代First发布日期2021年9月22日,​2年前​(2021-09-22)單價美元 1600 - 3100作業系統Windows 11 (Consumer models) Windows 11 (Business models)電源56.3Wh battery中央处理器酷睿 H35 i5-11300H 酷睿 H35 i7-11370H内存(RAM)16GB, 32GB 移动DDR RAM硬盘儲存空間256 GB, 512 GB, 1TB, 2TB Removable 固态硬盘顯示14.4 inch touchscreen 12...

 

Bài viết này cần thêm chú thích nguồn gốc để kiểm chứng thông tin. Mời bạn giúp hoàn thiện bài viết này bằng cách bổ sung chú thích tới các nguồn đáng tin cậy. Các nội dung không có nguồn có thể bị nghi ngờ và xóa bỏ. Một dĩa thức ăn ở Na Uy Ẩm thực Na Uy ở dạng truyền thống chủ yếu dựa trên các nguyên liệu có sẵn ở Na Uy và núi non, các khu vực hoang dã và bờ biển quốc gia Na U...

 

National colours of the Czech Republic The national colours of the Czech Republic (Czech: státní barvy České republiky) are one of the national symbols of the Czech Republic, which officially represent the Czech Republic. The colours forming tricolour are in the following order: white, red and blue.[1] The national colours come from the coat of arms of the Czech Republic and the flag of the Czech Republic. The law explicitly specifies the correct order of colours as white–red–...

Artikel ini sebatang kara, artinya tidak ada artikel lain yang memiliki pranala balik ke halaman ini.Bantulah menambah pranala ke artikel ini dari artikel yang berhubungan atau coba peralatan pencari pranala.Tag ini diberikan pada Februari 2023. SD Pamor NusantaraInformasiJenisSekolah SwastaAlamatLokasi, Batam, Kepri,  IndonesiaMoto SD Pamor Nusantara, merupakan salah satu Sekolah Dasar swasta yang ada di Batam, Provinsi Kepulauan Riau. Sama dengan SD pada umumnya di Indonesia masa pendi...

 

1398–1864 Ottoman province in north Anatolia For other uses, see Rum (disambiguation). Eyâlet-i Rûmiyye-i Suğra / Eyâlet-i SivasEyalet of the Ottoman Empire1398–1864The Eyalet of Sivas in 1609CapitalAmasya, Tokat, Sivas[1]HistoryHistory • Established 1398• Disestablished 1864 Preceded by Succeeded by Kadi Burhan al-Din Sivas Vilayet Today part ofTurkey East Anatolian rug (detail), from the Şarkişla-Sivas region. Made c. 1800. The Eyalet of Rûm (Ottoman Tu...

 

PsikologiGreek letter 'psi' Garis besar Sejarah Cabang Dasar ilmu Abnormal Eksperimental Evolusi Kepribadian Kognitif Matematika Neuropsikologi Neurosains perilaku Perkembangan Positif Psikofisik Sosial Terapan Forensik Kesehatan Klinis Industri dan organisasi Pendidikan Okupasi kesehatan Olahraga Sekolah Daftar Ikhtisar Publikasi Terapi Topik  Portal Psikologilbs Psikologi agama merupakan cabang ilmu psikologi yang meneliti dan mempelajari tingkah laku manusia dalam hubungan dengan ...

جويل سانتانا معلومات شخصية الميلاد 25 ديسمبر 1948 (العمر 74 سنة)ريو دي جانيرو مركز اللعب مدافع الجنسية البرازيل  معلومات النادي النادي الحالي United Premier Soccer League [الإنجليزية]‏ مسيرة الشباب سنوات فريق 1958–1962 سانتوس 1963–1971 ريال مدريد المسيرة الاحترافية1 سنوات فريق م. (هـ.) 1971–...

 

В Википедии есть статьи о других людях с такой фамилией, см. Асеев; Асеев, Николай. Николай Николаевич Асеев Имя при рождении Николай Николаевич Ассеев Псевдонимы Штальбаум Полное имя Николай Николаевич Асеев Дата рождения 28 июня (10 июля) 1889[1] Место рождения Льгов, ...

 

John Dalton, pencetus hukum perbandingan berganda Dalam kimia, hukum perbandingan berganda adalah salah satu hukum dasar stoikiometri. Hukum ini juga kadang-kadang disebut hukum Dalton (diambil dari nama kimiawan Inggris John Dalton), tetapi biasanya hukum Dalton merujuk kepada hukum tekanan parsial. Hukum ini menyatakan bahwa apabila dua unsur bereaksi membentuk dua atau lebih senyawa, maka perbandingan berat salah satu unsur yang bereaksi dengan berat tertentu dari unsur yang lain pada kedu...

Saga Airlines IATA ICAO Callsign H3 SGX SAGA Founded2004Ceased operations2013Operating bases Istanbul Secondary hubs Antalya Bodrum Dalaman Fleet size0Destinations0HeadquartersIstanbul, TurkeyKey peopleAbdülkadir Kolot (chairman)Musa Alioglu (vice chairman) Ali Birhan Temel (managing director)Websitewww.sagaairlines.com Saga Airlines was a charter airline based in Istanbul, Turkey, which served the tourism industry. History The airline was established in 2004 and started operations in June 2...

 

Bagian dari seri IslamFikih Ibadah Syahadat Salat Rakaat Kiblat Turbah Salat sunah (Salat tahajudSalat tarawih) Salat witir Salat nawafil Saum Zakat Haji Ihram (pakaian ihram tamatuk) Tawaf Umrah (dan Haji) Politik Khilafah Khalifah Majelis syura Imamah Wilayat al-faqih Baiat Dzimmi Aman Keluarga Nikah Ijab kabul Mahar Misyar Halala Urfi Mut‘ah Poligini Talak Khulu Zihar Iddah Kafa'ah Kafalah Menyusui Seks Aurat Aborsi Baligh Haya' Adab seks Pemerkosaan Zina Masturbasi Jinayat Hud...

 

This article is about titles for the original Game Boy. For other lists, see Lists of Game boy games. The original model of the Game Boy The Game Boy portable system has a library of games, which were released in plastic ROM cartridges. The Game Boy first launched in Japan on April 21, 1989, with Super Mario Land, Alleyway, Baseball, and Yakuman. For the North American launches, Tetris and Tennis were also featured, while Yakuman was never released outside of Japan. The last games to be publi...

Map all coordinates using: OpenStreetMap Download coordinates as: KML GPX (all coordinates) GPX (primary coordinates) GPX (secondary coordinates) This list includes properties and districts listed on the National Register of Historic Places in Mecklenburg County, North Carolina. Click the Map of all coordinates link to the right to view an online map of all properties and districts with latitude and longitude coordinates in the table below.[1] Current listings       &#...

 

Norwegian black metal band God SeedGod SeedBackground informationOriginBergen, NorwayGenresBlack metalYears active2008-2009, 2012–2015LabelsIndie RecordingsMembersKing ov HellGaahlGeir BratlandStian Sir KårstadLust KilmanKenneth Kapstad God Seed was a Norwegian black metal band based in Bergen, Norway. Former Gorgoroth members Gaahl and King ov Hell adopted the name in March 2009 following the ending of the Gorgoroth name dispute. After performing a few gigs as God Seed, vocalist Gaahl lef...

 

This article does not cite any sources. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: List of Bengali films of 1976 – news · newspapers · books · scholar · JSTOR (August 2021) (Learn how and when to remove this template message) Bengali cinema 1930s 1930 1931 1932 1933 19341935 1936 1937 1938 1939 1940s 1940 1941 1942 1943 19441945 1946 1947 1948 1949 1950s 1950 ...

Yaƙin Siffin  35°57′N 39°01′E / 35.95°N 39.02°E / 35.95; 39.02Iri faɗaBangare na First Fitna (en) Kwanan watan 21 ga Yuli, 657 –  28 ga Yuli, 657 (Gregorian) Wuri Q3960268 Ƙasa Siriya An gwabza Yakin Siffin ne a shekara ta 657 miladiyya (37H) tsakanin Ali bin Abi Talib na hudu na Khalifofin Rashidun kuma Imamin Shi'a na farko da Mu'awiyah bn Abi Sufyan, gwamnan Sham mai tawaye.[1] An yi wa yakin suna ne bayan wurin da yake, Siffin, a...

 

American artist (born 1931) Audrey FlackArtist's signature on bronzeBorn (1931-05-30) May 30, 1931 (age 92)New York City, U.S.NationalityAmericanEducationThe High School of Music & Art New York University Institute of Fine ArtsYale UniversityCooper UnionKnown forPainting, SculptureMovementPhotorealismSpouseH.Robert MarcusWebsitehttp://www.audreyflack.com Audrey Flack (born May 30, 1931) is an American artist. Her work pioneered the art genre of photorealism and encompasses paint...

 

Strategi Solo vs Squad di Free Fire: Cara Menang Mudah!