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
Mapping extended entity relationship model to object modeling technique
ACM SIGMOD Record
Converting relational to object-oriented databases
ACM SIGMOD Record
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
Converting A Relational Database Model into an Entity-Relationship Model
Proceedings of the Sixth International Conference on Entity-Relationship Approach
A Method for Translating Relational Schemas into Conceptual Schemas
Proceedings of the Eight International Conference on Enity-Relationship Approach to Database Design and Querying
Schema Transformation Techniques for Database Reverse Engineering
ER '93 Proceedings of the 12th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
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
Using Queries to Improve Database Reverse Engineering
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
Mapping an Extended Entity-Relationship Schema into a Schema of Complex Objects
OOER '95 Proceedings of the 14th International Conference on Object-Oriented and Entity-Relationship Modelling
Extracting N-ary Relationships Through Database Reverse Engineering
ER '96 Proceedings of the 15th International Conference on Conceptual Modeling
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)
Relational Database Reverse Engineering: Elicitation of Generalization Hierarchies
ER '99 Proceedings of the Workshops on Evolution and Change in Data Management, Reverse Engineering in Information Systems, and the World Wide Web and Conceptual Modeling
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
Study of the Automatic Construction of XML Documents Models from a Relational Data Model
DEXA '03 Proceedings of the 14th International Workshop on Database and Expert Systems Applications
ITCC '04 Proceedings of the International Conference on Information Technology: Coding and Computing (ITCC'04) Volume 2 - Volume 2
XTABLES: Bridging relational technology and XML
IBM Systems Journal
Novel Approach for Reengineering Relational Databases into XML
ICDEW '05 Proceedings of the 21st International Conference on Data Engineering Workshops
Information and Software Technology
Algebraic database migration to object technology
ER'00 Proceedings of the 19th international conference on Conceptual modeling
XML conceptual modeling using UML
ER'00 Proceedings of the 19th international conference on Conceptual modeling
Whole-part relationships in the object-relational databases
ICCOMP'06 Proceedings of the 10th WSEAS international conference on Computers
| Hi-index | 0.00 |
This paper surveys the recent literature about various research trends relevant to Relational DataBase (RDB) reengineering. The paper presents an analysis of approaches and techniques used in this context, including construction of object views on top of RDBs, database integration and database migration. A categorisation is presented of the selected work, concentrating on migrating an RDB as a source into object-based and XML databases as targets. Database migration from the source into each of the targets is discussed and critically evaluated, including the semantic enrichment, schema translation and data conversion. Based on a detailed analysis of the existing literature, it seems that the existing work does not provide a complete solution for more than one target database for either schema or data conversion. Besides, none of the existing proposals can be considered as a method for migrating an RDB into an object-relational database. We propose such a method based on an intermediate canonical data model, which enriches the semantics of the source RDB and captures characteristics of the target databases.