Conceptual Schema Design
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.
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...
- 1.Abrial J-R. Data semantics. In: Koffeman K, editor. Data management systems. Amsterdam: North-Holland; 1974.Google Scholar
- 2.Atzeni P, Ceri S, Paraboschi S, Torlone R. Database systems: concepts, languages & architectures. New York: McGraw Hill; 1999.Google Scholar
- 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