CN115495528A

CN115495528A - Distributed database statement execution method, device, equipment and storage medium

Info

Publication number: CN115495528A
Application number: CN202211292579.4A
Authority: CN
Inventors: 吴宇松; 王海军; 张军
Original assignee: Jinzhuan Xinke Co Ltd
Current assignee: Jinzhuan Xinke Co Ltd
Priority date: 2022-10-21
Filing date: 2022-10-21
Publication date: 2022-12-20

Abstract

The invention discloses a statement execution method, a statement execution device, statement execution equipment and a storage medium for a distributed database, and relates to the field of databases. The method comprises the following steps: responding to the received SQL statement to be executed, and judging whether the SQL statement contains the primary key information; sending a global variable acquisition request to a sequence server under the condition that the SQL statement does not contain the primary key information, and updating the SQL statement according to the global variable fed back by the sequence server; and generating a target SQL statement corresponding to the database based on the updated SQL statement and issuing the target SQL statement to the database. The technical scheme of the embodiment of the invention can ensure that the distributed database supports data storage under the default condition of the main key.

Description

Distributed database statement execution method, device, equipment and storage medium

Technical Field

The present invention relates to the field of databases, and in particular, to a method, an apparatus, a device, and a storage medium for executing a distributed database statement.

Background

Primary key (primary key) is called primary key for short, and is one or more fields in a database table, and is used for uniquely identifying a record in the table, and the database can execute corresponding data adding, deleting, modifying and querying operations on the database table according to the primary key.

In many cases, the database will also operate on some tables of default primary keys. In a standalone database scenario, taking creating a database table as an example, the prior art often creates a table with a default primary key in the following two ways: 1) Judging whether a non-empty unique index exists in the database table, if so, taking the first non-empty unique index as a main key; if not, the stand-alone database generates an invisible field as a primary key, the field can be a self-increment field, and the field value is self-increment along with the insertion of each piece of data.

When the distributed databases need to operate the table of the default primary key, when the same data is pressed to a plurality of databases, if the table is still created or data is inserted in a manner that each database individually generates a field as the primary key, the primary keys generated by the databases for the same data may conflict, which affects the normal storage of the data.

Disclosure of Invention

The invention provides a distributed database statement execution method, a device, equipment and a storage medium, which aim to solve the problem that a distributed database does not support data storage under the condition that a main key is default.

According to an aspect of the present invention, there is provided a distributed database statement execution method, including:

responding to the received SQL statement to be executed, and judging whether the SQL statement contains the primary key information;

sending a global variable acquisition request to a sequence server under the condition that the SQL statement does not contain the primary key information, and updating the SQL statement according to the global variable fed back by the sequence server;

and generating a target SQL statement corresponding to the distributed database based on the updated SQL statement and issuing the target SQL statement to the distributed database.

According to another aspect of the present invention, there is provided a distributed database statement executing apparatus, including:

the main key judging module is used for responding to the received SQL statement to be executed and judging whether the SQL statement contains main key information;

the statement updating module is used for sending a global variable acquisition request to the sequence server under the condition that the SQL statement does not contain the primary key information, and updating the SQL statement according to the global variable fed back by the sequence server;

and the statement issuing module is used for generating a target SQL statement corresponding to the distributed database based on the updated SQL statement and issuing the target SQL statement to the distributed database.

According to another aspect of the present invention, there is provided an electronic apparatus including:

at least one processor; and

a memory communicatively coupled to the at least one processor; wherein, the first and the second end of the pipe are connected with each other,

the memory stores a computer program executable by the at least one processor, the computer program being executable by the at least one processor to enable the at least one processor to perform the distributed database statement execution method according to any of the embodiments of the present invention.

According to another aspect of the present invention, there is provided a computer-readable storage medium storing computer instructions for causing a processor to implement the distributed database statement execution method according to any one of the embodiments of the present invention when the computer instructions are executed.

According to the technical scheme of the embodiment of the invention, whether the SQL statement contains the primary key information or not is judged in response to the received SQL statement to be executed, a global variable acquisition request is sent to the sequence server under the condition that the SQL statement does not contain the primary key information, the SQL statement is updated according to the global variable fed back by the sequence server, and finally, a target SQL statement corresponding to the distributed database is generated and issued to the distributed database based on the updated SQL statement, so that the problem that the distributed database does not support data storage under the condition that the primary key is in default is solved, the execution flexibility of the distributed database statement is improved, the application range of the distributed database is expanded, and more service scenes are met.

