Degree Name

Master of Science (Hons.)


School of Information Technology and Computer Science


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.



Unless otherwise indicated, the views expressed in this thesis are those of the author and do not necessarily represent the views of the University of Wollongong.