skip to main content
research-article

EIRENE: interactive design and refinement of schema mappings via data examples

Published:01 August 2011Publication History
Skip Abstract Section

Abstract

One of the first steps in the process of integrating information from multiple sources into a desired target format is to specify the relationships, called schema mappings, between the source schemas and the target schema. In this demonstration, we showcase a new methodology for designing schema mappings. Our system Eirene interactively solicits data examples from the mapping designer in order to design a schema mapping between a source schema and a target schema. A data example, in this context, is a pair consisting of a source instance and a target instance showing the desired outcome of performing data exchange using the schema mapping being designed. One of the central parts of the system is a module that, given a set of data examples, either returns a "best" fitting schema mapping, or reports that no fitting schema mapping exists.

References

  1. B. Alexe, W. C. Tan, and Y. Velegrakis. STBenchmark: Towards a Benchmark for Mapping Systems. PVLDB, 1(1):230--244, 2008.Google ScholarGoogle Scholar
  2. B. Alexe, B. ten Cate, P. G. Kolaitis, and W.-C. Tan. Designing and Refining Schema Mappings via Data Examples. In ACM SIGMOD International Conference on Management of Data (SIGMOD), 2011 (to appear).Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. A. Bonifati, E. Q. Chang, T. Ho, V. S. Lakshmanan, and R. Pottinger. HePToX: Marrying XML and Heterogeneity in Your P2P Databases. In VLDB, pages 1267--1270, 2005.Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. R. Fagin, P. G. Kolaitis, R. J. Miller, and L. Popa. Data Exchange: Semantics and Query Answering. TCS, 336(1):89--124, 2005.Google ScholarGoogle Scholar
  5. L. M. Haas, M. A. Hernández, H. Ho, L. Popa, and M. Roth. Clio Grows Up: From Research Prototype to Industrial Tool. In ACM SIGMOD, pages 805--810, 2005.Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. P. G. Kolaitis. Schema Mappings, Data Exchange, and Metadata Management. In ACM PODS, pages 61--75, 2005.Google ScholarGoogle Scholar
  7. M. Lenzerini. Data Integration: A Theoretical Perspective. In ACM PODS, pages 233--246, 2002.Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. EIRENE: interactive design and refinement of schema mappings via data examples
            Index terms have been assigned to the content through auto-classification.

            Recommendations

            Comments

            Login options

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

            Sign in

            Full Access

            • Published in

              cover image Proceedings of the VLDB Endowment
              Proceedings of the VLDB Endowment  Volume 4, Issue 12
              August 2011
              303 pages

              Publisher

              VLDB Endowment

              Publication History

              • Published: 1 August 2011
              Published in pvldb Volume 4, Issue 12

              Qualifiers

              • research-article

            PDF Format

            View or Download as a PDF file.

            PDF

            eReader

            View online with eReader.

            eReader