CN108563736B

CN108563736B - Method and device for querying data based on data characteristics

Info

Publication number: CN108563736B
Application number: CN201810316658.1A
Authority: CN
Inventors: 卜乐
Original assignee: Koubei Shanghai Information Technology Co Ltd
Current assignee: Koubei Shanghai Information Technology Co Ltd
Priority date: 2018-04-10
Filing date: 2018-04-10
Publication date: 2021-04-27
Anticipated expiration: 2038-04-10
Also published as: CN108563736A

Abstract

The invention discloses a method and a device for querying data based on data characteristics, wherein the method comprises the following steps: acquiring query data input by a page according to query operation; analyzing the query data according to a preset analysis rule to obtain a characteristic value corresponding to the table name of the first data table and a characteristic value corresponding to the query field of the first data table; obtaining a first data table name and a first data table query field according to the pre-stored association relationship between the characteristic value and the table name and between the characteristic value and the query field; assembling and generating a query statement containing a first data table name, a first data table query field and query data; and executing the query statement to obtain a query result of the first data table, and displaying the query result in the page. The invention reduces the familiarity requirement of the service operator on the service data, can automatically acquire the corresponding table name and the corresponding query field by only using the query data without specifying the specific table name and the query field, and acquires the corresponding query result.

Description

Method and device for querying data based on data characteristics

Technical Field

The invention relates to the field of software, in particular to a method and a device for querying data based on data characteristics.

Background

When data is queried, a table to be queried, a query field and query data are generally required to be provided, so that a query statement can be generated according to the data to obtain a corresponding query result. And inquiring the commodity id value XXX in the commodity table to obtain corresponding commodity information, and further displaying the commodity information. However, in the general service query, only one query data is sometimes obtained, but the corresponding table, query field, etc. cannot be known, and at this time, a person unfamiliar with the service cannot obtain the corresponding query result according to the query data. Based on the problem, a method for querying data based on the characteristics of the data is needed, so as to reduce the requirement of the personnel on business familiarity during querying.

Disclosure of Invention

In view of the above, the present invention has been made to provide a method and apparatus for querying data based on data characteristics that overcomes or at least partially solves the above problems.

According to an aspect of the present invention, there is provided a method for querying data based on data characteristics, comprising:

acquiring query data input by a page according to query operation;

analyzing the query data according to a preset analysis rule to obtain a characteristic value corresponding to the table name of the first data table and a characteristic value corresponding to the query field of the first data table;

obtaining a first data table name and a first data table query field according to the pre-stored association relationship between the characteristic value and the table name and between the characteristic value and the query field;

assembling and generating a query statement containing a first data table name, a first data table query field and query data;

and executing the query statement to obtain a query result of the first data table, and displaying the query result in the page.

Optionally, the method further comprises:

traversing the query result displayed in the page, and acquiring the numerical values of the characteristic values of the second data table and the characteristic values of the query fields contained in the query result;

taking the numerical value as query data to obtain a query result of a second data table;

and adding the correlation operation of the query result of the second data table and the numerical value in the query result in the page, so as to jump to the page where the query result of the second data table is located according to the correlation operation triggered by the user.

Optionally, traversing the query result displayed in the page, and obtaining the value containing the third data table field further includes:

traversing each numerical value of the query result displayed in the page, analyzing the numerical value according to a preset analysis rule, and judging whether the numerical value comprises a characteristic value corresponding to the table name of the second data table and a characteristic value corresponding to the query field of the second data table;

if yes, obtaining the numerical value.

Optionally, the method further comprises:

acquiring a third data table having a topological relation with the first data table, and generating a query statement of the third data table; the query condition of the query statement is generated according to the query result of the first data table;

executing the query statement to obtain a query result of the third data table;

and summarizing the query result of the first data table and the query result of the third data table, and displaying the summarized query results in a page.

Optionally, the topological relation is an association relation or an expansion relation; wherein, the topological relation records the association field or the extension field between the data tables.

Optionally, the topological relation is an association relation;

obtaining a third data table having a topological relation with the first data table, and generating a query statement for the third data table further includes:

judging whether a third data table having a correlation with the first data table exists or not; and if so, acquiring a third data table having a correlation with the first data table, and generating a query statement of the third data table, wherein the query condition statement is generated according to the correlation fields of the third data table and the first data table.

Optionally, the topological relationship is an expansion relationship;

judging whether a third data table with each stage having an expansion relation with the first data table exists or not; if yes, acquiring a third data table of each stage having an expansion relation with the first data table;

and generating query statements of the third data tables of all levels according to the corresponding extended relations of all levels, wherein the query condition statements are generated according to the extended fields of the extended relations of all levels.

According to another aspect of the present invention, there is provided an apparatus for querying data based on data characteristics, comprising:

the acquisition module is suitable for acquiring query data input by a page according to query operation;

the analysis module is suitable for analyzing the query data according to a preset analysis rule to obtain a characteristic value corresponding to the first data table name and a characteristic value corresponding to the first data table query field;

the association module is suitable for obtaining a first data table name and a first data table query field according to the association relation between the pre-stored characteristic value and the table name and between the pre-stored characteristic value and the query field;

the assembly module is suitable for assembling and generating a query statement containing a first data table name, a first data table query field and query data;

