WO2022042288A1

WO2022042288A1 - Data query method and apparatus

Info

Publication number: WO2022042288A1
Application number: PCT/CN2021/111696
Authority: WO
Inventors: 许伟栋; 吴旭冬; 张建伟; 王晨
Original assignee: 阿里巴巴集团控股有限公司
Priority date: 2020-08-31
Filing date: 2021-08-10
Publication date: 2022-03-03
Also published as: CN112163000A

Abstract

The embodiments of the present application provide a data query method and apparatus. Said method comprises: acquiring a query statement, the query statement comprising parameter information; searching for a preset template statement matching the query statement, and acquiring preprocessed information corresponding to the template statement; using the preprocessed information and the parameter information to generate a target execution statement; and using the target execution sentence to query a preset database for target data. In this way, a query statement sent by a user can be converted into a target execution statement, and the target execution statement is used to query a database for target data, so that the database can directly execute a query task without a statement parsing optimization process, thereby increasing the query efficiency of the database.

Description

A data query method and device

This application claims the priority of the Chinese patent application with application number 202010901686.7 filed on August 31, 2020 and the invention title is "A data query method and device", the entire contents of which are incorporated into this application by reference.

technical field

The present application relates to the technical field of data processing, and in particular, to a data query method and a data query device.

Background technique

In the prior art, when a user needs to query data from a database, a query statement can usually be sent to the database. The database can perform lexical and semantic analysis on the query statement, optimize the query statement, formulate an execution plan, and then execute and return the result to the user. Among them, the database performs lexical and semantic analysis on the query statement, and the process of optimizing the query statement usually consumes certain computing resources, which easily leads to a long processing time of the query statement and reduces the processing efficiency of the database.

SUMMARY OF THE INVENTION

In view of the above problems, the embodiments of the present application are proposed to provide a data query method and a corresponding data query device that overcome the above problems or at least partially solve the above problems.

In order to solve the above problems, an embodiment of the present application discloses a data query method, including:

Obtain a query statement; wherein, the query statement includes parameter information;

Searching for a preset template statement matching the query statement, and acquiring preprocessing information corresponding to the template statement;

Using the preprocessing information and the parameter information to generate a target execution statement;

Using the target execution statement, query target data from a preset database.

Optionally, the method further includes:

In the case that the query statement does not have a matching template statement, generate a template statement according to the query statement;

Using the template statement to generate a prepared statement;

Send the preprocessing statement to the database, and obtain the preprocessing information returned by the database.

Optionally, the preprocessing information includes preprocessing identification information and parameter type information;

The method also includes:

A mapping relationship between the template statement, the preprocessing identification information, and the parameter type information is generated.

Optionally, the step of generating a target execution statement by using the preprocessing information and the parameter information includes:

Using the preprocessing information, the parameter information, and the preset encoding identification information, a target execution statement is generated; the encoding identification information is used to instruct the data to return target data encoded based on a text protocol.

Optionally, the step of searching for a preset template statement matching the query statement includes:

A template statement that is the same as the query statement except for the parameter information is searched as a preset template statement matching the query statement.

determining whether the query statement conforms to a preset format;

In the case that the query statement conforms to a preset format, search for a preset template statement matching the query statement;

If the query statement does not conform to the preset format, the query statement is forwarded to the database.

The embodiment of the present application also discloses a data query method, which is applied to query processing middleware, and the query processing middleware communicates with a client and a database at the same time; the method includes:

The query processing middleware obtains the query statement sent by the client; wherein the query statement includes parameter information;

The query processing middleware searches for a preset template statement matching the query statement, and obtains preprocessing information corresponding to the template statement;

The query processing middleware uses the preprocessing information and the parameter information to generate a target execution statement;

The query processing middleware sends the target execution statement to the database, and obtains target data returned by the database;

The query processing middleware returns the target data to the client.

The embodiment of the present application also discloses a data query device, comprising:

a first query statement obtaining module, used for obtaining a query statement; wherein the query statement includes parameter information;

a first target statement search module, configured to search for a preset template statement matching the query statement, and obtain preprocessing information corresponding to the template statement;

a first target execution statement generation module, configured to use the preprocessing information and the parameter information to generate a target execution statement;

The first query module is configured to use the target execution statement to query target data from a preset database.

Optionally, the device further includes:

a template generation module, configured to generate a template statement according to the query statement when the query statement does not have a matching template statement;

a prepared statement generation module for generating a prepared statement by using the template statement;

The preprocessing information acquiring module is configured to send the preprocessing statement to the database, and acquire the preprocessing information returned by the database.

