Re-engineering relational databases

Abdelsalam Maatuk, Akhtar Ali, Nick Rossiter

Research output: Chapter in Book/Report/Conference proceedingChapterpeer-review

4 Citations (Scopus)
15 Downloads (Pure)

Abstract

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.
Original languageEnglish
Title of host publicationProceedings of the 2011 International Conference on Intelligent Semantic Web-Services and Applications - ISWSA '11 ( Amman, Jordan 18-20 April)
Place of PublicationNew York
PublisherACM
Pages1-10
ISBN (Print)978-1-4503-0474-0
DOIs
Publication statusPublished - Apr 2011

Fingerprint

Dive into the research topics of 'Re-engineering relational databases'. Together they form a unique fingerprint.

Cite this