Graduate School and Research Center in Digital Sciences

Meta-mappings for schema mapping reuse

Atzeni, Paolo; Bellomarini, Luigi; Papotti, Paolo; Torlone, Riccardo

VLDB 2019, 45th International Conference on Very Large Data Bases, August 26-30, 2019, Los Angeles, California, USA

The de nition of mappings between heterogeneous schemas is a critical activity of any database application. Existing tools provide high level interfaces for the discovery of correspondences between elements of schemas, but schema mappings need to be manually speci ed every time from scratch, even if the problem at hand is similar to one that has already been addressed. Schema mappings are precisely de ned over a pair of schemas and cannot directly be reused on different scenarios. We tackle this challenge by generalizing schema mappings as meta-mappings: formalisms that describe transformations between generic data structures called meta-schemas. We formally characterize schema mapping reuse and explain how meta-mappings are suitable to capture enterprise knowledge from previously de fined schema mappings. We develop the techniques to infer meta-mappings from existing mappings, to organize them into a searchable repository, and to leverage the repository to propose to the users mappings suitable for their needs. We study effectiveness and efficiency in an extensive evalu- ation over real-world scenarios, and show that our system can infer, store, and search millions of meta-mappings in seconds.

Document Doi Bibtex

Title:Meta-mappings for schema mapping reuse
Type:Conference
Language:English
City:Los Angeles
Country:UNITED STATES
Date:
Department:Data Science
Eurecom ref:5633
Copyright: © ACM, 2019. This is the author's version of the work. It is posted here by permission of ACM for your personal use. Not for redistribution. The definitive version was published in VLDB 2019, 45th International Conference on Very Large Data Bases, August 26-30, 2019, Los Angeles, California, USA http://dx.doi.org/10.14778/3303753.3303761
Bibtex: @inproceedings{EURECOM+5633, doi = {http://dx.doi.org/10.14778/3303753.3303761}, year = {2019}, title = {{M}eta-mappings for schema mapping reuse}, author = {{A}tzeni, {P}aolo and {B}ellomarini, {L}uigi and {P}apotti, {P}aolo and {T}orlone, {R}iccardo}, booktitle = {{VLDB} 2019, 45th {I}nternational {C}onference on {V}ery {L}arge {D}ata {B}ases, {A}ugust 26-30, 2019, {L}os {A}ngeles, {C}alifornia, {USA}}, address = {{L}os {A}ngeles, {UNITED} {STATES}}, month = {08}, url = {http://www.eurecom.fr/publication/5633} }
See also: