Method and device for generating multidimensional cubic based on relational database

A technology of dimensional cube and database, applied in the field of data management, can solve the problems of data warehouse pressure load, large amount of data, occupying data warehouse storage space, etc., to achieve the effect of improving efficiency and reducing load pressure

Inactive Publication Date: 2009-06-10
CHINA CONSTRUCTION BANK
View PDF0 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, the data displayed by the data display is usually extracted one by one from the data warehouse, saved in a temporary file, and then updated and loaded to the cube (multi-dimensional cube). This method will frequently access the data warehouse, causing pressure on the data warehouse , and the cube generation efficiency is low
In addition, due to the large amount of data, it greatly occupies the storage space of the data warehouse, causing the cost of the data warehouse to remain high

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 and device for generating multidimensional cubic based on relational database
  • Method and device for generating multidimensional cubic based on relational database
  • Method and device for generating multidimensional cubic based on relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0031] figure 1 is a schematic flowchart of the first embodiment of the method for generating a cube based on a relational database in the present invention. Such as figure 1 As shown, the method for generating a cube based on a relational database in this embodiment includes:

[0032] Step 101: Select a relational database with a star structure, ie, a data warehouse, convert and load data from the data warehouse to generate a cube, thereby realizing the applicat...

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 invention discloses a method for generating a multi-dimensional cube based on a relational database. The method comprises: converting and loading data of a data warehouse which is the relational database with a star structure to generate cube; importing updated data into the data warehouse; exporting the updated data from the data warehouse in the form of data text; and taking the data text as a data source to update and load the cube. The method exports the data from the data warehouse in the form of the regular data text first and then takes the data text as the data source to load and update the cube, so as to avoid direct access of the data warehouse when updating the cube, lighten the load pressure caused by frequent access of the data warehouse, and improve the efficiency of cube generation.

Description

technical field [0001] The invention relates to the field of data management, in particular to a method for generating a multidimensional cube based on a relational database. Background technique [0002] OLAP (On-Line Analytical Process) is a complex analysis technology based on massive data. It enables analysts and managers to convert from raw data from multiple perspectives and can truly be understood by users. It is a kind of software technology that can quickly, consistently and interactively access the information that truly reflects the dimensional characteristics of the data, so as to obtain a deeper understanding of the data. The data warehouse is a subject-oriented, integrated, relatively stable data collection that reflects historical changes, and is used to support management decisions. It proposes a comprehensive solution for OLAP. Therefore, in order to analyze various data more effectively, data warehouse technology is widely used in various fields. The appli...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 郑承满陈少静赵世辉胡涛江融函李鹏刘浩王成名董恒星
Owner CHINA CONSTRUCTION BANK
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap