Database Paper Browser

Back to papers

Correlation Maps: A Compressed Access Method for Exploiting Soft Functional Dependencies

Summary: Proposes Correlation Maps (CMs), a compressed access structure that exploits soft functional dependencies between a clustered attribute and unclustered predicates to localize lookups and cut random I/O. Bucketing domains makes CMs orders of magnitude smaller, enabling many CMs; an analytic cost model and automatic pair suggestions drive scalable, low-maintenance query acceleration, demonstrated on SDSS and TPC-H. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
9851
Venue
VLDB
Year
2009
Pagerank
8.0414149e-05
Overall Rank
2,837 | 80.27%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 19 of 19 citing papers.

Rank Citing Paper Year Venue Pagerank
1,375 FITing-Tree: A Data-aware Index Structure 2019 SIGMOD 0.00012303141
1,478 Learning Multi-dimensional Indexes 2020 SIGMOD 0.00011762542
1,889 Tsunami: A Learned Multi-dimensional Index for Correlated Data and Skewed Workloads 2021 VLDB 0.00010200865
2,865 Designing Succinct Secondary Indexing Mechanism by Exploiting Column Correlations 2019 SIGMOD 7.9862595e-05
3,207 Predicting Cost Amortization for Query Services 2011 SIGMOD 7.3818982e-05
3,867 CORADD: Correlation Aware Database Designer for Materialized Views and Indexes 2010 VLDB 6.683173e-05
3,922 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 6.6291079e-05
4,014 Exploiting Correlations for Expensive Predicate Evaluation 2015 SIGMOD 6.5273084e-05
6,173 Exploiting Soft and Hard Correlations in Big Data Query Optimization 2016 VLDB 5.1699414e-05
6,466 Pando: Enhanced Data Skipping with Logical Data Partitioning 2023 VLDB 5.0528281e-05
7,283 Sia: Optimizing Queries using Learned Predicates 2021 SIGMOD 4.7764688e-05
7,659 UPI: A Primary Index for Uncertain Databases 2010 VLDB 4.686672e-05
8,502 Conditional Cuckoo Filters 2021 SIGMOD 4.4972336e-05
9,410 Leveraging Application Data Constraints to Optimize Database-Backed Web Applications 2023 VLDB 4.3441378e-05
9,435 AMNES: Accelerating the computation of data correlation using FPGAs 2023 VLDB 4.3430376e-05
10,323 Scalable Grid-based Computation of Kendall’s tau Correlation 2026 VLDB 4.1945683e-05
10,385 Optimizing Block Skipping for High-Dimensional Data with Learned Adaptive Curve 2025 SIGMOD 4.1945683e-05
10,950 PLAQUE: Automated Predicate Learning at Query Time 2024 SIGMOD 4.1945683e-05
11,683 HERMIT in Action: Succinct Secondary Indexing Mechanism via Correlation Exploration 2019 VLDB 4.1945683e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 8 of 8 cited papers.

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

Rank Cited Paper Year Venue Pagerank
224 CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies 2004 SIGMOD 0.00032746205
308 Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports 2001 VLDB 0.00028142852
378 Towards Estimation Error Guarantees for Distinct Values 2000 PODS 0.0002497492
1,974 BHUNT: Automatic Discovery of Fuzzy Algebraic Constraints in Relational Data 2003 VLDB 9.8866171e-05
4,107 Exploiting Constraint-Like Data Characterizations in Query Optimization 2001 SIGMOD 6.4448692e-05
4,119 A System for Semantic Query Optimization 1987 SIGMOD 6.4365852e-05
4,408 Implementation of Two Semantic Query Optimization Techniques in DB2 Universal Database 1999 VLDB 6.2109612e-05
5,596 Approximate Encoding for Direct Access and Query Processing over Compressed Bitmaps 2006 VLDB 5.4181535e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
11,683 HERMIT in Action: Succinct Secondary Indexing Mechanism via Correlation Exploration 2019 VLDB 4.1945683e-05
7,653 CORDS: Automatic Generation of Correlation Statistics in DB2 2004 VLDB 4.6875371e-05
6,671 Discovering Longest-lasting Correlation in Sequence Databases 2013 VLDB 4.9669225e-05
6,173 Exploiting Soft and Hard Correlations in Big Data Query Optimization 2016 VLDB 5.1699414e-05
8,869 Sharing-Aware Horizontal Partitioning for Exploiting Correlations During Query Processing 2010 VLDB 4.4320338e-05
1,100 Query Optimization In Compressed Database Systems 2001 SIGMOD 0.00014072277
5,759 Indexing Correlated Probabilistic Databases 2009 SIGMOD 5.3392211e-05
3,824 Correlation Sketches for Approximate Join-Correlation Queries 2021 SIGMOD 6.7260705e-05
3,561 Estimating Block Accesses When Attributes Are Correlated 1986 VLDB 6.971123e-05
2,865 Designing Succinct Secondary Indexing Mechanism by Exploiting Column Correlations 2019 SIGMOD 7.9862595e-05