and the execution module is suitable for executing the query statement to obtain a query result of the first data table and displaying the query result in the page.

Optionally, the apparatus further comprises:

the association skip module is suitable for traversing the query result displayed in the page and acquiring the numerical values of the characteristic values of the second data table and the characteristic values of the query fields contained in the query result; taking the numerical value as query data to obtain a query result of a second data table; and adding the correlation operation of the query result of the second data table and the numerical value in the query result in the page, so as to jump to the page where the query result of the second data table is located according to the correlation operation triggered by the user.

Optionally, the association skip module is further adapted to:

traversing each numerical value of the query result displayed in the page, analyzing the numerical value according to a preset analysis rule, and judging whether the numerical value comprises a characteristic value corresponding to the table name of the second data table and a characteristic value corresponding to the query field of the second data table; if yes, obtaining the numerical value.

Optionally, the apparatus further comprises:

the topology module is suitable for acquiring a third data table having a topological relation with the first data table and generating a query statement of the third data table; the query condition of the query statement is generated according to the query result of the first data table; executing the query statement to obtain a query result of the third data table; and summarizing the query result of the first data table and the query result of the third data table, and displaying the summarized query results in a page.

Optionally, the topological relation is an association relation;

the topology module is further adapted to: judging whether a third data table having a correlation with the first data table exists or not; and if so, acquiring a third data table having a correlation with the first data table, and generating a query statement of the third data table, wherein the query condition statement is generated according to the correlation fields of the third data table and the first data table.

Optionally, the topological relationship is an expansion relationship;

the topology module is further adapted to: judging whether a third data table with each stage having an expansion relation with the first data table exists or not; if yes, acquiring a third data table of each stage having an expansion relation with the first data table; and generating query statements of the third data tables of all levels according to the corresponding extended relations of all levels, wherein the query condition statements are generated according to the extended fields of the extended relations of all levels.

According to still another aspect of the present invention, there is provided an electronic apparatus including: the processor, the memory and the communication interface complete mutual communication through the communication bus;

the memory is used for storing at least one executable instruction, and the executable instruction enables the processor to execute the operation corresponding to the method for querying the data based on the data characteristics.

According to still another aspect of the present invention, a computer storage medium is provided, in which at least one executable instruction is stored, and the executable instruction causes a processor to perform operations corresponding to the method for querying data based on data features as described above.

According to the data characteristic-based data query method and device provided by the invention, query data input by a page are obtained according to query operation; analyzing the query data according to a preset analysis rule to obtain a characteristic value corresponding to the table name of the first data table and a characteristic value corresponding to the query field of the first data table; obtaining a first data table name and a first data table query field according to the pre-stored association relationship between the characteristic value and the table name and between the characteristic value and the query field; assembling and generating a query statement containing a first data table name, a first data table query field and query data; and executing the query statement to obtain a query result of the first data table, and displaying the query result in the page. The invention reduces the familiarity requirement of the service operator on the service data, can automatically acquire the corresponding table name and the corresponding query field by only using the query data without specifying the specific table name and the query field, and acquires the corresponding query result.

The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.

Drawings

Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:

FIG. 1 illustrates a flow diagram of a method of querying data based on data characteristics, according to one embodiment of the invention;

FIG. 2 shows a schematic diagram of a query page and a present query results page;

FIG. 3 shows a flow diagram of a method of querying data based on data characteristics, according to another embodiment of the invention;

FIG. 4 is a schematic diagram illustrating an operation page for associating the first data table with the third data table;

FIG. 5 shows a functional block diagram of an apparatus for querying data based on data characteristics according to one embodiment of the present invention;

FIG. 6 shows a functional block diagram of an apparatus for querying data based on data characteristics according to another embodiment of the present invention;

fig. 7 shows a schematic structural diagram of an electronic device according to an embodiment of the invention.

Detailed Description

Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.

FIG. 1 shows a flow diagram of a method of querying data based on data characteristics, according to one embodiment of the invention. As shown in fig. 1, the method for querying data based on data characteristics specifically includes the following steps:

step S101, acquiring query data input by a page according to query operation.

As shown in fig. 2, after the user clicks the query button and executes the query operation request, the input query data is obtained from the page. The query data obtained here does not specify the first data table name and the query field to be queried, but only a specific query value.

It should be noted that, in the prior art, query data input by a page may specify a first data table name and a first data table query field that need to be queried, but this needs to be based on that a service person has a high requirement on service capability in a case where the query data is very clear to the service person. However, often, the service personnel cannot know all the data very well, and based on the situation, the embodiment aims at the query data without the need of knowing the first data table name corresponding to the query data and the corresponding first data table query field, and can directly query according to the query data. As shown in fig. 2, at the upper part of the query page, the table name and the query field are not specified, and only the query data is input to directly perform the query. The query data may be a numeric value or a character string, and fig. 2 is only an example and is not limited herein.

Step S102, analyzing the query data according to a preset analysis rule, and acquiring a characteristic value corresponding to the first data table name and a characteristic value corresponding to the query field of the first data table.

And analyzing the query data according to a preset analysis rule, wherein the preset analysis rule corresponds to a generation rule when the query data is generated. If the query data is generated, the characteristic value of the first data table name is stored in 11 th to 13 th bits, and the corresponding characteristic value of the query field is stored in 14 th to 16 th bits. In this way, when the analysis is carried out, the query data is intercepted according to bits, and the characteristic value corresponding to the table name of the first data table and the characteristic value corresponding to the query field of the first data table can be obtained.

