A multidimensional data analysis method based on presto data

A multi-dimensional analysis and data technology, applied in multi-dimensional database, database model, text database query, etc., can solve problems such as online multi-dimensional analysis of data that cannot solve terabytes of data

Active Publication Date: 2021-06-08
KE COM (BEIJING) TECHNOLOGY CO LTD
View PDF5 Cites 0 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
  • A multidimensional data analysis method based on presto data
  • A multidimensional data analysis method based on presto data

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 present invention provides a multidimensional analysis method based on presto data, the method comprising: S1, modeling all business data in the data warehouse, and mapping the modeled logic model to the data table of the data warehouse middle; S2, according to the logic model, convert the user's query operation into SQL language; S3, submit the SQL language to the presto query engine, and obtain the analysis result. The method provided by the present invention, by storing the data analyzed by OLAP in a data warehouse in a structured form, improves the storage scalability of data, the reading rate of data and the analysis rate, and can also perform real-time performance for data of TB size. Online analysis improves user experience.

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/28G06F16/242G06F16/33
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