Alternative Development for Data Migration Using Dynamic Query Generation

Romero-Ramírez, Johan Alfredo; Montenegro-Marín, Carlos Enrique; García-Díaz, Vicente; Lovelle, Juan Manuel Cueva

doi:10.1515/acss-2016-0003

Abstract

This article presents an ETL (Extract, Transform, Load) prototype called Valery as alternative approach to migration process which includes a compiler for dynamic generation of SQL queries. Its main features involve: SQL dynamic generation, set of configuration commands and environment for file uploading. The tests use the Northwind academic database and an individual environment. The model implementation uses flat files and SQL as query language. Finally, there is an analysis of the results obtained.

References

[1] J. Morris, Practical Data Migration, BCS. 2012, pp. 7, 8, 9, 10, 77, 164.
Search in Google Scholar
[2] C. Drumm, M Schmitt, H. H. Do and E. Rahm, “QuickMig. Automatic Schema Matching for Data Migration Projects,” in Proc. of the sixteenth ACM conf. on Conf. on information and knowledge management, CIKM’07, ACM New York, NY, USA, 2007, pp. 107–116. http://dx.doi.org/10.1145/1321440.1321458
Search in Google Scholar
[3] A. Bilke, J. Bleiholder, C. Böhm, K. Draba, F. Naumann, M. Weis, “Automatic Data Fusion with HumMer,” in Proc. of the 31st int. conf. on Very large data bases, VLDB '05, pp. 1251–1254, 2005.
Search in Google Scholar
[4] V. Ebai, What Is Sql?: Fundamentals of Sql, T-Sql, Pl/Sql and Datawarehousing, 2012, pp XI.
Search in Google Scholar
[5] K. Loudon, Mastering Algorithms with C, O Reilly Media, Inc. 2009, p. 206.
Search in Google Scholar
[6] A. D. Munoz, Metaheuristics. Ed. Dykinson, 2007, p. 12.
Search in Google Scholar
[7] B. R. Ullrey. Implementing a Data Warehouse: A Methodology that Worked. AuthorHouse, 2007, pp. 93–94.
Search in Google Scholar
[8] Z. Bellahsene, A. Bonifati, E. Rahm, Schema Matching and Mapping. Springer Science & Business Media. 2011, pp. 152, 153.
Search in Google Scholar
[9] A. D. Ionita, Migrating Legacy Applications: Challenges in Service Oriented Architecture and Cloud Computing Environments. 2012, pp. 210.10.4018/978-1-4666-2488-7
Search in Google Scholar
[10] S. Kedar, Database Management System, Technical Publications. 2009. p. 42.
Search in Google Scholar
[11] S. Sumathi, S. Esakkirajan, Fundamentals of Relational Database Management Systems. Springer, 2007, p. 26.10.1007/978-3-540-48399-1
Search in Google Scholar
[12] U. Donins, J. Osis, A. Slihte, E. Asnina and B. Gulbis, “Towards the Refinement of Topological Class Diagram as a Platform Independent Model,” in J. Osis, O. Nikiforova (Eds.). Model-Driven Architecture and Modeling-Driven Software Development. ENASE 2011, 3^rd Whs. MDA&MDSD, SciTePress, Portugal, 2011. pp. 79–88.
Search in Google Scholar
[13] J. Osis, E. Asnina, A. Grave, ”Computation Independent Representation of the Problem Domain in MDA,” e-Informatica Software Engineering J., vol. 2, issue 1, 2008, pp. 29–46.
Search in Google Scholar
[14] J. Osis, U. Donins, “Formalization of the UML Class Diagrams,” Evaluation of Novel Approaches to Software Engineering. Springer-Verlag, Berlin Heidelberg, New York, 2010, pp. 180–192. http://dx.doi.org/10.1007/978-3-642-14819-4_13
Search in Google Scholar
[15] J. Osis, A. Slihte, “Transforming Textual Use Cases to a Computation Independent Model,” in J. Osis, O. Nikiforova (Eds.). Model-Driven Architecture and Modeling Theory-Driven Development, ENASE 2010, 2^nd MDA&MTDD Whs., SciTePress, Portugal, 2010, pp. 33–42.
Search in Google Scholar
[16] A. Slihte, J. Osis and U. Donins, “Knowledge Integration for Domain Modeling,” in J. Osis, O. Nikiforova (Eds.). Model-Driven Architecture and Modeling-Driven Software Development. ENASE 2011, 3^rd Whs. MDA&MDSD, SciTePress, Portugal, 2011, pp. 46–56.
Search in Google Scholar

Alternative Development for Data Migration Using Dynamic Query Generation

Abstract

Paradigm

My account