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

Multidimensional data reading and writing method and apparatus in on-line analytical processing system

An online analytical processing, multi-dimensional data technology, applied in the computer field, to achieve the effect of being conducive to storage and query, occupying less memory space

Active Publication Date: 2007-04-18
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF0 Cites 19 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] In view of this, the present invention is to provide a method and device for reading and writing multi-dimensional data in an online analysis and processing system to solve the above-mentioned problems of storage and query of small data volumes

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
  • Multidimensional data reading and writing method and apparatus in on-line analytical processing system
  • Multidimensional data reading and writing method and apparatus in on-line analytical processing system
  • Multidimensional data reading and writing method and apparatus in on-line analytical processing system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] With the rapid development of the global economy today, whether it is a multinational company, an enterprise or a government agency, a large amount of data needs to be processed every day. These data include various categories, such as production, sales, and daily office work. Decision makers make decisions on market sales and production progress by analyzing the large amount of data generated. But for some small companies, less data is generated every day. If a large-scale OLAP system for analyzing massive data is used, large system resources will be wasted.

[0034] The idea and specific implementation process of the present invention will be described in detail below. The present invention is mainly applied to OLAP with small data volume embedded in memory. For the generated multidimensional data, the present invention stores the combination of members in each dimension and the corresponding data in memory for analysis and processing. See Figure 1,

[0035] Main st...

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 relates to many dimensions data read-write method and device in on-line analytical processing system. It includes the following steps: getting original data from the data source; setting each dimensionality member random combination for the original data; writing the metric value data of the combination and its corresponding original data in the internal memory; using the combination to read corresponding metric value data from the internal memory. It uses Hash table or array form to write in and read out while read-write data from the internal memory. The many dimensions data model is stored as Hash table form which is good for internal memory storing and inquiring. While read-write small data quantity, the Hash table takes up little internal memory space which will not be the bottle-neck of the system performance, realize small data quantity OLAP storing and inquiring based on internal memory.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for reading and writing multi-dimensional data in an online analysis and processing system. Background technique [0002] Today, with the rapid development of science and technology, the data that needs to be counted in various fields of society are increasing rapidly. The recording and query of massive data bring new development directions and provide new technical issues for computer technology. [0003] Enterprise Resource Planning (ERP, Enterprise Recourse Planning) system brings new data management methods to enterprises. Through the ERP system, enterprises can use and manage various resources of the enterprise more efficiently. A large amount of data is stored in the ERP database. From the perspective of analysis and processing, the analysis generally requires multi-table operations and long running time. If the existing data in the ERP business syste...

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 KINGDEE SOFTWARE(CHINA) CO LTD
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