And step S103, obtaining a first data table name and a first data table query field according to the pre-stored association relationship between the characteristic value and the table name and between the characteristic value and the query field.

And searching the pre-stored characteristic values, and finding out the characteristic values consistent with the acquired first data table name characteristic values and the acquired query field characteristic values. And obtaining the table name of the first data table and the query field of the first data table according to the pre-stored association relationship between the characteristic value and the table name and between the characteristic value and the query field. If the first data table name characteristic value is 076 and the query field characteristic value is 004, according to the pre-stored association relationship between the characteristic value and the table name and between the characteristic value and the query field, it can be known that the first data table name corresponding to 076 is ITEM _ info, and the first data table query field corresponding to 076004 is ITEM _ ID.

The incidence relation between the characteristic value and the table name and between the characteristic value and the query field is set according to the implementation situation, and the information such as the characteristic value digit, the numerical value and the like is not limited here.

And step S104, assembling and generating a query statement containing the first data table name, the first data table query field and query data.

And combining the query data input by the page according to the obtained first data table name and the first data table query field to assemble the query statement of the first data table. For example, the query statement may be a select from first data table name where query data, and the text is replaced with the specific first data table name, the first data table query field, and the query data, so as to obtain a query statement of the first data table based on the query data.

Step S105, execute the query statement to obtain a query result of the first data table.

And executing the query statement generated by the assembly to obtain a corresponding query result. As shown in fig. 2, item _ info data table.

According to the data characteristic-based data query method provided by the invention, query data input by a page are obtained according to query operation; analyzing the query data according to a preset analysis rule to obtain a characteristic value corresponding to the table name of the first data table and a characteristic value corresponding to the query field of the first data table; obtaining a first data table name and a first data table query field according to the pre-stored association relationship between the characteristic value and the table name and between the characteristic value and the query field; assembling and generating a query statement containing a first data table name, a first data table query field and query data; and executing the query statement to obtain a query result of the first data table, and displaying the query result in the page. The invention reduces the familiarity requirement of the service operator on the service data, can automatically acquire the corresponding table name and the corresponding query field by only using the query data without specifying the specific table name and the query field, and acquires the corresponding query result.

FIG. 3 shows a flow diagram of a method of querying data based on data characteristics, according to another embodiment of the invention. As shown in fig. 3, the method for querying data based on data characteristics specifically includes the following steps:

step S301, obtaining query data input by the page according to the query operation.

Step S302, the query data is analyzed according to a preset analysis rule, and a characteristic value corresponding to the first data table name and a characteristic value corresponding to the first data table query field are obtained.

Step S303, obtaining a first data table name and a first data table query field according to the association relationship between the pre-stored characteristic value and the table name and between the pre-stored characteristic value and the query field.

Step S304, assembling and generating a query statement containing the first data table name, the first data table query field and query data.

Step S305, execute the query statement to obtain a query result of the first data table.

The above steps are described with reference to steps S101 to S105 in the embodiment of fig. 1, and are not described again here.

Step S306, a third data table having a topological relation with the first data table is obtained, and a query statement of the third data table is generated.

A plurality of data tables exist in the database, and topological relations exist among some data tables. The topological relationships generally include, for example, associative relationships, extended relationships, and the like.

The data tables of the association relation are associated through fields in the tables; if the field a in the table A is the same as the field B in the table B, the table A and the table B have an association relationship.

The data table of the expansion relation is according to the business needs, such as a commodity table and a commodity information table, wherein the commodity table stores main information such as a commodity ID and price, and the commodity information table stores detailed information such as a commodity ID, parameter information, picture information, specification information, commodity description and the like; the commodity information table is an expansion table of the commodity table, the commodity information table further expands and stores the information of the commodity through the commodity ID, and the commodity information table and the commodity ID have an expansion relation. The expansion relations can be multistage expansion relations such as a first-stage expansion relation, a second-stage expansion relation, a third-stage expansion relation and the like, for example, the expansion table of the A table is an A1 table, an A2 table and an A3 table, and the A table is a first-stage expansion relation with an A1 table, an A2 table and an A3 table; the expansion tables of the A1 table are an A11 table and an A12 table, the A11 table and the A12 table are in a two-stage expansion relationship, and by analogy, each expansion table of the multi-stage expansion relationship under the A table with the tree structure can be obtained.

The topological relation among the data tables can be obtained according to the relation among the services, the service flow processing, or according to the data table design scheme. The topological relations among the data tables can be sorted in advance, and the topological relations among the data tables are stored. The topological relation records the association fields or the extension fields among the data tables; if a topological relation records the incidence relation between the A table and the B table, the incidence fields are the a field and the B field of the A table; or one topological relation records the expansion relation between the A table and the A1 table, the expansion fields are the a field of the A table and the a1 field of the A1 table, one topological relation records the expansion relation between the A1 table and the A11 table, and the expansion fields are the a1 table a1 field and the A11 table a11 field.

