%0 Journal Article
%T Survey on automatic physical database design
数据库物理自调优研究技术综述
%A CAO Wei
%A
曹巍
%J 计算机应用研究
%D 2012
%I
%X 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.
%K automatic physical design
%K query optimizers
%K what-if analysis
%K physical structures
%K workload
%K search in physical space
物理自调优
%K 查询优化器
%K whatif分析
%K 物理结构
%K 工作负载
%K 物理空间搜索
%U http://www.alljournals.cn/get_abstract_url.aspx?pcid=5B3AB970F71A803DEACDC0559115BFCF0A068CD97DD29835&cid=8240383F08CE46C8B05036380D75B607&jid=A9D9BE08CDC44144BE8B5685705D3AED&aid=F886A295C1E57CC58176EF70217D8F8F&yid=99E9153A83D4CB11&vid=771469D9D58C34FF&iid=94C357A881DFC066&sid=C20D616EFC5754AE&eid=2E3D2E3C7A6F11A2&journal_id=1001-3695&journal_name=计算机应用研究&referenced_num=0&reference_num=19