Migration from relational DBMS to object-relational DBMS

In the last few years, many companies have begun using their database systems for non-traditional applications because of demands such as storing images and multimedia objects in the database. Consequently, the objects and related operations are becoming more complex. A new technology has evolved in which relational and object-oriented concepts have been combined or merged - Object-Relational database systems. With the increasing popularity of Object-Relational technology, it becomes necessary to have a methodology that allows database designers to migrate from existing Relational database technology to Object-Relational database technology. The objective of this thesis is to develop such transformation methodology. There are a few tasks in the methodology, which include transformation of database structures, from relational database into a conceptual (UML) model and then to an object-relational database; transformation of database applications, relational SQL statements into O-R SQL statements; and data migration, from relational tables into object-relational tables with objects. Transformation rules are developed for each task.