Storage of hierarchical dimension in port data MOLAP
暂无分享,去创建一个
With the decision requirements of port enterprises,a data cube is confirmed by analyzing the present port data. MOLAP is the application query based on data cube,and support hierarchical dimension is an important feature in MOLAP,usually,the hierarchical dimension is stored by the array,but the array storage cannot present the hierarchical feature of the dimen-sion,and it makes the redundant data cell.For the lack of array storage,use the dimension storage tree to store the dimensional information,which can present the hierarchical information of the dimension,and eliminate the redundant data cell,so it facilitates the query and the update of the hierarchical dimension.Also,it can save the storage space and optimize the query time,because it is encoded by binary coding.