Skip to main content
Top

2011 | OriginalPaper | Chapter

7. Schema Mapping Evolution Through Composition and Inversion

Authors : Ronald Fagin, Phokion G. Kolaitis, Lucian Popa, Wang-Chiew Tan

Published in: Schema Matching and Mapping

Publisher: Springer Berlin Heidelberg

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

Mappings between different representations of data are the essential building blocks for many information integration tasks. A schema mapping is a high-level specification of the relationship between two schemas, and represents a useful abstraction that specifies how the data from a source format can be transformed into a target format. The development of schema mappings is laborious and time consuming, even in the presence of tools that facilitate this development. At the same time, schema evolution inevitably causes the invalidation of the existing schema mappings (since their schemas change). Providing tools and methods that can facilitate the adaptation and reuse of the existing schema mappings in the context of the new schemas is an important research problem. In this chapter, we show how two fundamental operators on schema mappings, namely composition and inversion, can be used to address the mapping adaptation problem in the context of schema evolution. We illustrate the applicability of the two operators in various concrete schema evolution scenarios, and we survey the most important developments on the semantics, algorithms, and implementation of composition and inversion. We also discuss the main research questions that still remain to be addressed.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Footnotes
1
These were introduced in Fagin et al. (2009b) under a different name: universal-faithful inverses. However, the term relaxed chase-inverses, which we use in this paper, is a more suggestive term that also reflects the relationship with the chase-inverses.
 
2
A stricter version of LAV s-t tgds, where no repeated variables in the left-hand side Q(x) are allowed and all variables in xappear in the right-hand side, is also used in literature. We refer to this type of LAV s-t tgds as strictLAV s-t tgds.
 
3
Note that it is logically equivalent to the earlier way we expressed \(\mathcal{M}\circ \mathcal{M} \), and where the roles of coand co′were switched.
 
4
In fact, that is how Madhavan and Halevy defined composition of schema mappings.
 
