Logical Database Design: From Conceptual to Logical Schema
Data model mapping; Logical schema design
Logical database design is the process of transforming (or mapping) a conceptual schema of the application domain into a schema for the data model underlying a particular DBMS, such as the relational or object-oriented data model. This mapping can be understood as the result of trying to achieve two distinct sets of goals: (i) representation goal: preserving the ability to capture and distinguish all valid states of the conceptual schema; (ii) data management goals: addressing issues related to the ease and cost of querying the logical schema, as well as costs of storage and constraint maintenance. This entry focuses mostly on the mapping of (Extended) Entity-Relationship (EER) diagrams to relational databases.
In the beginning, database schema design was driven by analysis of the prior paper or file systems in place in the enterprise. The use of a conceptual schema, in particular Entity Relationship...
- 2.Chen PP. The entity-relationship model: toward a unified view of data. In: Proceedings of the 1st International Conference on Very Large Data Bases; 1975.Google Scholar
- 4.da Silva AS, Laender AHF, Casanova MA. An approach to maintaining optimized relational representations of entity-relationship schemas. In: Proceedings of the 15th International Conference on Conceptual Modeling; 1996. p. 292–308.Google Scholar