The device also includes:

The mapping generation module is used for generating the mapping relationship among the template statement, the preprocessing identification information, and the parameter type information.

Optionally, the first target execution statement generation module includes:

A target execution statement generation submodule is used to generate a target execution statement by using the preprocessing information, the parameter information, and the preset encoding identification information; the encoding identification information is used to instruct the data to be returned based on text protocol encoding target data.

Optionally, the first target statement search module includes:

The first target statement search sub-module is configured to search for a template statement that is the same as the query statement except for the parameter information, as a preset template statement matching the query statement.

Optionally, the first target statement search module includes:

a format determination submodule for determining whether the query statement conforms to a preset format;

a second target statement search submodule, configured to search for a preset template statement matching the query statement when the query statement conforms to a preset format;

The forwarding sub-module is configured to forward the query statement to the database if the query statement does not conform to the preset format.

An embodiment of the present application discloses a data query device, which is applied to query processing middleware, and the query processing middleware communicates with a client and a database at the same time; the device is deployed in the query processing middleware, and the query processing middleware The device includes:

The second query statement obtaining module is used to obtain the query statement sent by the client; wherein, the query statement includes parameter information;

A second target statement search module, configured to search for a preset template statement matching the query statement, and obtain preprocessing information corresponding to the template statement;

a second target execution statement generation module, configured to generate a target execution statement by using the preprocessing information and the parameter information;

A second query module, configured to send the target execution statement to the database, and obtain target data returned by the database;

A data return module, configured to return the target data to the client.

The embodiment of the present application also discloses a device, comprising:

one or more processors; and

One or more machine-readable media having instructions stored thereon, when executed by the one or more processors, cause the apparatus to perform one or more of the methods described in the embodiments of the present application.

The embodiments of the present application further disclose one or more machine-readable media, on which instructions are stored, and when executed by one or more processors, cause the processors to execute one or more of the methods described in the embodiments of the present application. a method.

The embodiments of the present application include the following advantages:

Obtain a query statement through the data query method of the embodiment of the present application; wherein, the query statement includes parameter information; search for a preset template statement matching the query statement, and obtain preprocessing information corresponding to the template statement; Using the preprocessing information and the parameter information, a target execution statement is generated; using the target execution statement, a preset database is queried for target data. Therefore, the query statement sent by the user can be converted into a target execution statement, and the target execution statement can be used to query the database for target data, so that the database can directly execute the query task without going through the statement parsing and optimization process, which improves the performance of the database. query efficiency.

Description of drawings

Fig. 1 is a flow chart of steps of a data query method embodiment of the present application;

Fig. 2 is a flow chart of steps of a data query method embodiment of the present application;

3 is a flow chart of steps of an embodiment of a data query method of the present application;

4 is a schematic diagram of an embodiment of a data query method of the present application;

5 is a structural block diagram of an embodiment of a data query device of the present application;

FIG. 6 is a structural block diagram of an embodiment of a data query apparatus according to the present application.

detailed description

In order to make the above objects, features and advantages of the present application more clearly understood, the present application will be described in further detail below with reference to the accompanying drawings and specific embodiments.

The embodiment of the present application is aimed at the situation that the database performs lexical and semantic analysis on the query statement, and the process of optimizing the query statement reduces the efficiency of the database. The query statement is matched with the template statement, and based on the parameter information of the query statement and the preprocessing information corresponding to the template statement matching the query statement, a target execution statement is generated, and the target execution statement is used to query the database. After acquiring the target execution statement, the database can directly use the target execution statement to perform a data query task without analyzing and optimizing the target execution statement, and return the data query result, thereby improving the processing efficiency of the database.

Referring to FIG. 1, a flow chart of steps of an embodiment of a data query method of the present application is shown, which may specifically include the following steps:

Step 101, obtaining a query statement; wherein, the query statement includes parameter information;

In this embodiment of the present application, the query statement sent by the user can be acquired. The query statement can be used to query target data from a preset database. The query statement may include parameter information, and the parameter information may be information of a variable number of parameters in the query statement. For example, in the query statement "select name from a limit 1", 1 can be the parameter information.

Step 102, searching for a preset template statement matching the query statement, and acquiring preprocessing information corresponding to the template statement;

In this embodiment of the present application, several preset template statements may be stored, as well as the corresponding relationship between the template statements and preprocessing information. A preset template statement matching the query statement can be searched, and the preprocessing information corresponding to the template statement can be acquired according to the correspondence between the template statement and the preprocessing information.