And searching a third data table having a topological relation with the first data table according to the first data table. Specifically, a data table having a relationship with the first relationship table is searched for by querying a previously stored topological relationship, and if a third data table having a relationship with the first data table exists, whether the third data table exists is judged; and if so, acquiring a third data table having an association relation with the first data table. And acquiring the table name, the associated field and the like of the third data table, and generating a query statement of the third data table according to the table name and the associated field of the third data table. Wherein the query statement further comprises a query condition statement. The query condition is generated according to the query result of the first data table, and specifically, the query condition statement is generated according to the association fields of the third data table and the first data table. If the query statement for generating the B table is: select from B where b.b in (a.a). And when the A table has a plurality of query results, and the A.a has a plurality of values, splicing the values through commas.

Or, searching a data table having an expansion relation with the first relation table by inquiring a topology relation stored in advance, for example, judging whether a third data table of each stage having an expansion relation with the first data table exists; and if so, acquiring a third data table of each stage having an expansion relation with the first data table. In specific implementation, the first-level expansion table may be found according to the expansion relationship of the first data table, the second-level expansion table may be found by traversing the first-level expansion table, the third-level expansion table may be found by traversing the second-level expansion table, and the traversing may be performed sequentially downward until all the expansion tables with the expansion relationship are found. And generating query sentences of the searched third data tables at all levels according to the corresponding expansion relations at all levels, wherein the query condition sentences are generated according to the expansion fields of the expansion relations at all levels. If the query statement for generating the A1 table is: select from A1where A1.A1in (a.a). And when the A table has a plurality of query results, and the A.a has a plurality of values, splicing the values through commas.

It should be noted that there may be an association relationship between the a1 table and the B table, so as to avoid that when the topological relationship of the a table of the first data table is obtained here, after the B table and the a1 table are respectively found, when the topological relationship is found for the a1 table, the B table is found again, which causes an endless loop of finding the topological relationship. Here, for the lookup of the topological relation, it is limited that only the third data table having a direct association relation with the first data table is looked up when the association relation is looked up. When the expansion relationship is searched, the third data table having the expansion relationship with the first data table is searched, then the third data table is traversed to search the expansion data table having the expansion relationship with the third data table but not being associated with the third data table, namely, the third data table having each level of expansion relationship of the first data table is obtained by traversing according to the expansion relationship during traversing, so that possible endless loops of the A1 table and the B table are avoided.

Step S307, execute the query statement to obtain a query result of the third data table.

And correspondingly executing the query statement of the third data table to obtain a corresponding query result of the third data table. And if the third data table is a plurality of data tables, executing the query statements of the data tables one by one to obtain a plurality of corresponding query results.

And step S308, summarizing the query result of the first data table and the query result of the third data table, and displaying the summarized query results in a page.

Specifically, as shown in fig. 2, in the query results displayed on the page, the first data table is a commodity table, and the third data table includes a commodity order table having an association relationship with the first data table and a commodity entry information table having an extended relationship with the first data table. The query results of the first data table and the query results of the third data table are sequentially arranged and displayed, and the query statement of the first data table and the query statement of the third data table can be displayed together. Therefore, the user can see the data of each data table at a glance, and can know the relationship among the data tables in detail, help the user to comb the business process, check whether the data has problems, and the like. Fig. 2 is a schematic diagram, and during specific display, various data display manners may be adopted according to implementation conditions, which is not limited herein.

Step S309, traversing the query result displayed in the page, and obtaining the numerical values of the second data table name characteristic value and the query field characteristic value included in the query result.

Traversing each numerical value of the query result of the first data table displayed in the page, finding out each numerical value consisting of the numeric characters and the English character strings from the query result by using a regular expression and the like according to a numerical value generation rule during traversal, and taking the numerical values as numerical values to be analyzed. And analyzing the values to be analyzed according to a preset analysis rule, wherein the specific analysis mode refers to the description of the step S102, and is not described herein again. Here, in order to enable the analysis to more quickly and accurately determine whether the value includes the feature value corresponding to the second data table name and the feature value corresponding to the second data table query field, the length of the value may be limited when the value is searched by using a regular expression or when the value is analyzed according to a preset analysis rule. If the shortest length of the numerical value is limited, if the numerical value is smaller than the limited shortest length, the numerical value is not taken as the numerical value to be analyzed, or the numerical value is directly ignored and is not analyzed. After analyzing each numerical value, judging whether the numerical value comprises a characteristic value corresponding to the table name of the second data table and a characteristic value corresponding to the query field of the second data table, comparing the characteristic value obtained after analysis with a pre-stored characteristic value, and if the characteristic value consistent with the pre-stored characteristic value exists, indicating that the numerical value comprises the characteristic value corresponding to the table name of the second data table and the characteristic value corresponding to the query field of the second data table, and acquiring the numerical value. And meanwhile, obtaining a second data table name and a second data table query field according to the pre-stored association relationship between the characteristic value and the table name and between the characteristic value and the query field.

Further, if the page also includes the query results of other data tables, such as a third data table, etc., each numerical value in the query results is also traversed, and the numerical value including the name characteristic value of the second data table and the characteristic value of the query field is obtained from the numerical values.

Step S310, the numerical value is used as query data of the second data table, and a query result of the second data table is obtained.

And taking the numerical value as query data of the second data table, and assembling and generating query conditions of the second data table according to the description of the step S104. And executing the query condition of the second data table to obtain a query result of the second data table. Here, the query result of the second data table is not presented on the query result presentation page of the first data table, but is presented on another page. The presentation effect of another page may also refer to the presentation effect shown in fig. 2, where the query data is the value containing the second data table name characteristic value and the query field characteristic value.

Step 311, adding the correlation operation between the query result of the second data table and the numerical value in the query result in the page, so as to jump to the page where the query result of the second data table is located according to the correlation operation triggered by the user.

Adding the association operation between the query result of the second data table and the value in the query result of the first data table to the page of the query result of the first data table, as shown in fig. 4, adding a hyperlink to the value in the SHOP _ ID field in the query result of the first data table, so that the query result page in the first data table, the SHOP _ item _ relationship, can be associated with the query result page in the store view of the second data table. When the user triggers the association operation, the user can directly jump to the page where the query result of the second data table is located. And if the page also comprises the query result of the third data table and the query result of the second data table can be obtained according to the numerical value of the third data table, performing correlation operation on the corresponding query result of the second data table and the numerical value in the query result of the third data table.

According to the data characteristic-based data query method provided by the invention, one-time multi-table data query can be realized based on the topological relation among a plurality of data tables, and a user does not need to compile special SQL sentences for each table, so that the data query cost is greatly reduced, and the data query efficiency is improved. The query statement is automatically generated, and the possibility that manual query influences the query performance of the database is also avoided. The query results of the multiple data tables are summarized and displayed, so that a user can see the multiple query results at a glance, and operations such as problem troubleshooting, data analysis and service scene restoration are facilitated. Furthermore, the query can be continued according to the numerical value in the query result of the first data table to obtain the query results of other data tables, an association relationship is established, and the data are connected in series, so that a user can directly know the association relationship among the data, the storage relationship corresponding to each data in the business process and the like.

FIG. 5 shows a functional block diagram of an apparatus for querying data based on data characteristics, according to an embodiment of the invention. As shown in fig. 5, the apparatus for querying data based on data characteristics includes the following modules:

the obtaining module 510 is adapted to obtain query data input by the page according to the query operation.

As shown in fig. 2, after the user clicks the query button to execute the query operation request, the obtaining module 510 obtains the input query data from the page. Here, the first data table name and the query field that need to be queried are not specified in the query data acquired by the acquisition module 510, and are only specific query values.

The parsing module 520 is adapted to parse the query data according to a preset parsing rule to obtain a feature value corresponding to the first data table name and a feature value corresponding to the first data table query field.

The parsing module 520 parses the query data according to a preset parsing rule, where the preset parsing rule corresponds to a generation rule when the query data is generated. If the query data is generated, the characteristic value of the first data table name is stored in 11 th to 13 th bits, and the corresponding characteristic value of the query field is stored in 14 th to 16 th bits. In this way, when the parsing module 520 performs parsing, the query data is intercepted in bits, and the feature value corresponding to the table name of the first data table and the feature value corresponding to the query field of the first data table may be obtained.

The association module 530 is adapted to obtain a first data table name and a first data table query field according to the pre-stored association relationship between the feature value and the table name and between the feature value and the query field.

The correlation module 530 searches for the pre-stored feature values, and finds the feature values consistent with the obtained first data table name feature values and the obtained query field feature values. The association module 530 obtains the first data table name and the first data table query field according to the pre-stored association relationship between the feature value and the table name and between the feature value and the query field. If the first data table name characteristic value is 076 and the query field characteristic value is 004, according to the pre-stored association relationship between the characteristic value and the table name and between the characteristic value and the query field, it can be known that the first data table name corresponding to 076 is ITEM _ info, and the first data table query field corresponding to 076004 is ITEM _ ID.

The assembling module 540 is adapted to assemble and generate a query statement including the first data table name, the first data table query field, and the query data.

The assembly module 540 assembles the query statement of the first data table according to the obtained first data table name and the first data table query field and by combining the query data input by the page. For example, the query statement may be a select from first data table name where query data, and the text is replaced with the specific first data table name, the first data table query field, and the query data, so as to obtain a query statement of the first data table based on the query data.

The executing module 550 is adapted to execute the query statement, obtain a query result of the first data table, and display the query result in the page.

The executing module 550 executes the assembled query statement to obtain a corresponding query result. As shown in fig. 2, item _ info data table.

According to the data characteristic-based data query device provided by the invention, query data input by a page are obtained according to query operation; analyzing the query data according to a preset analysis rule to obtain a characteristic value corresponding to the table name of the first data table and a characteristic value corresponding to the query field of the first data table; obtaining a first data table name and a first data table query field according to the pre-stored association relationship between the characteristic value and the table name and between the characteristic value and the query field; assembling and generating a query statement containing a first data table name, a first data table query field and query data; and executing the query statement to obtain a query result of the first data table, and displaying the query result in the page. The invention reduces the familiarity requirement of the service operator on the service data, can automatically acquire the corresponding table name and the corresponding query field by only using the query data without specifying the specific table name and the query field, and acquires the corresponding query result.

Fig. 6 shows a functional block diagram of an apparatus for querying data based on data characteristics according to another embodiment of the present invention. As shown in fig. 6, compared with fig. 5, the apparatus for querying data based on data characteristics further includes the following modules:

the association skip module 560 is adapted to traverse the query result displayed in the page, and obtain the numerical values of the characteristic values of the second data table and the characteristic values of the query fields included in the query result; taking the numerical value as query data to obtain a query result of a second data table; and adding the correlation operation of the query result of the second data table and the numerical value in the query result in the page, so as to jump to the page where the query result of the second data table is located according to the correlation operation triggered by the user.

The association skip module 560 traverses each numerical value of the query result of the first data table displayed in the page, and during traversal, the association skip module 560 finds out each numerical value composed of numeric and english character strings from the query result by using a regular expression and the like according to a numerical value generation rule, and takes the numerical values as numerical values to be analyzed. The values to be analyzed are analyzed according to a preset analysis rule, and the specific analysis manner refers to the description in the first obtaining module 510, which is not described herein again. Here, in order to enable the parsing to more quickly and accurately determine whether the value includes the feature value corresponding to the second data table name and the feature value corresponding to the second data table query field, the association skip module 560 may limit the length of the value when searching for the value using the regular expression or when parsing according to a preset parsing rule. If the shortest length of the numerical value is limited, if the numerical value is smaller than the limited shortest length, the numerical value is not taken as the numerical value to be analyzed, or the numerical value is directly ignored and is not analyzed. After analyzing each numerical value, the association skip module 560 determines whether the numerical value includes a characteristic value corresponding to the table name of the second data table and a characteristic value corresponding to the query field of the second data table, that is, the characteristic value obtained after the analysis is compared with the pre-stored characteristic value, and if a characteristic value consistent with the pre-stored characteristic value exists, it indicates that the numerical value includes a characteristic value corresponding to the table name of the second data table and a characteristic value corresponding to the query field of the second data table, and obtains the numerical value. And meanwhile, obtaining a second data table name and a second data table query field according to the pre-stored association relationship between the characteristic value and the table name and between the characteristic value and the query field.

Further, if the page further includes query results of other data tables, such as a third data table, the association skip module 560 also traverses each numerical value in the query results to obtain a numerical value including a second data table name characteristic value and a query field characteristic value.

And the association skip module 560 takes the numerical value as query data of the second data table, and assembles a query condition for generating the second data table. And executing the query condition of the second data table to obtain a query result of the second data table. Here, the query result of the second data table is not presented on the query result presentation page of the first data table, but is presented on another page. The presentation effect of another page may also refer to the presentation effect shown in fig. 2, where the query data is the value containing the second data table name characteristic value and the query field characteristic value.

The association jump module 560 adds an association operation between the query result of the second data table and the value in the query result of the first data table in the page of the query result of the first data table, as shown in fig. 4, adds a hyperlink to the value in the SHOP _ ID field in the query result of the first data table SHOP, so that the query result page in the first data table SHOP view can be associated with the query result page in the second data table SHOP view. When the user triggers the association operation, the user can directly jump to the page where the query result of the second data table is located. If the page further includes the query result of the third data table, and the query result of the second data table can be obtained according to the value of the third data table, the association skip module 560 performs an association operation on the corresponding query result of the second data table and the value in the query result of the third data table.

The topology module 570 is adapted to obtain a third data table having a topological relation with the first data table, and generate a query statement of the third data table; wherein, the query statement also comprises a query condition statement; executing the query statement to obtain a query result of the third data table; and summarizing the query result of the first data table and the query result of the third data table, and displaying the summarized query results in a page.

Based on the first data table, the topology module 570 looks up a third data table having a topological relationship with the first data table. Specifically, the topology module 570 searches a data table having a relationship with the first relationship table by querying a previously stored topology relationship, for example, determines whether a third data table having a relationship with the first data table exists; if yes, the topology module 570 obtains a third data table having an association relationship with the first data table. The table name, the associated field, and the like of the third data table are obtained, and the topology module 570 generates a query statement of the third data table according to the table name and the associated field of the third data table. Wherein the query statement further comprises a query condition statement. The query condition is generated according to the query result of the first data table, and specifically, the query condition statement is generated according to the association fields of the third data table and the first data table. If the topology module 570 generates the query statement of the B table as: select from B where b.b in (a.a). And when the A table has a plurality of query results, and the A.a has a plurality of values, splicing the values through commas.

Or, by querying a topology relationship stored in advance, the topology module 570 searches a data table having an expansion relationship with the first relationship table from the topology relationship, for example, determines whether there is a third data table of each stage having an expansion relationship with the first data table; if yes, the topology module 570 obtains the third data tables of each level having an expansion relationship with the first data table. In a specific implementation, the topology module 570 may first find the first-level expansion table according to the expansion relationship of the first data table, then traverse the first-level expansion table to find the second-level expansion table, then traverse the second-level expansion table to find the third-level expansion table, and sequentially traverse downward until all the expansion tables with the expansion relationship are found. The topology module 570 generates query statements of the searched third data tables according to the corresponding expansion relations of each level, wherein the query conditional statements are generated according to the expansion fields of the expansion relations of each level. If the topology module 570 generates the query statement of the a1 table as: select from A1where A1.A1in (a.a). And when the A table has a plurality of query results, and the A.a has a plurality of values, splicing the values through commas.

