Data drilling method

A drilling and data technology, applied in other database indexing, other database retrieval, other database query, etc., can solve the problems of not being able to add filtering, no storage, no storage of drill path nodes, etc., to achieve flexible and diverse display, query and Intuitive and convenient browsing, effects that improve visualization performance

Inactive Publication Date: 2019-04-30
天津数观科技有限公司
View PDF5 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] 1. Because there is no chart information stored in the drill path nodes, nodes a, b, c, and d can only be of the same chart type. If the chart created by node a during visualization is a column chart, the other nodes are all columns picture;
[0006] 2. Because the drill path node does not store chart data dimension combination information, nodes a, b, c, and d, except the dimensions specified on t...

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] Below, the structure and working principle of the present invention will be further described in conjunction with the accompanying drawings.

[0028] Such as figure 1 As shown, the data drilling method of the embodiment of the present invention includes the following steps:

[0029] S1. Obtain a plurality of nodes, and respectively determine graph description information of each node according to user needs. Wherein, the graph description information includes dimension column information, type information, and style information of the graph corresponding to the node, and all filter conditions corresponding to the node that can be used for query. Specifically, the dimension column information of the chart is used to determine the description group number of the dimension column of the icon, the name of each dimension column, the aggregation type of the dimension column, and the like. Among them, the number of dimension columns describing the number of groups is multipl...

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. The data drilling method comprises the steps of obtaining a plurality of nodes, and determining chart description information of each node; establishingat least one drilling path, and determining drilling path information of each node; storing each node with the corresponding chart description information and the corresponding drilling path information as node description information of the node; receiving a query instruction, and establishing a data query structure according to the query instruction; searching a drill-down data query result ofthe current node in a database according to the data query structure; and searching a drill-up data query result of any node in a database according to the data query structure. According to the datadrilling method, the corresponding node description information can be set for each node on the drilling path according to the business requirements, the visualization performance of the drilling result is improved, and a user can check the data drilling result more efficiently and conveniently through a visualization mode.

Description

technical field [0001] The invention relates to the technical field of computer applications, in particular to a data drilling method. Background technique [0002] Data drilling has become a basic functional requirement in the field of data visualization and business intelligence. The traditional drilling method based on the data source table or data model currently used usually needs to predefine the dimension drilling path on the data source, so during the drilling execution process, it can only be drilled according to this dimension path. At the same time, because the storage structure of the drill path does not store visualization-oriented description information, such as the type description information of the visualization chart, the data dimension combination description information of the visualization chart, or the style description information of the visualization chart, etc., there is no The drill path saves specific filter conditions, which will result in the i...

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/901G06F16/903
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