WO2023030461A1

WO2023030461A1 - Distributed database detection method and apparatus

Info

Publication number: WO2023030461A1
Application number: PCT/CN2022/116588
Authority: WO
Inventors: 陈双
Original assignee: 中兴通讯股份有限公司
Priority date: 2021-09-02
Filing date: 2022-09-01
Publication date: 2023-03-09
Also published as: CN115757083A

Abstract

Embodiments of the present disclosure provide a distributed database detection method and apparatus. The method comprises: obtaining a complexity factor of an SQL; constructing a table structure according to the complexity factor; obtaining a basic element of the SQL from a parameter dictionary according to the complexity factor, and generating an SQL statement according to the table structure and the basic element; and detecting a distributed database according to the table structure and the SQL statement, which can solve the problems in the related art that the SQL statement cannot be enumerated and traversed, an SQL grammar designed artificially is also relatively simple, a test grammar is easy to miss, and an actual complex application scenario of the distributed database cannot be met. The table structure is constructed according to the complexity factor, and the SQL statement is generated according to the table structure and the basic element, such that the addition, deletion, modification and checking of corresponding data from random creation of the table structure are implemented, and the SQL statement can be flexibly generated to deal with the complex application scenario of the distributed database.

Description

A distributed database detection method and device

Cross References to Related Applications

This disclosure is based on the Chinese patent application CN202111028813.8 filed on September 2, 2021 with the title of "a distributed database detection method and device", and claims the priority of this patent application, and the disclosed content is incorporated by reference All are incorporated into this disclosure.

technical field

Embodiments of the present disclosure relate to the communication field, and in particular, to a distributed database detection method and device.

Background technique

With the rapid development of domestic distributed databases, the syntax compatibility and usage of Structured Query Language (SQL) are facing great challenges. At the same time, distributed databases are used in more and more scenarios, and higher requirements are placed on the functions and performance supported by the database. Due to the different structures of different business tables and the complex and changeable business logic, there are also various ways to write SQL statements. Manually written test SQL or SQL automatically generated by conventional SQL generation tools cannot be enumerated and traversed, and the designed The SQL syntax is also relatively simple, which is prone to omissions in the test syntax and may not be able to meet the complex application scenarios of the actual distributed database.

The SQL statements of related technologies cannot be enumerated and traversed, and the artificially designed SQL syntax is relatively simple, which may easily cause the omission of test syntax and fail to meet the complex application scenarios of the actual distributed database. No solution has been proposed yet.

Contents of the invention

The embodiment of the present disclosure provides a distributed database detection method and device to at least solve the problem that SQL statements in related technologies cannot be enumerated and traversed, and the artificially designed SQL syntax is relatively simple, which may easily cause the possibility of omission of test syntax and cannot meet the requirements. The problem of complex application scenarios of actual distributed databases.

According to an embodiment of the present disclosure, a distributed database detection method is provided, including:

Get the complexity factor of SQL;

Constructing a table structure according to the complexity factor;

Obtain the basic elements of the SQL from the parameter dictionary according to the complexity factor, and generate an SQL statement according to the table structure and the basic elements;

The distributed database is detected according to the table structure and the SQL statement.

According to another embodiment of the present disclosure, a distributed database detection device is provided, including:

Get the module, set to get the complexity factor of SQL;

A construction module, configured to construct a table structure according to the complexity factor;

A generation module configured to obtain the basic elements of the SQL from the parameter dictionary according to the complexity factor, and generate an SQL statement according to the table structure and the basic elements;

The detection module is configured to detect the distributed database according to the table structure and the SQL statement.

According to yet another embodiment of the present disclosure, there is also provided a computer-readable storage medium, where a computer program is stored in the storage medium, wherein the computer program is set to execute any one of the above method embodiments when running in the steps.

According to yet another embodiment of the present disclosure, there is also provided an electronic device, including a memory and a processor, wherein a computer program is stored in the memory, and the processor is configured to run the computer program to perform any of the above Steps in the method examples.

Description of drawings

FIG. 1 is a block diagram of a hardware structure of a mobile terminal of a distributed database detection method according to an embodiment of the present disclosure;

2 is a flowchart of a distributed database detection method according to an embodiment of the present disclosure;

