CFP last date
15 April 2024
Reseach Article

Automatic Data Migration between Two Databases with Different Structure

by Ramin Ahmadi, Bagher Rahimpour Cami, Hamid Hassanpour
International Journal of Applied Information Systems
Foundation of Computer Science (FCS), NY, USA
Volume 3 - Number 3
Year of Publication: 2012
Authors: Ramin Ahmadi, Bagher Rahimpour Cami, Hamid Hassanpour

Ramin Ahmadi, Bagher Rahimpour Cami, Hamid Hassanpour . Automatic Data Migration between Two Databases with Different Structure. International Journal of Applied Information Systems. 3, 3 ( July 2012), 13-28. DOI=http:/ijais12-450477

@article{ http:/ijais12-450477,
author = { Ramin Ahmadi, Bagher Rahimpour Cami, Hamid Hassanpour },
title = { Automatic Data Migration between Two Databases with Different Structure },
journal = { International Journal of Applied Information Systems },
issue_date = { July 2012 },
volume = { 3 },
number = { 3 },
month = { July },
year = { 2012 },
issn = { 2249-0868 },
pages = { 13-28 },
numpages = {9},
url = { },
doi = { http:/ijais12-450477 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
%0 Journal Article
%1 2023-07-05T10:45:34.857778+05:30
%A Ramin Ahmadi
%A Bagher Rahimpour Cami
%A Hamid Hassanpour
%T Automatic Data Migration between Two Databases with Different Structure
%J International Journal of Applied Information Systems
%@ 2249-0868
%V 3
%N 3
%P 13-28
%D 2012
%I Foundation of Computer Science (FCS), NY, USA

The process of data migration is one of the major challenges in the database structure development and improvement. The huge size of databases and the difference in syntax and semantics of tables are some of the crucial problems in data migration field. Data migration is performed in two phases sequentially: structure mapping and migration. In traditional approach, the first phase is carried out by the use of human experts, and the second phase is done by software. In new data migrating approaches, the process is carried out automatically by the use of ontology in the first phase. In this paper with studying various methods in this field, a new model for migrating data between two databases with a different structure is proposed. By reviewing the existing models for traditional and semantic databases, the proposed model focuses on data migration between two traditional and semantic databases. In this model, data migration process is carried out by creating a middle layer. Covering both semantic and traditional databases is one of the most important features of proposed model.

  1. Data_migration, http://en. wikipedia. org/ wiki/ Data_, accessed 2010.
  2. Hugill, A. and Zhou, H. 2007. Data Interoperability via Ontology-Based Data Understanding. http://www. mti. dmu. ac. uk.
  3. Antoniou, G. and Harmelen, F. V. 2008. A Semantic Web Primer. ISBN-13:978-0-262-01242-3.
  4. "Apex SQL Diff", Apex SQL. 2010. http://www. apexsql. com /sql_tools_diff. aspx.
  5. "Red Gate SQL Compare", http://www. red-gate. com/ products/SQL_Compare/index. htm, accessed 2010.
  6. "Apex SQL Data Diff", http://www. apexsql. com/ sql_tools_datadiff. aspx, accessed 2010.
  7. Rishe, N. ODB: Semantic Object DBMS, High performance Database Research Center School of Computer Science University Park, ECS243, Miami, FL3319, http://hpdrc. fiu. edu/.
  8. "Apex SQL Comparison Studio", http://www. apexsql. com/sql_tools_comparison_studio. aspx, accessed 2010.
  9. Elmasri, R. and Navathe, S. B. 2004. Fundamentals of DataBase Systems, Pearson Education, ISBN 0-321-12226-7, Fourth Edition.
  10. Chen, P. P. 2002. Entity-Relationship Modelling: Historical Events, Future Trends, and Lessons Learned, Springer- Verlag New York, Inc, 296-310.
  11. Saias, J. and Quaresma, P. 2003. A Methodology to Create Ontology-Based Information Retrieval Systems. Computer Science, Vol. 2902/2003, 424-434.
  12. Noy, N. F. and McGuinness, D. L. 2001. Ontology Development 101: A Guide to Creating Your First Ontology. Stanford Knowledge Systems Laboratory Technical Report KSL-01-05 and Stanford Medical Informatics Technical Report SMI-2001-0880.
  13. Liu, L. and TamerOzsu, M. 2008. Ontology. Entry in the Encyclopedia of Database Systems, Springer-Verlag.
  14. Tujarov, H. and Mihailov, I. 2004. ER model: semantic data models developing. ACM, ISBN: 954-9641-38-4.
  15. Davidson, L. 2008. Pro SQL Server 2008 Relational Database Design and Implementation. Apress, ISBN-13 (electronic): 978-1-4302-0867-9.
  16. Cullot, N. , Ghawi, R. and Yetongnon, K. 2007. B2OWL: A Tool for Automatic Database to Ontology Mapping. In Proc. Of 15th Italian Symposium on Advanced Database Systems (SEBD2007), 491-494,TorreCanne, Italy.
  17. Fritchman, B. L. , Guck, R. L. , Jagannathan, D. , Thompson, J. P. and Tolbret, D. M. 1989. SIM: design and implementation of a semantic database system. in:Proceedings of The ACM SIGMOD Conference, 46–55.
  18. Premerlani, W. and Blaha, M. 1994. An Approach for Reverse Engineering of Relational Databases. Communications of the ACM, Vol. 37, No. 5, 42–49.
  19. Ma, Z. M. and Yan, L. 2007. Fuzzy XML data modeling with the UML and relational data models. Data & Knowledge Engineering-DKE, Vol. 63, No. 3, 972-996.
  20. Hammer, M. and McLeod, D. 1981. Database Description with DM: A Semantic Database Model. ACM Transactions on Database Systems- TODS, Vol. 6, No. 3, 351-386.
  21. Rishe, N. Yuan, J. Athauda, R. Chen, S. Lu, X. Ma, X. Vaschillo, A. Shaposhnikov, A. and Vasilevsky. D. 2000. Semantic Access: Semantic Interface for Querying Databases. In Proc. Of the 26th VLDB, 591–594.
  22. Wimmer, M. 2009. A Meta – Framework for Generating Ontologies from Legacy Schemas. dexa, 474-479, 20th International Workshop on Database and Expert Systems Application.
  23. Hitzler, P. Krotzsch, M. Ehrig, M. and Sure, Y. 2005. What is Ontology Merging? American Association for Artificial Intelligence.
  24. Marchewka, J. T. and Liu, C. 2002. Mapping UML to XML: A Method for Teaching an Object-Oriented Approach to E-Business Development. Journal of Informatics Education and Research, 27-34.
  25. Rodrigues, T. Rosa, P. and Cardoso, J. 2006. Mapping XML to Existing OWL Ontologies. International Conference WWW/Internet.
Index Terms

Computer Science
Information Sciences


Data Migration Semantic Data Migration Semantic Database Ontology