Converting Relational Databases into Objectrelational Databases
Abdelsalam Maatuk, M. Akhtar Ali, and Nick Rossiter
School of Computing, Engineering & Information Sciences,
Northumbria University, Newcastle upon Tyne, UK |
 |
REFEREED
ARTICLE
PDF Version |
Abstract
This paper proposes an approach for migrating existing Relational DataBases (RDBs)
into Object-Relational DataBases (ORDBs). The approach is superior to existing
proposals as it can generate not only the target schema but also the data instances.
The solution takes an existing RDB as input, enriches its metadata representation
with required semantics, and generates an enhanced canonical data model, which
captures essential characteristics of the target ORDB, and is suitable for migration. A
prototype has been developed, which migrates successfully RDBs into ORDBs (Oracle
11g) based on the canonical model. The experimental results were very encouraging,
demonstrating that the proposed approach is feasible, efficient and correct.
Note: Due to the typographical sophistication of this article, no HTML version is available. Please use the PDF version
About the authors
|
|
Dr. Abdelsalam Maatuk is a lecturer at Faculty of Science,
Department of Computer, Omar Al-Mukhtar University, Libya. He
received his Ph.D. in 2009 from Northumbria University, UK. His
research interest include schema integration, database migration and
reverse engineering. He can be reached at ammaatuk@yahoo.com. |
|
|
Dr. M. Akhtar Ali is a senior lecturer at School of Computing, Engineering and Information Sciences, Northumbria University,
Newcastle, UK. In 2003 he received his Ph.D. from Manchester University. He is interested in self-tuning of databases for high performance. He can be reached at akhtar.ali@northumbria.ac.uk. |
|
|
Dr. Nick Rossiter is a reader at School of Computing, Engineering
and Information Sciences, Northumbria University, Newcastle, UK.
He is interested in interoperability of information systems. He can
be reached at nick.rossiter@northumbria.ac.uk.
|
Abdelsalam Maatuk,
M. Akhtar Ali,
Nick Rossiter: “Converting Relational Databases into Objectrelational Databases”, in Journal of Object Technology, vol. 9, no. 2, March-April 2010, pp. 145-161 http://www.jot.fm/issues/issue_2010_03/article3/
|