It should be noted that there may be an association relationship between the a1 table and the B table, so as to avoid that when the topological relationship of the a table of the first data table is obtained here, after the B table and the a1 table are respectively found, when the topological relationship is found for the a1 table, the B table is found again, which causes an endless loop of finding the topological relationship. Here, for the lookup of the topological relationship, the constrained topology module 570 only looks up the third data table having a direct association with the first data table when looking up the association. When searching for the extended relationship, the topology module 570 searches for the third data table having the extended relationship with the first data table, and then traverses the third data table to search for the extended data table having the extended relationship with the third data table instead of the associated relationship with the third data table, that is, traverses according to the extended relationship during traversal, to obtain the third data table having the extended relationship at each level of the first data table, thereby avoiding possible endless loops between the a1 table and the B table.

The topology module 570 correspondingly executes the query statement of the third data table to obtain a corresponding query result of the third data table. If the third data table is a plurality of data tables, the topology module 570 executes the query statements of the data tables one by one to obtain a plurality of corresponding query results.

The topology module 570 summarizes and displays the query result of the first data table and the query result of the third data table, specifically, as shown in fig. 2, in the query results displayed on the page, the first data table is a commodity table, and the third data table includes a commodity order table having a relationship with the first data table and a commodity entry information table having an extended relationship with the first data table. The topology module 570 sequentially arranges and displays the query result of the first data table and the query result of the third data table, and may also display the query statement of the first data table and the query statement of the third data table together. Therefore, the user can see the data of each data table at a glance, and can know the relationship among the data tables in detail, help the user to comb the business process, check whether the data has problems, and the like. Fig. 2 is a schematic diagram, and during specific display, various data display manners may be adopted according to implementation conditions, which is not limited herein.

According to the device for querying data based on data characteristics, provided by the invention, one-time multi-table data query can be realized based on the topological relation among a plurality of data tables, and a user does not need to compile special SQL (structured query language) statements for each table, so that the cost of data query is greatly reduced, and the data query efficiency is improved. The query statement is automatically generated, and the possibility that manual query influences the query performance of the database is also avoided. The query results of the multiple data tables are summarized and displayed, so that a user can see the multiple query results at a glance, and operations such as problem troubleshooting, data analysis and service scene restoration are facilitated. Furthermore, the query can be continued according to the numerical value in the query result of the first data table to obtain the query results of other data tables, an association relationship is established, and the data are connected in series, so that a user can directly know the association relationship among the data, the storage relationship corresponding to each data in the business process and the like.

The present application further provides a non-volatile computer storage medium, where the computer storage medium stores at least one executable instruction, and the computer executable instruction can execute the method for querying data based on data characteristics in any of the above method embodiments.

Fig. 7 is a schematic structural diagram of an electronic device according to an embodiment of the present invention, and the specific embodiment of the present invention does not limit the specific implementation of the electronic device.

As shown in fig. 7, the electronic device may include: a processor (processor)702, a Communications Interface 704, a memory 706, and a communication bus 708.

Wherein:

the processor 702, communication interface 704, and memory 706 communicate with each other via a communication bus 708.

A communication interface 704 for communicating with network elements of other devices, such as clients or other servers.

The processor 702 is configured to execute the program 710, and may specifically execute relevant steps in the above-described method embodiment for querying data based on data characteristics.

In particular, the program 710 may include program code that includes computer operating instructions.

The processor 702 may be a central processing unit CPU, or an Application Specific Integrated Circuit (ASIC), or one or more Integrated circuits configured to implement an embodiment of the present invention. The electronic device comprises one or more processors, which can be the same type of processor, such as one or more CPUs; or may be different types of processors such as one or more CPUs and one or more ASICs.

The memory 706 stores a program 710. The memory 706 may comprise high-speed RAM memory, and may also include non-volatile memory (non-volatile memory), such as at least one disk memory.

The program 710 may specifically be configured to cause the processor 702 to execute a method for querying data based on data characteristics in any of the above-described method embodiments. For specific implementation of each step in the program 710, reference may be made to corresponding steps and corresponding descriptions in units in the above embodiments for querying data based on data characteristics, which are not described herein again. It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described devices and modules may refer to the corresponding process descriptions in the foregoing method embodiments, and are not described herein again.

The algorithms and displays presented herein are not inherently related to any particular computer, virtual machine, or other apparatus. Various general purpose systems may also be used with the teachings herein. The required structure for constructing such a system will be apparent from the description above. Moreover, the present invention is not directed to any particular programming language. It is appreciated that a variety of programming languages may be used to implement the teachings of the present invention as described herein, and any descriptions of specific languages are provided above to disclose the best mode of the invention.

In the description provided herein, numerous specific details are set forth. It is understood, however, that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure an understanding of this description.

Similarly, it should be appreciated that in the foregoing description of exemplary embodiments of the invention, various features of the invention are sometimes grouped together in a single embodiment, figure, or description thereof for the purpose of streamlining the disclosure and aiding in the understanding of one or more of the various inventive aspects. However, the disclosed method should not be interpreted as reflecting an intention that: that the invention as claimed requires more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive aspects lie in less than all features of a single foregoing disclosed embodiment. Thus, the claims following the detailed description are hereby expressly incorporated into this detailed description, with each claim standing on its own as a separate embodiment of this invention.

