Automated design of multidimensional clustering tables for relational databases
Summary: Automates clustering-key design for MDC in DBs with 3+ dims, via what-if cost modeling, sampling, and a search. Balances sparsity and performance across granularity (week vs month); yields expert-level designs, implemented in IBM DB2 UDB 8.2. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 3 of 3 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 258 | DB2 Design Advisor: Integrated Automatic Physical Database Design | 2004 | VLDB | 0.0003022091 |
| 514 | An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning | 2019 | SIGMOD | 0.0002124895 |
| 10,790 | SQL:Trek Automated Index Design at Airbnb | 2025 | VLDB | 4.1945683e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 10 of 10 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 59 | Sampling-Based Estimation of the Number of Distinct Values of an Attribute | 1995 | VLDB | 0.00064501896 |
| 158 | Automated Selection of Materialized Views and Indexes for SQL Databases | 2000 | VLDB | 0.00040071492 |
| 258 | DB2 Design Advisor: Integrated Automatic Physical Database Design | 2004 | VLDB | 0.0003022091 |
| 285 | Automating Physical Database Design in a Parallel Database | 2002 | SIGMOD | 0.0002899128 |
| 516 | AutoAdmin "What-if" Index Analysis Utility | 1998 | SIGMOD | 0.00021196031 |
| 773 | Multi-Dimensional Database Allocation for Parallel Data Warehouses | 2000 | VLDB | 0.00016870159 |
| 1,710 | Microsoft Index Tuning Wizard for SQL Server 7.0 | 1998 | SIGMOD | 0.00010807871 |
| 2,045 | Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 | 2003 | SIGMOD | 9.6939983e-05 |
| 3,028 | Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2 | 2003 | VLDB | 7.6816205e-05 |
| 8,387 | WARLOCK : A Data Allocation Tool for Parallel Warehouses | 2001 | VLDB | 4.5299073e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,823 | Automatic Discovery of Attributes in Relational Databases | 2011 | SIGMOD | 6.7261168e-05 |
| 767 | Explaining differences in multidimensional aggregates | 1999 | VLDB | 0.00016981309 |
| 158 | Automated Selection of Materialized Views and Indexes for SQL Databases | 2000 | VLDB | 0.00040071492 |
| 773 | Multi-Dimensional Database Allocation for Parallel Data Warehouses | 2000 | VLDB | 0.00016870159 |
| 681 | Materialized View Selection in a Multidimensional Database | 1997 | VLDB | 0.00018203591 |
| 9,275 | Efficient Bulk Deletes for Multi Dimensional Clustered Tables in DB2 | 2007 | VLDB | 4.3645459e-05 |
| 258 | DB2 Design Advisor: Integrated Automatic Physical Database Design | 2004 | VLDB | 0.0003022091 |
| 829 | Simultaneous Optimization and Evaluation of Multiple Dimensional Queries | 1998 | SIGMOD | 0.0001618536 |
| 3,028 | Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2 | 2003 | VLDB | 7.6816205e-05 |
| 2,045 | Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 | 2003 | SIGMOD | 9.6939983e-05 |