CN109063031B

CN109063031B - Data drilling method and device and server

Info

Publication number: CN109063031B
Application number: CN201810777642.0A
Authority: CN
Inventors: 张军; 刘一鸣
Original assignee: Beijing Baidu Netcom Science and Technology Co Ltd
Current assignee: Beijing Baidu Netcom Science and Technology Co Ltd
Priority date: 2018-07-16
Filing date: 2018-07-16
Publication date: 2020-11-20
Anticipated expiration: 2038-07-16
Also published as: CN109063031A

Abstract

The invention provides a data drilling method, a device and a server, wherein the method comprises the following steps: under the condition that a drilling request aiming at the data of the current layer is detected, the data of the current layer is obtained; reading a drill-in statement for the current layer data; wherein the drill statement comprises a data source command and a drill 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 comprising the drilling parameters by using the data source command and the extracted drilling parameters; and displaying a drilling result according to the standard SQL statement and the pre-configuration of the current layer data. According to the data drilling method provided by the invention, the drilling sentences are independently configured for the data from different data sources, so that the standard SQL sentences are generated, and the data drilling can be more flexibly carried out according to the requirements.

Description

Data drilling method and device and server

Technical Field

The invention relates to the field of data management, in particular to a data drilling method, a data drilling device and a server.

Background

With the development of technology, computer technology is widely applied in all aspects of life, and people utilize computers and the internet to manage a large amount of data generated in life and production. Techniques such as databases for managing data have thus far advanced and evolved.

In data management, data is often displayed in the form of a graph for ease of viewing, and further data analysis is performed. Existing data analysis tools often use data drilling to analyze data in depth when performing an analysis.

When data drilling is used for data analysis, the drilled dimension or layer is set when a data chart is established, and when some data is selected by a method of clicking with a mouse and the like, the next page of the current data is entered. In addition, in the existing data analysis tools, the used SQL statements are all generated simply, so that data drilling can be performed only in one data source, and the data drilling is not flexible enough.

Disclosure of Invention

Embodiments of the present invention provide a data drilling method, apparatus, and server, so as to at least solve one or more technical problems in the prior art, and at least provide a useful choice.

In a first aspect, an embodiment of the present invention provides a data drilling method, including:

under the condition that a drilling request aiming at the data of the current layer is detected, the data of the current layer is obtained;

reading a drill-in statement for the current layer data; wherein the drill statement comprises a data source command and a drill 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 comprising the drilling parameters by using the data source command and the extracted drilling parameters; and

and displaying a drilling result according to the standard SQL statement and the pre-configuration of the current layer data.

With reference to the first aspect, the present invention provides, in a first implementation manner of the first aspect, the extracting drilling parameters from the current layer data according to the data source command and the drilling parameter extraction command, including at least one of:

under the condition that the current layer is the layer 1, extracting drilling parameters from the layer 1 data;

under the condition that the current layer is the Nth layer, extracting drilling parameters from the Nth layer of data; and

under the condition that the current layer is the Nth layer, extracting drilling parameters from the Nth layer data, and extracting the drilling parameters from at least one layer of data from the 1 st layer to the N-1 st layer;

wherein N is an integer greater than 1.

With reference to the first aspect, the present invention, in a second implementation manner of the first aspect, further includes:

writing a drilling statement corresponding to the current layer data by using a preset drilling grammar; wherein the predetermined drill grammar extracts at least a portion of the current layer data as drill parameters by predetermined keywords.

With reference to the first aspect, in a third implementation manner of the first aspect, the preconfiguration includes whether to start data drilling for the current layer data and a display manner of the drilling result.

With reference to the first aspect, in a fourth implementation manner of the first aspect, the displaying a drilling result according to the standard SQL statement and the pre-configuration of the current layer data includes:

when the pre-configuration comprises a drilling command not to be started, maintaining a current interface; and

and when the pre-configuration comprises a drilling starting instruction, displaying a drilling result according to the standard SQL statement.

In a second aspect, an embodiment of the present invention provides a data drilling apparatus, including:

the data acquisition module is used for acquiring the data of the current layer under the condition that a drilling request aiming at the data of the current layer is detected;

