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.7348167e-05
Overall Rank: 4,206 | 71.73%
DOI: 10.14778/2824032.2824036

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.0001205355
2,382	DeepJoin: Joinable Table Discovery with Pre-trained Language Models	2023	VLDB	8.5458532e-05
2,612	Auto-Join: Joining Tables by Leveraging Transformations	2017	VLDB	8.2265197e-05
2,641	Auto-Suggest: Learning-to-Recommend Data Preparation Steps Using Data Science Notebooks	2020	SIGMOD	8.1787073e-05
2,748	Uni-Detect: A Unified Approach to Automated Error Detection in Tables	2019	SIGMOD	8.0610697e-05
2,960	Auto-Detect: Data-Driven Error Detection in Tables	2018	SIGMOD	7.8075103e-05
4,424	Auto-Transform: Learning-to-Transform by Patterns	2020	VLDB	6.6048065e-05
4,970	Auto-FuzzyJoin: Auto-Program Fuzzy Similarity Joins Without Labeled Examples	2021	SIGMOD	6.3329595e-05
5,529	Putting Things into Context: Rich Explanations for Query Answers using Join Graphs	2021	SIGMOD	6.0935553e-05
5,687	DTT: An Example-Driven Tabular Transformer for Joinability by Leveraging Large Language Models	2024	SIGMOD	6.0360406e-05
7,097	Design and Analysis of a Processing-in-DIMM Join Algorithm: A Case Study with UPMEM DIMMs	2023	SIGMOD	5.601767e-05
7,526	Auto-Prep: Holistic Prediction of Data Preparation Steps for Self-Service Business Intelligence	2025	VLDB	5.5020723e-05
7,928	TabulaX: Leveraging Large Language Models for Multi-Class Table Transformations	2025	VLDB	5.4254488e-05
8,144	Synthesizing Mapping Relationships Using Table Corpus	2017	SIGMOD	5.3910618e-05
8,979	Auto-BI: Automatically Build BI-Models Leveraging Local Join Prediction and Global Schema Graph	2023	VLDB	5.2443558e-05
10,845	Featurized-Decomposition Join: Low-Cost Semantic Joins with Guarantees	2026	VLDB	4.9793485e-05
10,894	MosaicJoin: Compact Semantic Sketches for Value-Level Join Discovery	2026	VLDB	4.9793485e-05
11,615	Dealing with Acronyms, Abbreviations, and Typos in Real-World Entity Matching	2024	VLDB	4.9793485e-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.0023947656
7	Implementation Techniques For Main Memory Database Systems	1984	SIGMOD	0.00081992507
65	Freebase: A Collaboratively Created Graph Database For Structuring Human Knowledge	2008	SIGMOD	0.00038222149
367	InfoGather: Entity Augmentation and Attribute Discovery By Holistic Matching with Web Tables	2012	SIGMOD	0.00019884846
484	Data Integration for the Relational Web	2009	VLDB	0.00017548541
3,304	Multi-column Substring Matching for Database Schema Translation	2006	VLDB	7.4426486e-05
3,748	Discovering Linkage Points over Web Data	2013	VLDB	7.0530039e-05

Semantically Similar Papers

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