Skip to main content
SpringerLink
Log in
Book cover

Encyclopedia of Database Systems pp 2137–2141Cite as

Logical Database Design: From Conceptual to Logical Schema

  • Reference work entry
  • First Online:

  • 118 Accesses

Synonyms

Data model mapping; Logical schema design

Definition

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 via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   4,499.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD   6,499.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Recommended Reading

  1. Casanova MA, Tucherman L, Laender AHF. On the design and maintenance of optimized relational representations of entity-relationship schemas. Data Knowl Eng. 1993;11(1):1–20.

    Article  Google Scholar 

  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 

  3. Chen PP. The entity-relationship model – toward a unified view of data. ACM Trans Database Syst. 1976;1(1):9–36.

    Article  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 

  5. da Silva AS, Laender AHF, Casanova MA. On the relational representation of complex specialization structures. Inf Syst. 2000;25(6–7):399–415.

    Article  MATH  Google Scholar 

  6. Markowitz VM, Shoshani A. Representing extended entity-relationship structures in relational databases: a modular approach. ACM Trans Database Syst. 1992;17(3):423–64.

    Article  Google Scholar 

  7. Teorey TJ, Yang D, Fry JP. A logical design methodology for relational databases using the extended entity-relationship model. ACM Comput Surv. 1986;18(2):197–222.

    Article  MATH  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Rutgers University, New Brunswick, NJ, USA

    Alexander Borgida

  2. Pontifical Catholic University of Rio de Janeiro, Rio de Janeiro, Brazil

    Marco A. Casanova

  3. Federal University of Minas Gerais, Belo Horizonte, Brazil

    Alberto H. F. Laender

Authors
  1. Alexander Borgida
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Marco A. Casanova
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Alberto H. F. Laender
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Alexander Borgida .

Editor information

Editors and Affiliations

  1. Georgia Institute of Technology College of Computing, Atlanta, GA, USA

    Ling Liu

  2. University of Waterloo School of Computer Science, Waterloo, ON, Canada

    M. Tamer Özsu

Section Editor information

  1. Rutgers University, New Brunswick, NJ, USA

    Alexander Borgida

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer Science+Business Media, LLC, part of Springer Nature

About this entry

Check for updates. Verify currency and authenticity via CrossMark

Cite this entry

Borgida, A., Casanova, M.A., Laender, A.H.F. (2018). Logical Database Design: From Conceptual to Logical Schema. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_645

Download citation

Publish with us

Policies and ethics

Search

Navigation