a drilling statement reading module for reading the drilling statement used for the current layer data; wherein the drill statement comprises a data source command and a drill parameter extraction command;

the parameter extraction module is used for extracting drilling parameters from the current layer data according to the data source command and the drilling parameter extraction command;

the SQL statement generating module is used for generating a standard SQL statement comprising the drilling parameter by utilizing the data source command and the extracted drilling parameter; and

and the result display module is used for displaying the drilling result according to the standard SQL statement and the pre-configuration of the current layer data.

With reference to the second aspect, in a first implementation manner of the second aspect, the parameter extraction module is further configured to extract the drilling parameters by at least one of the following manners:

wherein N is an integer greater than 1.

With reference to the second aspect, the present invention, in a second embodiment of the second aspect, further includes:

the statement writing module is used for writing the drilling statement corresponding to the current layer data by using a preset drilling grammar; wherein the predetermined drill grammar extracts at least a portion of the current layer data as drill parameters by predetermined keywords.

With reference to the second aspect, in a third implementation manner of the second aspect, the preconfiguration includes whether to start data drilling for the current layer data and a display manner of the drilling result.

With reference to the second aspect, in a fourth embodiment of the second aspect, the result display module is further configured to:

In a third aspect, an embodiment of the present invention provides a server, where the server includes:

one or more processors;

a storage configured to store one or more programs;

a communication interface configured to enable the processor and the storage device to communicate with an external device;

the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of the first aspect as described above.

In a fourth aspect, an embodiment of the present invention provides a computer-readable storage medium for storing computer software instructions for the data drilling apparatus, which includes a program for executing the data drilling method in the first aspect to the data drilling apparatus.

Another technical scheme in the above technical scheme has the following advantages or beneficial effects: drilling statements are independently configured for data from different data sources, so that standard SQL statements are generated, and data drilling can be flexibly performed according to needs.

The foregoing summary is provided for the purpose of description only and is not intended to be limiting in any way. In addition to the illustrative aspects, embodiments, and features described above, further aspects, embodiments, and features of the present invention will be readily apparent by reference to the drawings and following detailed description.

Drawings

In the drawings, like reference numerals refer to the same or similar parts or elements throughout the several views unless otherwise specified. The figures are not necessarily to scale. It is appreciated that these drawings depict only some embodiments in accordance with the disclosure and are therefore not to be considered limiting of its scope.

FIG. 1 is a flow diagram of a data drilling method according to one embodiment of the present invention;

FIG. 2 is a schematic illustration of layer 1 data and its preconfiguration according to a specific example of the present invention;

FIG. 3 is a schematic diagram of a layer 1 drilled pseudo SQL Association configuration according to a specific example of the invention;

FIG. 4 is a diagram of a layer 1 pseudo SQL statement and a standard SQL statement according to a specific example of the invention;

FIG. 5 is a schematic illustration of layer 2 data and its preconfiguration according to a specific example of the present invention;

FIG. 6 is a schematic diagram of a pseudo SQL Association configuration drilled at layer 2, according to a specific example of the invention;

FIG. 7 is a diagram of a layer 2 pseudo SQL statement and a standard SQL statement according to a specific example of the invention;

FIG. 8 is a diagrammatic illustration of a preview interface in accordance with another specific example of the present invention;

FIG. 9 is a schematic diagram of a data drilling apparatus according to another embodiment of the present invention;

fig. 10 is a schematic structural diagram of a server according to another embodiment of the present invention.

Detailed Description

In the following, only certain exemplary embodiments are briefly described. As those skilled in the art will recognize, 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 description are to be regarded as illustrative in nature, and not as restrictive.

FIG. 1 shows a flow diagram of a data drilling method that may be used in a general database and in various data analysis tools, according to one embodiment of the invention. The data drilling method is described in detail below with a common data analysis platform, but it should be understood that the data drilling method is not limited to the illustrated application platform, and is only a part of the contents of the platform, and the data drilling method provided by the embodiment of the present invention is not limited thereto. As shown in fig. 1, the data drilling method may include:

s110: under the condition that a drilling request aiming at the data of the current layer is detected, the data of the current layer is obtained;

