Ramez El-Masri
Gio Wiederhold
ABSTRACT
One approach to the design of a logical model for an integrated database requires each potential user or application to specify its view as a data model. An integration phase follows, where these user data models are integrated into a global database model. We address the problem of view integration when user data models are expressed using the structural model [Wi77, WE79].The structural model is built from relations in Boyce-Codd normal form [Co74]. A basic set of integrity assertions is implicit in the model. The integrity assertions are defined by classification of relations into types, and are represented by connections between relations. We will show how to integrate different representations of two related real-world entity classes.
- {Ba69} Bachman, C.W., "Data Structure Diagrams", Database (ACM SIGBDP), Vol.1, No.2, Summer 1969 Google Scholar
Digital Library
- {CGT75} Chamberlin, D.D., J.N.Gray, and I.L.Traiger, "Views, Authorization, and Locking in a Relational Database System", Proc. NCC, AFIPS, 1975, pp.425--430Google Scholar
- {Ch76} Chen, P.P.S., "The Entity-Relationship Model --- Towards a Unified View of Data", ACM Trans, on Database Systems, Vol.1, No.1, March 1976, pp.9--36 Google ScholarDigital Library
- {Co70} Codd, E.F., "A Relational Model for Large Shared Data Banks", Comm. ACM, Vol.13, No.6, June 1970, pp.377--387 Google ScholarDigital Library
- {Co72} Codd, E.F., "Further Normalization of the Data Base Relational Model", in R.Rustin (ed.), "Data Base Systems", Courant Comp. Sci. Symp., Volume 6, Prentice-Hall, 1972, pp.33--64Google Scholar
- {Co74} Codd, E.F., "Recent Investigations in Relational Data Base Systems", Information Processing 74, North-Holland, 1974, pp.1017--1021Google Scholar
- {DB78} Dayal, U. and P.A. Bernstein, "On the Updatability of Relational Views", in S.B.Yao (ed.), Proc. Fourth Intl. Conf. on VLDB, West-Berlin, 1978, pp.368--377Google Scholar
- {EC75} Eswaran, K.P. and D.D. Chamberlin, "Functional Specifications of a Subsystem for Database Integrity", in D.S.Kerr (ed.), "Very Large Data Bases", (Proc. Intl. Conf. on VLDB), ACM, 1975, pp.48--68Google Scholar
- {HM78} Hammer, M. and D.McLeod, "The Semantic Data Model: A Modelling Mechanism for Data Base Applications", in E.Lowenthal and N.B.Dale (eds.), ACM SIGMOD Intl. Conf. on Management of Data, Austin, Texas, 1978, pp.26--36 Google ScholarDigital Library
- {NS78} Navathe, S.B. and M.Schkolnick, "View Representation in Logical Database Design", in E.Lowenthal and N.B.Dale (eds.), ACM SIGMOD Intl. Conf. on Management of Data, Austin, Texas, 1978, pp.144--156 Google ScholarDigital Library
- {SS75} Schmid, H.A. and J.R.Swenson, "On the semantics of the relational model", in W.F.King (ed.), ACM SIGMOD Intl. Conf. on Management of Data, San Jose, California, 1975, pp.211--223 Google ScholarDigital Library
- {SS77} Smith, J.M. and D.C.P.Smith, "Database Abstractions: Aggregation and Generalization", ACM Trans. on Database Systems, Vol.2, No.2, June 1977, pp.105--133 Google ScholarDigital Library
- {WE79} Wiederhold, G. and R. El-Masri, "A Structural Model for Database Systems", Stanford University, Computer Science Dept. Technical Report CS-79-722, April 1979 Google ScholarDigital Library
- {Wi77} Wiederhold, G., "Database Design", McGraw-Hill, 1977, Chapter 7, pp.329--367 Google ScholarDigital Library
- Data model integration using the structural model
Recommendations
Extending the database relational model to capture more meaning
During the last three or four years several investigators have been exploring “semantic models” for formatted databases. The intent is to capture (in a more or less formal way) more of the meaning of the data so that database design can become more ...
Modeling MongoDB with Relational Model
EIDWT '13: Proceedings of the 2013 Fourth International Conference on Emerging Intelligent Data and Web TechnologiesRelational databases have been prevailing for the last two decades, with features of clear semantics and ease of use with SQL supported by the underlying theory, relational algebra. Relational databases provide good support for structural data ...
The entity-relationship model—toward a unified view of data
Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MAA data model, called the entity-relationship model, is proposed. This model incorporates some of the important semantic information about the real world. A special diagrammatic technique is introduced as a tool for database design. An example of ...
Comments