The preprocessing information may be information obtained by preparsing the template statement by the database. Therefore, when the database can use the preprocessing information to perform a query task similar to the template statement, it is not necessary to parse the acquired statement again, and the data query task can be directly performed based on the preprocessing information.

In a specific implementation, if the template statement is the same as the query statement except for the parameter information, it can be considered that the query statement matches the template statement.

Step 103, using the preprocessing information and the parameter information to generate a target execution statement;

In this embodiment of the present application, the preprocessing information and the parameter information may be used to generate a target execution statement. The target execution statement can be used to query the same target data as the query statement.

Step 104, using the target execution statement to query target data from a preset database.

In this embodiment of the present application, the target execution statement may be used to query target data from a preset database. Since the target execution statement contains the preprocessing information, the database can directly use the preprocessing information and the parameter information contained in the target execution statement without parsing the target execution statement again to execute the query task , query the target data.

Thus, for the query statement sent by the user, in the case of an existing template statement, the query statement can be converted into a target execution statement, and the target execution statement can be used to query the preset data for target data. Therefore, the database can directly execute the query task without re-analyzing the obtained target execution statement, and obtain the target data by query, thereby improving the query processing efficiency.

As an example of the present application, the query statement is "select*from a limit 1", and after finding a template statement matching the query statement, the preprocessing information corresponding to the template statement can be obtained, using the The preprocessing information and the parameter information are used to generate a target execution statement. The database can use the preprocessing information and the parameter information contained in the target execution statement to learn that what the user wants to query is "select*from a limit1", and execute the query task to return the target data.

In a specific implementation, a middleware can be preset, and the middleware can communicate with the user and the database at the same time. The middleware stores several preset template statements, and the corresponding relationship between the template statements and preprocessing information. After acquiring the query statement sent by the user, the middleware may search for a preset template statement matching the query statement, acquire preprocessing information corresponding to the template statement, and use the preprocessing information and the The parameter information is used to generate a target execution statement, and the target execution statement is used to query the target data from a preset database. After obtaining the target data, the middleware can return the target data to the user. Therefore, the middleware can assist the user to convert the query statement into the target execution statement, thereby improving the query efficiency. In addition, users can use the target execution statement to query target data without modifying the client or the client interface.

Referring to FIG. 2 , a flow chart of steps of an embodiment of a data query method of the present application is shown, which may specifically include the following steps:

Step 201, obtaining a query statement; wherein, the query statement includes parameter information;

Step 202, searching for a preset template statement matching the query statement, and acquiring preprocessing information corresponding to the template statement;

In this embodiment of the present application, several preset template statements may be stored, as well as the corresponding relationship between the template statements and preprocessing information. A preset template statement matching the query statement may be searched for, and preprocessing information corresponding to the template statement may be acquired according to the correspondence between the template statement and the preprocessing information.

The step of searching for a preset template statement matching the query statement includes:

S11: Search for a template statement that is the same as the query statement except for the parameter information, as a preset template statement matching the query statement.

In this embodiment of the present application, the template statement matching the query statement may be the same as the query statement except that the parameter information is different from the query statement. In this way, it is possible to find out whether there is a template statement that is the same as the query statement except for the parameter information, as a preset target statement matching the query statement.

As an example of the present application, if the query statement is "select*from t limit 1", the template statement matching the query statement may be "select*from t limit?".

In an embodiment of the present application, the method further includes:

S21, in the case that the query statement does not have a matching template statement, generate a template statement according to the query statement;

In the embodiment of the present application, in the case that the query statement does not have a matching template statement, a template statement can be generated according to the query statement, so as to facilitate the subsequent improvement of processing efficiency of query statements of the same type.

In an embodiment of the present application, the step of generating a template statement according to the query statement includes:

S31 , replace the parameter information in the query statement with placeholder information to generate a template statement.

In the embodiment of the present application, since the template statement needs to be adapted to query statements containing different parameter information, the parameter information in the query statement can be replaced with placeholder information, so that the template statement can be generated.

As an example of this application, the query statement is "select name from a where id between 1and 2", where the parameter information is "1" and "2", the placeholder "?" can be used to replace the parameter information with "1" and "2", resulting in the template statement "select name from a where id between?and?".

S22, using the template statement to generate a prepared statement;

In this embodiment of the present application, the template statement may be used to generate a preprocessing statement for acquiring preprocessing information from a database.

In a specific implementation, the template statement can be used to generate a binary prepared statement conforming to the database communication protocol. As a specific implementation manner of the present application, the prepared statement may be a message of type COM_STMT_PREPARE.

