| 本文已被：浏览 4762次 下载 6364次 |
码上扫一扫！ |
|
|
| 多维数据实视图的动态选择 |
|
谭红星1,2, 周龙骧1
|
|
1.中国科学院,数学与系统科学研究院,数学研究所,北京,100080;2.河南大学,计算机科学学院,河南,开封,475001
|
|
| 摘要: |
| 提出了多维数据中实视图的动态选择方案.其基本思想是由系统跟踪查询的分布情况,并据此动态地调整实视图集合.具体实现了该方案,并证明了在一定条件下,单次选择算法的效果与最优效果的差具有一定的上限.实验结果表明,动态方案的效果优于已有的其他选择方案. |
| 关键词: 实视图 OLAP(online analytical processing) 多维数据 数据仓库 |
| DOI： |
| 分类号: |
| 基金项目:国家自然科学基金资助项目(2008100) |
|
| Dynamic Selection of Materialized Views of Multi-Dimensional Data |
|
TAN Hong-xing,ZHOU Long-xiang
|
| Abstract: |
| A novel method is proposed to select materialized views of multi-dimensional data called dynamic selection. The idea of dynamic selection is that the system is in charged of collecting the queries to obtain their distribution. The set of materialized views is adjusted dynamically according to the queries?distribution. The method is given in detail including the algorithm of single-step selection and the instant adjusting method. It is also proved that under certain constraints, the performance of the single-step algorithm is guaranteed to be no worse than that of the optimal one by a certain bound.The xeperimental results show that the dynamic selection is more effective than other solutions. |
| Key words: materialized view OLAP （online analytical processing） multi-dimensional data data warehousing |
