林子雨注：本文是在北京大学数据库实验室攻读博士学位期间发表的。
[LYWS09]林子雨, 杨冬青,王腾蛟,宋国杰. 实视图选择研究. 软件学报.Vol.20, No.2, February 2009, pp.193-213.[全文PDF下载]
实视图选择研究∗
林子雨1,2+, 杨冬青1,2, 王腾蛟1,2, 宋国杰3
1(高可信软件技术教育部重点实验室(北京大学),北京 100871)
2(北京大学 信息科学技术学院,北京 100871)
3(机器感知与智能教育部重点实验室(北京大学),北京 100871)
Research on Materialized View Selection
LIN Zi-Yu1,2+, YANG Dong-Qing1,2, WANG Teng-Jiao1,2, SONG Guo-Jie3
1(Key Laboratory of High Confidence Software Technologies for the Ministry of Education (Peking University), Beijing 100871, China)
2(School of Electronics Engineering and Computer Science, Peking University, Beijing 100871, China)
3(Key Laboratory of Machine Perception for the Ministry of Education (Peking University), Beijing 100871, China)
Lin ZY, Yang DQ, Wang TJ, Song GJ. Research on materialized view selection. Journal of Software, 2009, 20(2):193−213. http://www.jos.org.cn/1000-9825/3416.htm
Abstract: Definition of view selection issue in the field of data warehouses is presented, followed by the discussion of related problems, such as cost model, benefit function, cost computation, restriction condition, view index, etc. Then three categories of view selection methods, namely, static, dynamic and hybrid methods are discussed. For each method, some representative work is introduced. Finally some future trends in this area are discussed.
Key words: materialized view; view selection; data warehouse
摘 要: 定义了数据仓库领域的视图选择问题,并讨论了与该问题相关的代价模型、收益函数、代价计算、约束条件和视图索引等内容;介绍了3大类视图选择方法,即静态方法、动态方法和混合方法,以及各类方法的代表性研究成果;最后展望未来的研究方向.
关键词: 实视图;视图选择;数据仓库