Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A 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, reducing the number of queries, and improving data query efficiency

Active Publication Date: 2022-02-11
南京网眼信息技术有限公司
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 analysis process in the prior art, the present invention provides a data drilling method and system

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0062] In the following, we first take the data query of this period as an example to illustrate, such as figure 1 Shown:

[0063] 1. The server receives a request from the front end to drill down to display data;

[0064] 2. The server side parses the request. The parsing process is as follows: According to the drill-down parameters, 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, currently analyzing two user data of a and b, if in the original list, the number of a has two groups, a and b are the dimension fields, the quantity is the dimension field, and the dimension...

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 receives a request from the front end to drill down to display data;

[0088] 2. The server side parses the request. The parsing process is as follows: According to the drill-down parameters, 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, currently analyzing two user data of a and b, if in the original list, the number of a has two groups, a and b are the dimension fields, the quantity is the dimension fie...

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, comprising the following steps: S1, receiving and analyzing user requests, and generating a drill-down list of N layers, wherein N≥1, and N is a positive integer; S2, according to the drill-down list, from Starting from the first layer, the drill-down data of each layer is obtained and analyzed layer by layer until the end of the Nth layer; S3, the acquired data is processed, and the format data that meets the direct display requirements of the front end is generated and returned to the user. At the same time, the present invention also provides a data drilling system, which uses a layered drill-down list to drill data layer by layer, thereby effectively improving data drilling efficiency.

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
Patent Type & Authority Patents(China)
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 Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com