It should be understood that the statements in this section do not necessarily identify key or critical features of the embodiments of the present invention, nor do they necessarily limit the scope of the invention. Other features of the present invention will become apparent from the following description.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings required to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the description below are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without creative efforts.

FIG. 1 is a flow chart of a distributed database statement execution method according to an embodiment of the present invention;

FIG. 2 is a flow chart of a distributed database statement execution method according to an embodiment of the present invention;

FIG. 3 is a flow chart of a distributed database statement execution method according to an embodiment of the present invention;

FIG. 4 is a timing diagram of an execution table creation statement provided in accordance with an embodiment of the present invention;

FIG. 5 is a timing diagram of a execute data insert statement provided in accordance with an embodiment of the present invention;

FIG. 6 is a schematic structural diagram of a distributed database statement executing apparatus according to an embodiment of the present invention;

fig. 7 is a schematic structural diagram of an electronic device implementing the distributed database statement execution method according to the embodiment of the present invention.

Detailed Description

In order to make those skilled in the art better understand the technical solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be obtained by a person skilled in the art without making any creative effort based on the embodiments in the present invention, shall fall within the protection scope of the present invention.

It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

Fig. 1 is a flowchart of a distributed database statement execution method according to an embodiment of the present invention, where the embodiment is applicable to a case where a distributed database executes an SQL statement without a primary key, the method may be executed by a distributed database statement execution apparatus, the distributed database statement execution apparatus may be implemented in hardware and/or software, and the distributed database statement execution apparatus may be configured in various general-purpose computing devices, for example, a distributed computing engine may be configured through a computing device. As shown in fig. 1, the method includes:

s110, responding to the received SQL statement to be executed, and judging whether the SQL statement contains the main key information.

A Structured Query Language (SQL) statement to be executed is a statement sent by a user end to instruct a distributed database to execute a corresponding operation, and the SQL statement to be executed may be a table creation statement, a data insertion statement, or a data Query statement. The primary key information refers to information associated with a primary key of a table, and may be, for example, a primary key field or a primary key value.

In the embodiment of the invention, when receiving the SQL sentence to be executed sent by the user side, the distributed computing engine firstly judges whether the SQL sentence contains the main key information. Specifically, after receiving the SQL statement, the distributed computing engine determines the type of the SQL statement by extracting a keyword in the SQL statement, for example, if a "CREAT" keyword is extracted from the SQL statement, it is determined that the current SQL statement is a table creation statement, and if an "INSERT" keyword is extracted from the SQL statement, it is determined that the current SQL statement is a data insertion statement. Further, it is determined whether the SQL statement includes primary key information, for example, whether a table to be created in the table creation statement includes a primary key field, or whether data to be inserted in the data insertion statement includes a primary key value.

In a specific example, the SQL statement sent by the client is "create TABLE front (id INT PRIMARY KEY, name VARCHAR (30), price VARCHAR (10))", it can be determined that the SQL statement is a TABLE creation statement by acquiring a keyword "create TABLE" in the SQL statement, and the user creates a data TABLE with a TABLE name "front", where the data TABLE includes 3 columns of data, the first column is id and the type is integer data (INT), the second column of data is name and the type is 30 bytes of character data, and the third column of data is price and the type is 10 bytes of character data. In addition, it can be determined that id is designated in the SQL statement as the PRIMARY KEY field of the table to be created through the KEY word "PRIMARY KEY" in the SQL statement, and when the KEY word "PRIMARY KEY" does not exist, it can be determined that the PRIMARY KEY field of the table to be created is not designated in the current SQL statement.

In another specific example, the SQL statement sent by the ue is "INSERT intra fruit (id, name, price) VALUES (0, applet, 5)", and it may be determined that the SQL statement is a data insertion statement by obtaining a keyword "INSERT" in the SQL statement, where the user INSERTs a piece of data in the table fruit, the id is 0, the name is applet, and the price is 5. In addition, it has been specified in the table fruit that the field of the primary key is id, and when the id value is included in the current data insertion statement, that is, the primary key information is included in the SQL statement.

And S120, sending a global variable acquisition request to the sequence server under the condition that the SQL statement does not contain the primary key information, and updating the SQL statement according to the global variable fed back by the sequence server.

