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,838 | CHORUS: Foundation Models for Unified Data Discovery and Exploration | 2024 | VLDB | 9.5195856e-05 |
| 2,645 | Auto-Suggest: Learning-to-Recommend Data Preparation Steps Using Data Science Notebooks | 2020 | SIGMOD | 8.1641056e-05 |
| 5,132 | Efficient Estimation of Inclusion Coefficient using HyperLogLog Sketches | 2018 | VLDB | 6.2462533e-05 |
| 7,107 | WarpGate: A Semantic Join Discovery System for Cloud Data Warehouses | 2023 | CIDR | 5.5818446e-05 |
| 7,217 | Cross Modal Data Discovery over Structured and Unstructured Data Lakes | 2023 | VLDB | 5.5679482e-05 |
| 7,548 | Auto-Prep: Holistic Prediction of Data Preparation Steps for Self-Service Business Intelligence | 2025 | VLDB | 5.481283e-05 |
| 8,517 | SPRINTER: A Fast n-ary Join Query Processing Method for Complex OLAP Queries | 2020 | SIGMOD | 5.3110227e-05 |
| 9,008 | Auto-BI: Automatically Build BI-Models Leveraging Local Join Prediction and Global Schema Graph | 2023 | VLDB | 5.2245403e-05 |
| 9,775 | Retrofitting GDPR Compliance onto Legacy Databases | 2022 | VLDB | 5.115551e-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 |
|---|---|---|---|---|
| 162 | Robust and Efficient Fuzzy Match for Online Data Cleaning | 2003 | SIGMOD | 0.00027626077 |
| 1,538 | On Multi-Column Foreign Key Discovery | 2010 | VLDB | 0.00010295575 |
| 3,467 | Automatic Discovery of Attributes in Relational Databases | 2011 | SIGMOD | 7.2609187e-05 |
| 5,352 | Dynamic Workload Driven Data Integration in Tableau | 2012 | SIGMOD | 6.1519505e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 2,608 | Auto-Join: Joining Tables by Leveraging Transformations | 2017 | VLDB |
| 2 | 7,172 | Business Modeling Using SQL Spreadsheets | 2003 | VLDB |
| 3 | 1,381 | Execution Strategies for SQL Subqueries | 2007 | SIGMOD |
| 4 | 11,467 | Mining Meaningful Keys and Foreign Keys with High Precision and Recall | 2025 | VLDB |
| 5 | 4,747 | QuickInsights: Quick and Automatic Discovery of Insights from Multi-Dimensional Data | 2019 | SIGMOD |
| 6 | 4,740 | Auto-Tables: Synthesizing Multi-Step Transformations to Relationalize Tables without Using Examples | 2023 | VLDB |
| 7 | 1,702 | PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS | 2004 | VLDB |
| 8 | 3,317 | Spreadsheet As a Relational Database Engine | 2010 | SIGMOD |
| 9 | 4,574 | Query By Excel | 2005 | VLDB |
| 10 | 1,538 | On Multi-Column Foreign Key Discovery | 2010 | VLDB |