in the embodiment of the invention, the drilling request can be sent out in a click-to-select mode. For example, if the data of the current layer is a certain row or a certain column in the data table, the row or the column where the data of the current layer is located may be clicked. If the current layer data exists in the column graph, the column in which the current layer data exists can be clicked to send out a drilling request.

S120: reading a drill-in statement for the data of the current layer;

in the embodiment of the invention, the drilling statement can be generated by adopting a 'pseudo SQL statement'. The pseudo SQL statements may be pre-written code segments, and the format may be specified by those skilled in the art. The pseudo SQL statement may include a data source command and a drill-in parameter extraction command. The data source command indicates the data source from which the drill-out result is generated, e.g., if the drill-out result is generated based on a data report, the name, address, etc. of the data report may be indicated in the data source command.

The drilling parameters are typically the current layer data itself, or a part thereof. For example, if the current row of data is a row of data, the drill-in parameter may be a field name of the row of data.

Further, the pseudo SQL statement of the current layer data may be written using a predetermined drill-in syntax, and the predetermined drill-in syntax may extract at least a portion of the current layer data as drill-in parameters by a predetermined keyword.

S130: extracting drilling parameters from the current layer data according to the data source command and the drilling parameter extraction command;

the drilling parameters are typically the current layer data itself, or a part thereof. For example, if the current layer data is a line of data, the drilling parameter may be the entirety of the line of data, or may be the contents of one of the fields.

It is understood that data drilling may be performed in multiple layers. In one exemplary scenario, for example in a report that presents sales data for a product, the sales data may be data drilled according to administrative levels. Specifically, if the sales data is displayed in the form of a national map, after the layer 1 data drilling (a drilling request can be sent by clicking on an area where a certain province is located), the data of the province can be obtained; after the layer 2 data drill (similarly, a drill request may be made by clicking on the area where a city of a province is located), the data for that city may be obtained, and so on.

In this case, S130 may be preferably performed in at least one of the following ways:

wherein N is an integer greater than 1.

When N is larger than 1, when the drilling parameter is extracted by using the preset keyword, the data of the current layer can be extracted, at least one layer of data in the data of the current layer and the data of the N-1 layer can also be extracted as the drilling parameter, and the data can be flexibly selected according to the requirement.

When multi-layer data drilling is carried out, the data source command indicates that the data source of the current layer data is still the data source. For example, if there are two sales reports, representing sales in two countries, respectively, a line of code indicating the data source of the current layer data may be included in the pseudo SQL statement. It will be appreciated that the data sources may be different and that the resulting drill-out results may be different.

S140: generating a standard SQL statement comprising the drilling parameters by using the data source command and the extracted drilling parameters;

and generating a standard SQL statement according to the data source command and the drilling parameter. The form and operation mechanism of the standard SQL statement may adopt the prior art, and are not described herein.

S150: and displaying the drilling result according to the standard SQL statement and the pre-configuration of the current layer data.

The pre-configuration in the embodiment of the present invention may include whether to start data drilling for the current layer data, and a display mode of a drilling result. The display mode of the drilling result can be any common data display mode, such as a pie chart, a bar chart and the like, and can also be a more flexible display mode, such as the map and the like mentioned in the foregoing.

Particularly, if the pre-configuration does not contain a command for starting drilling, data drilling is not carried out, and the current interface is kept; and if the command for starting the drilling is contained, displaying the drilling result according to the generated standard SQL statement. Therefore, data drilling can be turned on or off according to needs, and the data drilling device is more convenient and flexible to use.

Preferably, the method provided by the embodiment of the present invention may further include: and further setting the display mode of the drilling result. For example, if the drilling result is displayed in a bar graph in the pre-configuration of the drilling result, a specific form of the bar graph may be set, such as which part of the data each bar represents, and the like.

The above-described data drilling method is explained in detail with reference to a specific example below with reference to fig. 2 to 7. In this particular example, two layers of data drilling are performed.

Referring first to FIG. 2, FIG. 2 illustrates the pre-configuration of drillable data and current layer data, i.e., layer 1 data. The drillable data is presented in tabular form on the left side of fig. 2. As can be seen, the illustrated table includes two fields, one of which is the "name" field and the other of which is the "val" field. And, four rows of data are included under each field, and the layer 1 data in this specific example is one row in the table.