The sequence server can generate the global variable in a self-increment manner, the server deploying the distributed database can be used as the sequence server to generate the global variable, and certainly, a special server can also be used as the sequence server to generate the global variable. Communication connection needs to be established between the distributed computation engine and the sequence server, and under the condition that the current SQL statement does not contain the primary key information, the distributed computation engine can request the sequence server for the global variable, so that the missing primary key information in the SQL statement is supplemented according to the global variable fed back by the sequence server.

In order to prevent single point failure and improve the reliability of generating global variables, a plurality of sequence servers can be arranged, and each sequence server maintains a different global variable table. When the global variable is requested, the first sequence server side fails and cannot provide the global variable, and the second sequence server side can continuously request the global variable. Illustratively, 3 sequence servers are currently provided, and the global variable table maintained by the first sequence server is from 1, and is incremented by 3 each time, i.e. the global variable maintained by the first sequence server is 1,4,7, 10, \8230. The global variable maintained by the second sequence server is increased by 3 each time starting from 2, namely the global variable maintained by the second sequence server is 2,5,8, 11, \ 8230. The global variable maintained by the third sequence server is increased by 3 each time starting from 3, namely the global variable maintained by the third sequence server is 3,6,9, 12, \8230. By the method, the reliability of the sequence server side can be guaranteed, and meanwhile the uniqueness of the global variable can be guaranteed.

In the embodiment of the invention, under the condition that the SQL statement does not contain the primary key information, the global variable request can be sent to the sequence server, and the SQL statement is updated after the global variable fed back by the sequence server is received. Specifically, when the table to be created in the table creation statement is judged not to contain the primary key field, a global variable request is sent to the sequence server, and a global variable fed back by the sequence server is received. And further generating a main key field according to the global variable, and adding the main key field into the SQL statement to obtain an updated SQL statement.

Similarly, when the data to be inserted in the data insertion statement is judged not to contain the primary key value, a global variable request is sent to the sequence server, and a global variable fed back by the sequence server is received. And then directly adding the global variable as a primary key value into the SQL statement to obtain an updated SQL statement.

In one specific example, the SQL statement to be executed is the TABLE creation statement "CREAT TABLE fruit (name VARCHAR (30), price VARCHAR (10))", which does not contain a primary key field. At this time, a global variable acquisition request may be sent to the sequence server, and the global variable that is acquired to be fed back by the sequence server is 100. Further, a primary key field named "id _100" can be constructed according to the global variable. Finally, the generated PRIMARY KEY field can be added to the SQL statement to obtain the updated SQL statement "create TABLE front (name VARCHAR (30), price VARCHAR (10), id — 100INT PRIMARY KEY)".

In another specific example, the SQL statement to be executed is a data insertion statement "INSERT INTO front (name, price) VALUES (applet, 5)", which does not contain the primary key corresponding to the primary key field. At this time, a global variable acquisition request may be sent to the sequence server, and the global variable that is acquired to be fed back by the sequence server is 101. And then, a primary key value matched with the data to be inserted may be generated according to the global variable, for example, the global variable 101 may be directly used as the primary key value of the data. Finally, the generated primary key value may be added to the SQL statement, and the updated SQL statement is "INSERT intofront free (name, price, id _ 100) VALUES (applet, 5, 101)".

In addition, under the condition that the SQL statement does not include the primary key information, it may be determined whether the data table associated with the SQL statement includes the non-empty unique index field, and if so, the non-empty unique index field may be directly used as the primary key of the current data table.

And S130, generating a target SQL statement corresponding to the distributed database based on the updated SQL statement and issuing the target SQL statement to the distributed database.

A distributed database is understood to be a database consisting of a plurality of individual databases which are interconnected to one another by a network. In some cases, when a user performs a data insertion operation, the same SQL statement needs to be pushed down to multiple stand-alone databases. When the statement does not contain the primary key information, each single-machine database can respectively generate a primary key value for storage, and the situation that the primary key values of the same data in different single-machine databases are different can occur, so that the global uniqueness of the primary key values cannot be ensured.

Illustratively, when a user inserts data and needs to perform multi-node backup on the inserted data, a data insertion statement is issued, and the data insertion statement is executed by a plurality of stand-alone databases, that is, the data is simultaneously inserted into the plurality of stand-alone databases. When the data insertion statement does not contain the primary key value, a primary key value of 100 is generated for the data to be inserted in the first single-machine database, and a primary key value of 70 is generated for the data to be inserted in the second single-machine database. Obviously, different primary key values are generated by different single-machine databases aiming at the same data, so that the global uniqueness of the primary key values cannot be ensured, and the normal storage of the data is influenced.

