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)
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 |
|---|---|---|---|---|
| 1,932 | CHORUS: Foundation Models for Unified Data Discovery and Exploration | 2024 | VLDB | 9.34643e-05 |
| 2,641 | Auto-Suggest: Learning-to-Recommend Data Preparation Steps Using Data Science Notebooks | 2020 | SIGMOD | 8.1787073e-05 |
| 5,108 | Efficient Estimation of Inclusion Coefficient using HyperLogLog Sketches | 2018 | VLDB | 6.2696201e-05 |
| 7,161 | WarpGate: A Semantic Join Discovery System for Cloud Data Warehouses | 2023 | CIDR | 5.596048e-05 |
| 7,197 | Cross Modal Data Discovery over Structured and Unstructured Data Lakes | 2023 | VLDB | 5.5890662e-05 |
| 7,526 | Auto-Prep: Holistic Prediction of Data Preparation Steps for Self-Service Business Intelligence | 2025 | VLDB | 5.5020723e-05 |
| 8,493 | SPRINTER: A Fast n-ary Join Query Processing Method for Complex OLAP Queries | 2020 | SIGMOD | 5.3310013e-05 |
| 8,979 | Auto-BI: Automatically Build BI-Models Leveraging Local Join Prediction and Global Schema Graph | 2023 | VLDB | 5.2443558e-05 |
| 9,738 | Retrofitting GDPR Compliance onto Legacy Databases | 2022 | VLDB | 5.1349531e-05 |
Previous
Page 1 / 1
Next
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 |
|---|---|---|---|---|
| 161 | Robust and Efficient Fuzzy Match for Online Data Cleaning | 2003 | SIGMOD | 0.00027718195 |
| 1,532 | On Multi-Column Foreign Key Discovery | 2010 | VLDB | 0.00010332696 |
| 3,470 | Automatic Discovery of Attributes in Relational Databases | 2011 | SIGMOD | 7.2765721e-05 |
| 5,338 | Dynamic Workload Driven Data Integration in Tableau | 2012 | SIGMOD | 6.1744641e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 2,612 | Auto-Join: Joining Tables by Leveraging Transformations | 2017 | VLDB |
| 2 | 7,144 | Business Modeling Using SQL Spreadsheets | 2003 | VLDB |
| 3 | 1,378 | Execution Strategies for SQL Subqueries | 2007 | SIGMOD |
| 4 | 11,408 | Mining Meaningful Keys and Foreign Keys with High Precision and Recall | 2025 | VLDB |
| 5 | 4,725 | QuickInsights: Quick and Automatic Discovery of Insights from Multi-Dimensional Data | 2019 | SIGMOD |
| 6 | 5,167 | Auto-Tables: Synthesizing Multi-Step Transformations to Relationalize Tables without Using Examples | 2023 | VLDB |
| 7 | 1,696 | PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS | 2004 | VLDB |
| 8 | 3,303 | Spreadsheet As a Relational Database Engine | 2010 | SIGMOD |
| 9 | 4,555 | Query By Excel | 2005 | VLDB |
| 10 | 1,532 | On Multi-Column Foreign Key Discovery | 2010 | VLDB |