Abstract
In a typical data migration project, analysts identify the mappings between source and target data models at a conceptual level using informal textual descriptions. An implementation team translates these mappings into programs that migrate the data. While doing so, the programmers have to understand how the conceptual models and business rules map to physical databases. We propose a modeling mechanism where we can specify conceptual models, physical models and mappings between them in a formal manner. We can also specify rules on conceptual models. From these models and mappings, we can automatically generate a program to migrate data from source to target. We can also generate a program to migrate data access queries from source to target. The overall approach results in a significant improvement in productivity and also a significant reduction in migration errors.
Chapter PDF
Similar content being viewed by others
References
Abiteboul S., Hull R., Vianu V. Foundations of Databases. Addison Wesley, Reading, Mass., USA (1995)
Ullman, J.D.: Information integration using logical views. In: Afrati, F.N., Kolaitis, P.G. (eds.) ICDT 1997. LNCS, vol. 1186, pp. 19–40. Springer, Heidelberg (1996)
Ullman, J.D.: Principles of database and knowledge-base systems, vol. I, II. Computer Science, Rockville, Md., USA (1989)
Halevy, A.Y.: Answering queries using views: A survey. The VLDB Journal 10(4), 270–294 (2001)
Maurizio, L.: Data integration: a theoretical perspective. In: Proceedings of the Twenty-First ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems. ACM (2002)
Skoutas, D., Simitsis, A.: Designing ETL processes using semantic web technologies. In: Proceedings of the 9th ACM International Workshop on Data Warehousing and OLAP. ACM (2006)
Muñoz, L., Mazón, J.-N., Trujillo, J.: Automatic generation of ETL processes from conceptual models. In: Proceedings of the ACM Twelfth International Workshop on Data Warehousing and OLAP. ACM (2009)
Vassiliadis, P., Simitsis, A.: Extraction, transformation, and loading. Encyclopedia of Database Systems. Springer US, pp. 1095-1101 (2009)
Kulkarni, V., Reddy, S.: A model-driven architectural framework for integration-capable enterprise application product lines. In: IEEE European Conference on Model Driven Architecture - Foundations and Applications, Bilbao, Spain, July 2006
Dayal, U., et al.: Data integration flows for business intelligence. In: Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology. ACM (2009)
Dessloch, S., et al.: Orchid: integrating schema mapping and etl. In: IEEE 24th International Conference on Data Engineering, ICDE 2008. IEEE (2008)
Abinitio, March 2014. http://www.abinitio.com/#prod-cs
Informatica, March 2014. http://www.informatica.com/in/solutions/enterprise-data-integration-and-management/data-migration/
Talend, March 2014. http://www.talend.com/solutions/data-migration
Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. The VLDB Journal (2001)
Shvaiko, P., Euzenat, J.: A survey of schema-based matching approaches. In: Spaccapietra, S. (ed.) Journal on Data Semantics IV. LNCS, vol. 3730, pp. 146–171. Springer, Heidelberg (2005)
Unifed Modeling Language. www.omg.org/spec/UML
Semantic Web Rule Language. http://www.w3.org/Submission/SWRL/#2
Object Query Language. Wikipedia. en.wikipedia.org/wiki/Object_Query_Language
Cohen, S., Nutt, W., Serebrenik, A.: Algorithms for rewriting aggregate queries using views. In: Masunaga, Y., Thalheim, B., Štuller, J., Pokorný, J. (eds.) ADBIS 2000 and DASFAA 2000. LNCS, vol. 1884, pp. 65–78. Springer, Heidelberg (2000)
ACORD. https://www.acord.org/
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
Yeddula, R.R., Das, P., Reddy, S. (2015). A Model-Driven Approach to Enterprise Data Migration. In: Zdravkovic, J., Kirikova, M., Johannesson, P. (eds) Advanced Information Systems Engineering. CAiSE 2015. Lecture Notes in Computer Science(), vol 9097. Springer, Cham. https://doi.org/10.1007/978-3-319-19069-3_15
Download citation
DOI: https://doi.org/10.1007/978-3-319-19069-3_15
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-19068-6
Online ISBN: 978-3-319-19069-3
eBook Packages: Computer ScienceComputer Science (R0)