In the embodiment of the invention, the main key information is added in the SQL sentence sent by the user to obtain the updated SQL sentence, and then the target SQL sentence corresponding to the distributed database is generated and issued to the distributed database based on the updated SQL sentence. Specifically, a single-machine database associated with the SQL statement sent by the user side is determined, and then after the updated SQL statement is obtained, the updated SQL statement is sent to the corresponding single-machine database, so that the single-machine database completes table creation or data insertion operation by running the SQL statement. Under the condition that SQL sentences sent by users need to be pressed down to a plurality of stand-alone databases, the SQL sentences to be executed are updated first, the main key information is added, the SQL sentences added with the main key information are then issued to the stand-alone databases, the main key information does not need to be generated independently by the stand-alone databases, the main key information in the stand-alone databases contained in the distributed databases is consistent, and the global consistency of the main keys is ensured.

In a specific example, a database associated with an SQL statement to be executed sent by a user is determined, and a syntax execution tree is generated based on the updated SQL statement and the associated database. Further, according to the grammar execution number, the updated SQL statement is split into a target SQL statement aiming at least one database contained in the distributed database. And finally, sending the target SQL statement to a corresponding database.

Fig. 2 is a flowchart of a distributed database statement execution method according to an embodiment of the present invention, which is further detailed based on the above embodiment, and provides a specific step of determining whether an SQL statement includes primary key information in response to receiving an SQL statement to be executed, and a specific step of sending a global variable acquisition request to a sequence server and updating the SQL statement according to a global variable fed back by the sequence server when the SQL statement does not include the primary key information. As shown in fig. 2, the method includes:

s210, in response to receiving the table creation statement to be executed, judging whether the table to be created in the table creation statement contains a primary key field.

The primary key field is used to uniquely identify a record in the database table, and may be made up of one or more fields contained in the database table. Illustratively, in the student achievement table, 3 fields of school number, name and achievement are included, wherein the school number is a field used for uniquely identifying a student and can be used as a primary key field of the data table.

In the embodiment of the invention, after receiving a table creation statement to be executed sent by a user side, a distributed computing engine judges whether the table to be created in the table creation statement contains a primary key field. Specifically, after receiving a table creation statement to be executed, the distributed computing engine first extracts a keyword in the table creation statement, and then determines whether the table creation statement includes a primary key field according to the keyword.

In a specific example, the TABLE creation statement sent by the client is "create TABLE front (id INT PRIMARY KEY, name variable (30), price variable (10))", and by extracting the keyword "PRIMARY KEY" in the TABLE creation statement, it can be determined that the TABLE creation statement has specified the PRIMARY KEY field of the TABLE to be created, that is, the TABLE creation statement contains the PRIMARY KEY information. Otherwise, if the keyword "PRIMARY KEY" is not extracted in the table creation statement, it may be determined that the table creation statement does not include the PRIMARY KEY field.

S220, under the condition that the table to be created does not contain the primary key field, sending a global variable acquisition request to the sequence server, and generating the primary key field of the table to be created according to the global variable fed back by the sequence server.

In the embodiment of the invention, under the condition that the table to be created does not contain the primary key field, a global variable acquisition request is sent to the sequence server, and the primary key field of the table to be created is generated according to the global variable fed back by the sequence server. Specifically, when the table creation statement does not specify the primary key field of the table to be created, a global variable acquisition request may be sent to the sequence server. And the sequence server determines a unique global variable according to a preset self-increment rule and feeds the unique global variable back to the distributed computing engine. And after receiving the global variable, the distributed computing engine constructs a primary key field for the table to be created according to the global variable. For example, the global variable is directly used as a primary key field of the table to be created, or a primary key field is constructed for the table to be created according to a preset naming rule, and the primary key field may include the global variable.

In a specific example, the TABLE creation statement sent by the client is "create TABLE front (name VARCHAR (30), print VARCHAR (10))", and by extracting the key in the TABLE creation statement, it can be determined that the TABLE creation statement does not specify the primary key field of the TABLE to be created, that is, the TABLE creation statement does not contain primary key information. At this time, a global variable acquisition request may be sent to the sequence server, and the global variable that is fed back by the sequence server is acquired as "100". Further, a primary key field, for example, named "id _100", may be constructed for the table to be created according to the global variable.

And S230, adding the primary key field to the table creation statement to serve as the updated SQL statement.