Fig. 3 is the flow chart of the generation method of the SELECT statement according to the present embodiment;

Fig. 4 is a block diagram of a distributed database detection device according to the present embodiment;

Fig. 5 is a block diagram 1 of a distributed database detection device according to this preferred embodiment;

Fig. 6 is a second block diagram of a distributed database detection device according to this preferred embodiment;

Fig. 7 is a third block diagram of a distributed database detection device according to this preferred embodiment.

Detailed ways

Hereinafter, embodiments of the present disclosure will be described in detail with reference to the drawings and in combination with the embodiments.

It should be noted that the terms "first" and "second" in the specification and claims of the present disclosure and the above drawings are used to distinguish similar objects, but not necessarily used to describe a specific sequence or sequence.

The method embodiments provided in the embodiments of the present disclosure may be executed in mobile terminals, computer terminals or similar computing devices. Taking running on a mobile terminal as an example, FIG. 1 is a block diagram of a hardware structure of a mobile terminal according to a distributed database detection method according to an embodiment of the present disclosure. As shown in FIG. 1 , a mobile terminal may include one or more (only shown in FIG. 1 a) a processor 102 (the processor 102 may include but not limited to a processing device such as a microprocessor MCU or a programmable logic device FPGA) and a memory 104 for storing data, wherein the above-mentioned mobile terminal may also include a memory for communication Functional transmission device 106 and input and output device 108 . Those skilled in the art can understand that the structure shown in FIG. 1 is only for illustration, and it does not limit the structure of the above mobile terminal. For example, the mobile terminal may also include more or fewer components than those shown in FIG. 1 , or have a different configuration from that shown in FIG. 1 .

The memory 104 can be used to store computer programs, for example, software programs and modules of application software, such as the computer program corresponding to the distributed database detection method in the embodiment of the present disclosure, and the processor 102 runs the computer program stored in the memory 104, thereby Executing various functional applications and slicing processing of the service chain address pool is to realize the above-mentioned method. The memory 104 may include high-speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 104 may further include a memory that is remotely located relative to the processor 102, and these remote memories may be connected to the mobile terminal through a network. Examples of the aforementioned networks include, but are not limited to, the Internet, intranets, local area networks, mobile communication networks, and combinations thereof.

The transmission device 106 is used to receive or transmit data via a network. The specific example of the above network may include a wireless network provided by the communication provider of the mobile terminal. In one example, the transmission device 106 includes a network interface controller (NIC for short), which can be connected to other network devices through a base station so as to communicate with the Internet. In one example, the transmission device 106 may be a radio frequency (Radio Frequency, referred to as RF) module, which is used to communicate with the Internet in a wireless manner.

In this embodiment, a distributed database detection method running on the above-mentioned mobile terminal or network architecture is provided, which is applied to a terminal, and the terminal accesses the current master node of the source area through a dual connection (Dual Connection, referred to as DC) MN cell and current secondary node SN cell, Figure 2 is a flowchart of a distributed database detection method according to an embodiment of the present disclosure, as shown in Figure 2, the process includes the following steps:

Step S202, obtaining the complexity factor of SQL;

Step S204, constructing a table structure according to the complexity factor;

In this embodiment, the above step S204 may specifically include: obtaining the field, field type, field length, distribution strategy, and partition strategy from the parameter dictionary table; The strategy and the partition strategy are combined to obtain a combination result; the table structure of the distributed database and the table structure of the heterogeneous database are constructed according to the combination. Specifically, the table structure is created through a CREATE statement, the CREATE statement includes table fields, table partitions, table distribution keys, and table indexes, and the CREATE statement is one of the SQL statements. Create syntax rules are as follows:

CREATE TABLE[IF NOT EXISTS]tbl_name(create_definition,...)[partition_options][distributed_option], where [] means optional, create_definition means table definition, including fields, field types, indexes, etc., partition_options means partition strategy, distributed_option Indicates the distribution strategy.

Step S206, obtaining the basic elements of the SQL from the parameter dictionary according to the complexity factor, and generating an SQL statement according to the table structure and the basic elements;

Step S208, detecting the distributed database according to the table structure and the SQL statement.

