Bulk Loading Techniques for Object Databases and an Application to Relational Data

We present a framework for designing, in a declarative and flexible way, efficient migra-tion programs and an undergoing implemen-tation of a migration tool called RelOO whose targets are any ODBC compliant system on the relational side and the 02 system on the object side. The framework consists of (i) a declarative language to specify database transformations from relations to objects, but also physical properties on the object database (clustering and sorting) and (ii) an algebra-based program rewriting technique which op-timizes the migration processing time while taking into account physical properties and transaction decomposition. To achieve this, we introduce equivalences of a new kind that consider side-effects on the object database.