In the embodiment of the invention, after the primary key field is constructed, the primary key field is added into the table creation statement to obtain the updated SQL statement. In a specific example, the generated PRIMARY KEY field may be finally added to the TABLE creation statement, so that the updated TABLE creation statement is "create TABLE free (name variable (30), price variable (10), id _100INT PRIMARY KEY)".

And S240, generating a grammar execution tree based on the updated SQL statement.

In the embodiment of the invention, after the main key field is added to the table creation statement to obtain the updated SQL statement, the lexical syntax analysis is further carried out on the updated SQL statement, so that the syntax execution tree is generated. The atomic nodes of the syntax execution tree may include SQL statement keywords, names of relationships or attributes, constants, brackets, operators, and other components of the SQL statement.

And S250, according to the syntax execution tree, splitting the updated SQL statement into a target SQL statement aiming at least one database contained in the distributed database, and sending the target SQL statement to the corresponding database.

In the embodiment of the invention, after the syntax execution tree is generated, the updated SQL statement is further split into the target SQL statement aiming at least one database contained in the distributed database according to the syntax execution tree, and the target SQL statement is sent to the corresponding database. Illustratively, a table creation statement sent by a user side is associated with 3 databases in the distributed databases, so that the updated SQL statement may be split into target SQL statements for the databases according to the syntax execution tree, and the target SQL statements are sent to the databases, so that the databases can perform the table creation operation, and the used primary key values are uniform.

Optionally, the technical solution of this embodiment further includes:

responding to the received data query statement to be executed, and sending the data query statement to a corresponding database;

and acquiring a query result fed back by the database, and filtering the primary key values in the query result.

In this optional embodiment, under the condition that the main key information is not included, after the data table is created and the data is inserted, if the distributed computing engine receives a data query statement to be executed, the data query statement is sent to the corresponding database. Further, a query result fed back by the database is obtained, the query result includes a primary key value generated when data is inserted, but the primary key value has no practical significance for a user, so that the primary key value in the query result needs to be filtered, the query result after the primary key value is filtered is fed back to the user side, and the user side is prevented from obtaining data without practical significance.

Optionally, if the distributed computing engine receives an update (update) statement and a delete (delete) statement to be executed, the filtering of the primary key value is still performed.

Optionally, when data is imported and exported, the hidden primary key value and other data need to be imported and exported simultaneously.

According to the technical scheme of the embodiment of the invention, after the table creation statement to be executed is received, if the table to be created in the table creation statement does not contain the primary key field, a global variable is requested from the sequence server, the primary key field of the table to be created is generated according to the global variable and added into the table creation statement, and finally the corresponding SQL statement is sent to at least one database contained in the distributed database based on the updated table creation statement, so that the global consistency of the primary key field in each database contained in the distributed database can be ensured.

Fig. 3 is a flowchart of a distributed database statement execution method according to an embodiment of the present invention, which is further detailed on the basis of the foregoing embodiment, and provides specific steps of determining whether an SQL statement includes primary key information in response to receiving an SQL statement to be executed, and sending a global variable acquisition request to a sequence server when the SQL statement does not include the primary key information, and updating the SQL statement according to a global variable fed back by the sequence server. As shown in fig. 3, the method includes:

s310, responding to the received data insertion statement to be executed, and judging whether the data to be inserted in the data insertion statement contains the primary key value.

In the embodiment of the invention, after receiving the data insertion statement to be executed sent by the user side, the distributed computing engine judges whether the data to be inserted in the data insertion statement contains the primary key field. Specifically, after receiving a data insertion statement to be executed, the distributed computing engine first extracts a keyword in the data insertion statement, and then judges whether the data insertion statement contains a primary key value according to the keyword. Wherein the primary key is a field value uniquely identifying a row of data.

In a specific example, the primary key field of the data table fruit is "id _100", and the data insertion statement "INSERT _ info fruit (name, price) value (applet, 5)" sent by the ue does not include the primary key corresponding to the primary key field "id _100".

S320, under the condition that the data to be inserted does not contain the primary key value, judging whether the data insertion statement contains the table to be inquired.

In the embodiment of the present invention, when the data to be inserted does not include the primary key value, it is further necessary to determine whether the current data insertion statement includes the table to be queried, that is, to query the data from the table to be queried, and insert the queried data into the data table specified by the current statement to be inserted. In the case of including the table to be looked up, whether the table to be looked up includes the primary key needs to be further considered to determine the manner by which the primary key value of the data to be inserted is determined.

