Encyclopedia of Database Systems

2009 Edition

Logical Database Design: from Conceptual to Logical Schema

  • Alexander Borgida
  • Marco A. Casanova
  • Alberto H. F. Laender
Reference work entry
DOI: https://doi.org/10.1007/978-0-387-39940-9_645



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.

Historical Background

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...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Casanova M.A., Tucherman L., and Laender A.H.F. On the design and maintenance of optimized relational representations of entity-relationship schemas. Data Knowl. Eng., 11(1):1–20, 1993.CrossRefGoogle Scholar
  2. 2.
    Chen P.P. The entity-relationship model: toward a unified view of data. In Proc. 1st Int. Conf. on Very Large Data Bases, 1975.Google Scholar
  3. 3.
    Chen P.P. The entity-relationship model – toward a unified view of data. ACM Trans. Database Syst., 1(1):9–36, 1976.CrossRefGoogle Scholar
  4. 4.
    da Silva A.S., Laender A.H.F., and Casanova M.A. An approach to maintaining optimized relational representations of entity-relationship schemas. In Proc. 15th Int. Conf. on Conceptual Modeling, 1996, pp. 292–308.Google Scholar
  5. 5.
    da Silva A.S., Laender A.H.F., and Casanova M.A. On the relational representation of complex specialization structures. Inf. Syst., 25(6–7):399–415, 2000.zbMATHCrossRefGoogle Scholar
  6. 6.
    Markowitz V.M. and Shoshani A. Representing extended entity-relationship structures in relational databases: a modular approach. ACM Trans. Database Syst., 17(3):423–464, 1992.CrossRefGoogle Scholar
  7. 7.
    Teorey T.J., Yang D., and Fry J.P. A logical design methodology for relational databases using the extended entity-relationship model. ACM Comput. Surv., 18(2):197–222, 1986.zbMATHCrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC 2009

Authors and Affiliations

  • Alexander Borgida
    • 1
  • Marco A. Casanova
    • 2
  • Alberto H. F. Laender
    • 3
  1. 1.Rutgers UniversityPiscatawayUSA
  2. 2.Pontifical Catholic University of Rio de JaneiroRio de JaneiroBrazil
  3. 3.Federal University of Minas GeraisBelo HorizonteBrazil