Schema matching is a critical step in many applications, such as XML message mapping, data warehouse loading, and schema integration. The study investigates generic schema matching algorithms and proposes Cupid, an algorithm that discovers mappings between schema elements based on names, data types, constraints, and structure using a broader set of techniques. The authors present a taxonomy of past solutions and introduce Cupid, which integrates linguistic and structural matching, context-dependent matching of shared types, and a bias toward leaf structure to discover schema element mappings. Experimental results compare Cupid to two other schema matching systems.
Schema matching is a critical step in many applications, such as XML message mapping, data warehouse loading, and schema integration. In this paper, we investigate algorithms for generic schema matching, outside of any particular data model or application. We first present a taxonomy for past solutions, showing that a rich range of techniques is available. We then propose a new algorithm, Cupid, that discovers mappings between schema elements based on their names, data types, constraints, and schema structure, using a broader set of techniques than past approaches. Some of our innovations are the integrated use of linguistic and structural matching, context-dependent matching of shared types, and a bias toward leaf structure where much of the schema content resides. After describing our algorithm, we present experimental results that compare Cupid to two other schema matching systems.
12
George A. Miller · Communications of the ACM · 1995 · 14K citations · Full text
Natural Language Processing, Meaningful Words, Engineering +14
Reconciling schemas of disparate data sources
AnHai Doan, Pedro Domingos, Alon Halevy · 2001 · 729 citations
Schema Mapping as Query Discovery
Renée J. Miller, Laura M. Haas, Mauricio A. Hernández · Very Large Data Bases · 2000 · 437 citations
Using Schema Matching to Simplify Heterogeneous Data Translation
Tova Milo, Sagit Zohar · 1998 · 392 citations