Data drilling method and system

A data and drilling technology, applied in the field of data processing, can solve problems such as excessive time consumption, achieve the effect of improving drilling efficiency, improving data query efficiency, and reducing the number of queries

Active Publication Date: 2021-12-10
南京网眼信息技术有限公司
View PDF12 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0014] Aiming at the problem of excessive time-consuming querying data existing in the data ana

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 drilling method and system
  • Data drilling method and system
  • Data drilling method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0062] The following first takes the query of the current data as an example to illustrate, such as figure 1 shown:

[0063] 1. The server side receives the request that the front end needs to drill down to display data;

[0064] 2. The server parses the request, and the parsing process is as follows: according to the parameters of the drill-down, generate the drill-down list information of N layers, where N≥1, and N is a positive integer, including the drill-down dimension field of each layer , the number of dimension values, the sorting dimension field and whether the sorting dimension is sorted in ascending or descending order, the sorting dimension field and its calculation formula (the calculation formula can be preset by the user and saved on the server side) and other information. For example, two user data a and b are currently being analyzed. If in the original list, the number of a has two groups, a and b are dimension fields, the number is the dimension field, and ...

Embodiment 2

[0086] This embodiment takes the query of chain ratio data as an example, and the specific steps are as follows figure 2 and image 3 shown:

[0087] 1. The server side receives the request that the front end needs to drill down to display data;

[0088] 2. The server parses the request, and the parsing process is as follows: according to the parameters of the drill-down, generate the drill-down list information of N layers, where N≥1, and N is a positive integer, including the drill-down dimension field of each layer , the number of dimension values, the sorting dimension field and whether the sorting dimension is sorted in ascending or descending order, the sorting dimension field and its calculation formula (the calculation formula can be preset by the user and saved on the server side) and other information. For example, two user data a and b are currently being analyzed. If in the original list, the number of a has two groups, a and b are dimension fields, the number i...

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 drilling method which comprises the following steps of S1, receiving and analyzing a user request, and generating N layers of drill-down lists, N being a positive integer greater than or equal to 1; S2, according to the drill-down lists, obtaining and analyzing the drill-down data of each layer from the first layer in a layer-by-layer manner until the N-th layer is ended; and S3, processing the obtained data, generating the format data meeting the front-end direct display requirement, and returning the format data to a user. The invention further provides a data drilling system. According to the present invention, data are drilled layer by layer by using the layered drill-downs, and the data drilling efficiency is effectively improved.

Description

technical field [0001] The invention belongs to the technical field of data processing, and more specifically relates to a data drilling method and system. Background technique [0002] Drilling is one of the special functions in the report. By using the drilling function, users can click a link in a report to directly open other related reports. For example, in an intelligent system of online data analysis, there is such a result: the product category with the highest purchase rate of customer groups aged 30 to 40. Now users also need to know more detailed results, such as which products they mainly purchased. In technical terms, it is necessary to know which data this conclusion is based on. At this time, it can be realized by using report drill. [0003] When performing big data analysis, the most frequently used operation is to drill. Drilling is to change the dimension level and change the granularity of analysis. It includes drill up and drill down. Drilling up is...

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/22G06F16/2458G06F16/248G06F16/25G06F16/84
CPCG06F16/2246G06F16/2282G06F16/2474G06F16/248G06F16/258G06F16/84
Inventor 张杰徐健任翔袁有雷朱宏峰闵克东曹荣解宇
Owner 南京网眼信息技术有限公司
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