Schema Mapping as Query Discovery

Authors: 
Miller, Renee; Haas, Laura; Hernandez, Mauricio
Author: 
Miller, R
Haas, L
Hernandez, M
Year: 
2000
Venue: 
Proc. 26th VLDB, 2000
URL: 
http://www.vldb.org/conf/2000/P077.pdf
Citations: 
454
Citations range: 
100 - 499
AttachmentSize
Miller2000SchemaMappingasQuery.pdf348.04 KB

To enable modern data intensive applications we must solve the data 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 a 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.