In this embodiment, the above step S208 may specifically include: injecting the table structure of the distributed database and the SQL statement into the distributed database, and simultaneously injecting the table structure of the heterogeneous database and the heterogeneous database, and generate the first result file of the distributed database and the second result file of the heterogeneous database; compare the first result file with the second result file to obtain the comparison result; if the If the comparison result is that the first result file is the same as the second result file, it is determined that the distributed database is normal; if the comparison result is that the first result file is different from the second result file, it is determined that the Distributed database exceptions described above.

Through the above steps S202 to S208, obtain the complexity factor of SQL; construct a table structure according to the complexity factor; obtain the basic elements of the SQL from the parameter dictionary according to the complexity factor, and according to the table structure and the The above basic elements generate SQL statements; according to the table structure and the SQL statement, the distributed database is detected, which can solve the problem that the SQL statement of the related technology cannot be enumerated and traversed, and the artificially designed SQL syntax is relatively simple, which is easy to cause test The grammar is missing and cannot meet the complex application scenarios of the actual distributed database. The table structure is constructed according to the complexity factor, and the SQL statement is generated according to the table structure and basic elements, and the random creation of the table structure to the addition, deletion, modification and query of the corresponding data is realized, so that It can flexibly generate SQL statements and cope with complex application scenarios of distributed databases.

In this embodiment, the above step S206 may specifically include:

S2061. Acquire functions, grammar rules, grammar constraints and field ranges from the parameter dictionary, wherein the basic elements include the functions, the grammar rules, the grammar constraints and the field ranges;

S2062. Generate the SQL statement according to the complexity factor, the table structure, the function, the grammar rule, the grammar constraint and the field range.

In an embodiment, the above S2062 may specifically include:

If the SQL statement is a SELECT statement, generate the first SELECT statement according to the basic elements; generate the SELECT LIST of the SELECT statement according to the table structure and the complexity factor, specifically, if from the table structure The selected SELECT LIST contains nested subqueries, and the number of nesting levels is determined according to the complexity factor; SELECT nesting is performed according to the number of nesting levels until the nested subqueries are not included, and the SELECT LIST is obtained by combination , wherein, the SELECT LIST is a component of the expression SELECT_expr of the SELECT statement; the FROM of the SELECT statement is determined according to the first SELECT statement, specifically, the FROM is determined according to the SQL complexity factor Composition structure; if the tab_reference in the FROM is a physical table, obtain the table name of the physical table, and generate the FROM according to the table name of the physical table; if the tab_reference in the FROM is a table based on the query result, determine that the FROM involves In the case of a sub-query, the FROM composed of the first SELECT statement is generated, and the SELECT query result of executing the first SELECT statement is used as the tab_reference of the FROM; In the case of association, obtain the association table information, generate the second SELECT statement based on the association table, and generate the FROM formed by the second SELECT statement; determine the CONDITION of the SELECT statement according to the complexity factor; The grammatical rule of the SELECT statement generates the SELECT statement, the grammatical rule of the SELECT statement is SELECT SELECT_expr FROM tab_reference CONDITION; that is, the SQL statement is a SELECT statement, according to the complexity factor, the table structure, the Create the SELECT statement based on the function, the grammatical rule, the grammatical restriction and the field range, the grammatical rule of the SELECT statement is SELECT SELECT_expr FROM tab_reference CONDITION, and the SELECT SELECT_expr includes the function described CONDITION is the grammatical restriction, the SELECT SELECT_expr and the CONDITION include the function;

If the SQL statement is an INSERT statement, determine the composition of the VALUE contained in the INSERT statement according to the complexity factor, if the VALUES value_list is composed of specific values, determine the VALUES value_list according to the data type value range of the field in the table structure If the VALUES value_list is determined by the SELECT query result, generate the SELECT statement to form the VALUES value_list; determine the tbl_name according to the table structure; generate the INSERT statement according to the grammatical rules of the INSERT statement, wherein the grammatical rule of the INSERT statement is: INSERT INTO tbl_name VALUES value_list; that is, the SQL statement is an INSERT statement, the INSERT statement includes VALUE and SELECT, and the grammatical rule of the INSERT statement is: INSERT INTO tbl_name VALUES value_list, wherein, tbl_name is the table name, which is determined when the table structure is created). VALUES value_list is a specific value or is composed of a select query statement. The composition of value is determined according to the complexity factor. If the value is composed of specific values, the generation rule of the specific value is determined according to the value range of the data type of the field in the table structure. The value range of the data type is obtained from the parameter dictionary. Randomly generate a value that meets the requirements within the value range of the field data type; if the value is determined by the SELECT query result, call the SELECT generator to generate a select statement to form a value_list;

