SEMA-JOIN: Joining Semantically-Related Tables Using Big Table Corpora

Summary: SEMA-JOIN automates semantic joins beyond equi-joins by mining a big table corpus (>100M tables) to learn row- and column-level correlations. Join discovery is framed as maximizing aggregate correlation with a linear-program relaxation and a 2-approximation, yielding high precision on public and enterprise data. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: hbd55a1971e2fb0f5
Venue: VLDB
Year: 2015
Pagerank: 6.7137538e-05
Overall Rank: 4,220 | 71.72%
DOI: 10.14778/2824032.2824036
PDF: Download (CC BY-NC-ND 3.0)

Incoming Non-self Citations Over Time

Authors

1. Yeye He (Microsoft)
2. Kris Ganjam (Microsoft)
3. Xu Chu (University of Waterloo)

BibTeX Citation

@article{he_vldb15,
        title = {{SEMA-JOIN: Joining Semantically-Related Tables Using Big Table Corpora}},
        author = {He, Yeye and Ganjam, Kris and Chu, Xu},
        journal = {PVLDB},
        series = {{VLDB} '15},
        volume = {8},
        number = {12},
        pages = {1358--1369},
        doi = {10.14778/2824032.2824036},
        url = {https://doi.org/10.14778/2824032.2824036},
        year = {2015}
}

Incoming Citations (Sorted by Pagerank)

Showing 18 of 18 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,094	BlinkFill: Semi-supervised Programming By Example for Syntactic String Transformations	2016	VLDB	0.00012039085
2,370	DeepJoin: Joinable Table Discovery with Pre-trained Language Models	2023	VLDB	8.5469172e-05
2,608	Auto-Join: Joining Tables by Leveraging Transformations	2017	VLDB	8.209962e-05
2,645	Auto-Suggest: Learning-to-Recommend Data Preparation Steps Using Data Science Notebooks	2020	SIGMOD	8.1641056e-05
2,752	Uni-Detect: A Unified Approach to Automated Error Detection in Tables	2019	SIGMOD	8.0387193e-05
2,960	Auto-Detect: Data-Driven Error Detection in Tables	2018	SIGMOD	7.7967245e-05
4,444	Auto-Transform: Learning-to-Transform by Patterns	2020	VLDB	6.5812416e-05
4,994	Auto-FuzzyJoin: Auto-Program Fuzzy Similarity Joins Without Labeled Examples	2021	SIGMOD	6.3099657e-05
5,556	Putting Things into Context: Rich Explanations for Query Answers using Join Graphs	2021	SIGMOD	6.0705311e-05
5,654	DTT: An Example-Driven Tabular Transformer for Joinability by Leveraging Large Language Models	2024	SIGMOD	6.0324041e-05
7,122	Design and Analysis of a Processing-in-DIMM Join Algorithm: A Case Study with UPMEM DIMMs	2023	SIGMOD	5.580601e-05
7,548	Auto-Prep: Holistic Prediction of Data Preparation Steps for Self-Service Business Intelligence	2025	VLDB	5.481283e-05
7,946	TabulaX: Leveraging Large Language Models for Multi-Class Table Transformations	2025	VLDB	5.404949e-05
8,158	Synthesizing Mapping Relationships Using Table Corpus	2017	SIGMOD	5.3726245e-05
9,008	Auto-BI: Automatically Build BI-Models Leveraging Local Join Prediction and Global Schema Graph	2023	VLDB	5.2245403e-05
10,232	Featurized-Decomposition Join: Low-Cost Semantic Joins with Guarantees	2026	VLDB	5.0432098e-05
10,964	MosaicJoin: Compact Semantic Sketches for Value-Level Join Discovery	2026	VLDB	4.9605343e-05
11,668	Dealing with Acronyms, Abbreviations, and Typos in Real-World Entity Matching	2024	VLDB	4.9605343e-05

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
1	Access Path Selection in a Relational Database Management System	1979	SIGMOD	0.0023948467
7	Implementation Techniques For Main Memory Database Systems	1984	SIGMOD	0.00081781676
65	Freebase: A Collaboratively Created Graph Database For Structuring Human Knowledge	2008	SIGMOD	0.0003826876
367	InfoGather: Entity Augmentation and Attribute Discovery By Holistic Matching with Web Tables	2012	SIGMOD	0.00019882429
484	Data Integration for the Relational Web	2009	VLDB	0.00017535511
3,313	Multi-column Substring Matching for Database Schema Translation	2006	VLDB	7.4160617e-05
3,756	Discovering Linkage Points over Web Data	2013	VLDB	7.0275986e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,933	Leveraging Set Relations in Exact Set Similarity Join	2017	VLDB
2	10,928	Sema: A High-performance System for LLM-based Semantic Query Processing	2026	VLDB
3	10,964	MosaicJoin: Compact Semantic Sketches for Value-Level Join Discovery	2026	VLDB
4	3,956	A System for Semantic Query Optimization	1987	SIGMOD
5	2,370	DeepJoin: Joinable Table Discovery with Pre-trained Language Models	2023	VLDB
6	3,093	Correlation Sketches for Approximate Join-Correlation Queries	2021	SIGMOD
7	8,434	Fast Approximate Similarity Join in Vector Databases	2025	SIGMOD
8	10,232	Featurized-Decomposition Join: Low-Cost Semantic Joins with Guarantees	2026	VLDB
9	10,745	Qualitative Join Discovery in Data Lakes using Examples	2026	SIGMOD
10	2,608	Auto-Join: Joining Tables by Leveraging Transformations	2017	VLDB