Database Paper Browser

Back to papers

Automated Selection of Materialized Views and Indexes for SQL Databases

Summary: End-to-end automated selection of materialized views and indexes for SQL databases, guided by workload-aware cost models. Validated experimentally; implemented as a tuning wizard in SQL Server 2000 for automated MV/index selection on general SQL workloads. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
8674
Venue
VLDB
Year
2000
Pagerank
0.00040071492
Overall Rank
158 | 98.91%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 50 of 125 citing papers.

Rank Citing Paper Year Venue Pagerank
4,455 Generalized Scale Independence Through Incremental Precomputation 2013 SIGMOD 6.171182e-05
4,623 Automated Generation of Materialized Views in Oracle 2020 VLDB 6.0411909e-05
4,680 To Share or Not to Share? 2007 VLDB 6.0039406e-05
4,774 LIMA: Fine-grained Lineage Tracing and Reuse in Machine Learning Systems 2021 SIGMOD 5.9316087e-05
4,864 COLT: Continuous On-Line Database Tuning 2006 SIGMOD 5.8689388e-05
5,060 Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications 2009 VLDB 5.7273583e-05
5,258 One Model to Rule them All: Towards Zero-Shot Learning for Databases 2022 CIDR 5.5998705e-05
5,435 Materialized View and Index Selection Tool for Microsoft SQL Server 2000 2001 SIGMOD 5.5043441e-05
5,567 Optimizing Data Pipelines for Machine Learning in Feature Stores 2023 VLDB 5.4305348e-05
5,614 New Directions in Cloud Programming 2021 CIDR 5.4101976e-05
5,682 Optimal Indexing Using Near-Minimal Space [Extended Abstract] 2003 PODS 5.372736e-05
5,686 Budget-aware Index Tuning with Reinforcement Learning 2022 SIGMOD 5.3712312e-05
5,727 Enabling Incremental Query Re-Optimization 2016 SIGMOD 5.3510544e-05
5,736 Efficient Computation of Multiple Group By Queries 2005 SIGMOD 5.3482537e-05
5,815 StatAdvisor: Recommending Statistical Views 2009 VLDB 5.3165295e-05
5,834 Efficient Detection of Empty-Result Queries 2006 VLDB 5.3103189e-05
5,924 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 5.2719183e-05
6,075 Opportunistic Physical Design for Big Data Analytics 2014 SIGMOD 5.223901e-05
6,157 Compression Aware Physical Database Design 2011 VLDB 5.1801143e-05
6,242 Helios: Hyperscale Indexing for the Cloud & Edge 2020 VLDB 5.1408379e-05
6,272 Content Integration for E-Business 2001 SIGMOD 5.1327853e-05
6,297 Towards instance-optimized data systems 2021 VLDB 5.1227886e-05
6,328 A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies 2024 VLDB 5.1082882e-05
6,398 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 5.0819209e-05
6,466 Pando: Enhanced Data Skipping with Logical Data Partitioning 2023 VLDB 5.0528281e-05
6,832 Stacked Indexed Views in Microsoft SQL Server 2005 SIGMOD 4.9128255e-05
6,968 Utilizing IDs to Accelerate Incremental View Maintenance 2015 SIGMOD 4.8801295e-05
6,984 Replicated Layout for In-Memory Database Systems 2022 VLDB 4.873081e-05
6,988 CrocodileDB: Efficient Database Execution through Intelligent Deferment 2020 CIDR 4.8718019e-05
7,001 Progressive Indexes: Indexing for Interactive Data Analysis 2019 VLDB 4.8671553e-05
7,128 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 4.8230171e-05
7,254 DEX: Query Execution in a Delta-based Storage System 2017 SIGMOD 4.7885915e-05
7,296 Multi-Tenant Cloud Data Services: State-of-the-Art, Challenges and Opportunities 2022 SIGMOD 4.7723197e-05
7,407 Intermittent Query Processing 2019 VLDB 4.7373205e-05
7,603 Automated design of multidimensional clustering tables for relational databases 2004 VLDB 4.6985903e-05
7,689 ROBUS: Fair Cache Allocation for Data-parallel Workloads 2017 SIGMOD 4.6765769e-05
7,842 ChronoCache: Predictive and Adaptive Mid-Tier Query Result Caching 2020 SIGMOD 4.6368238e-05
7,999 TI: An Efficient Indexing Mechanism for Real-Time Search on Tweets 2011 SIGMOD 4.6100392e-05
8,016 User-Optimizer Communication using Abstract Plans in Sybase ASE 2001 VLDB 4.6050078e-05
8,131 Sibyl: Forecasting Time-Evolving Query Workloads 2024 SIGMOD 4.5784634e-05
8,225 Automated Multidimensional Data Layouts in Amazon Redshift 2024 SIGMOD 4.555289e-05
8,295 View Selection over Knowledge Graphs in Triple Stores 2021 VLDB 4.5435639e-05
8,364 Query Log Compression for Workload Analytics 2019 VLDB 4.5357797e-05
8,389 A Storage Advisor for Hybrid-Store Databases 2012 VLDB 4.5296588e-05
8,391 Goals and Benchmarks for Autonomic Configuration Recommenders 2005 SIGMOD 4.5287897e-05
8,440 Materialized View Selection for XQuery Workloads 2012 SIGMOD 4.5127636e-05
8,442 SageDB: An Instance-Optimized Data Analytics System 2022 VLDB 4.5120602e-05
8,600 Making RDBMSs Efficient on Graph Workloads Through Predefined Joins 2022 VLDB 4.4876776e-05
8,627 Limousine: Blending Learned and Classical Indexes to Self-Design Larger-than-Memory Cloud Storage Engines 2024 SIGMOD 4.4829101e-05
8,783 GEqO: ML-Accelerated Semantic Equivalence Detection 2023 SIGMOD 4.452825e-05
Previous Page 2 / 3 Next

Outgoing Citations (Sorted by Pagerank)

Showing 9 of 9 cited papers.

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

Previous Page 1 / 1 Next

Semantically Similar Papers