Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method of seting up and inquirying multiple-demensional data cube

A multi-dimensional data and cube technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of time-consuming and labor-intensive maintenance of multi-dimensional cubes, increased reconstruction time, etc., to save precious time and energy, simple maintenance process, The effect of saving storage media and money

Inactive Publication Date: 2005-01-12
HONGYUE TECH CHONGQING
View PDF0 Cites 50 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

As the amount of data increases, this rebuild time will also rise sharply, making the maintenance of multidimensional cubes a time-consuming and laborious task

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method of seting up and inquirying multiple-demensional data cube
  • Method of seting up and inquirying multiple-demensional data cube
  • Method of seting up and inquirying multiple-demensional data cube

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0045] The specific implementation can be divided into two steps: the first is to build a multi-dimensional data cube; the second is to extract data from the multi-dimensional data cube and perform roll-up calculation. The details are now as follows:

[0046] The first step is to build a multidimensional data cube:

[0047] 1. Establish a blank basic table as the index table of the multidimensional data cube; the index table is composed of the following three columns: the column used to record the attribute type of the multidimensional data cube node, the column used to record the attribute value of the multidimensional data cube node , and a column for recording the index value of the multidimensional data cube node;

[0048] 2. Determine the index generation method. Here, the index value is implemented as an integer type or a real type, and the attribute value is implemented as a string type; firstly, an index value generation function GetIndexCode is established, and the ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
Inventor 尹明悦唐兴亮
Owner HONGYUE TECH CHONGQING
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com