Computation of Data Dube in Analysis of Water Census Results
Zhu Ka · Computer and Digital Engineering · 2014
The cube with n dimensions can generate 2n aggregated cuboids.How to execute cube computation to seek balance in storage space and query time is a key issue in the application of multidimensional analysis.Based on the strategy of partial materialization,and combined with characteristics of water census,the minimal cubing approach is improved and a novel method HDEF cubing(hierarchical dimension encoding fragments cubing)is proposed.By using the small hierarchical dimension encoding and its hierarchical prefix path,HDEF cubing can rapidly retrieve the hierarchical dimension encoding matching with the query keywords.As a result,this method can greatly reduce multi-table join operations and highly improve the efficiency of multidimensional analysis.Taking water census data for example,the improved method of cube computation is verified to store and query the cube efficiently,and it's suitable for analysis of water census results.