tutorial

Model management and schema mappings: theory and practice

Authors:

Philip A. Bernstein,

Howard HoAuthors Info & Claims

VLDB '07: Proceedings of the 33rd international conference on Very large data bases

Pages 1439 - 1440

Published: 23 September 2007 Publication History

Get Access

Abstract

We present an overview of a tutorial on model management---an approach to solving data integration problems, such as data warehousing, e-commerce, object-to-relational mapping, schema evolution and enterprise information integration. Model management defines a small set of operations for manipulating schemas and mappings, such as Match, Compose, Inverse, and Merge. The long-term goal is to build generic implementations of the operations that can be applied to a wide variety of data integration problems.

References

[1]

P. A. Bernstein, A. Y. Halevy, R. Pottinger: A vision of management of complex models. SIGMOD Record 29(4): 55--63.

Digital Library

Google Scholar

[2]

P. A. Bernstein, S. Melnik: Model management 2.0: manipulating richer mappings. SIGMOD 2007: 1--12.

Digital Library

Google Scholar

[3]

L. M. Haas, M. A. Hernández, C. T. H. Ho, L. Popa. M. Roth: Clio grows up: from research prototype to industrial tool. SIGMOD 2005: 805--810.

Digital Library

Google Scholar

[4]

P. G. Kolaitis: Schema mappings, data exchange, and metadata management. PODS 2005: 61--75.

Digital Library

Google Scholar

[5]

S. Melnik, A. Adya, P. A. Bernstein: Compiling mappings to bridge applications and databases. SIGMOD 2007: 461--472.

Digital Library

Google Scholar

[6]

R. J. Miller, L. M. Haas, and M. A. Hernández: Schema Mapping as Query Discovery. VLDB 2000: 77--88.

Digital Library

Google Scholar

[7]

R. J. Miller, M. A. Hernández, L. M. Haas, L. Yan, H. Ho, R. Fagin, L. Popa: The Clio project: managing heterogeneity. SIGMOD Record 30(1): 78--83 (2001).

Digital Library

Google Scholar

[8]

E. Rahm, P. A. Bernstein: An online bibliography on schema evolution. SIGMOD Record 35(4): 30--31 (2006).

Digital Library

Google Scholar

[9]

M. Roth, M. A. Hernández, P. Coulthard, L.-L. Yan, L. Popa, C. T. H. Ho, C. C. Salter: XML mapping technology: Making connections in an XML-centric world. IBM Systems Journal 45(2): 389--410 (2006).

Digital Library

Google Scholar

Cited By

View all

Gilman EBugiotti FKhalid AMehmood HKostakos PTuovinen LYlipulli JSu XFerreira D(2024)Addressing Data Challenges to Drive the Transformation of Smart CitiesACM Transactions on Intelligent Systems and Technology10.1145/366348215:5(1-65)Online publication date: 7-Nov-2024
https://dl.acm.org/doi/10.1145/3663482
Rae IRollins EShute JSodhi SVingralek R(2013)Online, asynchronous schema change in F1Proceedings of the VLDB Endowment10.14778/2536222.25362306:11(1045-1056)Online publication date: 1-Aug-2013
https://dl.acm.org/doi/10.14778/2536222.2536230
Calvanese DDe Giacomo GLenzerini MVardi MMilo T(2011)Simplifying schema mappingsProceedings of the 14th International Conference on Database Theory10.1145/1938551.1938568(114-125)Online publication date: 21-Mar-2011
https://dl.acm.org/doi/10.1145/1938551.1938568
Show More Cited By

Recommendations

Composing schema mappings: second-order dependencies to the rescue
PODS '04: Proceedings of the twenty-third ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems

A schema mapping is a specification that describes how data structured under one schema (the source schema) is to be transformed into data structured under a different schema (the target schema). Schema mappings play a key role in numerous areas of ...
Quasi-inverses of schema mappings

Schema mappings are high-level specifications that describe the relationship between two database schemas. Two operators on schema mappings, namely the composition operator and the inverse operator, are regarded as especially important. Progress on the ...
Composing schema mappings: Second-order dependencies to the rescue
Special Issue: SIGMOD/PODS 2004

A schema mapping is a specification that describes how data structured under one schema (the source schema) is to be transformed into data structured under a different schema (the target schema). A fundamental problem is composing schema mappings: given ...

Comments

Information & Contributors

Information

Published In

VLDB '07: Proceedings of the 33rd international conference on Very large data bases

September 2007

1443 pages

ISBN:9781595936493

General Chairs:
Wolfgang Klas
University of Vienna, Austria
,
Erich J. Neuhold
Research Studio Digital Memory Engineering, Austria

Publisher

VLDB Endowment

Publication History

Published: 23 September 2007

Qualifiers

Tutorial

Conference

VLDB '07

Sponsor:

Intel
Microsoft Research
ORACLE
IBM

VLDB '07: Proceedings of the 33rd International Conference on Very Large Data Bases

September 23 - 27, 2007

Vienna, Austria

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

4
Total Citations
View Citations
370
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 08 Feb 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Gilman EBugiotti FKhalid AMehmood HKostakos PTuovinen LYlipulli JSu XFerreira D(2024)Addressing Data Challenges to Drive the Transformation of Smart CitiesACM Transactions on Intelligent Systems and Technology10.1145/366348215:5(1-65)Online publication date: 7-Nov-2024
https://dl.acm.org/doi/10.1145/3663482
Rae IRollins EShute JSodhi SVingralek R(2013)Online, asynchronous schema change in F1Proceedings of the VLDB Endowment10.14778/2536222.25362306:11(1045-1056)Online publication date: 1-Aug-2013
https://dl.acm.org/doi/10.14778/2536222.2536230
Calvanese DDe Giacomo GLenzerini MVardi MMilo T(2011)Simplifying schema mappingsProceedings of the 14th International Conference on Database Theory10.1145/1938551.1938568(114-125)Online publication date: 21-Mar-2011
https://dl.acm.org/doi/10.1145/1938551.1938568
Li XQuix CKensche DGeisler SHuang JKoudas NJones GWu XCollins-Thompson KAn A(2010)Automatic schema merging using mapping constraints among incomplete sourcesProceedings of the 19th ACM international conference on Information and knowledge management10.1145/1871437.1871479(299-308)Online publication date: 26-Oct-2010
https://dl.acm.org/doi/10.1145/1871437.1871479

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Abstract

References

Cited By

Recommendations

Composing schema mappings: second-order dependencies to the rescue

Quasi-inverses of schema mappings

Composing schema mappings: Second-order dependencies to the rescue

Comments

Information

Published In

Sponsors

Publisher

Publication History

Qualifiers

Conference

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

Login options

Full Access

View options

PDF

eReader

Share

Share this Publication link

Share on social media

Affiliations