S23: Send the preprocessing statement to the database, and obtain the preprocessing information returned by the database.

In this embodiment of the present application, the preprocessed statement may be sent to the database, and the database may perform parsing processing on the preprocessed statement, generate preprocessing information, and return it, so as to obtain the preprocessed statement returned by the database. information.

In a specific implementation, the preprocessing information returned by the database may include preprocessing identification information and parameter type information. The preprocessing identification information may be identification information allocated by the database to the preprocessing statement. The parameter type information is the type of parameters that can be set by the prepared statement recorded in the database. The parameter type may be an integer type, a string type, etc., which is not limited in this application.

As an example of the present application, the preprocessing information returned by the database for the prepared statement may include: status (status information), statement_id (preprocessing identification information), num_columns (number of columns), and num_params (number of parameters) , reserved_1 (reserved filler), warning_count (warning times), Parameter Definition Block (parameter type information), and Column Definition Block (column definition information).

In an embodiment of the present application, the step of searching for a preset template statement matching the query statement includes:

S41, determine whether the query statement conforms to a preset format;

In this embodiment of the present application, the query statement sent by the user may be in multiple different formats. In the present application, a query statement that conforms to a preset format can be matched with a template statement and converted into a target execution statement. For the query statement that does not conform to the format, it may not be processed. Thus, it can be determined whether the query statement conforms to the preset format.

The preset format can be set according to actual needs, for example, the preset format can be at least one of a simple query statement, a complex query statement, a multi-table query statement, a nested query statement, and a parameterized query statement , this application does not limit it.

S42, when the query statement conforms to a preset format, search for a preset template statement matching the query statement;

In this embodiment of the present application, if the query statement conforms to the preset format, the query statement can be converted into a target execution statement at this time. The preset template statement matching the query statement can be queried, and the preprocessing information corresponding to the template statement can be obtained, and the target execution statement can be generated by using the preprocessing information and the parameter information, and executed by using the target statement. statement, the step of querying the target data from the preset database.

S43, if the query statement does not conform to the preset format, forward the query statement to the database.

In this embodiment of the present application, if the query statement does not conform to the preset format, it may not be necessary to convert the query statement into a target execution statement at this time. At this time, the query statement can be directly forwarded to the database, and the database can directly parse the query statement and return the target data.

In the embodiment of the present application, if the query statement conforms to the preset format, it may be further determined whether the query statement contains parameter information, and if the query statement does not contain parameter information, it may be considered that the query statement does not contain parameter information. If it is suitable for converting the query statement into a target execution statement, the query statement can also be directly forwarded to the database at this time, and the database directly parses the query statement and returns the target data.

In this way, the dynamic opening and closing of converting the query statement into the target execution statement can be realized, the query statement that conforms to the preset format is executed and the query statement is converted into the target execution statement, and the query statement that does not conform to the preset format can be directly forwarded to the database, and the query statement is directly parsed and processed by the database.

As an example of the present application, the preset format may be a non-parameterized query statement. When the obtained query statement is a non-parameterized query statement, the query statement can be converted into a target execution statement, the query statement is executed, and the preset template statement matching the query statement is executed, and the preset template statement corresponding to the template statement is obtained. Processing information, using the preprocessing information and the parameter information, generating a target execution statement, and querying a preset database for target data by using the target execution statement. If the obtained query statement is a parameterized query statement, the query statement may not need to be processed at this time, and the query statement may be directly forwarded to the database.

In an embodiment of the present application, the method further includes:

S51. Generate a mapping relationship among the template statement, the preprocessing identification information, and the parameter type information.

In this embodiment of the present application, a mapping relationship between the template statement, the preprocessing identification information, and the parameter type information may be generated, and the mapping relationship may be stored. Therefore, after acquiring the query statement, a template statement matching the query statement is searched, and the preprocessing identification information and parameter type information corresponding to the query statement are determined according to the mapping relationship, thereby further improving processing efficiency.

In a specific implementation, the template statement may be converted into a hash value based on a hash algorithm (hash), and then a mapping relationship between the hash value, the preprocessing identification information, and the parameter type information is generated, And the mapping relationship is stored, so that data security can be ensured while reducing the amount of data.

As an example of this application, the query statement is "select name from a limit 888", the parameter information "888" in the query statement can be replaced with a placeholder "?" to obtain the template statement "select name from a limit 888" limit?". Thereafter, the template statement "select name from a limit?" can be converted into a hash value "abdc", after determining that the preprocessing information is the preprocessing identification information "3" and the parameter type information is "int", A mapping relationship between the template statement, the preprocessing identification information, and the parameter type information can be generated {abdc=>{3,{int,? }}.

