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 25 of 125 citing papers.

Rank Citing Paper Year Venue Pagerank
8,886 Provenance-based Data Skipping 2022 VLDB 4.4237386e-05
9,375 In-depth Analysis of Continuous Subgraph Matching in a Common Delta Query Compilation Framework 2024 SIGMOD 4.3452177e-05
9,450 Online Optimization and Fair Costing for Dynamic Data Sharing in a Cloud Data Market 2014 SIGMOD 4.3367172e-05
9,551 Supporting Distributed Feed-Following Apps over Edge Devices 2013 VLDB 4.3214665e-05
9,818 Generating Application-Specific Data Layouts for In-memory Databases 2019 VLDB 4.2733415e-05
9,930 Wred: Workload Reduction for Scalable Index Tuning 2024 SIGMOD 4.2469394e-05
10,032 Rainbow: Risk-aware Index Benefit Estimation Facing Out Of Distribution Workloads 2026 SIGMOD 4.1905499e-05
10,116 Stochastic Submodular Data Forgetting 2026 SIGMOD 4.1905499e-05
10,552 Esc: An Early-Stopping Checker for Budget-aware Index Tuning 2025 VLDB 4.1905499e-05
10,767 SIEVE: Effective Filtered Vector Search with Collection of Indexes 2025 VLDB 4.1905499e-05
10,780 Automatic Indexing in Oracle 2025 VLDB 4.1905499e-05
10,794 Streaming View: An Efficient Data Processing Engine for Modern Real-time Data Warehouse of Alibaba Cloud 2025 VLDB 4.1905499e-05
10,796 SQL:Trek Automated Index Design at Airbnb 2025 VLDB 4.1905499e-05
10,853 AXE: A Task Decomposition Approach to Learned LSM Tuning 2025 VLDB 4.1905499e-05
11,543 FlashP: An Analytical Pipeline for Real-time Forecasting of Time-Series Relational Data 2021 VLDB 4.1905499e-05
11,546 View-Driven Optimization of Database-Backed Web Applications 2020 CIDR 4.1905499e-05
11,662 An Efficient Index for RDF Query Containment 2019 SIGMOD 4.1905499e-05
11,688 HERMIT in Action: Succinct Secondary Indexing Mechanism via Correlation Exploration 2019 VLDB 4.1905499e-05
12,345 Declarative Management in Microsoft SQL Server 2009 VLDB 4.1905499e-05
12,412 When is it Time to Rethink the Aggregate Configuration of Your OLAP Server? 2008 VLDB 4.1905499e-05
12,431 The Data Ring: Community Content Sharing 2007 CIDR 4.1905499e-05
12,483 Deadline and QoS Aware Data Warehouse 2007 VLDB 4.1905499e-05
12,568 ULoad: Choosing the Right Storage for your XML Application 2005 VLDB 4.1905499e-05
12,618 Speculative Query Processing 2003 CIDR 4.1905499e-05
12,662 SMART: Making DB2 (More) Autonomic 2002 VLDB 4.1905499e-05
Previous Page 3 / 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.

Rank Cited Paper Year Venue Pagerank
11 Implementing Data Cubes Efficiently 1996 SIGMOD 0.0011695087
237 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00031727601
517 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00021193179
600 Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies 1996 VLDB 0.00019400653
681 Materialized View Selection in a Multidimensional Database 1997 VLDB 0.0001818285
978 DynaMat: A Dynamic View Management System for Data Warehouses 1999 SIGMOD 0.00014876414
1,007 A Framework for Automating Physical Database Design 1991 VLDB 0.00014683533
1,023 Materialized View Selection for Multidimensional Datasets* 1998 VLDB 0.00014601981
1,911 Algorithms for Materialized View Design in Data Warehousing Environment 1997 VLDB 0.00010117173
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
6,830 Stacked Indexed Views in Microsoft SQL Server 2005 SIGMOD 4.9081078e-05
5,055 Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications 2009 VLDB 5.72317e-05
11,103 Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches 2024 VLDB 4.1905499e-05
517 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00021193179
1,911 Algorithms for Materialized View Design in Data Warehousing Environment 1997 VLDB 0.00010117173
681 Materialized View Selection in a Multidimensional Database 1997 VLDB 0.0001818285
1,110 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD 0.00013902997
728 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017459654
237 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00031727601
5,445 Materialized View and Index Selection Tool for Microsoft SQL Server 2000 2001 SIGMOD 5.499851e-05