CAJ | 학술논문

从港口企业面临的决策需求出发,分析港口现有数据来构建港口数据立方体.多维联机分析处理(MOLAP)是在数据立方体上进行的应用查询,支持维层次是MOLAP的一个重要特征,一般层次维是以数组形式进行存储的,但是教组存储不仅不能体现维的层次特征,还使得数据单元出现冗余.针对数组存储的不足,采用维层次存储树来保存层次维信息,体现了维的层次特性,消除了冗余数据,方便层次维的查询和更新,且各层维成员采用二进制编码方式,不仅节省了存储空间,还提高了查询效率.
종항구기업면림적결책수구출발,분석항구현유수거래구건항구수거립방체.다유련궤분석처리(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,se 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.