Treffer: On the Migration of Relational Schemas and Data to Object-Oriented Database Systems

Many organizations have collected large volumes of data which are often stored in relational databases. Now that object-oriented database management systems (OODBMSs) are becoming mature, many organizations also want to benefit from object-oriented technology in general and OODBMSs in particular. One general approach to migrate to object technology is to divide the process into two phases, where the first one transforms the relational into an object-oriented schema and the second one migrates the data into the object-oriented database system. Our approach differs from comparable approaches because it provides assistance in both phases, while other work considers only the first phase. In the first phase, we use transformation rules to construct an object-oriented schema which is semantically equivalent to the relational schema. In the second phase, the schema transformation information is used to generate programs that migrate the relational data into an object-oriented database. The co.