Before data drilling, the drillable data needs to be configured in advance, which may be referred to as pre-configuration. The right side of fig. 2 shows the pre-configuration of the drillable data, which may be performed through a pre-set control panel. First, the pre-configuration contains the bound data, i.e., the data for which data drilling is performed. The step 1 is data drilling for the 1 st time, and the bound data is the data of the 1 st layer. Specifically, data binding may be accomplished by clicking on the row in which layer 1 data resides.

Also, in a specific implementation, the "drill down" tab of the control panel shown on the right side of FIG. 2 may be used. In the "drill-down" tab, the first option is to bind the data to be drilled, and the data is regarded as row clicking by default. It will be appreciated that other methods may be utilized to bind the data to be drilled. Further, the illustrated control panel is merely exemplary, and another form of control panel may be provided as needed.

Next, as described above, the pre-configuration also includes a display mode of the drilling result. Such as the "pie chart" shown in the right control panel of fig. 2, the pre-configuration also includes whether to initiate drill-down for the bound data.

After the pre-configuration is completed, clicking the layer 1 data, namely the data of the bound pv row, and popping up a further set window interface. Referring now to FIG. 3, FIG. 3 also shows a control panel, but here the control panel is for the configuration associated with the pseudo SQL statement, and the specific configuration of the display of the drill-in results. For example, for the pie chart shown on the left side of fig. 4, the pie chart may be further arranged in the control panel on the right side, such as "one pie slice per row". The "bind chart data" on the right side of FIG. 4 provides three options indicating the data source on which the pie chart shown on the left side is based or how the pie chart is generated. "SQL modeling" is chosen here, i.e., the generation of the drill-out result is indicated by the generation of a standard SQL statement by a pseudo SQL statement.

Writing of the pseudo SQL statement may be performed by clicking on "table _ pie" under "associated SQL model". "table _ pie" is only an example of the name of the SQL model, is not a limitation on the used SQL model, and may be named additionally according to actual needs.

Referring to fig. 4, the left side of fig. 4 shows a pre-written pseudo SQL statement according to a specific example, which may be popped up by clicking "table _ pie" on the right side of fig. 3. The predetermined drill-in syntax used to write the pseudo SQL statement is { { drillensystem (0). name } }. Here, drillDowns can be used as keywords, predefined, for extracting the drilling parameters. In { { drillDowns (0). name } }, name denotes the name field of the drilling parameter, which can be used to indicate the data to be drilled, and 0 in parentheses denotes the number of drilling layers. 0 indicates that the first layer data was extracted, but since no data drilling was done before the first layer data, it is indicated as 0. The name field is used to indicate the name field of the current data.

For ease of understanding, the extracted drilling parameters are shown in the upper right of FIG. 4. It should be noted that the information shown in the upper right of fig. 3 is automatically generated in the compiling process, and is not required to be written, and this is for illustrative purposes only.

In addition, the data source of the drill result is indicated by the pseudo SQL statement, for example, the first row "select data, val from kpi" of the pseudo SQL statement shown on the left side of FIG. 2, indicating that the drill result is generated based on kpi data in this data source, kpi may be a database report.

Referring to the specific example of FIG. 2, the drill-out results are shown as a pie chart and the distribution of the data is shown in the pie chart. In particular, if no instruction to start drilling is contained in the pre-configuration, no data drilling is performed, keeping the interface on the left side of FIG. 2; and if the command for starting the drilling is contained, displaying the drilling result according to the generated standard SQL statement, wherein the displayed drilling result is a pie chart shown on the left side of the figure 4.

Layer 2 data drilling is described below with reference to fig. 5.

The drilling results for layer 1 drilling are shown on the left side of FIG. 5, and the pre-configuration of the current layer data, i.e., layer 2 data, is shown on the right side of FIG. 5. Firstly, data to be drilled are bound, the data to be drilled are data of the layer 2, and the data binding can be carried out by clicking a sector area of a pie chart. Similar to layer 1 data, the display of the drill results may be set in the control panel, here chosen as a "line graph" and the drill down turned on for the pie chart.

