Abstract
Schema mappings are fundamental notions in data exchange and integration for relating source and target schemas. Visual mapping languages provide graphical means to visually describe such transformations. There is a plethora of tools and languages available however all use different notions and visualizations and are hardly extensible.
In this paper we propose a new universal layer Umap for schema mapping languages which provides a unified abstraction and middleware for high-level visual mapping languages. We use only standardized Uml and OCL artifacts which allow for easy code generation in a number of target languages (e.g.C++ code) and for a modular extension mechanism to support complex schema mappings. We illustrate our layer by translating key elements of Clip, a recent expressive visual mapping language, and show that Umap has enough expressive power to encode all Clip features. Moreover, we outline a strategy for automating the translation of any visual input language with a formal meta-model to Umap.
This work was supported by the Austrian Science Fund (FWF), project P25207-N23.
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
Preview
Unable to display preview. Download preview PDF.
References
Fagin, R., Kolaitis, P.G., Popa, L., Tan, W.C.: Composing schema mappings: Second-order dependencies to the rescue. ACM TODS 30(4), 994–1055 (2005)
Lenzerini, M.: Data integration: a theoretical perspective. In: PODS. ACM (2002)
Popa, L., Velegrakis, Y., Hernández, M.A., Miller, R.J., Fagin, R.: Translating web data. In: CAiSE 2002 and VLDB 2002, pp. 598–609. Morgan Kaufmann (2002)
Fuxman, A., Hernandez, M.A., Ho, H., Miller, R.J., Papotti, P., Popa, L.: Nested mappings: schema mapping reloaded. In: VLDB, pp. 67–78 (2006)
Raffio, A., Braga, D., Ceri, S., Papotti, P., Hernández, M.A.: Clip: a visual language for explicit schema mappings. In: ICDE 2008, pp. 30–39 (2008)
Alexe, B., ten Cate, B., Kolaitis, P.G., Tan, W.C.: Designing and refining schema mappings via data examples. In: SIGMOD Conference, pp. 133–144 (2011)
OMG: Unified Modeling Language Superstructure 2.4.1. (2011), www.omg.org
OMG: Object Constraint Language 2.3.1. (2012), http://www.omg.org
Berardi, D., Calvanese, D., De Giacomo, G.: Reasoning on UML class diagrams. Artificial Intelligence 168(1-2), 70–118 (2005)
Beckert, B., Keller, U., Schmitt, P.: Translating the Object Constraint Language into first-order predicate logic. In: VERIFY, FLoC (2002)
Fagin, R., Kolaitis, P.G., Miller, R.J., Popa, L.: Data exchange: semantics and query answering. Theor. Comput. Sci. 336(1), 89–124 (2005)
OMG: Unified Modeling Language Infrastructure 2.4.1. (2011), www.omg.org
Meyer, B.: Introduction to the Theory of Programming Languages. P.-H. (1990)
Chertes, F.: DBAI-TR-2012-76. Technical report, DBAI, TU Wien (2012)
Akehurst, D.H., Bordbar, B.: On querying UML data models with OCL. In: Gogolla, M., Kobryn, C. (eds.) UML 2001. LNCS, vol. 2185, pp. 91–103. Springer, Heidelberg (2001)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Chertes, F., Feinerer, I. (2013). UMAP: A Universal Layer for Schema Mapping Languages. In: Decker, H., Lhotská, L., Link, S., Basl, J., Tjoa, A.M. (eds) Database and Expert Systems Applications. DEXA 2013. Lecture Notes in Computer Science, vol 8056. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-40173-2_28
Download citation
DOI: https://doi.org/10.1007/978-3-642-40173-2_28
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-40172-5
Online ISBN: 978-3-642-40173-2
eBook Packages: Computer ScienceComputer Science (R0)