| 超大型压缩数据仓库的查询研究 |
| |
| 引用本文： | 张应龙,盛立琨. 超大型压缩数据仓库的查询研究[J]. 计算机与现代化, 2009, 0(6) |
| |
| 作者姓名： | 张应龙 盛立琨 |
| |
| 作者单位： | 1. 华南理工大学软件学院,广东,广州,510006;江西农业大学计算机学院,江西,南昌,330045
2. 江西农业大学图书馆,江西,南昌,330045 |
| |
| 摘 要： | 查询速度是联机分析处理中的一个关键性能指标,人们通过事先生成所有可能的聚集来提高查询速度,然而这样的完全物化是以存储空间为代价的.针对数据立方体数据分布特点和结合压缩技术,本文介绍如何最大化节省存储空间来进行完全物化,然后在此基础上对查询进行了研究,以达到最小存储空间以及较好的查询速度的目的.
|
| 关 键 词： | 数据仓库 联机分析处理 数据立方体 压缩 查询 |
Research on Query for Very Large Compressed Data Warehouse |
| |
| ZHANG Ying-long,SHENG Li-kun. Research on Query for Very Large Compressed Data Warehouse[J]. Computer and Modernization, 2009, 0(6) |
| |
| Authors: | ZHANG Ying-long SHENG Li-kun |
| |
| Affiliation: | 1.School of Software;South China University of Technology;Guangzhou 510006;China;2.School of Computer;Jiangxi Agriculture University;Nanchang 330045;3.Library of Jiangxi Agriculture University;China |
| |
| Abstract: | The query is one of key performance index in OLAP processing,by generating all possible aggregations,the speed of query is improved,but the full materialization can consume large numbers of storage space.According to the distribution of data cube and using compressed technology,the paper first introduces how to materialize the cube to saving storage space,then studies the query on the cube for the targets which have the least storage space and well query speed. |
| |
| Keywords: | data warehouse OLAP data cube compress query |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