Those skilled in the art will appreciate that the modules in the device in an embodiment may be adaptively changed and disposed in one or more devices different from the embodiment. The modules or units or components of the embodiments may be combined into one module or unit or component, and furthermore they may be divided into a plurality of sub-modules or sub-units or sub-components. All of the features disclosed in this specification (including any accompanying claims, abstract and drawings), and all of the processes or elements of any method or apparatus so disclosed, may be combined in any combination, except combinations where at least some of such features and/or processes or elements are mutually exclusive. Each feature disclosed in this specification (including any accompanying claims, abstract and drawings) may be replaced by alternative features serving the same, equivalent or similar purpose, unless expressly stated otherwise.

Furthermore, those skilled in the art will appreciate that while some embodiments described herein include some features included in other embodiments, rather than other features, combinations of features of different embodiments are meant to be within the scope of the invention and form different embodiments. For example, in the following claims, any of the claimed embodiments may be used in any combination.

The various component embodiments of the invention may be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. Those skilled in the art will appreciate that a microprocessor or Digital Signal Processor (DSP) may be used in practice to implement some or all of the functions of some or all of the components of an apparatus for querying data based on data characteristics according to embodiments of the present invention. The present invention may also be embodied as apparatus or device programs (e.g., computer programs and computer program products) for performing a portion or all of the methods described herein. Such programs implementing the present invention may be stored on computer-readable media or may be in the form of one or more signals. Such a signal may be downloaded from an internet website or provided on a carrier signal or in any other form.

It should be noted that the above-mentioned embodiments illustrate rather than limit the invention, and that those skilled in the art will be able to design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention may be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by one and the same item of hardware. The usage of the words first, second and third, etcetera do not indicate any ordering. These words may be interpreted as names.

Claims

1.A method of querying data based on data characteristics, comprising:

acquiring query data input by a page according to query operation; the query data is used for querying conditions in query sentences;

analyzing the query data according to a preset analysis rule to obtain a characteristic value corresponding to a first data table name and a characteristic value corresponding to a first data table query field;

and executing the query statement to obtain a query result of the first data table, and displaying the query result in a page.

2. The method of claim 1, wherein the method further comprises:

3. The method of claim 2, wherein traversing the query result presented in the page to obtain a value comprising a third data table field further comprises:

and if so, acquiring the numerical value.

4. The method according to any one of claims 1-3, wherein the method further comprises:

acquiring a third data table having a topological relation with the first data table, and generating a query statement of the third data table; wherein, the query condition of the query statement is generated according to the query result of the first data table;

executing the query statement to obtain a query result of a third data table;

5. The method of claim 4, wherein the topological relationship is an incidence relationship or an expansion relationship; wherein, the topological relation records the association field or the extension field between the data tables.

6. The method of claim 5, wherein the topological relationship is a relationship;

the obtaining a third data table having a topological relation with the first data table, and generating a query statement of the third data table further includes:

7. The method of claim 5, wherein the topological relationship is an expansion relationship;

and generating query statements of the third data tables at all levels according to the corresponding extended relationships at all levels, wherein the query condition statements are generated according to the extended fields of the extended relationships at all levels.

8. An apparatus for querying data based on data characteristics, comprising:

the acquisition module is suitable for acquiring query data input by a page according to query operation; the query data is used for querying conditions in query sentences;

and the execution module is suitable for executing the query statement to obtain a query result of the first data table and displaying the query result in a page.

9. The apparatus of claim 8, wherein the apparatus further comprises:

10. The apparatus of claim 9, wherein the association hopping module is further adapted to:

traversing each numerical value of the query result displayed in the page, analyzing the numerical value according to a preset analysis rule, and judging whether the numerical value comprises a characteristic value corresponding to the table name of the second data table and a characteristic value corresponding to the query field of the second data table; and if so, acquiring the numerical value.

11. The apparatus of any one of claims 8-10, wherein the apparatus further comprises:

the topology module is suitable for acquiring a third data table having a topological relation with the first data table and generating a query statement of the third data table; wherein, the query condition of the query statement is generated according to the query result of the first data table; executing the query statement to obtain a query result of a third data table; and summarizing the query result of the first data table and the query result of the third data table, and displaying the summarized query results in a page.

12. The apparatus of claim 11, wherein the topological relationship is an incidence relationship or an expansion relationship; wherein, the topological relation records the association field or the extension field between the data tables.

13. The apparatus of claim 12, wherein the topological relationship is a relationship;

14. The apparatus of claim 12, wherein the topological relationship is an expansion relationship;

the topology module is further adapted to: judging whether a third data table with each stage having an expansion relation with the first data table exists or not; if yes, acquiring a third data table of each stage having an expansion relation with the first data table; and generating query statements of the third data tables at all levels according to the corresponding extended relationships at all levels, wherein the query condition statements are generated according to the extended fields of the extended relationships at all levels.

15. An electronic device, comprising: the system comprises a processor, a memory, a communication interface and a communication bus, wherein the processor, the memory and the communication interface complete mutual communication through the communication bus;

the memory is used for storing at least one executable instruction, and the executable instruction causes the processor to execute the operation corresponding to the method for querying data based on data characteristics according to any one of claims 1-7.

16. A computer storage medium having stored therein at least one executable instruction for causing a processor to perform operations corresponding to the method of querying data based on data features of any one of claims 1-7.