HAMSTER: Using Search Clicklogs for Schema and Taxonomy Matching

Summary: Unsupervised schema matching to integrate many sources into a warehouse schema via clicklogs. HAMSTER uses click-through distributions over keyword-queries to align schema elements; outperforms traditional schema- and instance-based matching. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h74061b2d024d89ae
Venue: VLDB
Year: 2009
Pagerank: 6.1035636e-05
Overall Rank: 5,498 | 63.04%
DOI: 10.14778/1687627.1687649

Incoming Non-self Citations Over Time

Authors

1. Arnab Nandi (University of Michigan)
2. Philip A. Bernstein (Microsoft)

BibTeX Citation

@article{nandi_vldb09,
        title = {{HAMSTER: Using Search Clicklogs for Schema and Taxonomy Matching}},
        author = {Nandi, Arnab and Bernstein, Philip A.},
        journal = {PVLDB},
        series = {{VLDB} '09},
        doi = {10.14778/1687627.1687649},
        url = {https://doi.org/10.14778/1687627.1687649},
        year = {2009}
}

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
765	Table Union Search on Open Data	2018	VLDB	0.00014125424
1,505	Generic Schema Matching, Ten Years Later	2011	VLDB	0.00010454635
1,776	Sample-Driven Schema Mapping	2012	SIGMOD	9.6674087e-05
2,158	Open Data Integration	2018	VLDB	8.941016e-05
8,381	Automated Migration of Hierarchical Data to Relational Tables using Programming-by-Example	2018	VLDB	5.3428083e-05

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
24	Data Integration: A Theoretical Perspective	2002	PODS	0.00055043581
162	Integration of Heterogeneous Databases Without Common Domains Using Queries Based on Textual Similarity	1998	SIGMOD	0.00027536748
230	Reference Reconciliation in Complex Information Spaces	2005	SIGMOD	0.00023871933
269	Reconciling Schemas of Disparate Data Sources: A Machine-Learning Approach	2001	SIGMOD	0.00022620777
296	Generic Schema Matching with Cupid	2001	VLDB	0.00021867512
991	Web-scale Data Integration: You can only afford to Pay As You Go	2007	CIDR	0.00012647155
1,146	Schema and Ontology Matching with COMA++	2005	SIGMOD	0.00011815973
2,580	Tuning Schema Matching Software using Synthetic Scenarios	2005	VLDB	8.2716518e-05
2,901	Incremental Schema Matching	2006	VLDB	7.8830583e-05
3,700	Data Management Projects at Google	2006	SIGMOD	7.0864941e-05
6,628	Content Integration for E-Business	2001	SIGMOD	5.7281855e-05
9,170	The Role of Schema Matching in Large Enterprises	2009	CIDR	5.2141009e-05
9,171	Analyzing and Revising Data Integration Schemas to Improve Their Matchability	2008	VLDB	5.2141009e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	7,065	Automatically Incorporating New Sources in Keyword Search-Based Data Integration	2010	SIGMOD
2	1,958	iMAP: Discovering Complex Semantic Matches between Database Schemas	2004	SIGMOD
3	6,997	Facet Discovery for Structured Web Search: A Query-log Mining Approach	2011	SIGMOD
4	9,555	Leveraging Query Logs for Schema Mapping Generation in U-MAP	2011	SIGMOD
5	814	An Interactive Clustering-based Approach to Integrating Source Query Interfaces on the Deep Web	2004	SIGMOD
6	1,053	Answering Table Queries on the Web using Column Keywords	2012	VLDB
7	2,417	Instance-based Schema Matching for Web Databases by Domain-specific Query Probing	2004	VLDB
8	10,466	HAMMER: An Automatic RAG Tuning System via Hierarchical Memory-Guided Monte Carlo Tree Search	2026	SIGMOD
9	12,709	Schema Clustering and Retrieval for Multi-domain Pay-As-You-Go Data Integration Systems	2010	SIGMOD
10	801	Statistical Schema Matching across Web Query Interfaces	2003	SIGMOD