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

Presto-based data multi-dimensional analysis method

A multi-dimensional analysis and data technology, applied in multi-dimensional databases, database models, structured data retrieval, etc., can solve problems such as online multi-dimensional analysis of data that cannot solve terabyte-level data, and improve storage scalability and user experience. Effect

Active Publication Date: 2018-05-18
KE COM (BEIJING) TECHNOLOGY CO LTD
View PDF5 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The present invention provides a presto-based data multidimensional analysis method that overcomes the problem of online multidimensional analysis of TB-level data that cannot be solved by existing OLAP analysis

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
  • Presto-based data multi-dimensional analysis method
  • Presto-based data multi-dimensional analysis method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] The specific implementation manners of the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. The following examples are used to illustrate the present invention, but are not intended to limit the scope of the present invention.

[0039] In order to overcome the problem that OLAP analysis in the prior art cannot solve the problem of online multidimensional analysis of TB-level data, the present invention provides a presto-based multidimensional analysis method for data.

[0040] figure 1 It is a flow chart of a multidimensional analysis method based on presto data provided according to an embodiment of the present invention, such as figure 1 As shown, the method includes:

[0041] S1. Model all the business data in the data warehouse, and map the modeled logic model to the data table of the data warehouse.

[0042] S2, according to the logic model, convert the query operation of the user into SQL...

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 a presto-based data multi-dimensional analysis method. The method comprises the steps that S1, modeling is performed on all business data in a data warehouse, and a logic modelobtained after modeling is mapped into a data table of the data warehouse; S2, query operation by a user is converted into an SQL according to the logic model; and S3, the SQL is submitted to a prestoquery engine, and an analysis result is acquired. Through the method, by storing data analyzed through OLAP into the data warehouse in a structured form, the storage extensibility, the reading rate and the analysis rate of the data are improved, real-time online analysis also can be performed on data in a TB data volume, and user experience is improved.

Description

technical field [0001] The present invention relates to the technical field of computer data management, and more specifically, relates to a multidimensional analysis method of presto-based data. Background technique [0002] OLAP is online analytical processing. OLAP system is the most important application of data warehouse system. It is specially designed to support complex analysis operations, focusing on decision support for decision makers and senior management personnel. It can be quickly and flexibly according to the requirements of analysts. Complex query processing of large amounts of data, and provide the query results to decision makers in an intuitive and easy-to-understand form, so that they can accurately grasp the business status of the enterprise, understand the needs of the object, and formulate the correct plan. In recent years, OLAP has become a popular method for processing multidimensional data used by data warehouses and business intelligence. [0003...

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/2433G06F16/283G06F16/33
Inventor 王勇
Owner KE COM (BEIJING) TECHNOLOGY 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