If the SQL statement is an UPDATE statement, determine the assignment_list of the UPDATE statement according to the table structure, wherein the VALUE corresponding to the assignment_list is composed of a specific value or a query result of a select statement; determine the FROM and CONDITION of the UPDATE statement, and according to the UPDATE statement The grammatical rules of the UPDATE statement generate the UPDATE statement, the grammatical rule of the UPDATE statement is: update tbl_name set assignment_list where condition; the grammatical rule of the UPDATE statement formed by the SET unit is: update tbl_name set assignment_list where condition, assignment_list represents the column name, the column name is determined according to the table structure, the VALUE corresponding to the assignment_list is composed of a specific value or the query result of the select statement, if it is obtained from the query result of the select statement, call step S5, call step S4 for the condition, and then form a complete UPDATE statement;

If the SQL statement is a DELETE statement, determine tbl_name according to the table structure, determine the FROM and CONDITION of the DELETE statement, the specific method of determination is similar to that of FROM and CONDITION in the SELECT statement, and will not be repeated here. According to the The grammatical rule of the DELETE statement generates the DELETE statement, wherein the grammatical rule of the DELETE statement is: DELETE FROM tbl_name where CONDITION;

If the SQL statement is a DELETE statement, determine tbl_name according to the table structure, determine the FROM and CONDITION of the DELETE statement, and generate the DELETE statement according to the grammatical rules of the DELETE statement, wherein the grammatical rules of the DELETE statement are: DELETE FROM tbl_name where CONDITION;

If the SQL statement is an ALTER statement, determine the tbl_name of the ALTER statement according to the table structure; determine the alter_option of the ALTER statement according to the complexity factor, generate the ALTER statement according to the grammatical rules of the ALTER statement, Wherein, the grammatical rule of the ALTER statement is ALTER TABLE tbl_name alter_option; the grammatical rule of the ALTER statement is ALTER TABLE tbl_name alter_option, wherein, tbl_name is the table name determined when creating the table structure, alter_option includes the attribute of modifying the table structure, alter_option Including the data type, partition, and index in the parameter dictionary, determining the number of columns to add or delete according to the complexity factor, whether to modify the name of the variable column, whether to add or delete indexes, and partitions, to generate the ALTER statement;

If the SQL statement is a DROP statement, obtain the table name from the table structure, replace the table name with tbl_name according to the grammatical rules of the DROP statement, and generate the DROP statement, wherein the grammatical rule of the DROP statement is drop table tbl_name.

In this embodiment, a parameter dictionary is created, which covers all field types, distribution strategies, partition strategies, all supported functions, grammar rules, grammar constraints, and field type value ranges. The method of automatically generating the table structure: Randomly combine the fields, field types, field lengths, distribution strategies, and partition strategies from the parameter dictionary table to construct the table structure according to the requirements of the distributed database table structure, and generate the table structure of the heterogeneous database at the same time; SELECT , INSERT, UPDATE, and DELETE statements are automatically generated as follows: get functions, grammar rules, grammar constraints, and field ranges from the parameter dictionary, generate SQL complexity factors from the complexity module, and generate SQL from the SQL generator. In the distributed database, the INSERT statement is automatically created according to the randomly generated table structure. The value of the INSERT is randomly obtained within the boundary value range, and an illegal value is added for each field type at the same time; the random generation method of the SELECT statement is to obtain any function from the parameter dictionary, The grammatical rules of the function, combined with the complexity factor of the randomly generated SELECT query statement, automatically generates the query SQL. The query SQL involves a SELECT LIST composed of simple fields, a SELECT LIST containing functions and expressions, and a SELECT LIST containing multiple table fields; UPDATE The statement includes updating all table fields and traversing field boundary values. This embodiment can generate as many different SQLs as possible, covering different SQL statements, avoiding the omission of test cases, and increasing the reliability of the distributed database.