In a specific example, the received data insertion statement is "INSERT intra front (name, price) SELECT (name, price) FROM table2", that is, the data values of the two fields, name and price, need to be queried FROM the packet table2, and then the queried data values are inserted INTO the data table front. At this time, the data insertion statement obviously does not include the primary key value, and it is necessary to further determine whether the table to be looked up is included. Obviously, the data insertion statement at this time includes table2 to be looked up.

S330, under the condition that the data to be inserted does not contain the primary key value and the data insertion statement does not contain the table to be queried, sending a global variable acquisition request to the sequence server, and generating the primary key value of the data to be inserted according to the global variable fed back by the sequence server.

In the embodiment of the invention, under the condition that the data to be inserted does not contain the primary key value and the data insertion statement does not contain the table to be queried, a global variable acquisition request can be sent to the sequence server, and the primary key value of the data to be inserted is generated according to the global variable fed back by the sequence server.

In a specific example, the primary key field of the data table fruit is "id _100", and the ue sends the data insertion statement "INSERT intra fruit (name, price) value (applet, 5)", which does not include the primary key corresponding to the primary key field "id _100" and does not include the table to be queried. At this time, a global variable acquisition request may be sent to the sequence server, and the global variable that is acquired to be fed back by the sequence server is 101. And further, a primary key value matched with the data to be inserted may be generated according to the global variable, for example, the global variable 101 may be directly used as the primary key value of the piece of data.

And S340, adding the primary key value to the data insertion statement to serve as the updated SQL statement.

In the embodiment of the invention, after the primary key value is generated according to the global variable fed back by the sequence server, the primary key value is added into the data insertion statement to obtain the updated SQL statement. Illustratively, the received data INSERT statement "INSERT INTO real (name, price) VALUES (applet, 5)", and the global variable fed back by the sequence server is 101. Finally, 101 may be added to the SQL statement as a primary key, and the updated SQL statement is "INSERT intofront free (name, price, id — 100) VALUES (applet, 5, 101)".

Optionally, under the condition that the data to be inserted does not contain the primary key value and the data insertion statement contains the table to be queried, judging whether the table to be queried contains the primary key value;

under the condition that the primary key value is not contained in the table to be queried, sending a global variable acquisition request to the sequence server, and generating the primary key value of the data to be inserted according to the global variable fed back by the sequence server;

a primary key value is added to the data insertion statement.

In this optional embodiment, under the condition that the data to be inserted does not include the primary key value and the data insertion statement includes the table to be queried, it is further determined whether the table to be queried includes the primary key value. And under the condition that the table to be queried does not contain the primary key value, sending a global variable acquisition request to the sequence server, generating the primary key value of the data to be inserted according to the global variable fed back by the sequence server, and adding the primary key value to the data insertion statement. The specific SQL statement updating method is the same as the above case that the table to be queried is not included, and is not described herein again.

Optionally, the primary key value in the table to be queried is added to the data insertion statement under the condition that the data to be inserted does not contain the primary key value and the table to be queried in the data insertion statement contains the primary key value.

In this optional embodiment, when the data to be inserted does not include the primary key value and the table to be queried in the data insertion statement includes the primary key value, the primary key value in the table to be queried may be directly added to the data insertion statement, and used as the primary key value of the currently inserted data in the new data table.

And S350, generating a target SQL statement corresponding to the distributed database based on the updated SQL statement and issuing the target SQL statement to the distributed database.

According to the technical scheme of the embodiment of the invention, after the data insertion statement to be executed is received, if the data to be inserted in the data insertion statement does not contain the primary key value, a global variable is requested from the sequence server, the primary key value of the data to be inserted is generated according to the global variable and added into the data insertion statement, and finally the corresponding SQL statement is sent to at least one database contained in the distributed database based on the updated data insertion statement, so that the global consistency of the primary key value in each database contained in the distributed database can be ensured.

Fig. 4 is a sequence diagram of an execution table creation statement. As shown in fig. 4, the table creation statement execution process includes:

s410, the user side sends a table creating statement to the distributed computing engine.

S420, the distributed computing engine judges whether the table creation statement contains the primary key field, if so, S460 is executed, and if not, S430 is executed.

S430, the distributed computing engine requests the global auto-increment variable from the sequence server.

And S440, the sequence server side feeds back the global variable to the distributed computing engine.

