Title
Translating Web Data
Abstract
We present a novel framework for mapping between any combination of XML and relational schemas, in which a high-level, user-specified mapping is translated into semantically meaningful queries that transform source data into the target representation. Our approach works in two phases. In the first phase, the high-level mapping, expressed as a set of inter-schema correspondences, is converted into a set of mappings that capture the design choices made in the source and target schemas (including their hierarchical organization as well as their nested referential constraints). The second phase translates these mappings into queries over the source schemas that produce data satisfying the constraints and structure of the target schema, and preserving the semantic relationships of the source. Nonnull target values may need to be invented in this process. The mapping algorithm is complete in that it produces all mappings that are consistent with the schema constraints. We have implemented the translation algorithm in Clio, a schema mapping tool, and present our experience using Clio on several real schemas.
Year
Venue
Keywords
2002
VLDB
nonnull target value,target schema,schema mapping tool,high-level mapping,source schema,source data,user-specified mapping,target representation,translating web data,real schema,mapping algorithm,satisfiability
Field
DocType
ISSN
Data mining,XML,Computer science,Source data,Theoretical computer science,Schema mapping,Mapping algorithm,Schema (psychology),Database,Hierarchical organization
Conference
VLDB '02: Proceedings of the 28th International Conference on Very Large Databases
Citations 
PageRank 
References 
250
18.28
20
Authors
5
Search Limit
100250
Name
Order
Citations
PageRank
Lucian Popa144428.86
Yannis Velegrakis2112885.30
Renée J. Miller33545373.59
Mauricio A. Hernández41960197.19
Ronald Fagin588082643.66