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

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 la

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

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

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