Literature
.
go back to reference Alexe B, Hernández MA, Popa L, Tan WC (2010) MapMerge: Correlating independent schema mappings. In: PVLDB, vol 3(1), pp 81–92 Alexe B, Hernández MA, Popa L, Tan WC (2010) MapMerge: Correlating independent schema mappings. In: PVLDB, vol 3(1), pp 81–92
.
go back to reference Arenas M, Pérez J, Riveros C (2008) The recovery of a schema mapping: Bringing exchanged data back. In: PODS. ACM, NY, pp 13–22 Arenas M, Pérez J, Riveros C (2008) The recovery of a schema mapping: Bringing exchanged data back. In: PODS. ACM, NY, pp 13–22
.
go back to reference Bernstein PA (2003) Applying model management to classical meta-data problems. In: Conference on innovative data systems research (CIDR), Asilomar, CA, pp 209–220 Bernstein PA (2003) Applying model management to classical meta-data problems. In: Conference on innovative data systems research (CIDR), Asilomar, CA, pp 209–220
.
go back to reference Bernstein PA, Green TJ, Melnik S, Nash A (2008) Implementing mapping composition. VLDB J 17(2):333–353CrossRef Bernstein PA, Green TJ, Melnik S, Nash A (2008) Implementing mapping composition. VLDB J 17(2):333–353CrossRef
.
go back to reference Chandra AK, Merlin PM (1977) Optimal implementation of conjunctive queries in relational data bases. In: ACM symposium on theory of computing (STOC). ACM, NY, pp 77–90 Chandra AK, Merlin PM (1977) Optimal implementation of conjunctive queries in relational data bases. In: ACM symposium on theory of computing (STOC). ACM, NY, pp 77–90
.
go back to reference Curino C, Moon HJ, Zaniolo C (2008) Graceful database schema evolution: The PRISM workbench. PVLDB 1(1):761–772 Curino C, Moon HJ, Zaniolo C (2008) Graceful database schema evolution: The PRISM workbench. PVLDB 1(1):761–772
.
go back to reference Deutsch A, Tannen V (2003) MARS: A system for publishing XML from mixed and redundant storage. In: International conference on very large data bases (VLDB). VLDB Endowment,pp 201–212 Deutsch A, Tannen V (2003) MARS: A system for publishing XML from mixed and redundant storage. In: International conference on very large data bases (VLDB). VLDB Endowment,pp 201–212
.
go back to reference Deutsch A, Popa L, Tannen V (1999) Physical data independence, constraints and optimization with universal plans. In: International conference on very large data bases (VLDB). Morgan Kaufmann, CA, pp 459–470 Deutsch A, Popa L, Tannen V (1999) Physical data independence, constraints and optimization with universal plans. In: International conference on very large data bases (VLDB). Morgan Kaufmann, CA, pp 459–470
.
go back to reference Deutsch A, Popa L, Tannen V (2006) Query reformulation with constraints. SIGMOD Rec 35(1):65–73CrossRef Deutsch A, Popa L, Tannen V (2006) Query reformulation with constraints. SIGMOD Rec 35(1):65–73CrossRef
.
go back to reference Fagin R (2007) Inverting schema mappings. ACM Trans Database Syst (TODS) 32(4), Article No. 11 Fagin R (2007) Inverting schema mappings. ACM Trans Database Syst (TODS) 32(4), Article No. 11
.
go back to reference Fagin R, Kolaitis PG, Popa L, Tan WC (2004) Composing schema mappings: Second-order dependencies to the rescue. In: ACM symposium on principles of database systems (PODS). ACM, NY, pp 83–94 Fagin R, Kolaitis PG, Popa L, Tan WC (2004) Composing schema mappings: Second-order dependencies to the rescue. In: ACM symposium on principles of database systems (PODS). ACM, NY, pp 83–94
.
go back to reference Fagin R, Kolaitis PG, Miller RJ, Popa L (2005a) Data exchange: Semantics and query answering. Theor Comput Sci (TCS) 336(1):89–124MathSciNetMATHCrossRef Fagin R, Kolaitis PG, Miller RJ, Popa L (2005a) Data exchange: Semantics and query answering. Theor Comput Sci (TCS) 336(1):89–124MathSciNetMATHCrossRef
.
go back to reference Fagin R, Kolaitis PG, Popa L, Tan WC (2005b) Composing schema mappings: Second-order dependencies to the rescue. ACM Trans Database Syst (TODS) 30(4):994–1055CrossRef Fagin R, Kolaitis PG, Popa L, Tan WC (2005b) Composing schema mappings: Second-order dependencies to the rescue. ACM Trans Database Syst (TODS) 30(4):994–1055CrossRef
.
go back to reference Fagin R, Kolaitis PG, Nash A, Popa L (2008a) Towards a theory of schema-mapping optimization. In: ACM symposium on principles of database systems (PODS). ACM, NY, pp 33–42 Fagin R, Kolaitis PG, Nash A, Popa L (2008a) Towards a theory of schema-mapping optimization. In: ACM symposium on principles of database systems (PODS). ACM, NY, pp 33–42
.
go back to reference Fagin R, Kolaitis PG, Popa L, Tan WC (2008b) Quasi-inverses of schema mappings. ACM Trans Database Syst (TODS) 33(2), Article No. 11 Fagin R, Kolaitis PG, Popa L, Tan WC (2008b) Quasi-inverses of schema mappings. ACM Trans Database Syst (TODS) 33(2), Article No. 11
.
go back to reference Fagin R, Haas LM, Hernández MA, Miller RJ, Popa L, Velegrakis Y (2009a) Clio: Schema mapping creation and data exchange. In: Conceptual modeling: Foundations and applications, Essays in Honor of John Mylopoulos. Springer, Heidelberg, pp 198–236 Fagin R, Haas LM, Hernández MA, Miller RJ, Popa L, Velegrakis Y (2009a) Clio: Schema mapping creation and data exchange. In: Conceptual modeling: Foundations and applications, Essays in Honor of John Mylopoulos. Springer, Heidelberg, pp 198–236
.
go back to reference Fagin R, Kolaitis PG, Popa L, Tan WC (2009b) Reverse data exchange: Coping with nulls. In: ACM symposium on principles of database systems (PODS). ACM, NY, pp 23–32 Fagin R, Kolaitis PG, Popa L, Tan WC (2009b) Reverse data exchange: Coping with nulls. In: ACM symposium on principles of database systems (PODS). ACM, NY, pp 23–32
.
go back to reference Fagin R, Kolaitis PG, Popa L, Tan WC (2010) Reverse data exchange: Coping with nulls. In: ACM symposium on principles of database systems (PODS). ACM, NY, pp 23–32 Fagin R, Kolaitis PG, Popa L, Tan WC (2010) Reverse data exchange: Coping with nulls. In: ACM symposium on principles of database systems (PODS). ACM, NY, pp 23–32
.
go back to reference Haas LM, Hernández MA, Ho H, Popa L, Roth M (2005) Clio grows up: From research prototype to industrial tool. In: SIGMOD. ACM, NY, pp 805–810 Haas LM, Hernández MA, Ho H, Popa L, Roth M (2005) Clio grows up: From research prototype to industrial tool. In: SIGMOD. ACM, NY, pp 805–810
.
go back to reference Hartung M, Terwilliger J, Rahm E (2011) Recent advances in schema and ontology evolution. In: Bellahsene Z, Bonifati A, Rahm E (eds) Schema matching and mapping. Data-Centric Systems and Applications Series. Springer, Heidelberg Hartung M, Terwilliger J, Rahm E (2011) Recent advances in schema and ontology evolution. In: Bellahsene Z, Bonifati A, Rahm E (eds) Schema matching and mapping. Data-Centric Systems and Applications Series. Springer, Heidelberg
.
go back to reference Lenzerini M (2002) Data integration: A theoretical perspective. In: ACM symposium on principles of database systems (PODS). ACM, NY, pp 233–246 Lenzerini M (2002) Data integration: A theoretical perspective. In: ACM symposium on principles of database systems (PODS). ACM, NY, pp 233–246
.
go back to reference Madhavan J, Halevy AY (2003) Composing mappings among data sources. In: International conference on very large data bases (VLDB). VLDB Endowment, pp 572–583 Madhavan J, Halevy AY (2003) Composing mappings among data sources. In: International conference on very large data bases (VLDB). VLDB Endowment, pp 572–583
.
go back to reference Melnik S (2004) Generic model management: Concepts and algorithms. Lecture Notes in Computer Science, vol 2967. Springer, Heidelberg Melnik S (2004) Generic model management: Concepts and algorithms. Lecture Notes in Computer Science, vol 2967. Springer, Heidelberg
.
go back to reference Melnik S, Bernstein PA, Halevy A, Rahm E (2005) Applying model management to executable mappings. In: SIGMOD, ACM, NY, pp 167–178 Melnik S, Bernstein PA, Halevy A, Rahm E (2005) Applying model management to executable mappings. In: SIGMOD, ACM, NY, pp 167–178
.
go back to reference Nash A, Bernstein PA, Melnik S (2005) Composition of mappings given by embedded dependencies. In: ACM symposium on principles of database systems (PODS). ACM, NY,pp 172–183 Nash A, Bernstein PA, Melnik S (2005) Composition of mappings given by embedded dependencies. In: ACM symposium on principles of database systems (PODS). ACM, NY,pp 172–183
.
go back to reference Shu NC, Housel BC, Taylor RW, Ghosh SP, Lum VY (1977) EXPRESS: A data extraction, processing, amd restructuring system. ACM Trans Database Syst (TODS) 2(2):134–174CrossRef Shu NC, Housel BC, Taylor RW, Ghosh SP, Lum VY (1977) EXPRESS: A data extraction, processing, amd restructuring system. ACM Trans Database Syst (TODS) 2(2):134–174CrossRef
.
go back to reference Velegrakis Y, Miller RJ, Popa L (2003) Mapping adaptation under evolving schemas. In: International conference on very large data bases (VLDB). VLDB Endowment, pp 584–595 Velegrakis Y, Miller RJ, Popa L (2003) Mapping adaptation under evolving schemas. In: International conference on very large data bases (VLDB). VLDB Endowment, pp 584–595
.
go back to reference Yu C, Popa L (2005) Semantic adaptation of schema mappings when schemas evolve. In: VLDB. VLDB Endowment, pp 1006–1017 Yu C, Popa L (2005) Semantic adaptation of schema mappings when schemas evolve. In: VLDB. VLDB Endowment, pp 1006–1017
Metadata
Title
Schema Mapping Evolution Through Composition and Inversion
Authors
Ronald Fagin
Phokion G. Kolaitis
Lucian Popa
Wang-Chiew Tan
Copyright Year
2011
Publisher
Springer Berlin Heidelberg
DOI
https://doi.org/10.1007/978-3-642-16518-4_7

Premium Partner