On mapping ER and relational models into OO schemas
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.
KeywordsComposite Attribute Constraint Class Instance Variable Transition Constraint Person Class
Unable to display preview. Download preview PDF.
- Booch, G., Object-Oriented Design with Applications, Benjamin /Cummings, Redwood City, California, 1991.Google Scholar
- Elmasri, R., and Navathe, S.B., Fundamentals of Database Systems, 2nd Ed., Benjamin/Cummings, Redwood City, California, 1994.Google Scholar
- Lippman, S.B., C++ Primer, Addison-Wesley, Reading, Massachusetts, 1989.Google Scholar
- Rumbaugh, J., Relations as Semantic Constructs in an Object-Oriented Language, OOPSLA, 1987, pp. 466–481.Google Scholar
- 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.Google Scholar