In this embodiment, according to the complexity factor generated randomly by the SQL complexity control module, the complexity of the SQL is determined, the grammatical rules and grammatical rule constraints are obtained from the parameter dictionary, random field types and field range values are selected, and automatically generated by the SQL generator module Generate SQL. Inject the constructed table structure and SQL into the object under test and the heterogeneous database at the same time and generate a result file. The result comparer compares the two result comparison files to ensure the correctness of the result of the object under test.

The generation of SQL statements in this embodiment includes the generation of DDL and DML, and the generation of DDL includes the generation of CREATE, ALTER, and DROP statements of distributed database tables. The CREATE statement includes table fields, table partitions, and table distribution keys; the ALTER statement includes fields, indexes, partitions, table indexes, and column attributes; the DROP statement includes table names. The DML generation includes SELECT, UPDATE, INSERT, DELETE generation; SELECT generation includes SELECT LIST, FROM and CONDITION generation; the SELECT generation includes subqueries and functions, the FROM generation includes subqueries and associated tables, and the CONDITION generation contains subqueries;

If the SQL statement is a SELECT statement, Fig. 3 is a flow chart of the generation method of the SELECT statement according to the present embodiment, as shown in Fig. 3, comprising the following steps:

Step S301, obtain the SQL complexity factor, control the SQL complexity, the SQL generator obtains the SQL basic elements from the parameter dictionary according to the complexity factor, and generates a SELECT statement (corresponding to the first SELECT statement above, and the SELECT statement is composed of: SELECT SELECT_expr FROM tab_reference CONDITION);

Step S302, generate the SELECT LIST of the SELECT statement according to the table structure, the SELECT LIST is a component of the expression SELECT_expr, randomly generate field values and several functions according to the complexity factor combined with the grammatical rules obtained from the parameter dictionary, if the selected SELECT LIST contains For nested subquery, nested SELECT is generated. The number of nesting layers is determined by the complexity factor. After combination, the SELECT LIST structure is determined, including: column name, function, and subquery;

Step S303, determine the FROM of the SELECT statement, execute FROM generation, determine the FROM composition structure by the SQL complexity factor, the table tab_reference in the FROM includes a physical table or a table (virtual table) based on the query result, if it is a physical table, obtain the physical table The table name of the table and the table name of the physical table generate FROM; if FROM contains a table based on the query result, FROM involves a subquery, then call step S301 to generate a FROM composed of a SELECT statement, and use the SELECT query result of the executed SELECT statement as The tab_reference of FROM; if it is determined that FROM includes the association between tables, then obtain the association table information from the CREATE generation module, and call step S301, generate a SELECT statement based on the association table, and generate a FROM formed by the SELECT statement;

Step S304, determine the CONDITION of the SQL statement according to the complexity factor, wherein the SQL condition includes a logical expression, execute CONDITION generation, the SQL condition is determined by the complexity factor and step S301, the CONDITION includes a logical expression, and the condition in the expression Consists of a SELECT statement or a specific value, where the specific value is directly generated according to the field range in the parameter dictionary;

Step S305, generate all query statements according to the SELECT statement generated in step S302, the FROM determined in step S303, and the CONDITION generated in step S304, and all statement blocks are nested and spliced into a complete SQL query statement (corresponding to the second SELECT above statement) output.

According to another embodiment of the present disclosure, a distributed database detection device is provided. FIG. 4 is a block diagram of a distributed database detection device according to this embodiment. As shown in FIG. 4 , it includes:

Obtaining module 42, configured to obtain the complexity factor of SQL;

A construction module 44, configured to construct a table structure according to the complexity factor;

The generation module 46 is configured to obtain the basic elements of the SQL from the parameter dictionary according to the complexity factor, and generate an SQL statement according to the table structure and the basic elements;

The detection module 48 is configured to detect the distributed database according to the table structure and the SQL statement.

Fig. 5 is a block diagram one of a distributed database detection device according to this preferred embodiment. As shown in Fig. 5, the construction module 44 includes:

The first obtaining submodule 52 is configured to obtain fields, field types, field lengths, distribution strategies and partition strategies from the parameter dictionary table;

The combination submodule 54 is configured to combine the field, the field type, the field length, the distribution strategy and the partition strategy to obtain a combination result;

The construction sub-module 56 is configured to construct the table structure of the distributed database and the table structure of the heterogeneous database according to the combination.

Fig. 6 is a block diagram two of a distributed database detection device according to this preferred embodiment. As shown in Fig. 6, the detection module 48 includes:

The injection sub-module 62 is configured to inject the table structure of the distributed database and the SQL statement into the distributed database, and simultaneously inject the table structure of the heterogeneous database and the SQL statement into the heterogeneous database, and generate The first result file of the distributed database and the second result file of the heterogeneous database;

The comparison submodule 64 is configured to compare the first result file with the second result file to obtain a comparison result;

The first determination sub-module 66 is configured to determine that the distributed database is normal if the comparison result is that the first result file is the same as the second result file;

The second determination sub-module 68 is configured to determine that the distributed database is abnormal if the comparison result is that the first result file is different from the second result file.

Fig. 7 is a block diagram three of a distributed database detection device according to this preferred embodiment, as shown in Fig. 7, the generating module 46 includes:

The second acquiring submodule 72 is configured to acquire functions, grammar rules, grammar constraints, and field ranges from the parameter dictionary, wherein the basic elements include the functions, the grammar rules, the grammar constraints, and the field range;

The generating submodule 74 is configured to generate the SQL statement according to the complexity factor, the table structure, the function, the grammatical rule, the grammatical restriction and the field range.

In one embodiment, the generating submodule 74 is further configured to:

If the SQL statement is a SELECT statement, generate the first SELECT statement according to the basic elements; generate the SELECT LIST of the SELECT statement according to the table structure and the complexity factor, wherein the SELECT LIST is the SELECT A component of the expression SELECT_expr of the statement; determine the FROM of the SELECT statement according to the first SELECT statement, determine the CONDITION of the SELECT statement according to the complexity factor; generate the SELECT according to the grammatical rules of the SELECT statement statement, the grammatical rule of the SELECT statement is SELECT SELECT_expr FROM tab_reference CONDITION.

If the SQL statement is an INSERT statement, determine the composition of the VALUE contained in the INSERT statement according to the complexity factor, if the VALUES value_list is composed of specific values, determine the VALUES value_list according to the data type value range of the field in the table structure If the VALUES value_list is determined by the SELECT query result, generate the SELECT statement to form the VALUES value_list; determine the tbl_name according to the table structure; generate the INSERT statement according to the grammatical rules of the INSERT statement, wherein the grammatical rule of the INSERT statement is: INSERT INTO tbl_name VALUES value_list;

If the SQL statement is an UPDATE statement, determine the assignment_list of the UPDATE statement according to the table structure, wherein the VALUE corresponding to the assignment_list is composed of a specific value or a query result of a select statement; determine the FROM and CONDITION of the UPDATE statement, and according to the UPDATE statement The grammatical rules of the UPDATE statement are generated, and the grammatical rules of the UPDATE statement are: update tbl_name set assignment_list where condition;

If the SQL statement is an ALTER statement, determine the tbl_name of the ALTER statement according to the table structure; determine the alter_option of the ALTER statement according to the complexity factor, generate the ALTER statement according to the grammatical rules of the ALTER statement, Among them, the grammatical rule of the ALTER statement is ALTER TABLE tbl_name alter_option;

In one embodiment, the generating submodule 74 is further configured to:

If the SELECT LIST selected from the table structure includes nested subqueries, the number of nested layers is determined according to the complexity factor;

SELECT nesting is performed according to the number of nesting layers until the nested sub-queries are not included, and the SELECT LIST is obtained through combination.

In one embodiment, the generating submodule 74 is further configured to:

Determine the composition structure of the FROM according to the SQL complexity factor;

If the tab_reference in the FROM is a physical table, obtain the table name of the physical table, and generate the FROM according to the table name of the physical table;

