Automated Selection of Materialized Views and Indexes in SQL Databases

@inproceedings{Agrawal2000AutomatedSO,
  title={Automated Selection of Materialized Views and Indexes in SQL Databases},
  author={Sanjay Agrawal and Surajit Chaudhuri and Vivek R. Narasayya},
  booktitle={VLDB},
  year={2000}
}
Automatically selecting an appropriate set of materialized views and indexes for SQL databases is a non-trivial task. A judicious choice must be cost-driven and influenced by the workload experienced by the system. Although there has been work in materialized view selection in the context of multidimensional (OLAP) databases, no past work has looked at the problem of building an industry-strength tool for automated selection of materialized views and indexes for SQL workloads. In this paper, we… CONTINUE READING

Citations

Publications citing this paper.
SHOWING 1-10 OF 382 CITATIONS, ESTIMATED 28% COVERAGE

A Comparative Study of Materialised View Selection in Data Warehouse Environment

  • 2013 5th International Conference on Computational Intelligence and Communication Networks
  • 2013
VIEW 4 EXCERPTS
CITES BACKGROUND & METHODS
HIGHLY INFLUENCED

Managing large-scale probabilistic databases

VIEW 42 EXCERPTS
CITES BACKGROUND & METHODS
HIGHLY INFLUENCED

A Comparative Analysis of Materialized Views Selection and Concurrency Control Mechanisms in NoSQL Databases

  • 2017 IEEE International Conference on Cluster Computing (CLUSTER)
  • 2017
VIEW 5 EXCERPTS
CITES BACKGROUND & METHODS
HIGHLY INFLUENCED

Efficient Data Blocking and Skipping Framework Applying Heuristic Rules

  • 2017 IEEE 23rd International Conference on Parallel and Distributed Systems (ICPADS)
  • 2017
VIEW 4 EXCERPTS
CITES METHODS & BACKGROUND
HIGHLY INFLUENCED

Cost effective storage space for data cubes

  • Journal of Intelligent Information Systems
  • 2016
VIEW 10 EXCERPTS
CITES METHODS & BACKGROUND
HIGHLY INFLUENCED

Allocation Strategies for Data-Oriented Architectures

VIEW 5 EXCERPTS
CITES BACKGROUND, METHODS & RESULTS
HIGHLY INFLUENCED

An integer programming approach for the view and index selection problem

VIEW 16 EXCERPTS
CITES BACKGROUND & METHODS
HIGHLY INFLUENCED

FILTER CITATIONS BY YEAR

2001
2019

CITATION STATISTICS

  • 61 Highly Influenced Citations

  • Averaged 23 Citations per year over the last 3 years

Similar Papers

Loading similar papers…