Unlock instant, AI-driven research and patent intelligence for your innovation.

Data online analysis processing method and device, equipment and storage medium

An online analytical processing and data technology, applied in the field of communication, can solve problems such as difficulty in changing multi-dimensional data models, longer response time for data query, and large storage space for result data.

Pending Publication Date: 2021-05-07
EVERSEC BEIJING TECH
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, in the ROLAP method, when the amount of data in the data table or the computational complexity increases, the data query response time will become longer and the response speed will be slower; the MOLAP method uses a multidimensional array storage model to query data, although the response speed is faster, but Since the multidimensional data model is difficult to change once it is built, and the result data is stored in the cube mode, the MOLAP method has low flexibility in data query, and the result data occupies a large storage space

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
  • Data online analysis processing method and device, equipment and storage medium
  • Data online analysis processing method and device, equipment and storage medium
  • Data online analysis processing method and device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0032] figure 1 It is a flow chart of an online data analysis and processing method provided by Embodiment 1 of the present invention. This embodiment is applicable to the situation of providing users with matching target data according to user query requests. This method can be implemented by an online data analysis and processing device To execute, the device can be implemented by software and / or hardware, and can generally be integrated in computers and all smart devices (such as terminal devices or servers) that include program running functions, specifically including the following steps:

[0033] Step 110: Acquire a multidimensional data model defined by the user, and use the multidimensional data model to perform precomputation on the original data in response to the user's query request to generate a precalculation result set.

[0034] In this embodiment, the multidimensional data model is a fact-based and dimension-based database model established to meet the needs of...

Embodiment 2

[0049] This embodiment is a further refinement of the first embodiment above, and explanations of terms that are the same as or corresponding to those in the above embodiment will not be repeated in this embodiment. figure 2 It is a flow chart of a data online analysis and processing method provided by Embodiment 2 of the present invention. In this embodiment, the technical solution of this embodiment can be combined with one or more methods in the solutions of the above embodiments. In this example, if figure 2 As shown, the method provided in the embodiment of the present invention may also include:

[0050] Step 210, acquiring a user-defined multi-dimensional data model.

[0051] Step 220, in response to the user's query request, verify the validity of the parameters of the multi-dimensional data model.

[0052] In a specific embodiment, the legal verification may refer to non-nullness verification or data source verification on the parameters of the multidimensional da...

Embodiment 3

[0068] This embodiment is a further refinement of the above-mentioned embodiment two, and explanations of terms that are the same as or corresponding to those in the above-mentioned embodiment will not be repeated in this embodiment. Figure 3a It is a flow chart of an online data analysis and processing method provided by Embodiment 3 of the present invention. In this embodiment, the technical solution of this embodiment can be combined with one or more methods in the solutions of the above embodiments. In this example, if Figure 3a As shown, the method provided in the embodiment of the present invention may also include:

[0069] Step 310: Acquire a multidimensional data model defined by the user, and use the multidimensional data model to perform precomputation on the original data in response to the user's query request to generate a precalculation result set.

[0070] Step 320: Generate an in-memory data table according to the pre-computation result set, and convert the...

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 discloses a data online analysis processing method and device, equipment and a storage medium, and the method comprises the steps: obtaining a multi-dimensional data model, making pre-calculation of original data, and generating a pre-calculation result set; according to the pre-calculation result set, generating a memory data table, and converting an SQL language corresponding to the multi-dimensional data model into an SQL language corresponding to the memory data table; establishing a mapping relationship between the memory data table and the multi-dimensional data model, updating the memory data table according to the mapping relationship, and converting an SQL language corresponding to the memory data table into a new SQL language according to the updated memory data table; and converting the query request into a target SQL language, obtaining target data by using the target SQL language, converting the target data into a target result set, and providing the target result set for the user. According to the technical scheme, the response speed of data query can be increased, a more flexible query scene is supported, and the storage space of the target data is reduced.

Description

technical field [0001] Embodiments of the present invention relate to the field of communication technologies, and in particular, to a method, device, device, and storage medium for online analysis and processing of data. Background technique [0002] Online Analytical Processing (OLAP) is a data analysis and processing technology that enables analysts to quickly, consistently, and interactively observe information from various aspects in order to achieve a deep understanding of data. [0003] Existing methods for implementing OLAP mainly include the following two methods. The first method is the Relational Online Analytical Processing (ROLAP) method. Relational design, using standard Structured Query Language (Structured Query Language, SQL) can instantly query data of different dimensions according to user needs; the second is the multidimensional online analytical processing (Multidimensional Online Analytical Processing, MOLAP) method, this method uses To implement OLAP...

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): G06F16/28G06F16/242G06F16/2453G06F16/2457
CPCG06F16/283G06F16/2457G06F16/2433G06F16/2453Y02D10/00
Inventor 陈辛张铭超许伟史安明蔡雪柴睿王川侯立冬孟宝权王杰杨满智蔡琳梁彧田野傅强金红陈晓光
Owner EVERSEC BEIJING TECH