相關主題
商品描述
Due to the increasing complexity in application workloads and query engines, database administrators are turning to automated tuning tools that systematically explore the space of physical design alternatives. A critical element of such tuning is physical database design since the choice of physical structures has a significant impact on the performance of the database system. Automated Physical Database Design and Tuning presents a detailed overview of the fundamental ideas and algorithms for automatically recommending changes to the physical design of a database system.
The first part of the book introduces the necessary technical background. The author explains SQL, the space of execution plans for answering SQL queries, query optimization, how the choice of access paths (e.g., indexes) is crucial to performance, and the complexity of the physical design problem.
The second part extensively discusses automated physical design techniques, covering fundamental research ideas in the last 15 years that have resulted in a new generation of tuning tools. The text focuses on the search space of alternatives, the necessity of a cost model to compare such alternatives, different mechanisms to traverse and enumerate the search space, and practical aspects in real-world tuning tools.
In the third part, the author explores new advances in automated physical design. He applies previous approaches to other physical structures, such as materialized views, partitioning, and multidimensional clustering. He also analyzes workload models for new types of applications, generalizes the optimizing function of current physical design tools to cope with other application scenarios, and examines open-ended challenges in physical database design.
This book offers valuable insights on well-established principles and cutting-edge research results in automated physical design. It helps readers gain a deeper understanding of how automated tuning tools work in database installations as well as the challenges and opportunities involved in designing next-generation tuning tools.
商品描述(中文翻譯)
由於應用工作負載和查詢引擎的複雜性日益增加，資料庫管理員開始轉向自動調整工具，這些工具系統性地探索物理設計替代方案的空間。這種調整的一個關鍵要素是物理資料庫設計，因為物理結構的選擇對資料庫系統的性能有重大影響。《自動化物理資料庫設計與調整》提供了自動推薦資料庫系統物理設計變更的基本概念和算法的詳細概述。
本書的第一部分介紹了必要的技術背景。作者解釋了 SQL、用於回答 SQL 查詢的執行計劃空間、查詢優化、訪問路徑（例如索引）的選擇對性能的重要性，以及物理設計問題的複雜性。
第二部分廣泛討論了自動化物理設計技術，涵蓋了過去 15 年來的基本研究思想，這些思想導致了一代新型的調整工具。文本重點在於替代方案的搜索空間、比較這些替代方案所需的成本模型、遍歷和列舉搜索空間的不同機制，以及現實世界調整工具中的實際方面。
在第三部分，作者探討了自動化物理設計的新進展。他將先前的方法應用於其他物理結構，如物化視圖、分區和多維聚類。他還分析了新類型應用的工作負載模型，將當前物理設計工具的優化函數進行概括，以應對其他應用場景，並檢視物理資料庫設計中的開放性挑戰。
本書提供了有關自動化物理設計的成熟原則和前沿研究成果的寶貴見解。它幫助讀者更深入地理解自動調整工具在資料庫安裝中的運作方式，以及設計下一代調整工具所面臨的挑戰和機遇。
