Abstract
Model Driven Engineering (MDE) aims to make face to the development, maintenance and evolution of complex software systems, focusing in models and model transformations. This approach can be employed in other domains such as database schema integration. In this paper, we propose a framework based on MDE to integrate database schema. In MDE context, database schema are viewed as database model. A metamodel for creating database models, an algorithm for database model matching and an algorithm for database model merging are presented. We provide a prototype that extends the MT4MDE and SAMT4MDE tools in order to demonstrate the implementation of our proposed framework. An illustrative example helps to understand our proposed framework.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
E. Rahm and P. A. Bernstein, "A survey of approaches to automatic schema matching," The VLDB Journal, vol. 10, no. 4, pp. 334-350, #dec# 2001.
P. A. Bernstein, "Applying Model Management to Classical Meta Data Problems," in CIDR, 2003.
J. Madhavan, P. A. Bernstein and E. Rahm, "Generic Schema Matching with Cupid," in Proceedings of the 27th International Conference on Very Large Data Bases, San Francisco, CA, USA, 2001.
P. A. Bernstein, J. Madhavan and E. Rahm, "Generic Schema Matching, Ten Years Later.," PVLDB, vol. 4, no. 11, pp. 695-701, 2011.
M. D. Del Fabro and P. Valduriez, "Semi-automatic model integration using matching transformations and weaving models," in Proceedings of the 2007 ACM symposium on Applied computing, New York, NY, USA, 2007.
L. Popa, Y. Velegrakis, R. Miller, M. Hernandez and R. Fagin, "Mapping Generation and Data Translation of Heterogeneous Web Data," in International Workshop on Data Integration over the Web (DIWeb), 2002.
A. Kleppe, J. Warmer and W. Bast, MDA Explained: The Model Driven Architecture: Practice and Promise, 1st ed., Addison-Wesley, 2003, p. 170.OMG, Object Management Group, Available at http://www.omg.org/, Acessed at 17-05-2013, 2013.
OMG, Object Management Group, Available at http://www.omg.org/, Acessed at 17-05-2013, 2013
EMF, Eclipse Modeling Framework Project, Available at http://www.eclipse.org/modeling/emf/. Acessed at 05/05/2013., 2013.
R. Pottinger and P. A. Bernstein, "Schema merging and mapping creation for relational sources," in Proceedings of the 11th international conference on Extending database technology: Advances in database technology, New York, NY, USA, 2008.
S. Melnik, E. Rahm and P. A. Bernstein, "Rondo: a programming platform for generic model management," pp. 193-204, 2003.
M. A. Hernández, R. J. Miller and L. M. Haas, "Clio: a semi-automatic tool for schema mapping," SIGMOD Rec., vol. 30, no. 2, pp. 607--, #may# 2001.
S. Massmann, S. Raunich, D. Aumuller, P. Arnold and E. Rahm, "{Evolution of the COMA Match System}," in The Sixth International Workshop on Ontology Matching, 2011.
D. Lopes, S. Hammoudi, J. de Souza and A. Bontempo, "Metamodel Matching: Experiments and Comparison," in Software Engineering Advances, International Conference on, 2006.
ATLAS, "ATL: Atlas Transformation Language - ATL User Manual version 0.7," 2006.
D. Lopes, H. Slimane and Z. Abdelouahab, "Schema Matching in the Context of Model Driven Engineering: From Theory to Practice," In: Advances in Systems, Computing Sciences and Software Engineering ed.: Springer 2006, 2006.
R. Pottinger and P. A. Bernstein, "Associativity and Commutativity in Generic Merge," pp. 254-272, 2009.
Acknowledgment
The work described in this paper is supported by CAPES, FAPEMA (through the grant APP-00944/09) and CNPq (through the grant 560231/2010-5).
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
Carvalho, M.V., Lopes, D., Abdelouahab, Z. (2015). A Framework Based on Model Driven Engineering to Support Schema Merging in Database Systems. In: Elleithy, K., Sobh, T. (eds) New Trends in Networking, Computing, E-learning, Systems Sciences, and Engineering. Lecture Notes in Electrical Engineering, vol 312. Springer, Cham. https://doi.org/10.1007/978-3-319-06764-3_49
Download citation
DOI: https://doi.org/10.1007/978-3-319-06764-3_49
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-06763-6
Online ISBN: 978-3-319-06764-3
eBook Packages: EngineeringEngineering (R0)