S450, the distributed computing engine adds the received global variable serving as a primary key field to the table creation statement to obtain an updated table creation statement.

And S460, the distributed computing engine generates a grammar execution tree according to the table creation statement.

S470, the distributed computing engine sends the corresponding SQL statement to at least one database associated with the distributed database according to the syntax execution tree.

And S480, the database feeds back the execution result of the SQL statement to the distributed computing engine.

S490, the distributed computing engine feeds back the execution result to the user side.

According to the technical scheme, after the table creation statement to be executed is received, if the table to be created in the table creation statement does not contain the primary key field, a global variable is requested from a sequence server, the primary key field of the table to be created is generated according to the global variable and added to the table creation statement, finally, the corresponding SQL statement is sent to at least one database contained in the distributed database based on the updated table creation statement, and the global consistency of the primary key field in each database contained in the distributed database can be guaranteed.

Fig. 5 is a timing chart of the execution data insertion statement. As shown in fig. 5, the data insertion statement execution process includes:

s510, the user side sends a data insertion statement to the distributed computing engine.

S520, the distributed computing engine judges whether the data insertion statement contains the primary key value, if so, S590 is executed, and if not, S530 is executed.

S530, the distributed computing engine judges whether the data insertion statement contains a table to be queried, if so, S540 is executed, and if not, S550 is executed.

And S540, the distributed computing engine judges whether the table to be queried contains the primary key value, if not, S550 is executed, and if so, S580 is executed.

S550, the distributed computing engine requests the global auto-increment variable from the sequence server.

And S560, the sequence server side feeds back the global variable to the distributed computing engine.

And S570, the distributed computing engine adds the received global variable serving as a primary key value to the data insertion statement to obtain an updated data insertion statement.

S580, the distributed computing engine adds the primary key values in the table to be queried to the data insertion statement to obtain the updated data insertion statement.

And S590, generating a grammar execution tree by the distributed computing engine according to the data insertion statement.

And S591, the distributed computing engine issues the corresponding SQL statements to at least one database associated with the distributed databases according to the syntax execution tree.

S592, the database feeds back the execution result of the SQL statement to the distributed computing engine.

S593, the distributed computing engine feeds back the execution result to the user side.

Fig. 6 is a schematic structural diagram of a distributed database statement execution apparatus according to an embodiment of the present invention. As shown in fig. 6, the apparatus includes:

the primary key determining module 610 is configured to determine, in response to receiving an SQL statement to be executed, whether the SQL statement includes primary key information;

a statement updating module 620, configured to send a global variable acquisition request to the sequence server when the SQL statement does not contain the primary key information, and update the SQL statement according to the global variable fed back by the sequence server;

and the statement issuing module 630 is configured to generate a target SQL statement corresponding to the distributed database based on the updated SQL statement and issue the target SQL statement to the distributed database.

Optionally, the primary key determining module 610 is specifically configured to:

in response to receiving a table creation statement to be executed, judging whether a table to be created in the table creation statement contains a primary key field;

the statement updating module 620 is specifically configured to:

under the condition that the table to be created does not contain the primary key field, sending a global variable acquisition request to a sequence server, and generating the primary key field of the table to be created according to the global variable fed back by the sequence server;

adding the primary key field to the table creation statement.

Optionally, the primary key determining module 610 is further configured to:

in response to receiving a data insertion statement to be executed, judging whether the data to be inserted in the data insertion statement contains a primary key value;

statement updating module 620, further configured to:

under the condition that the data to be inserted does not contain the primary key value, judging whether the data insertion statement contains a table to be queried or not;

sending a global variable acquisition request to a sequence server under the condition that the data to be inserted does not contain a primary key value and the data insertion statement does not contain a table to be queried, and generating the primary key value of the data to be inserted according to a global variable fed back by the sequence server;

adding the primary key value to the data insertion statement.

Optionally, the statement updating module 620 is further configured to:

under the condition that the data to be inserted does not contain the primary key value and the data insertion statement contains a table to be queried, judging whether the table to be queried contains the primary key value;

sending a global variable acquisition request to a sequence server under the condition that the primary key value is not contained in the to-be-inquired table, and generating the primary key value of the to-be-inserted data according to the global variable fed back by the sequence server;

adding the primary key value to the data insertion statement.

Optionally, the distributed database statement executing apparatus further includes:

and the primary key insertion module is used for adding the primary key value in the table to be queried to the data insertion statement under the condition that the data to be inserted does not contain the primary key value and the table to be queried in the data insertion statement contains the primary key value.

