用字典法压缩数据仓库数据方案

A Scheme of Using Dictionary Method to Compress Data in Data-Warehouse

数据仓库中的数据量是呈几何级数增长的。数据量的急剧增长严重影响数据仓库系统的性能,降低数据库系统的查询效率。文章在分析数据仓库数据特性的基础上,提出了使用字典法压缩数据仓库数据的方案。在对数据进行压缩的同时,也极大地改善了数据库系统的性能。

The measure in DW is growing in geometric series.Rapidly increasing of the DW measure influence the per-formance of DW system badly,reduce the query efficiency of DB system.This article brings forward a scheme of com-pressing DW data,which basing on DW's data characteristic.When compressing the data,it can also greatly improve the performance of the DB system.