Referring next to FIG. 6, shown on the left side of FIG. 6 is a resulting line graph, and on the right side is a written correlation interface for a pseudo SQL statement for layer 2 data.

Referring now to FIG. 6, the lower left of FIG. 6 shows a pseudo SQL statement for layer 2 data. It can be seen that the pseudo SQL statement here contains two layers, and the drill-in syntax is used twice, which are { { drill downs (0). name } } and { { drill downs (1). value } }. Wherein { { drillDowns (1). value } } is used for extracting data of a value attribute of the drilling parameter for the layer 2 data, and the extraction of the data of the value attribute is still performed through the keyword drillDowns.

The generated standard SQL statement is shown in the lower right of fig. 6, and the information of the drill-in parameter is shown in the upper right, which is still generated during background compilation and is only used for illustration. Further, as shown in the upper right of FIG. 6, the drill-down parameters may be an array of numbers that includes drill parameters for the two-tier data drill performed. By analogy, if three or more layers of data extraction are performed, in addition to the current layer data, the drilling parameters of at least one of the layers 1 to N-1 can be extracted by using the pseudo SQL statement. For example, if the data is drilled for five layers, the drilling parameters of the 1 st layer, the 3 rd layer and the 5 th layer can be extracted, so that the data drilling method provided by the embodiment of the invention has higher flexibility.

Typically, only the current layer data may be taken as drilling parameters, but in some cases, the drilling parameters may be extracted as needed.

In another example, if data drilling is performed on a world map, countries, provinces (or equal administrative units) of countries, cities (or equal administrative units), and the like are taken as display objects for data drilling at each level. If the provincial administration of two countries has the same name, the data of the provincial administration layer can be extracted and used as the drilling parameter when the data drilling of the next layer is carried out.

Moreover, in fig. 6, the drilling result of the drilling of the layer 2 data is different from the data source of the layer 1 data, and the first row of the pseudo SQL statement at the lower left of fig. 6 indicates the data source of the drilling result, which is the data in "anotherTable".

Similarly, when data drilling is required for a polyline graph, one portion of the polyline graph may be treated as layer 3 data, the polyline graph preconfigured and the drill-in statements pre-written, using a portion of the layer 1 to layer 3 data as drill-in parameters. And then generating a standard SQL statement and displaying the drilling result.

It should be noted that fig. 2-7 may be performed before drilling the data, such as pre-configuring and pre-writing a pseudo SQL statement. According to this specific example, when steps S110 to S140 provided by the embodiment of the present invention are executed, the interface displayed first is the interface on the left side of fig. 2, that is, the table data. By clicking on a row of the table, a drill request is issued, indicating that drilling of the row of data is required, and after the execution of step S140 is finished, a pie chart on the left side of fig. 5 is presented. The control panel shown in fig. 2-7 is not present.

In fact, when no pre-configuration of data and writing of drill-in statements are performed, the control panel is not displayed if a preview is performed, as shown in fig. 8. Although a line graph is shown, it is a general display only, and does not appear to be associated with any data.

According to the data drilling method, drilling sentences are independently written for the data of each layer, when drilling commands are obtained, standard SQL sentences are generated according to the drilling sentences, and then data drilling is carried out, so that the method is more flexible. And because the drilling statement is written separately, data drilling can be performed across data sources, and multi-layer drilling, even infinite-layer drilling, can be performed as required.

Fig. 9 is a schematic structural diagram of a data drilling apparatus according to another embodiment of the present invention, and as shown in fig. 9, the apparatus may include:

a data obtaining module 210, configured to obtain current layer data when a drilling request for the current layer data is detected;

a drill statement reading module 220, configured to read a drill statement for the current layer data; wherein the drill statement comprises a data source command and a drill parameter extraction command;

a parameter extraction module 230, configured to extract drilling parameters from the current layer data according to the data source command and the drilling parameter extraction command;

preferably, the parameter extraction module 230 may be further configured to extract the drilling parameters using at least one of the following:

wherein N is an integer greater than 1.

