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

Online analytical processing method and device

An on-line analysis and processing technology to be queried, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as high failure rate and disk IO bottleneck, reduce the failure rate, avoid disk IO bottleneck, and alleviate The effect of disk IO pressure

Active Publication Date: 2017-06-13
JINGZAN ADVERTISING SHANGHAI CO LTD
View PDF5 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The technical problem solved by the present invention is that the existing online analysis and processing scheme is prone to disk IO bottlenecks and high failure rates when processing massive data

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
  • Online analytical processing method and device
  • Online analytical processing method and device
  • Online analytical processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] Those skilled in the art understand that, as mentioned in the background art, the existing OLAP solution cannot effectively solve the disk IO bottleneck problem at a lower cost and failure rate when performing complex analysis operations on massive data.

[0029] The inventor found through research that the above problem is caused by the fact that the existing OLAP solution still stores the data to be analyzed by row.

[0030] In order to solve the above technical problems, the technical solution of the embodiment of the present invention, after receiving the query instruction, determines the column store associated with the query condition in the preset column store based on the query condition included in the query instruction. database, so as to search in the column storage sub-library to obtain records meeting the query conditions, wherein the records included in the column storage sub-library are stored in columns. Compared with the existing online analysis and pro...

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 provides an online analytical processing method and device. The method comprises the steps that query instructions are received, the query instructions include pending to query conditions; a column storage child library associated with the pending to query conditions in the preset column storage library is determined based on the pending to query conditions, the preset column storage library includes at least a column storage child library, the column storage child library has at least a record according to the column storage, each record includes an identifier and data corresponding to the identifier, data of different column storage child library have different properties; records meeting the pending to query conditions are searched and obtained from the column storage library associated with the pending to query conditions. According to the technical scheme, the disk IO bottleneck problem caused by big data can be better solved, the speed and efficiency of online analytical processing are effectively improved, and large-scale promotions and applications of online analytical processing models are facilitated.

Description

technical field [0001] The invention relates to the field of big data applications, in particular to an online analysis and processing method and device. Background technique [0002] At this stage, in the field of data warehouse systems, it mainly relies on On-Line Analytical Processing (OLAP) to perform complex analysis operations on massive data, so as to provide data support for decision makers and senior managers. When the computer is performing online analysis and processing, it can quickly and flexibly perform complex query processing of large amounts of data according to the requirements of analysts, and present the query results to decision makers in an intuitive and easy-to-understand form, which is convenient for users to accurately grasp the enterprise The business situation of the company, understand the needs of the target, and then formulate the correct plan. [0003] For professional analysts and management decision makers in enterprises, when they analyze b...

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
CPCG06F16/24553G06F16/2457G06F16/283
Inventor 汤奇峰罗青山
Owner JINGZAN ADVERTISING SHANGHAI 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