14 March 2009

🛢DBMS: Physical Data Model (Definitions)

"The Physical data model supports the needs of the database administrator and application developers, who focus on the physical implementation of the model in a database." (Sharon Allen & Evan Terry, "Beginning Relational Data Modeling" 2nd Ed., 2005)

"In the ANSI four-schema architecture, this is the organization of data used to place it in specific storage media. This is in terms of 'Tablespaces', 'Cylinders', and so on." (David C Hay, "Data Model Patterns: A Metadata Map", 2010)

"A model in which the physical characteristics (location, path, and format) are described for the data. Both hardware- and software-dependent. See also physical design." (Carlos Coronel et al, "Database Systems: Design, Implementation, and Management" 9th Ed., 2011)

"The logical data model transformed into a physical implementation using a specific DBMS product (e.g., DB2, Oracle, SQL Server, etc.)." (Craig S Mullins, "Database Administration", 2012)

"A model in which the physical characteristics (location, path, and format) are described for the data. Both hardware- and software-dependent." (Carlos Coronel & Steven Morris, "Database Systems: Design, Implementation, & Management  Ed. 11", 2014)

"The physical definition of the shape and structure of data (as defined to the DBMS)" (Daniel Linstedt & W H Inmon, "Data Architecture: A Primer for the Data Scientist", 2014)

"Model of a database expressed at platform dependent level in the way accepted by a specific database management system. Beside the data it can also contain implementation of business logic in the form of stored procedures or transaction definitions." (Iwona Dubielewicz et al, "Quality-Driven Database System Development within MDA Approach", 2015)

"In DB2 data warehousing, a metadata model that represents the tables and other objects in a database." (Sybase, "Open Server Server-Library/C Reference Manual", 2019)

"A data model that represents the implementation of the data contained in a data structure." (IEEE 610.5-1990)

No comments:

Related Posts Plugin for WordPress, Blogger...

About Me

My photo
Koeln, NRW, Germany
IT Professional with more than 24 years experience in IT in the area of full life-cycle of Web/Desktop/Database Applications Development, Software Engineering, Consultancy, Data Management, Data Quality, Data Migrations, Reporting, ERP implementations & support, Team/Project/IT Management, etc.