Step 203, using the preprocessing information, the parameter information, and the preset encoding identification information to generate a target execution statement; the encoding identification information is used to instruct the data to return the target data encoded based on the text protocol;

In this embodiment of the present application, the preprocessing information, the parameter information, and the preset coding identification information may be used to generate a target execution statement; the coding identification information is used to instruct the data to return a text protocol-encoded based target data.

Wherein, the target execution statement may be a statement based on binary coding. Thus, the preprocessing information and the parameter information can be used to generate a target execution statement including the preprocessing information and the parameter information, and the target execution statement can be converted into a statement based on a binary encoding protocol. As an example of the present application, the target execution statement may be a COM_STMT_EXECUTE message.

In a specific implementation, in general, the database may execute a statement for the target, and return target data in an encoding manner based on a binary protocol. However, because the query statement usually returns the target data based on the encoding method of the text protocol. Therefore, the encoding identification information can be used to set the database to return the target data encoded based on the text protocol for the target execution statement.

After acquiring the target execution statement, the database may determine to return target data based on a text protocol encoding method according to the encoding identification information contained in the target execution statement. Therefore, the target data finally obtained by the user may be encoded based on the text protocol.

As an example of the present application, a flag bit (flag) may exist in the target execution statement. Generally speaking, the flag bit is a field of 8 bytes, and the database usually only uses the last 4 bits. The first 4 bits of the flag bits can be used as self-defined encoding identification information and set to 0x80. The database may be configured to use text protocol encoding to return the target data after receiving the target execution statement whose flag bit contains 0x80 encoded identification information. Therefore, although the target execution statement based on the binary protocol encoding is used to obtain the target data, the final returned target data can still be encoded based on the text protocol. The target data is encoded in the text protocol, and the processing efficiency of the database is improved.

Step 204, using the target execution statement to query a preset database for target data.

As an example of this application, the query statement is "select*from a limit 1", and the parameter information is "1". After a template statement matching the query statement is found, the preprocessing information corresponding to the template statement can be obtained, and the preprocessing information includes the preprocessing identification information "3" and the parameter type information "int". The identification information "3", the parameter type information "int", and the parameter information "1" are processed to generate a target execution statement. The database can use the preprocessing information and the parameter information contained in the target execution statement to learn that what the user wants to query is "select*from a limit 1", and execute the query task to return the target data.

Obtain a query statement through the data query method of the embodiment of the present application; wherein, the query statement includes parameter information; search for a preset template statement matching the query statement, and obtain preprocessing information corresponding to the template statement; Using the preprocessing information, the parameter information, and the preset coding identification information, a target execution statement is generated; and the target execution statement is used to query a preset database for target data. Therefore, the query statement sent by the user can be converted into a target execution statement, and the target execution statement can be used to query the database for target data, so that the database can directly execute the query task without going through the statement parsing and optimization process, which improves the performance of the database. query efficiency.

Referring to FIG. 3 , a flow chart of steps of an embodiment of a data query method of the present application is shown, which is applied to query processing middleware, and the query processing middleware communicates with the client and the database at the same time.

In the embodiment of the present application, it is usually difficult to modify the client of the user, and if the user needs to use prepared statements and target execution statements, the client usually needs to be modified and updated before the client can use Prepared statements and target execution statements. Especially for online applications, it is difficult to restart the online application so that the online application can use prepared statements and target execution statements. In addition, if the user incorrectly uses the prepared statement and the target execution statement, regardless of whether there is a template statement, the preprocessing information is obtained for the query statement, and then the target execution statement is generated to obtain the target data, which will easily cause the database to consume more computing resources. .

Thus, a query processing middleware can be set between the user's client and the database, and the query processing middleware communicates with the client and the database at the same time. The query processing intermediate key can convert the query statement sent by the client into a target execution statement, and use the target execution statement to obtain target data from the database, so that the user can use the target execution preset to obtain the database without changing the application program. The target data can effectively improve the processing efficiency of the database, and it is easy for users to use.

The method may specifically include the following steps:

Step 301, the query processing middleware obtains a query statement sent by the client; wherein the query statement includes parameter information;

In this embodiment of the present application, the query processing middleware may acquire a query statement sent by the client of the user. The query statement can be used to query target data from a preset database. The query statement may include parameter information, and the parameter information may be information of a variable number of parameters in the query statement.

Step 302, the query processing middleware searches for a preset template statement matching the query statement, and obtains preprocessing information corresponding to the template statement;

