An approach for reverse engineering of relational databases
Communications of the ACM
Reverse engineering of relational databases: extraction of an EER model from a relational database
Data & Knowledge Engineering
Converting relational to object-oriented databases
ACM SIGMOD Record
Succeeding with object databases
Succeeding with object databases
NeT & CoT: translating relational schemas to XML schemas using semantic constraints
Proceedings of the eleventh international conference on Information and knowledge management
Transforming Relational Database Schemas into Object-Oriented Schemas according to ODMG-93
DOOD '95 Proceedings of the Fourth International Conference on Deductive and Object-Oriented Databases
On Mapping ER Models into OO Schemas
ER '93 Proceedings of the 12th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
Extracting an Entity Relationship Schema from a Relational Database through Reverse Engineering
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
Inference of Aggregate Relationships through Database Reverse Engineering
ER '98 Proceedings of the 17th International Conference on Conceptual Modeling
Translating Relational Schema With Constraints Into OODB Schema
Proceedings of the IFIP WG 2.6 Database Semantics Conference on Interoperable Database Systems (DS-5)
Semantically Enriching Relational Databases into an Object Oriented Semantic Model
DEXA '94 Proceedings of the 5th International Conference on Database and Expert Systems Applications
WCRE '01 Proceedings of the Eighth Working Conference on Reverse Engineering (WCRE'01)
XML Structures for Relational Data
WISE '01 Proceedings of the Second International Conference on Web Information Systems Engineering (WISE'01) Volume 1 - Volume 1
Information and Software Technology
A metadata driven approach to performing complex heterogeneous database schema migrations
Innovations in Systems and Software Engineering
| Hi-index | 0.02 |
This paper presents an investigation into approaches and techniques used for database conversion. Constructing object views on top of a Relational DataBase (RDB), simple database integration and database migration are among these approaches. We present a categorisation of selected works proposed in the literature and translation techniques used for the problem of database conversion, concentrating on migrating an RDB as source into object-based and XML databases as targets. Database migration from the source into each of the targets is discussed in detail including semantic enrichment, schema translation and data conversion. Based on a detailed analysis of the existing literature, we conclude that an existing RDB can be migrated into object-based/XML databases according to available database standards. We propose an integrated method for migrating an RDB into object-based/XML databases using an intermediate Canonical Data Model (CDM), which enriches the source database's semantics and captures characteristics of the target databases. A prototype has been implemented, which successfully translates CDM into object-oriented (ODMG 3.0 ODL), object-relational (Oracle 10g) and XML schemas.