Database system concepts
Fundamentals of database systems
Fundamentals of database systems
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
A relational model of data for large shared data banks
Communications of the ACM
Hi-index | 0.00 |
The advent of Entity-Relationship (E-R) model has revolutionized the database design process. The overwhelming success of Entity-Relationship approach to database design partly lies in the simplicity and semantic clarity of the E-R model. However, two seemingly conflicting measurements of database design: logical-clarity and physical-efficiency, force database designers to choose either logically-clear design or physically-efficient design. As a result, the resulting design is either logically-clear or physically-efficient, but not both. This paper is to provide a remedy for this situation. In this paper, we first discuss the concept of logical-clarity and physical-efficiency of logical database design. Then the concept of bi-level conceptual schema is introduced. The bi-level conceptual schema concept allows us to create a logical database design that is both logically-clear and physically-efficient. Finally, a database management system prototype (DBMSB) that supports bi-level conceptual schema is described.