In this embodiment of the present application, the query processing middleware may store several preset template statements, as well as the correspondence between the template statements and preprocessing information. The query processing middleware may search for a preset template statement matching the query statement, and obtain preprocessing information corresponding to the template statement according to the correspondence between the template statement and the preprocessing information.

Step 303, the query processing middleware uses the preprocessing information and the parameter information to generate a target execution statement;

In this embodiment of the present application, the query processing middleware may use the preprocessing information and the parameter information to generate a target execution statement. The target execution statement can be used to query the same target data as the query statement.

Step 304, the query processing middleware sends the target execution statement to the database, and obtains the target data returned by the database.

In this embodiment of the present application, the query processing middleware may use the target execution statement to query a preset database for target data. Since the target execution statement contains the preprocessing information, the database can directly use the preprocessing information and the parameter information contained in the target execution statement without parsing the target execution statement again to execute the query task , query the target data. Thereafter, the query processing middleware may acquire the target data returned by the database.

Therefore, for the query statement sent by the client, if the query processing middleware already has a template statement, the query processing middleware can convert the query statement into a target execution statement, and use the The target execution statement queries the data for target data. Therefore, the database can directly execute the query task without re-analyzing the obtained target execution statement, and obtain the target data by query, thereby improving the query processing efficiency.

Step 305, the query processing middleware returns the target data to the client.

In this embodiment of the present application, the query processing middleware may return the target data to the client, so that the client may obtain the target data corresponding to the query statement. However, the query processing middleware obtains target data from the database after converting the query statement into a target execution statement. The processing efficiency of the database is improved.

In this embodiment of the present application, the client may, according to actual needs, enable or disable the function of the query processing middleware to convert the query statement into a target execution statement. The query processing middleware can convert the query statements that conform to the preset format into target execution statements according to actual needs, and directly forward the query statements that do not conform to the preset format to the database, so that the query statement can be implemented according to actual needs. The query statement is converted into the dynamic use of the target execution statement function.

As an example of the present application, FIG. 4 is a schematic diagram of an embodiment of a data query method according to an embodiment of the present application. It includes the client 401 , the query processing middleware 402 , and the database 403 .

The client 401 may send a query statement to the query processing middleware 402, and if the query processing middleware 402 does not have a template statement matching the query statement, a template may be generated according to the query statement statement; generate a prepared statement according to the template statement, and send the prepared statement to the database 403 . The database 403 may return preprocessing identification information and parameter type information to the query processing middleware 402 . Thereafter, the query processing middleware 402 may generate a target execution statement based on the preprocessing identification information and parameter type information, and the parameter information in the query statement, and send the target execution statement to the database 403. , the database 403 may return target data to the query processing middleware 402 for the target execution statement. Thereafter, the query processing middleware 402 may forward the target data to the client 401, and the client 401 may obtain the target data for the query statement.

With the data query method of the embodiment of the present application, the query processing middleware obtains the query statement sent by the client; wherein, the query statement includes parameter information; the query processing middleware searches for the query statement that matches the query statement. preset template statement, and obtain the preprocessing information corresponding to the template statement; the query processing middleware uses the preprocessing information and the parameter information to generate a target execution statement; the query processing middleware reports to the The database sends the target execution statement, and obtains the target data returned by the database; the query processing middleware returns the target data to the client. Therefore, without changing the client, the query processing middleware converts the query statement sent by the client into a target execution statement, and uses the target execution statement to query the database for target data, so that the database can After the statement parsing and optimization process, the query task can be directly executed, which improves the query efficiency of the database.

It should be noted that, for the sake of simple description, the method embodiments are expressed as a series of action combinations, but those skilled in the art should know that the embodiments of the present application are not limited by the described action sequence, because According to the embodiments of the present application, certain steps may be performed in other sequences or simultaneously. Secondly, those skilled in the art should also know that the embodiments described in the specification are all preferred embodiments, and the actions involved are not necessarily required by the embodiments of the present application.

Referring to FIG. 5, a structural block diagram of an embodiment of a data query apparatus of the present application is shown, which may specifically include the following modules:

The first query statement obtaining module 501 is used to obtain a query statement; wherein, the query statement includes parameter information;

The first target statement search module 502 is configured to search for a preset template statement matching the query statement, and obtain preprocessing information corresponding to the template statement;

a first target execution statement generation module 503, configured to generate a target execution statement by using the preprocessing information and the parameter information;

The first query module 504 is configured to use the target execution statement to query target data from a preset database.

