| 基于层次有序维的分组聚集算法 |
| |
| 引用本文： | 王生富,张继福,刘爱琴,荀亚玲. 基于层次有序维的分组聚集算法[J]. 小型微型计算机系统, 2010, 31(6) |
| |
| 作者姓名： | 王生富 张继福 刘爱琴 荀亚玲 |
| |
| 作者单位： | 太原科技大学,计算机科学与技术学院,山西,太原,030024 |
| |
| 摘 要： | 在联机分析处理(OLAP)中,有效地维度模型对海量数据的即席复杂分组聚集查询起着关键的作用.在偏序和映射的基础上,通过定义层次有序维,提出一种基于层次有序维的分组聚集算法.该算法利用维属性之间的聚集关系,通过约束层次链中的元素次序,实现了分组聚集计算中多表连接转换为维范围的查询,提高了连接和聚集效率.最后,实验结果验证了该算法的有效性.
|
| 关 键 词： | 数据仓库 维模型 联机分析处理 聚集查询 多表连接 |
Aggregation Algorithm Based on Hierarchical Sequence Dimensions |
| |
| WANG Sheng-fu,ZHANG Ji-fu,LIU Ai-qin,XUN Ya-ling. Aggregation Algorithm Based on Hierarchical Sequence Dimensions[J]. Mini-micro Systems, 2010, 31(6) |
| |
| Authors: | WANG Sheng-fu ZHANG Ji-fu LIU Ai-qin XUN Ya-ling |
| |
| Affiliation: | WANG Sheng-fu,ZHANG Ji-fu,LIU Ai-qin,XUN Ya-ling(Institute of Computer Science , Technology,TaiYuan University of Science , Technology,Taiyuan 030024,China) |
| |
| Abstract: | In OLAP(Online Analytical Processing),an effective dimension model plays an important role in the complex aggregation queries on massive data set.In this paper,an aggregation algorithm based on hierarchical sequence dimensions is presented by using hierarchical sequence dimensions based on the concepts of partial order and mapping.Using the aggregation relationship between dimensional attributes,the algorithm transforms multi-table joining into dimensional query ranges in the aggregation computing based on ... |
| |
| Keywords: | data warehouse dimensional model OLAP aggregate query multi-table join |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
