Alternative Development for Data Migration Using Dynamic Query Generation

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

doi:10.1515/acss-2016-0003

.blurhash-client-img { display: none !important; }

Alternative Development for Data Migration Using Dynamic Query Generation

Applied Computer Systems

Volume 19 (2016): Issue 1 (May 2016)

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

Open Access

|May 2016

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

Articles in this issue

DOI: https://doi.org/10.1515/acss-2016-0003 | Journal eISSN: 2255-8691 | Journal ISSN: 2255-8683

Journal RSS Feed

Language: English

Page range: 25 - 29

Published on: May 28, 2016

Published by: Riga Technical University

In partnership with: Paradigm Publishing Services

Publication frequency: Volume open

Keywords:

ETL,

Related subjects:

Artificial intelligence,

Information technology,

Project management,

Software development

© 2016 Johan Alfredo Romero-Ramírez, Carlos Enrique Montenegro-Marín, Vicente García-Díaz, Juan Manuel Cueva Lovelle, published by Riga Technical University
This work is licensed under the Creative Commons Attribution 4.0 License.

Volume 19 (2016): Issue 1 (May 2016)