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
8675
Venue
VLDB
Year
2000
Pagerank
0.00040053897
Overall Rank
160 | 98.89%
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,457 Generalized Scale Independence Through Incremental Precomputation 2013 SIGMOD 6.1636855e-05
4,621 Automated Generation of Materialized Views in Oracle 2020 VLDB 6.036749e-05
4,677 To Share or Not to Share? 2007 VLDB 5.9988869e-05
4,779 LIMA: Fine-grained Lineage Tracing and Reuse in Machine Learning Systems 2021 SIGMOD 5.9259373e-05
4,863 COLT: Continuous On-Line Database Tuning 2006 SIGMOD 5.8646122e-05
5,055 Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications 2009 VLDB 5.72317e-05
5,250 One Model to Rule them All: Towards Zero-Shot Learning for Databases 2022 CIDR 5.6007779e-05
5,445 Materialized View and Index Selection Tool for Microsoft SQL Server 2000 2001 SIGMOD 5.499851e-05
5,575 Optimizing Data Pipelines for Machine Learning in Feature Stores 2023 VLDB 5.4253204e-05
5,623 New Directions in Cloud Programming 2021 CIDR 5.4050025e-05
5,673 Budget-aware Index Tuning with Reinforcement Learning 2022 SIGMOD 5.3789277e-05
5,695 Optimal Indexing Using Near-Minimal Space [Extended Abstract] 2003 PODS 5.3675705e-05
5,737 Enabling Incremental Query Re-Optimization 2016 SIGMOD 5.3459609e-05
5,742 Efficient Computation of Multiple Group By Queries 2005 SIGMOD 5.3432178e-05
5,824 StatAdvisor: Recommending Statistical Views 2009 VLDB 5.311975e-05
5,846 Efficient Detection of Empty-Result Queries 2006 VLDB 5.3052255e-05
5,925 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 5.2669029e-05
6,079 Opportunistic Physical Design for Big Data Analytics 2014 SIGMOD 5.2194019e-05
6,160 Compression Aware Physical Database Design 2011 VLDB 5.1750659e-05
6,241 Helios: Hyperscale Indexing for the Cloud & Edge 2020 VLDB 5.1357476e-05
6,270 Content Integration for E-Business 2001 SIGMOD 5.1277454e-05
6,298 Towards instance-optimized data systems 2021 VLDB 5.1182917e-05
6,328 A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies 2024 VLDB 5.1034426e-05
6,394 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 5.0770427e-05
6,461 Pando: Enhanced Data Skipping with Logical Data Partitioning 2023 VLDB 5.0479786e-05
6,830 Stacked Indexed Views in Microsoft SQL Server 2005 SIGMOD 4.9081078e-05
6,962 Replicated Layout for In-Memory Database Systems 2022 VLDB 4.8771234e-05
6,966 Utilizing IDs to Accelerate Incremental View Maintenance 2015 SIGMOD 4.8754926e-05
6,986 CrocodileDB: Efficient Database Execution through Intelligent Deferment 2020 CIDR 4.8672517e-05
7,000 Progressive Indexes: Indexing for Interactive Data Analysis 2019 VLDB 4.862486e-05
7,127 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 4.8184276e-05
7,251 DEX: Query Execution in a Delta-based Storage System 2017 SIGMOD 4.7839943e-05
7,291 Multi-Tenant Cloud Data Services: State-of-the-Art, Challenges and Opportunities 2022 SIGMOD 4.7677422e-05
7,397 Intermittent Query Processing 2019 VLDB 4.7367491e-05
7,591 Automated design of multidimensional clustering tables for relational databases 2004 VLDB 4.6986414e-05
7,690 ROBUS: Fair Cache Allocation for Data-parallel Workloads 2017 SIGMOD 4.6723821e-05
7,809 Sibyl: Forecasting Time-Evolving Query Workloads 2024 SIGMOD 4.6415559e-05
7,847 ChronoCache: Predictive and Adaptive Mid-Tier Query Result Caching 2020 SIGMOD 4.632377e-05
8,001 TI: An Efficient Indexing Mechanism for Real-Time Search on Tweets 2011 SIGMOD 4.6056189e-05
8,020 User-Optimizer Communication using Abstract Plans in Sybase ASE 2001 VLDB 4.6005954e-05
8,223 Automated Multidimensional Data Layouts in Amazon Redshift 2024 SIGMOD 4.5509217e-05
8,288 View Selection over Knowledge Graphs in Triple Stores 2021 VLDB 4.5392079e-05
8,360 Query Log Compression for Workload Analytics 2019 VLDB 4.5314883e-05
8,387 A Storage Advisor for Hybrid-Store Databases 2012 VLDB 4.5255213e-05
8,390 Goals and Benchmarks for Autonomic Configuration Recommenders 2005 SIGMOD 4.524666e-05
8,431 Materialized View Selection for XQuery Workloads 2012 SIGMOD 4.5084372e-05
8,434 SageDB: An Instance-Optimized Data Analytics System 2022 VLDB 4.5077955e-05
8,487 Making RDBMSs Efficient on Graph Workloads Through Predefined Joins 2022 VLDB 4.4953604e-05
8,624 Limousine: Blending Learned and Classical Indexes to Self-Design Larger-than-Memory Cloud Storage Engines 2024 SIGMOD 4.4786127e-05
8,780 GEqO: ML-Accelerated Semantic Equivalence Detection 2023 SIGMOD 4.4485568e-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