港口数据MOLAP中层次维的存储  

Storage of hierarchical dimension in port data MOLAP

作　　者：潘明霞[1] 王宇[1] 

机构地区：[1]大连理工大学管理学院信息管理系,辽宁大连116024

出　　处：《计算机工程与应用》2010年第3期211-214,共4页Computer Engineering and Applications

摘　　要：从港口企业面临的决策需求出发,分析港口现有数据来构建港口数据立方体。多维联机分析处理(MOLAP)是在数据立方体上进行的应用查询,支持维层次是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 dimension,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.

关 键 词：港口 数据立方体 多维联机分析处理 层次维 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论] U691[自动化与计算机技术—计算机科学与技术]