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

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

Example Embodiment

[0038] The specific embodiments of the present invention will be described in further detail below in conjunction with the drawings and embodiments. The following examples are used to illustrate the present invention, but not 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 online multidimensional analysis of TB-level data, the present invention provides a presto-based data multidimensional analysis method.

[0040] figure 1 A flow chart of a presto-based data multi-dimensional analysis method provided according to an embodiment of the present invention, such as figure 1 As shown, the method includes:

[0041] S1: Model all business data in the data warehouse, and map the logical model after the modeling to the data table of the data warehouse.

[0042] S2: According to the logic model, the user's query operation is converted into SQL language;

[0043] S3. Submit the SQL language to the presto q...

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