Abstract
The Entity-Relationship model (ER model) views data in the form of entities and relationships. The Object-Oriented model (OO model) views data as classes, types and their subtypes. A mapping procedure that considers various features of the ER model and transforms the ER schema and its associated relational schema into an OO schema is proposed. The mapping rules are illustrated with appropriate examples. A procedure for mapping constraints on the ER database into the OO schema is then discussed. Finally, OO representations are developed for ER schema operations.
Preview
Unable to display preview. Download preview PDF.
References
Booch, G., Object-Oriented Design with Applications, Benjamin /Cummings, Redwood City, California, 1991.
Chen, P.P., The Entity-Relationship Model — Towards a Unified View of Data, ACM Transactions on Databases, Vol 1, No 1, March 1976, pp. 9–36.
Elmasri, R., and Navathe, S.B., Fundamentals of Database Systems, 2nd Ed., Benjamin/Cummings, Redwood City, California, 1994.
Lippman, S.B., C++ Primer, Addison-Wesley, Reading, Massachusetts, 1989.
Rumbaugh, J., Relations as Semantic Constructs in an Object-Oriented Language, OOPSLA, 1987, pp. 466–481.
Narasimhan, B., Navathe, S.B., Jayaraman, S., On Mapping ER Models to OO Schemas, Technical Report # SJ-PYI-9306, School of Textile & Fiber Engineering, Georgia Institute of Technology, Atlanta, GA 30332-0295.
Author information
Authors and Affiliations
Corresponding author
Editor information
Rights and permissions
Copyright information
© 1994 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Narasimhan, B., Navathe, S.B., Jayaraman, S. (1994). On mapping ER and relational models into OO schemas. In: Elmasri, R.A., Kouramajian, V., Thalheim, B. (eds) Entity-Relationship Approach — ER '93. ER 1993. Lecture Notes in Computer Science, vol 823. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0024383
Download citation
DOI: https://doi.org/10.1007/BFb0024383
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-58217-5
Online ISBN: 978-3-540-48575-9
eBook Packages: Springer Book Archive