Fast Foreign-Key Detection in Microsoft SQL Server PowerPivot for Excel

Summary: Fast foreign-key detection in PowerPivot for Excel enabling interactive discovery over large, multi-table schemas. High-precision FK discovery at scale (hundreds of millions of rows, many tables) integrated into the in-memory BI engine; validated on synthetic and real data. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 10990
Venue: VLDB
Year: 2014
Pagerank: 6.3646928e-05
Overall Rank: 5,099 | 65.02%
DOI: 10.14778/2733004.2733014

Incoming Non-self Citations Over Time

Authors

1. Zhimin Chen (Microsoft)
2. Vivek Narasayya (Microsoft)
3. Surajit Chaudhuri (Microsoft)

BibTeX Citation

@article{chen_vldb14,
        title = {{Fast Foreign-Key Detection in Microsoft SQL Server PowerPivot for Excel}},
        author = {Chen, Zhimin and Narasayya, Vivek and Chaudhuri, Surajit},
        journal = {PVLDB},
        series = {{VLDB} '14},
        volume = {7},
        number = {13},
        pages = {1417--1428},
        doi = {10.14778/2733004.2733014},
        url = {https://doi.org/10.14778/2733004.2733014},
        year = {2014}
}

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,242	CHORUS: Foundation Models for Unified Data Discovery and Exploration	2024	VLDB	8.8823802e-05
2,744	Auto-Suggest: Learning-to-Recommend Data Preparation Steps Using Data Science Notebooks	2020	SIGMOD	8.1781662e-05
5,257	Efficient Estimation of Inclusion Coefficient using HyperLogLog Sketches	2018	VLDB	6.2971456e-05
7,572	Cross Modal Data Discovery over Structured and Unstructured Data Lakes	2023	VLDB	5.5938952e-05
8,144	WarpGate: A Semantic Join Discovery System for Cloud Data Warehouses	2023	CIDR	5.4800625e-05
8,374	SPRINTER: A Fast n-ary Join Query Processing Method for Complex OLAP Queries	2020	SIGMOD	5.4399097e-05
9,380	Auto-Prep: Holistic Prediction of Data Preparation Steps for Self-Service Business Intelligence	2025	VLDB	5.2755515e-05
9,563	Retrofitting GDPR Compliance onto Legacy Databases	2022	VLDB	5.2528121e-05
9,629	Auto-BI: Automatically Build BI-Models Leveraging Local Join Prediction and Global Schema Graph	2023	VLDB	5.2434488e-05

Outgoing Citations (Sorted by Pagerank)

Showing 4 of 4 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
158	Robust and Efficient Fuzzy Match for Online Data Cleaning	2003	SIGMOD	0.00028199923
1,521	On Multi-Column Foreign Key Discovery	2010	VLDB	0.00010506299
3,456	Automatic Discovery of Attributes in Relational Databases	2011	SIGMOD	7.3998323e-05
5,219	Dynamic Workload Driven Data Integration in Tableau	2012	SIGMOD	6.3110514e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	7,008	Business Modeling Using SQL Spreadsheets	2003	VLDB
2	2,980	Auto-Join: Joining Tables by Leveraging Transformations	2017	VLDB
3	1,362	Execution Strategies for SQL Subqueries	2007	SIGMOD
4	11,044	Mining Meaningful Keys and Foreign Keys with High Precision and Recall	2025	VLDB
5	4,628	QuickInsights: Quick and Automatic Discovery of Insights from Multi-Dimensional Data	2019	SIGMOD
6	5,403	Auto-Tables: Synthesizing Multi-Step Transformations to Relationalize Tables without Using Examples	2023	VLDB
7	1,691	PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS	2004	VLDB
8	3,249	Spreadsheet As a Relational Database Engine	2010	SIGMOD
9	4,477	Query By Excel	2005	VLDB
10	1,521	On Multi-Column Foreign Key Discovery	2010	VLDB