Model Management Engine for Data Integration with Reverse-Engineering Support

  • Authors:

  • Michael N. Gubanov;Philip A. Bernstein;Alexander Moshchuk

  • Affiliations:

  • Computer Science and Engineering, University of Washington, Box 352350, Seattle, WA 98195, USA. mgubanov@cs.washington.edu;Microsoft Corporation, One Microsoft Way, Redmond, WA 98052, USA. philbe@microsoft.com;Computer Science and Engineering, University of Washington, Box 352350, Seattle, WA 98195, USA. anm@cs.washington.edu

  • Venue:
  • ICDE '08 Proceedings of the 2008 IEEE 24th International Conference on Data Engineering
  • Year:
  • 2008

Quantified Score

Hi-index 0.00

Visualization

Abstract

Model management is a high-level programming language designed to efficiently manipulate schemas and mappings. It is comprised of robust operators that combined in short programs can solve complex metadata-oriented problems in a compact way. For instance, countless enterprise data integration scenarios can be easily expressed in this high-level language thus saving hundreds of development man-hours. Here we present the first model management engine that has reverse-engineering support for data integration, which is one of the most pressing metadata-oriented problems. It merges two schemas based on the mappings between them and allows user to correct the result keeping all the mappings in sync automatically. For user it is much more convenient than determining which mappings to correct in order to get desired result. In addition, the engine supports restructuring merging which is important when the sources are structured differently and cannot be mapped directly. While making schema merging fully automatic is not yet possible, our work simplifies and automates this process to make it practical in complex data integration scenarios.