Method of seting up and inquirying multiple-demensional data cube

Abstract

The method includes steps: building index, defining dimension, building dimension, defining object structure, loading object. The method builds index for each attribute member of object data, organizes each attribute of object as query dimension, and dimension node is pointed to the index. In computation, based on selected dimension node, object data are obtained through looking up index, and then an operation of rolling up is carried out. Since data analysis is based on the cube, thus, analysis can be carried out for same attribute according to different sort modes. That is to say there are more than one rolling up routes for same attribute. When cube structure is needed to adjust, it is only needed to update index pointer of dimension nodes without need of reloading object. Thus, maintenance process is very simple and high efficiency.

Description

technical field

[0001] The invention relates to a method for operating computer programs on a known computer and processing external data, which is suitable for dynamic query and multidimensional analysis of database data, ensures that the dimension and hierarchical relations of multidimensional data models can be generated at any time, improves the efficiency of the maintenance process, and saves energy. time and storage medium. Background technique

[0002] More recently, database developers have turned to data warehousing technologies to resolve often conflicting data management requirements. In the traditional data analysis process, managers and decision makers of enterprises often obtain information through programming by information technology personnel or through fixed-format reports that have been "prefabricated" in the application system. The data warehouse and the online analytical processing (OLAP) technology based on it provide users with a multi-level, multi-an...

Images