A formal mapping of an object-oriented conceptual model to a relational implementation model
Date of Publication
1999
Document Type
Master's Thesis
Degree Name
Master of Science in Computer Science
Subject Categories
Computer Sciences
College
College of Computer Studies
Department/Unit
Computer Science
Thesis Adviser
Philip Chan
Defense Panel Chair
Jefferson Tan
Defense Panel Member
Teresita Limoanco
Rhodora Reyes
Abstract/Summary
This research explores an approach of integrating the strengths of two known technologies in the database design process: the relational and object-oriented technologies.In this approach, an object-oriented data model is used in the design of the conceptual schema, while a relational model is adopted for the implementation schema. A mapping scheme to transform the object-oriented database model to its relational model is defined. This mapping scheme is based on set theory definitions of the constructs of the two data models.
The object-oriented and relational technologies are based on different paradigms. Object-orientation is based on the concept that systems should be built from interacting components called objects, while relational technology is based on the concept that data for an application can be stored in one or more rows within tables. Because of this difference, difficulties arise when one tries to use them together. One cannot truly store an object in a relational database for objects have both data and functionality, while relational databases store only data.
This research shows that it is possible to map objects to relations and still retain their structure. However, it also shows that in the process of conversion, certain drawbacks are encountered. To achieve success in combining the object-oriented and relational technologies, we must understand both paradigms and their differences, as well as make intelligent tradeoffs based on that knowledge.
Abstract Format
html
Language
English
Format
Accession Number
TG02947
Shelf Location
Archives, The Learning Commons, 12F Henry Sy Sr. Hall
Physical Description
114 leaves ; 28 cm.
Keywords
Mappings (Mathematics); Database design; Object-oriented programming (Computer science)
Recommended Citation
Ko, C. Y. (1999). A formal mapping of an object-oriented conceptual model to a relational implementation model. Retrieved from https://animorepository.dlsu.edu.ph/etd_masteral/2037