Design of a simple and effective object-to-relational mapping technique
Fakhar Lodhi, Muhammad Ahmad Ghazali · 2007
Currently, most object-oriented applications use relational databases to meet their needs for persistent storage. However, object-oriented and relational paradigms represent information in manners that are quite different from each other. This results in two different models for representing the same information, thus increasing the design and maintenance efforts. Several attempts have been made to overcome this impedance mismatch but all of them have fallen short of providing satisfactory results from one aspect or the other. This paper outlines a simple and straightforward approach to effectively overcome this challenge. Our methodology yields a data model that is mechanically derived from the object model without compromising the performance of the system. The physical schema and the basic object persistence and population operations are automatically generated, thus, resulting in a system that makes design and maintenance much easier tasks than before.