Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Conceptual Schema Design

  • Alexander BorgidaEmail author
  • John MylopoulosEmail author
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_642


Conceptual schema design is the process of generating a description of the contents of a database in high-level terms that are natural and direct for users of the database. The process takes as input information requirements for the applications that will use the database, and produces a schema expressed in a conceptual modeling notation, such as the Extended Entity-Relationship (EER) Data Model or UML class diagrams. The challenges in designing a conceptual schema include: (i) turning informal information requirements into a cognitive model that describes unambiguously and completely the contents of the database-to-be; and (ii) using the constructs of a data modeling language appropriately to generate from the cognitive model a conceptual schema that reflects it as accurately as possible.

Historical Background

The history of conceptual schema design is intimately intertwined with that of conceptual data models (aka semantic data models). In fact, for many years researchers...

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

Recommended Reading

  1. 1.
    Abrial J-R. Data semantics. In: Koffeman K, editor. Data management systems. Amsterdam: North-Holland; 1974.Google Scholar
  2. 2.
    Atzeni P, Ceri S, Paraboschi S, Torlone R. Database systems: concepts, languages & architectures. New York: McGraw Hill; 1999.Google Scholar
  3. 3.
    Batini C, Ceri S, Navathe S. Conceptual database design. Menlo Park: Benjamin/Cummings Publishing Company; 1991.zbMATHGoogle Scholar
  4. 4.
    Chen PP. The entity-relationship model – toward a unified view of data. ACM Trans Database Syst. 1976;1(1):9–36.CrossRefGoogle Scholar
  5. 5.
    Gangemi A, Guarino A, Masolo C, Oltramari A, Schneider L. Sweetening ontologies with DOLCE. In: Proceedings of the 12th International Conference on Knowledge Engineering and Knowledge Management: Ontologies and the Semantic Web; 2002. p. 166–81.zbMATHCrossRefGoogle Scholar
  6. 6.
    Guizzardi G, Herre H, Wagner G. Towards ontological foundations for UML conceptual models. In: Proceedings of the Confederated International Conference on DOA, CoopIS and ODBASE; 2002. p. 1100–7.CrossRefGoogle Scholar
  7. 7.
    Rumbaugh J, Blaha M, Premerlani W, Eddy F, Lorensen W. Object-oriented modeling and design. Englewood Cliffs: Prentice Hall; 1991.zbMATHGoogle Scholar
  8. 8.
    Sakai H. Entity-relationship approach to the conceptual schema design. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1980. p. 1–8.Google Scholar
  9. 9.
    Teorey T, Yang D, Fry J. A logical design methodology for relational databases using the extended entity-relationship model. ACM Comput Surv. 1986;18(2):197–222.zbMATHCrossRefGoogle Scholar
  10. 10.
    Wand Y, Storey VC, Weber R. An ontological analysis of the relationship construct in conceptual modeling. ACM Trans Database Syst. 1999;24(4):494–528.CrossRefGoogle Scholar
  11. 11.
    Welty C, Guarino N. Supporting ontological analysis of taxonomic relationships. Data Knowl Eng. 2001;39(1):51–74.zbMATHCrossRefGoogle Scholar

Copyright information

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

Authors and Affiliations

  1. 1.Rutgers UniversityNew BrunswickUSA
  2. 2.Department of Computer ScienceUniversity of TorontoTorontoCanada

Section editors and affiliations

  • Alexander Borgida
    • 1
  1. 1.Rutgers UniversityNew BrunswickUSA