Physical Data Model / Modeling

Physical Data Model - A Data Model that is optimized for a specific database management system (DBMS). While Conceptual Data Models are completely devoid of database-level information, a Logical Data Model stores generic characteristics (such as indexes and foreign keys) without adding anything specific to a single DBMS. Physical Data Models translate information from a Logical Data Model to designs that are specific to a certain DBMS.

[Category=Data Governance ]

Source: The Data Governance Institute, 18 December 2009 09:08:17, http://www.datagovernance.com/glossary-governance/

---

These advertisers support this free service

---

Physical Data Modeling - Physical data modeling is similar to design class modeling, the goal is to design the internal schema of a database by depicting the data tables, the data columns of those tables and the relationships between the tables.

[Category=Information Management ]

Source: Information-Management.com, 03 July 2010 11:42:47, http://www.information-management.com/glossary/m.html

---

Physical Data Model - A data model that represents the denormalized physical implementation of data that support an information system. The logical data model is denormalized to a physical data model according to specific criteria that do not compromise the logical data model but allow the database to operate efficiently in a specific operating environment.

[Category=Data Warehousing ]

Source: Sun.com, 09 August 2010 07:23:06, http://www.sun.com/third-party/dw/brochures/67198.Acrobat.pdf

---

Physical Data Model - A data model that represents the denormalized physical implementation of data that support an information system. The logical data model is denormalized to a physical data model according to specific criteria that do not compromise the logical data model but allow the database to operate efficiently in a specific operating environment.

[Category=Data Warehousing ]

Source: Aexis Business Intelligence, 22 December 2010 14:58:15, http://www.aexis.eu/DataWarehouse-Glossary/