Re-engineering relational databases

Maatuk, Abdelsalam, Ali, Akhtar and Rossiter, Nick (2011) Re-engineering relational databases. In: Proceedings of the 2011 International Conference on Intelligent Semantic Web-Services and Applications - ISWSA '11 ( Amman, Jordan 18-20 April). Association for Computing Machinery, New York, pp. 1-10. ISBN 978-1-4503-0474-0

[img]
Preview
PDF (Conference paper)
iv_Ali_2011.pdf - Published Version

Download (260kB) | Preview
Official URL: http://dx.doi.org/10.1145/1980822.1980839

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.

Item Type: Book Section
Subjects: G400 Computer Science
G500 Information Systems
G600 Software Engineering
Department: Faculties > Engineering and Environment > Mathematics, Physics and Electrical Engineering
Related URLs:
Depositing User: Akhtar Ali
Date Deposited: 14 May 2012 08:47
Last Modified: 17 Dec 2023 13:04
URI: https://nrl.northumbria.ac.uk/id/eprint/7002

Actions (login required)

View Item View Item

Downloads

Downloads per month over past year

View more statistics