DBScholar

Back to papers

iMAP: Discovering Complex Semantic Matches between Database Schemas

Summary: iMAP semi-automates schema matching beyond 1-1 by exploring a large/infinite space for complex matches (e.g., address = concat(city, state)). It uses specialized searchers, domain knowledge, integrity constraints, and overlap data, with explanations to justify matches and accelerate convergence on real-world schemas. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
3596
Venue
SIGMOD
Year
2004
Pagerank
9.4490491e-05
Overall Rank
1,939 | 86.70%
DOI
10.1145/1007568.1007612

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{dhamankar_sigmod04,
        title = {{iMAP: Discovering Complex Semantic Matches between Database Schemas}},
        author = {Dhamankar, Robin and Lee, Yoonkyong and Doan, AnHai and Halevy, Alon and Domingos, Pedro},
        series = {{SIGMOD} '04},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1007568.1007612},
        url = {https://dl.acm.org/doi/10.1145/1007568.1007612},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 16 of 16 citing papers.

Rank Citing Paper Year Venue Pagerank
856 How to ConQueR Why-Not Questions 2010 SIGMOD 0.00013573466
1,649 Bootstrapping Pay-As-You-Go Data Integration Systems 2008 SIGMOD 0.00010117306
2,538 Tuning Schema Matching Software using Synthetic Scenarios 2005 VLDB 8.4548936e-05
2,980 Auto-Join: Joining Tables by Leveraging Transformations 2017 VLDB 7.8975073e-05
3,181 InfoGather+: Semantic Matching and Annotation of Numeric and Time-Varying Attributes in Web Tables 2013 SIGMOD 7.6595256e-05
3,294 Multi-column Substring Matching for Database Schema Translation 2006 VLDB 7.5491351e-05
3,746 Discovering Linkage Points over Web Data 2013 VLDB 7.1561558e-05
4,412 Auto-Transform: Learning-to-Transform by Patterns 2020 VLDB 6.7168614e-05
5,064 Mapping Maintenance for Data Integration Systems 2005 VLDB 6.3783698e-05
6,252 Putting Context into Schema Matching 2006 VLDB 5.941182e-05
6,436 Synthesizing Type-Detection Logic for Rich Semantic Data Types using Open-source Code 2018 SIGMOD 5.8793793e-05
6,461 Explain3D: Explaining Disagreements in Disjoint Datasets 2019 VLDB 5.8718966e-05
7,013 Synthesizing Products for Online Catalogs 2011 VLDB 5.7262474e-05
8,630 Extending Relational Query Optimization to Dynamic Schemas for Information Integration in Multidatabases 2007 SIGMOD 5.3967753e-05
8,664 Just-In-Time Query Retrieval Over Partially Indexed Data on Structured P2P Overlays 2008 SIGMOD 5.3887668e-05
9,015 Analyzing and Revising Data Integration Schemas to Improve Their Matchability 2008 VLDB 5.3321017e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
22 Data Integration: A Theoretical Perspective 2002 PODS 0.00056204792
263 Reconciling Schemas of Disparate Data Sources: A Machine-Learning Approach 2001 SIGMOD 0.0002305693
297 Generic Schema Matching with Cupid 2001 VLDB 0.00022157284
390 COMA - A system for flexible combination of schema matching approaches 2002 VLDB 0.00019382486
432 Mining Database Structure; Or, How to Build a Data Quality Browser 2002 SIGMOD 0.00018572055
454 Using Schema Matching to Simplify Heterogeneous Data Translation 1998 VLDB 0.00018133578
778 Statistical Schema Matching across Web Query Interfaces 2003 SIGMOD 0.00014102198
808 On Schema Matching with Opaque Column Names and Data Values 2003 SIGMOD 0.00013884332
1,030 Data-Driven Understanding and Refinement of Schema Mappings 2001 SIGMOD 0.00012545209
1,708 Using Schematically Heterogeneous Structures 1998 SIGMOD 9.958846e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 13,689 U-MAP: A System for Usage-Based Schema Matching and Mapping 2011 SIGMOD
2 180 Schema Mapping as Query Discovery 2000 VLDB
3 9,014 The Role of Schema Matching in Large Enterprises 2009 CIDR
4 3,942 On the Complexity of Deriving Schema Mappings from Database Instances 2008 PODS
5 3,341 Designing and Refining Schema Mappings via Data Examples 2011 SIGMOD
6 9,790 Meta-Mappings for Schema Mapping Reuse 2019 VLDB
7 390 COMA - A system for flexible combination of schema matching approaches 2002 VLDB
8 6,252 Putting Context into Schema Matching 2006 VLDB
9 9,015 Analyzing and Revising Data Integration Schemas to Improve Their Matchability 2008 VLDB
10 6,104 MapMerge: Correlating Independent Schema Mappings 2010 VLDB