If the tab_reference in the FROM is a table based on query results, when it is determined that the FROM involves a subquery, generate the FROM composed of the first SELECT statement, and use the SELECT query result of executing the first SELECT statement as The tab_reference of the FROM; when it is determined that the FROM includes a table-to-table association, obtain the association table information, generate a second SELECT statement based on the association table, and generate the FROM formed by the second SELECT statement .

Embodiments of the present disclosure also provide a computer-readable storage medium, in which a computer program is stored, wherein the computer program is configured to execute the steps in any one of the above method embodiments when running.

In an exemplary embodiment, the above-mentioned computer-readable storage medium may include but not limited to: U disk, read-only memory (Read-Only Memory, referred to as ROM), random access memory (Random Access Memory, referred to as RAM) , mobile hard disk, magnetic disk or optical disk and other media that can store computer programs.

Embodiments of the present disclosure also provide an electronic device, including a memory and a processor, where a computer program is stored in the memory, and the processor is configured to run the computer program to execute the steps in any one of the above method embodiments.

In an exemplary embodiment, the electronic device may further include a transmission device and an input and output device, wherein the transmission device is connected to the processor, and the input and output device is connected to the processor.

For specific examples in this embodiment, reference may be made to the examples described in the foregoing embodiments and exemplary implementation manners, and details will not be repeated here in this embodiment.

Obviously, those skilled in the art should understand that each module or each step of the above-mentioned disclosure can be realized by a general-purpose computing device, and they can be concentrated on a single computing device, or distributed in a network composed of multiple computing devices In fact, they can be implemented in program code executable by a computing device, and thus, they can be stored in a storage device to be executed by a computing device, and in some cases, can be executed in an order different from that shown here. Or described steps, or they are fabricated into individual integrated circuit modules, or multiple modules or steps among them are fabricated into a single integrated circuit module for implementation. As such, the present disclosure is not limited to any specific combination of hardware and software.

The above descriptions are only preferred embodiments of the present disclosure, and are not intended to limit the present disclosure. For those skilled in the art, the present disclosure may have various modifications and changes. Any modification, equivalent replacement, improvement, etc. made within the principle of the present disclosure shall be included in the protection scope of the present disclosure.

Claims

A distributed database detection method, comprising:

Obtain the complexity factor of the structured query statement SQL;

Constructing a table structure according to the complexity factor;

Obtain the basic elements of the SQL from the parameter dictionary according to the complexity factor, and generate an SQL statement according to the table structure and the basic elements;

The distributed database is detected according to the table structure and the SQL statement.
The method according to claim 1, wherein constructing a table structure according to the complexity factor comprises:

Obtain the field, field type, field length, distribution strategy and partition strategy from the parameter dictionary table;

Combining the field, the field type, the field length, the distribution strategy and the partition strategy to obtain a combination result;

The table structure of the distributed database and the table structure of the heterogeneous database are constructed according to the combination.
The method according to claim 2, wherein detecting the distributed database according to the table structure and the SQL statement comprises:

Inject the table structure of the distributed database and the SQL statement into the distributed database, and at the same time inject the table structure of the heterogeneous database and the SQL statement into the heterogeneous database, and generate the first a result file and a second result file of the heterogeneous database;

comparing the first result file with the second result file to obtain a comparison result;

If the comparison result is that the first result file is the same as the second result file, it is determined that the distributed database is normal;

If the comparison result is that the first result file is different from the second result file, it is determined that the distributed database is abnormal.
The method according to claim 1, wherein obtaining the basic elements of the SQL from the parameter dictionary according to the complexity factor, and generating the SQL statement according to the table structure and the basic elements comprises:

Acquiring functions, grammar rules, grammar constraints, and field ranges from the parameter dictionary, wherein the basic elements include the functions, the grammar rules, the grammar constraints, and the field ranges;

The SQL statement is generated according to the complexity factor, the table structure, the function, the grammatical rule, the grammatical restriction condition and the field range.
The method according to claim 4, wherein generating the SQL statement according to the complexity factor, the table structure, the function, the grammatical rule, the grammatical restriction and the field range comprises:

