| 一种基于时空因素的实化视图选择算法的研究与设计 |
| |
| 引用本文： | 侯贵宾,曹卫东.一种基于时空因素的实化视图选择算法的研究与设计[J].河北科技大学学报,2010,31(4):290-293. |
| |
| 作者姓名： | 侯贵宾 曹卫东 |
| |
| 作者单位： | 1. 秦皇岛港股份有限公司,河北秦皇岛,066002
2. 中国建设银行秦皇岛支行,河北秦皇岛,066022 |
| |
| 摘 要： | 分析了几种经典视图选择算法存在的不足,提出了一种新的基于时空因素的价值模型,在此基础上设计了一个新的视图选择算法——PBPUS(preprocessing benefit perunit space)算法。该算法与原有算法相比,降低了视图搜索的时间,减少了实化视图更新维护的代价,有效提高了实化视图的查询效率。
|
| 关 键 词： | 数据仓库 实化视图 选择算法 联机分析处理 |
| 收稿时间： | 2010/1/16 0:00:00 |
| 修稿时间： | 2010/3/28 0:00:00 |
Research and design of arithmetic for selecting materializeed views based on space-time factor |
| |
| HOU Gui-bin and CAO Wei-dong.Research and design of arithmetic for selecting materializeed views based on space-time factor[J].Journal of Hebei University of Science and Technology,2010,31(4):290-293. |
| |
| Authors: | HOU Gui-bin and CAO Wei-dong |
| |
| Institution: | HOU Gui-bin1,CAO Wei-dong2(1.Qinhuangdao Port Company Limited,Qinhuangdao Hebei 066002,China,2.Qinhuangdao Branch,China Construction Bank,Qinhuangdao Hebei 066022,China) |
| |
| Abstract: | This paper analyzes several shortcomings in the classical algorithms for selecting views,and a new cost model based on the space-time factor is proposed.A new algorithm PBPUS for selecting views is designed based on the model.In comparison with the original algorithm,it decreases the time complexity and maintenance cost,and improves the query efficiency of materialized views. |
| |
| Keywords: | data warehouse materialized view selection algorithm on-line analytical processing |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
| 点击此处可从《河北科技大学学报》浏览原始摘要信息 |
| 点击此处可从《河北科技大学学报》下载免费的PDF全文 |
|