An SQL statement generating module 240, configured to generate a standard SQL statement including the drill parameter by using the data source command and the extracted drill parameter; and

and a result display module 250, configured to display the drilling result according to the standard SQL statement and the pre-configuration of the current layer data.

In particular, the preconfiguration includes whether to start data drilling for the current layer data and a display mode of the drilling result.

And preferably, the result display module may be further configured to:

Preferably, the data drilling device may further include:

Fig. 10 shows a schematic structural diagram of a server according to another embodiment of the present invention. As shown in fig. 10, the server includes:

one or more processors 310;

a storage 320 configured to store one or more programs;

a communication interface 330 configured to enable the processor 310 and the storage 320 to communicate with an external device;

the one or more programs, when executed by the one or more processors 310, cause the one or more processors 310 to implement any of the aforementioned data drilling methods, apparatus, and server methods.

According to another embodiment of the present invention, there is provided a computer-readable storage medium storing a computer program which, when executed by a processor, implements any one of the aforementioned data drilling methods.

In the description herein, references to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.

Furthermore, the terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In the description of the present invention, "a plurality" means two or more unless specifically defined otherwise.

Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing specific logical functions or steps of the process, and alternate implementations are included within the scope of the preferred embodiment of the present invention in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the present invention.

The logic and/or steps represented in the flowcharts or otherwise described herein, e.g., an ordered listing of executable instructions that can be considered to implement logical functions, can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. For the purposes of this description, a "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable read-only memory (CDROM). Additionally, the computer-readable medium could even be paper or another suitable medium upon which the program is printed, as the program can be electronically captured, via for instance optical scanning of the paper or other medium, then compiled, interpreted or otherwise processed in a suitable manner if necessary, and then stored in a computer memory.

It should be understood that portions of the present invention may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, the various steps or methods may be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.

It will be understood by those skilled in the art that all or part of the steps carried by the method for implementing the above embodiments may be implemented by hardware related to instructions of a program, which may be stored in a computer readable storage medium, and when the program is executed, the program includes one or a combination of the steps of the method embodiments.

In addition, functional units in the embodiments of the present invention may be integrated into one processing module, or each unit may exist alone physically, or two or more units are integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. The integrated module, if implemented in the form of a software functional module and sold or used as a separate product, may also be stored in a computer readable storage medium. The storage medium may be a read-only memory, a magnetic or optical disk, or the like.

The above description is only for the specific embodiment of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art can easily conceive various changes or substitutions within the technical scope of the present invention, and these should be covered by the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the appended claims.

Claims

1. A method of data drilling, comprising:

and displaying a drilling result according to the standard SQL statement and the pre-configuration of the current layer data, wherein the pre-configuration comprises whether data drilling is started for the current layer data or not and a display mode of the drilling result.

2. The method of claim 1, wherein extracting drilling parameters from the current layer data based on the data source commands and the drilling parameter extraction commands comprises at least one of:

wherein N is an integer greater than 1.

3. The method of claim 1, further comprising:

4. The method of claim 1, wherein displaying the drill-in result according to the pre-configuration of the standard SQL statement and the current layer data comprises:

5. A data drilling apparatus, comprising:

a drilling statement reading module for reading the drilling statement used for the current layer data; wherein the drill statement comprises a data source command and a drill parameter extraction command for the current layer data;

the SQL statement generating module is used for generating a standard SQL statement comprising the drilling parameter by utilizing the data source for the current layer data and the extracted drilling parameter; and

and the result display module is used for displaying a drilling result according to the standard SQL statement and the pre-configuration of the current layer data, wherein the pre-configuration comprises whether data drilling is started for the current layer data or not and a display mode of the drilling result.

6. The apparatus of claim 5, wherein the parameter extraction module is further configured to extract drilling parameters using at least one of:

wherein N is an integer greater than 1.

7. The apparatus of claim 5, further comprising:

8. The apparatus of claim 5, wherein the result display module is further configured to:

9. A server, characterized in that the server comprises:

one or more processors;

a storage configured to store one or more programs;

a communication interface configured to cause the processor and the storage device to communicate with an external device;

the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method recited in any of claims 1-4.

10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 1-4.