If the SQL statement is a SELECT statement, generate the first SELECT statement according to the basic elements; generate the SELECT LIST of the SELECT statement according to the table structure and the complexity factor, wherein the SELECT LIST is the SELECT A component of the expression SELECT_expr of the statement; determine the FROM of the SELECT statement according to the first SELECT statement, determine the CONDITION of the SELECT statement according to the complexity factor; generate the SELECT according to the grammatical rules of the SELECT statement statement, the grammatical rule of the SELECT statement is SELECT SELECT_expr FROM tab_reference CONDITION;

If the SQL statement is an INSERT statement, determine the composition of the VALUE contained in the INSERT statement according to the complexity factor, if the VALUES value_list is composed of specific values, determine the VALUES value_list according to the data type value range of the field in the table structure If the VALUES value_list is determined by the SELECT query result, generate the SELECT statement to form the VALUES value_list; determine the tbl_name according to the table structure; generate the INSERT statement according to the grammatical rules of the INSERT statement, wherein the grammatical rule of the INSERT statement is: INSERT INTO tbl_name VALUES value_list;

If the SQL statement is an UPDATE statement, determine the assignment_list of the UPDATE statement according to the table structure, wherein the VALUE corresponding to the assignment_list is composed of a specific value or a query result of a select statement; determine the FROM and CONDITION of the UPDATE statement, and according to the UPDATE statement The grammatical rules of the UPDATE statement are generated, and the grammatical rules of the UPDATE statement are: update tbl_name set assignment_list where condition;

If the SQL statement is a DELETE statement, determine tbl_name according to the table structure, determine the FROM and CONDITION of the DELETE statement, and generate the DELETE statement according to the grammatical rules of the DELETE statement, wherein the grammatical rules of the DELETE statement are: DELETE FROM tbl_name where CONDITION;

If the SQL statement is a DELETE statement, determine tbl_name according to the table structure, determine the FROM and CONDITION of the DELETE statement, and generate the DELETE statement according to the grammatical rules of the DELETE statement, wherein the grammatical rules of the DELETE statement are: DELETE FROM tbl_name where CONDITION;

If the SQL statement is an ALTER statement, determine the tbl_name of the ALTER statement according to the table structure; determine the alter_option of the ALTER statement according to the complexity factor, generate the ALTER statement according to the grammatical rules of the ALTER statement, Among them, the grammatical rule of the ALTER statement is ALTER TABLE tbl_name alter_option;

If the SQL statement is a DROP statement, obtain the table name from the table structure, replace the table name with tbl_name according to the grammatical rules of the DROP statement, and generate the DROP statement, wherein the grammatical rule of the DROP statement is drop table tbl_name.
The method according to claim 5, wherein, generating the SELECT LIST of the SELECT statement according to the table structure and the complexity factor comprises:

If the SELECT LIST selected from the table structure includes nested subqueries, the number of nested layers is determined according to the complexity factor;

SELECT nesting is performed according to the number of nesting layers until the nested sub-queries are not included, and the SELECT LIST is obtained through combination.
The method according to claim 5, wherein determining the FROM of the SELECT statement according to the first SELECT statement comprises:

Determine the composition structure of the FROM according to the SQL complexity factor;

If the tab_reference in the FROM is a physical table, obtain the table name of the physical table, and generate the FROM according to the table name of the physical table;

If the tab_reference in FROM is a table based on query results, in the case that it is determined that the FROM involves a subquery, generate the FROM composed of the first SELECT statement, and execute the first SELECT statement as the FROM tab_reference; if it is determined that the FROM includes an association between tables, obtain association table information, generate a second SELECT statement based on the association table, and generate the FROM formed by the second SELECT statement.
A distributed database detection device, comprising:

The acquisition module is set to acquire the complexity factor of structured query statement SQL;

A construction module, configured to construct a table structure according to the complexity factor;

Generate module, be arranged to obtain the basic element of described SQL from parameter dictionary according to described complexity factor, and generate SQL statement according to described table structure and described basic element;

The detection module is configured to detect the distributed database according to the table structure and the SQL statement.
A computer-readable storage medium, wherein a computer program is stored in the storage medium, wherein the computer program is configured to perform the method described in any one of claims 1 to 7 when running.
An electronic device, comprising a memory and a processor, wherein a computer program is stored in the memory, and the processor is configured to run the computer program to perform the method described in any one of claims 1 to 7.