To enable modern data intensive applications including data warehousing, global information systems and electronic commerce, we must solve the schema mapping problem in which a source (legacy) database is mapped into a different, but fixed, target schema. Schema mapping involves the discovery of a query or set of queries that transform the source data into the new structure. We introduce an interactive mapping creation paradigm based on value correspondences that show how a value of a target attribute can be created from a set of values of source attributes. We describe the use of the value correspondence framework in Clio, a prototype tool for semi-automated schema mapping, and present an algorithm for query derivation from an evolving set of value correspondences.
CITATION STYLE
Miller, R. J., Haas, L. M., & Hernández, M. A. (2000). Schema mapping as query discovery. In Proceedings of the 26th International Conference on Very Large Data Bases, VLDB’00 (pp. 77–88).
Mendeley helps you to discover research relevant for your work.