Data drilling method, apparatus and server

A data extraction and drilling technology, applied in the field of data management, can solve problems such as inflexibility

Active Publication Date: 2018-12-21
BEIJING BAIDU NETCOM SCI & TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Moreover, in the existing data analysis tools, the SQL statements used are all simply generated, so that data drilling can usually only be performed in one data source, which is not flexible enough

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, apparatus and server
  • Data drilling method, apparatus and server
  • Data drilling method, apparatus and server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0059] In the following, only some exemplary embodiments are briefly described. As those skilled in the art would realize, the described embodiments may be modified in various different ways, all without departing from the spirit or scope of the present invention. Accordingly, the drawings and descriptions are to be regarded as illustrative in nature and not restrictive.

[0060] figure 1A flow chart of a data drilling method 100 according to an embodiment of the present invention is shown. The method 100 can be used in a general database, and can also be used in various data analysis tools. The method 100 will be described in detail below with a commonly used data analysis platform, but it can be understood that the method 100 is not limited to the shown application platform, and what is shown is only a part of the platform, and cannot limit this The data drilling method provided by the embodiment of the invention. Such as figure 1 As shown, method 100 may include:

[00...

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 data drilling method, a device and a server. The method comprises the following steps: acquiring the data of the current layer when a drilling request for the data of the current layer is detected; Reading a drill-through statement for the current layer data; Wherein the drill-through statement comprises a data source command and a drill-through parameter extraction command; Extracting drilling parameters from the current layer data according to the data source command and the drilling parameter extraction command; Generating a standard SQL statement including the drill-through parameters by using the data source command and the extracted drill-through parameters; And displaying a drill-through result according to the standard SQL statement and the pre-configuration of the current layer data. The data drilling method provided by the invention can perform data drilling more flexibly according to requirements by separately configuring drilling statements for datafrom different data sources and further generating standard SQL statements.

Description

technical field [0001] The invention relates to the field of data management, and in particular to a data drilling method, device and server. Background technique [0002] With the development of technology, computer technology has been widely used in all aspects of life. People use computers and the Internet to manage a large amount of data generated in life and production. Technologies such as databases for managing data have thus made great progress and development. [0003] In data management, in order to facilitate viewing, the data is often displayed in the form of charts and further data analysis. Existing data analysis tools often use data drilling to analyze data in depth. [0004] When using data drilling for data analysis, the dimension or level of drilling is usually set when the data chart is created, and when some data is selected by clicking with the mouse, it will enter the next page of the current data. Moreover, in existing data analysis tools, the SQL s...

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 张军刘一鸣
Owner BEIJING BAIDU NETCOM SCI & TECH 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