Survey on automatic physical database design
数据库物理自调优研究技术综述

Automatic physical database design is an important part in self-tuning and self-managing databases. To reflect upon the main research work on this topic, this paper gave a brief survey on the classic technology in physical database design tools in terms of background, problem definition, techniques, and potential future research directions. Specifically, this paper analyzed the common techniques from four dimensions, namely, cost optimality, scalability, high usability and benchmarking. And by comparing different strategies, it also spoted and evaluated their technical differences in detail. The paper discussed new research endeavors in recent years which went beyond the limits of the classic physical design problem. In the end, it gave the conclusion and the vision of the future research directions.