Affiliation:
1. Microsoft Research, Redmond, WA
Abstract
Physical database design tools rely on a DBA-provided workload to pick an “optimal” set of indexes and materialized views. Such tools allow either creating a new such
configuration
or adding new structures to existing ones. However, these tools do not provide adequate support for the incremental and flexible refinement of existing physical structures. Although such refinements are often very valuable for DBAs, a completely manual approach to refinement can lead to infeasible solutions (e.g., excessive use of space). In this article, we focus on the important problem of
physical design refinement
and propose a transformational architecture that is based upon two novel primitive operations, called
merging
and
reduction
. These operators help refine a configuration, treating indexes and materialized views in a unified way, as well as succinctly explain the refinement process to DBAs.
Publisher
Association for Computing Machinery (ACM)
Reference27 articles.
1. Database tuning advisor for microsoft SQL server 2005
2. Automatic physical design tuning
3. Brassard G. and Bratley P. 1996. Fundamental of Algorithmics. Prentice Hall Englewood Cliffs NJ. Brassard G. and Bratley P. 1996. Fundamental of Algorithmics. Prentice Hall Englewood Cliffs NJ.
4. Automatic physical database tuning
Cited by
14 articles.
订阅此论文施引文献
订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献
1. Pando: Enhanced Data Skipping with Logical Data Partitioning;Proceedings of the VLDB Endowment;2023-05
2. Budget-aware Index Tuning with Reinforcement Learning;Proceedings of the 2022 International Conference on Management of Data;2022-06-10
3. DISTILL;Proceedings of the VLDB Endowment;2022-06
4. Replicated layout for in-memory database systems;Proceedings of the VLDB Endowment;2021-12
5. Streaming statistical models via Merge & Reduce;International Journal of Data Science and Analytics;2020-06-12