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: 11202
Venue: VLDB
Year: 2015
Pagerank: 6.6456999e-05
Overall Rank: 4,525 | 68.96%
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 16 of 16 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,160	BlinkFill: Semi-supervised Programming By Example for Syntactic String Transformations	2016	VLDB	0.00011883163
2,728	Uni-Detect: A Unified Approach to Automated Error Detection in Tables	2019	SIGMOD	8.1995954e-05
2,744	Auto-Suggest: Learning-to-Recommend Data Preparation Steps Using Data Science Notebooks	2020	SIGMOD	8.1781662e-05
2,980	Auto-Join: Joining Tables by Leveraging Transformations	2017	VLDB	7.8975073e-05
3,073	DeepJoin: Joinable Table Discovery with Pre-trained Language Models	2023	VLDB	7.785842e-05
3,147	Auto-Detect: Data-Driven Error Detection in Tables	2018	SIGMOD	7.7077175e-05
4,412	Auto-Transform: Learning-to-Transform by Patterns	2020	VLDB	6.7168614e-05
5,134	Auto-FuzzyJoin: Auto-Program Fuzzy Similarity Joins Without Labeled Examples	2021	SIGMOD	6.3532024e-05
5,396	Putting Things into Context: Rich Explanations for Query Answers using Join Graphs	2021	SIGMOD	6.2329373e-05
6,545	DTT: An Example-Driven Tabular Transformer for Joinability by Leveraging Large Language Models	2024	SIGMOD	5.8454882e-05
6,957	Design and Analysis of a Processing-in-DIMM Join Algorithm: A Case Study with UPMEM DIMMs	2023	SIGMOD	5.7303405e-05
8,491	Synthesizing Mapping Relationships Using Table Corpus	2017	SIGMOD	5.414689e-05
9,380	Auto-Prep: Holistic Prediction of Data Preparation Steps for Self-Service Business Intelligence	2025	VLDB	5.2755515e-05
9,505	TabulaX: Leveraging Large Language Models for Multi-Class Table Transformations	2025	VLDB	5.258497e-05
9,629	Auto-BI: Automatically Build BI-Models Leveraging Local Join Prediction and Global Schema Graph	2023	VLDB	5.2434488e-05
11,293	Dealing with Acronyms, Abbreviations, and Typos in Real-World Entity Matching	2024	VLDB	5.093636e-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.0024089429
7	Implementation Techniques For Main Memory Database Systems	1984	SIGMOD	0.00083340894
65	Freebase: A Collaboratively Created Graph Database For Structuring Human Knowledge	2008	SIGMOD	0.00038697603
367	InfoGather: Entity Augmentation and Attribute Discovery By Holistic Matching with Web Tables	2012	SIGMOD	0.00019979463
493	Data Integration for the Relational Web	2009	VLDB	0.00017558709
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

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	8,491	Synthesizing Mapping Relationships Using Table Corpus	2017	SIGMOD
2	169	Efficient Exact Set-Similarity Joins	2006	VLDB
3	9,702	Towards a Unified Framework for String Similarity Joins	2019	VLDB
4	3,040	Leveraging Set Relations in Exact Set Similarity Join	2017	VLDB
5	3,901	A System for Semantic Query Optimization	1987	SIGMOD
6	3,073	DeepJoin: Joinable Table Discovery with Pre-trained Language Models	2023	VLDB
7	3,228	Correlation Sketches for Approximate Join-Correlation Queries	2021	SIGMOD
8	9,052	Fast Approximate Similarity Join in Vector Databases	2025	SIGMOD
9	10,486	Qualitative Join Discovery in Data Lakes using Examples	2026	SIGMOD
10	2,980	Auto-Join: Joining Tables by Leveraging Transformations	2017	VLDB