In an embodiment of the present application, the device further includes:

In an embodiment of the present application, the preprocessing information includes preprocessing identification information and parameter type information;

The device also includes:

In an embodiment of the present application, the first target execution statement generation module includes:

In an embodiment of the present application, the first target sentence search module includes:

The second target statement search submodule is used to search for a preset template statement matching with the query statement when the query statement meets the preset format;

Referring to FIG. 6, it shows a structural block diagram of an embodiment of a data query apparatus of the present application, which is applied to query processing middleware, and the query processing middleware communicates with a client and a database at the same time; the apparatus is deployed in the In the query processing middleware, the device may specifically include the following modules:

The second query statement obtaining module 601 is configured to obtain the query statement sent by the client; wherein the query statement includes parameter information;

A second target statement search module 602, configured to search for a preset template statement matching the query statement, and obtain preprocessing information corresponding to the template statement;

The second target execution statement generation module 603 is configured to use the preprocessing information and the parameter information to generate a target execution statement;

A second query module 604, configured to send the target execution statement to the database, and obtain target data returned by the database;

The data returning module 605 is configured to return the target data to the client.

As for the apparatus embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and reference may be made to the partial description of the method embodiment for related parts.

The embodiment of the present application also provides a device, including:

one or more processors; and

One or more machine-readable media having instructions stored thereon, when executed by the one or more processors, cause the apparatus to perform the methods described in the embodiments of the present application.

The embodiments of the present application further provide one or more machine-readable media on which instructions are stored, and when executed by one or more processors, cause the processors to execute the methods described in the embodiments of the present application.

The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments, and the same and similar parts between the various embodiments may be referred to each other.

Those skilled in the art should understand that the embodiments of the embodiments of the present application may be provided as methods, apparatuses, or computer program products. Accordingly, the embodiments of the present application may take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, embodiments of the present application may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) having computer-usable program code embodied therein.

The embodiments of the present application are described with reference to the flowcharts and/or block diagrams of the methods, terminal devices (systems), and computer program products according to the embodiments of the present application. It will be understood that each flow and/or block in the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to the processor of a general purpose computer, special purpose computer, embedded processor or other programmable data processing terminal equipment to produce a machine that causes the instructions to be executed by the processor of the computer or other programmable data processing terminal equipment Means are created for implementing the functions specified in the flow or flows of the flowcharts and/or the blocks or blocks of the block diagrams.

These computer program instructions may also be stored in a computer readable memory capable of directing a computer or other programmable data processing terminal equipment to operate in a particular manner, such that the instructions stored in the computer readable memory result in an article of manufacture comprising instruction means, the The instruction means implement the functions specified in the flow or flow of the flowcharts and/or the block or blocks of the block diagrams.

These computer program instructions can also be loaded on a computer or other programmable data processing terminal equipment, so that a series of operational steps are performed on the computer or other programmable terminal equipment to produce a computer-implemented process, thereby executing on the computer or other programmable terminal equipment The instructions executed on the above provide steps for implementing the functions specified in the flowchart or blocks and/or the block or blocks of the block diagrams.

Although the preferred embodiments of the embodiments of the present application have been described, those skilled in the art may make additional changes and modifications to these embodiments once the basic inventive concepts are known. Therefore, the appended claims are intended to be construed to include the preferred embodiments as well as all changes and modifications that fall within the scope of the embodiments of the present application.

Finally, it should also be noted that in this document, relational terms such as first and second are used only to distinguish one entity or operation from another, and do not necessarily require or imply these entities or that there is any such actual relationship or sequence between operations. Moreover, the terms "comprising", "comprising" or any other variation thereof are intended to encompass non-exclusive inclusion, such that a process, method, article or terminal device comprising a list of elements includes not only those elements, but also a non-exclusive list of elements. other elements, or also include elements inherent to such a process, method, article or terminal equipment. Without further limitation, an element defined by the phrase "comprises a..." does not preclude the presence of additional identical elements in the process, method, article or terminal device comprising said element.

A data query method and a data query device provided by the present application have been introduced in detail above. The principles and implementations of the present application are described with specific examples in this paper. The descriptions of the above embodiments are only used to help At the same time, for those of ordinary skill in the art, according to the idea of this application, there will be changes in the specific implementation and application scope. In summary, the content of this specification does not It should be understood as a limitation of this application.

Claims

A data query method, comprising:

Obtain a query statement; wherein, the query statement includes parameter information;

Searching for a preset template statement matching the query statement, and acquiring preprocessing information corresponding to the template statement;

