DM-36 - Physical Data Models

Constructs within a particular implementation of database management software guide the development of a physical data model, which is a product of a physical database design process. A physical data model documents how data are to be stored and accessed on storage media of computer hardware. A physical data model is dependent on specific data types and indexing mechanisms used within database management system software. Data types such as integers, reals, character strings, plus many others can lead to different storage structures. Indexing mechanisms such as region-trees and hash functions and others lead to differences in access performance. Physical data modeling choices about data types and indexing mechanisms related to storage structures refine details of a physical database design. Data types associated with field, record and file storage structures together with the access mechanisms to those structures foster (constrain) performance of a database design. Since all software runs using an operating system, field, record, and file storage structures must be translated into operating system constructs to be implemented. As such, all storage structures are contingent on the operating system and particular hardware that host data management software.
FC-10 - GIS Data Properties
Data properties are characteristics of GIS attribute systems and values whose design and format impacts analytical and computational processing. Geospatial data are expressed at conceptual, logical, and physical levels of database abstraction intended to represent geographical information. The appropriate design of attribute systems and selection of properties should be logically consistent and support appropriate scales of measurement for representation and analysis. Geospatial concepts such as object-field views and dimensional space for relating objects and qualities form data models based on a geographic matrix and feature geometry. Three GIS approaches and their attribute system design are described: tessellations, vectors, and graphs.