the statement sending module is used for responding to the received data query statement to be executed and sending the data query statement to a corresponding database;

and the primary key value filtering module is used for acquiring a query result fed back by the database and filtering the primary key values in the query result.

Optionally, the statement issuing module 630 is specifically configured to:

generating a syntax execution tree based on the updated SQL statement;

and splitting the updated SQL statement into a target SQL statement aiming at least one database contained in the distributed database according to the syntax execution tree, and sending the target SQL statement to the corresponding database.

The distributed database statement execution device provided by the embodiment of the invention can execute the distributed database statement execution method provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method.

FIG. 7 illustrates a schematic diagram of an electronic device 10 that may be used to implement an embodiment of the invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital assistants, cellular phones, smart phones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.

As shown in fig. 7, the electronic device 10 includes at least one processor 11, and a memory communicatively connected to the at least one processor 11, such as a Read Only Memory (ROM) 12, a Random Access Memory (RAM) 13, and the like, wherein the memory stores a computer program executable by the at least one processor, and the processor 11 can perform various suitable actions and processes according to the computer program stored in the Read Only Memory (ROM) 12 or the computer program loaded from a storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data necessary for the operation of the electronic apparatus 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to bus 14.

A number of components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, or the like; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.

Processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, a Digital Signal Processor (DSP), and any suitable processor, controller, microcontroller, or the like. The processor 11 performs the various methods and processes described above, such as the distributed database statement execution method.

In some embodiments, the distributed database statement execution method may be implemented as a computer program tangibly embodied on a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. When the computer program is loaded into RAM 13 and executed by processor 11, one or more steps of the distributed database statement execution method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to perform the distributed database statement execution method by any other suitable means (e.g., by means of firmware).

Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuitry, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), system on a chip (SOCs), complex Programmable Logic Devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.

A computer program for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be performed. A computer program can execute entirely on a machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.

In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. A computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user may provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form, including acoustic, speech, or tactile input.

The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.

The computing system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical host and VPS service are overcome.

It should be understood that various forms of the flows shown above may be used, with steps reordered, added, or deleted. For example, the steps described in the present invention may be executed in parallel, sequentially, or in different orders, and are not limited herein as long as the desired results of the technical solution of the present invention can be achieved.

The above-described embodiments should not be construed as limiting the scope of the invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made in accordance with design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A distributed database statement execution method, comprising:

responding to a received Structured Query Language (SQL) statement to be executed, and judging whether the SQL statement contains primary key information;

2. The method of claim 1, wherein determining whether the SQL statement contains primary key information in response to receiving the SQL statement to be executed comprises:

under the condition that the SQL statement does not contain the primary key information, sending a global variable acquisition request to a sequence server, and updating the SQL statement according to the global variable fed back by the sequence server, wherein the method comprises the following steps:

adding the primary key field to the table creation statement.

3. The method of claim 1, wherein determining whether the SQL statement contains primary key information in response to receiving the SQL statement to be executed comprises:

adding the primary key value to the data insertion statement.

4. The method according to claim 3, wherein when the SQL statement does not contain the primary key information, sending a global variable acquisition request to a sequence server, and updating the SQL statement according to a global variable fed back by the sequence server, further comprising:

adding the primary key value to the data insertion statement.

5. The method of claim 4, further comprising:

and under the condition that the data to be inserted does not contain the primary key value and the table to be queried in the data insertion statement contains the primary key value, adding the primary key value in the table to be queried to the data insertion statement.

6. The method of claim 1, further comprising:

responding to a received data query statement to be executed, and sending the data query statement to a corresponding database;

7. The method according to any one of claims 1 to 6, wherein generating a target SQL statement corresponding to the distributed database based on the updated SQL statement and issuing the target SQL statement to the distributed database comprises:

generating a syntax execution tree based on the updated SQL statement;

8. A distributed database statement execution apparatus, comprising:

the system comprises a main key judging module, a main key judging module and a main key judging module, wherein the main key judging module is used for responding to the received SQL sentences to be executed and judging whether the SQL sentences contain main key information;

9. An electronic device, characterized in that the electronic device comprises:

at least one processor; and

the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the distributed database statement execution method of any one of claims 1-7.

10. A computer-readable storage medium storing computer instructions for causing a processor to perform the distributed database statement execution method of any one of claims 1-7 when executed.