Using the preprocessing information and the parameter information to generate a target execution statement;

Using the target execution statement, query target data from a preset database.
The method according to claim 1, wherein the method further comprises:

In the case that the query statement does not have a matching template statement, generate a template statement according to the query statement;

Using the template statement to generate a prepared statement;

Send the preprocessing statement to the database, and obtain the preprocessing information returned by the database.
The method according to claim 2, wherein the preprocessing information comprises preprocessing identification information and parameter type information;

The method also includes:

A mapping relationship between the template statement, the preprocessing identification information, and the parameter type information is generated.
The method according to claim 1, wherein the step of using the preprocessing information and the parameter information to generate the target execution statement comprises:

Using the preprocessing information, the parameter information, and the preset encoding identification information, a target execution statement is generated; the encoding identification information is used to instruct the data to return target data encoded based on a text protocol.
The method according to claim 1, wherein the step of searching for a preset template statement matching the query statement comprises:

A template statement that is the same as the query statement except for the parameter information is searched as a preset template statement matching the query statement.
The method according to claim 1, wherein the step of searching for a preset template statement matching the query statement comprises:

determining whether the query statement conforms to a preset format;

In the case that the query statement conforms to a preset format, search for a preset template statement matching the query statement;

If the query statement does not conform to the preset format, the query statement is forwarded to the database.
A data query method, characterized in that it is applied to query processing middleware, and the query processing middleware communicates with a client and a database at the same time; the method comprises:

The query processing middleware obtains the query statement sent by the client; wherein the query statement includes parameter information;

The query processing middleware searches for a preset template statement matching the query statement, and obtains preprocessing information corresponding to the template statement;

The query processing middleware uses the preprocessing information and the parameter information to generate a target execution statement;

The query processing middleware sends the target execution statement to the database, and obtains target data returned by the database;

The query processing middleware returns the target data to the client.
A data query device, comprising:

a first query statement obtaining module, used for obtaining a query statement; wherein the query statement includes parameter information;

a first target statement search module, configured to search for a preset template statement matching the query statement, and obtain preprocessing information corresponding to the template statement;

a first target execution statement generation module, configured to use the preprocessing information and the parameter information to generate a target execution statement;

The first query module is configured to use the target execution statement to query target data from a preset database.
The device according to claim 8, wherein the device further comprises:

a template generation module, configured to generate a template statement according to the query statement when the query statement does not have a matching template statement;

a prepared statement generation module for generating a prepared statement by using the template statement;

The preprocessing information acquiring module is configured to send the preprocessing statement to the database, and acquire the preprocessing information returned by the database.
The apparatus according to claim 9, wherein the preprocessing information comprises preprocessing identification information and parameter type information;

The device also includes:

The mapping generation module is used for generating the mapping relationship among the template statement, the preprocessing identification information, and the parameter type information.
The device according to claim 8, wherein the first target execution statement generation module comprises:

A target execution statement generation submodule is used to generate a target execution statement by using the preprocessing information, the parameter information, and the preset encoding identification information; the encoding identification information is used to instruct the data to be returned based on text protocol encoding target data.
The device according to claim 8, wherein the first target sentence search module comprises:

The first target statement search sub-module is configured to search for a template statement that is the same as the query statement except for the parameter information, as a preset template statement matching the query statement.
The device according to claim 8, wherein the first target sentence search module comprises:

a format determination submodule for determining whether the query statement conforms to a preset format;

a second target statement search submodule, configured to search for a preset template statement matching the query statement when the query statement conforms to a preset format;

A forwarding sub-module is configured to forward the query statement to the database when the query statement does not conform to a preset format.
A data query device, characterized in that it is applied to query processing middleware, and the query processing middleware communicates with a client and a database at the same time; the device is deployed in the query processing middleware, and the device comprises:

The second query statement obtaining module is used to obtain the query statement sent by the client; wherein, the query statement includes parameter information;

A second target statement search module, configured to search for a preset template statement matching the query statement, and obtain preprocessing information corresponding to the template statement;

a second target execution statement generation module, configured to generate a target execution statement by using the preprocessing information and the parameter information;

A second query module, configured to send the target execution statement to the database, and obtain target data returned by the database;

A data return module, configured to return the target data to the client.
A data query device, comprising:

one or more processors; and

One or more machine-readable media having instructions stored thereon that, when executed by the one or more processors, cause the apparatus to perform the method of one or more of claims 1-6 or 7 .
One or more machine-readable media having stored thereon instructions that, when executed by one or more processors, cause the processors to perform the method of one or more of claims 1-6 or 7.