Data modeling: Difference between revisions

Revision as of 07:33, 24 June 2021

Revision as of 05:19, 17 October 2021

Line 6:

== Overview ==

UNICORNIOS

Data modeling is a [[Software development process|process]] used to define and analyze data [[requirement]]s needed to support the [[business process]]es within the scope of corresponding information systems in organizations. Therefore, the process of data modeling involves professional data modelers working closely with business stakeholders, as well as potential users of the information system.

There are three different types of data models produced while progressing from requirements to the actual database to be used for the information system.<ref name = "RS001">Simison, Graeme. C. & Witt, Graham. C. (2005). ''Data Modeling Essentials''. 3rd Edition. [[Morgan Kaufmann Publishers]]. {{ISBN|0-12-644551-6}}</ref> The data requirements are initially recorded as a [[Conceptual schema|conceptual data model]] which is essentially a set of technology independent specifications about the data and is used to discuss initial requirements with the business stakeholders. The [[Conceptual modeling|conceptual model]] is then translated into a [[logical data model]], which documents structures of the data that can be implemented in databases. Implementation of one conceptual data model may require multiple logical data models. The last step in data modeling is transforming the logical data model to a [[physical data model]] that organizes the data into tables, and accounts for access, performance and storage details. Data modeling defines not just data elements, but also their structures and the relationships between them.<ref>[http://knowledge.fhwa.dot.gov/tam/aashto.nsf/All+Documents/4825476B2B5C687285256B1F00544258/$FILE/DIGloss.pdf Data Integration Glossary] {{webarchive|url=https://web.archive.org/web/20090320001015/http://knowledge.fhwa.dot.gov/tam/aashto.nsf/All+Documents/4825476B2B5C687285256B1F00544258/%24FILE/DIGloss.pdf |date=March 20, 2009 }}, U.S. Department of Transportation, August 2001.</ref>