CORADD: Correlation Aware Database Designer for Materialized Views and Indexes

Summary: CORADD automatically designs databases by exploiting attribute correlations to select MVs and secondary indexes. ILP Feedback optimizes MV clustering–index correlation under constraints, yielding up to 6x speedups vs a commercial designer on APB-1/SSB. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 10154
Venue: VLDB
Year: 2010
Pagerank: 6.6786821e-05
Overall Rank: 3,868 | 73.12%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 10 of 10 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,536	Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions	2011	VLDB	0.00011458359
1,887	Tsunami: A Learned Multi-dimensional Index for Correlated Data and Skewed Workloads	2021	VLDB	0.00010201938
2,868	Designing Succinct Secondary Indexing Mechanism by Exploiting Column Correlations	2019	SIGMOD	7.9856878e-05
2,996	Data Generation for Application-Specific Benchmarking	2011	VLDB	7.7580926e-05
4,022	Exploiting Correlations for Expensive Predicate Evaluation	2015	SIGMOD	6.5185189e-05
6,177	Exploiting Soft and Hard Correlations in Big Data Query Optimization	2016	VLDB	5.1646971e-05
6,461	Pando: Enhanced Data Skipping with Logical Data Partitioning	2023	VLDB	5.0479786e-05
8,268	Divergent Physical Design Tuning for Replicated Databases	2012	SIGMOD	4.5408509e-05
9,440	AMNES: Accelerating the computation of data correlation using FPGAs	2023	VLDB	4.3389137e-05
9,818	Generating Application-Specific Data Layouts for In-memory Databases	2019	VLDB	4.2733415e-05

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
160	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00040053897
224	CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies	2004	SIGMOD	0.00032743209
237	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00031727601
316	Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports	2001	VLDB	0.00027981848
380	Towards Estimation Error Guarantees for Distinct Values	2000	PODS	0.00024943236
1,976	BHUNT: Automatic Discovery of Fuzzy Algebraic Constraints in Relational Data	2003	VLDB	9.8784644e-05
2,841	Correlation Maps: A Compressed Access Method for Exploiting Soft Functional Dependencies	2009	VLDB	8.0396876e-05
7,042	Processing Star Queries on Hierarchically-Clustered Fact Tables	2002	VLDB	4.8483133e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
9,525	Detecting Attribute Dependencies from Query Feedback	2007	VLDB	4.326879e-05
7,445	An Automated, Yet Interactive and Portable DB Designer	2010	SIGMOD	4.7235588e-05
5,824	StatAdvisor: Recommending Statistical Views	2009	VLDB	5.311975e-05
258	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.00030196528
3,827	Correlation Sketches for Approximate Join-Correlation Queries	2021	SIGMOD	6.7195959e-05
10,149	CorrBound: Cardinality Estimation Accounting for Inter- and Intra-relation Correlations	2026	SIGMOD	4.1905499e-05
6,177	Exploiting Soft and Hard Correlations in Big Data Query Optimization	2016	VLDB	5.1646971e-05
2,841	Correlation Maps: A Compressed Access Method for Exploiting Soft Functional Dependencies	2009	VLDB	8.0396876e-05
224	CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies	2004	SIGMOD	0.00032743209
7,655	CORDS: Automatic Generation of Correlation Statistics in DB2	2004	VLDB	4.6830102e-05