CN110569257B - Data processing method, corresponding device, equipment and storage medium - Google Patents
Data processing method, corresponding device, equipment and storage medium Download PDFInfo
- Publication number
- CN110569257B CN110569257B CN201910869719.1A CN201910869719A CN110569257B CN 110569257 B CN110569257 B CN 110569257B CN 201910869719 A CN201910869719 A CN 201910869719A CN 110569257 B CN110569257 B CN 110569257B
- Authority
- CN
- China
- Prior art keywords
- execution
- database server
- plan tree
- execution plan
- instruction
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24532—Query optimisation of parallel queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24542—Plan optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
The embodiment of the invention discloses a data processing method, a corresponding device, equipment and a storage medium. The method is applied to a main database server and comprises the following steps: and distributing the execution plan tree to a slave database server so that the master database server and the slave database server synchronously execute the execution plan tree, synchronously executing the operation corresponding to the preset condition node with the slave database server when the operation is executed to the preset condition node, returning to execute the execution plan tree after the operation execution is finished until the execution of the execution plan tree is finished, summarizing the execution result of the slave database server executing the execution plan tree, and sending the execution result to a user. The technical scheme of the embodiment of the invention ensures the synchronization of the execution of the master database server and the slave database server, prevents the occurrence of the abnormity such as deadlock and the like caused by the asynchronous execution of the master database server and the slave database server, ensures the normal operation of data processing and meets the requirements of users.
Description
Technical Field
The embodiment of the invention relates to the technical field of databases, in particular to a data processing method, a corresponding device, equipment and a storage medium.
Background
Massive Parallel Processing (MPP) supports a plurality of database server instances to be organized into a distributed Parallel computing cluster system to provide uniform database service to the outside. Each running database server instance in the MPP system is called an execution node (EP), each EP has the same function, and a user can connect any one of the EPs to operate according to needs. For each user session, the EP has a master-slave score, and the EP to which the user session is connected is referred to as the master EP for that user session, and the remaining EPs are referred to as slave EPs.
In actual application, the master EP parses a Structured Query Language (SQL) statement input by a user, generates a corresponding execution plan, distributes the execution plan to the slave EP, collects execution results of the slave EP, processes the collected execution results to obtain a result set, and feeds the result set back to the user. Because the SQL statement usually has a function call or a nested call of a function, each layer of function call may also include the SQL statement, if the above-mentioned processing is performed, different EPs are easily caused to execute different SQL, which results in information mismatch and causes an exception such as deadlock, where deadlock is a phenomenon that two or more processes are blocked during execution due to resource competition or due to mutual communication, and they cannot be pushed forward without external force.
Disclosure of Invention
Embodiments of the present invention provide a data processing method, a corresponding apparatus, a device, and a storage medium, so as to prevent an exception such as deadlock caused by mismatch of information during data processing, and ensure normal data processing.
In a first aspect, an embodiment of the present invention provides a data processing method applied to a master database server, including:
distributing an execution plan tree to a slave database server so that the master database server and the slave database server synchronously execute the execution plan tree, the execution plan tree being generated by the master database server through parsing of a structured query statement input by a user, the execution plan tree including preset condition nodes;
when the preset condition node is executed, synchronously executing the operation corresponding to the preset condition node with the slave database server, and returning to execute the execution plan tree after the operation execution is finished until the execution of the execution plan tree is finished;
and summarizing the execution result of the execution plan tree from the database server and sending the result to the user.
In a second aspect, an embodiment of the present invention further provides a data processing method, applied to a slave database server, including:
receiving an execution plan tree sent by a main database server, wherein the execution plan tree is generated by the main database server through analyzing a structured query statement input by a user and comprises preset condition nodes;
when the preset condition node is executed, synchronously executing the operation corresponding to the preset condition node with the main database server, and returning to execute the execution plan tree after the operation execution is finished until the execution of the execution plan tree is finished;
and transmitting an execution result of executing the execution plan tree to the main database server.
In a third aspect, an embodiment of the present invention further provides a data processing apparatus, which is disposed in a master database server, and includes:
a distribution module for distributing an execution plan tree to a slave database server so that the master database server and the slave database server synchronously execute the execution plan tree, the execution plan tree being generated by the master database server through parsing of a structured query statement input by a user, the execution plan tree including preset condition nodes;
the execution module is used for synchronously executing the operation corresponding to the preset condition node with the slave database server when the preset condition node is executed, and returning to execute the execution plan tree after the execution of the operation is finished until the execution of the execution plan tree is finished;
and the summarizing module is used for summarizing the execution result of the execution plan tree executed by the database server and sending the execution result to the user.
In a fourth aspect, an embodiment of the present invention further provides a data processing apparatus, which is disposed in a slave database server, and includes:
the system comprises a receiving module, a query module and a query module, wherein the receiving module is used for receiving an execution plan tree sent by a main database server, the execution plan tree is generated by the main database server through analyzing a structured query statement input by a user and comprises preset condition nodes;
the execution module is used for synchronously executing the operation corresponding to the preset condition node with the main database server when the preset condition node is executed, and returning to execute the execution plan tree after the operation execution is finished until the execution of the execution plan tree is finished;
and the result sending module is used for sending the execution result of executing the execution plan tree to the main database server.
In a fifth aspect, an embodiment of the present invention further provides an apparatus, including:
one or more processors;
a memory for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement a data processing method as described in the first aspect or the second aspect.
In a sixth aspect, the present invention further provides a storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the data processing method according to the first aspect or the second aspect.
The embodiment of the invention provides a data processing method, a corresponding device, equipment and a storage medium, wherein an execution plan tree is distributed to a slave database server through a master database server, so that the master database server and the slave database server synchronously execute the execution plan tree, suspend the execution of the execution plan tree when executing to a preset condition node, and then synchronously executing the operation corresponding to the preset condition node with the slave database server, and returning to execute the execution plan tree after the operation execution is finished, thereby ensuring the synchronization of the execution of the master database server and the slave database server, preventing the occurrence of the abnormity such as deadlock and the like caused by asynchronous execution of the master database server and the slave database server, ensuring the normal operation of data processing, finally summarizing the execution result of executing the execution plan tree by the slave database server, and sending the execution result to the user, thereby meeting the requirement of the user.
Drawings
Fig. 1 is a flowchart of a data processing method according to an embodiment of the present invention;
FIG. 2 is a diagram illustrating an execution plan tree according to an embodiment of the present invention;
fig. 3 is a flowchart of a data processing method according to a second embodiment of the present invention;
fig. 4 is a flowchart of a data processing method according to a third embodiment of the present invention;
FIG. 5 is a block diagram of a data processing system according to a fourth embodiment of the present invention;
fig. 6 is a schematic diagram illustrating a process of interaction between a master database server and a slave database server according to a fourth embodiment of the present invention;
fig. 7 is a structural diagram of a data processing apparatus according to a fifth embodiment of the present invention;
fig. 8 is a structural diagram of a data processing apparatus according to a sixth embodiment of the present invention;
fig. 9 is a block diagram of an apparatus according to a seventh embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures. In addition, the embodiments and features of the embodiments in the present invention may be combined with each other without conflict.
Example one
Fig. 1 is a flowchart of a data processing method according to an embodiment of the present invention, where the embodiment is applicable to a case where information input by a user is processed to obtain a result required by the user, and the method may be executed by a data processing apparatus, which may be implemented in software and/or hardware and may be configured in a master database server.
The master database server is a database server in the MPP system, and the database server in the MPP system has no master-slave division, namely, each database server in the MPP system has the same function. For the user session, the database servers in the MPP system have a master-slave score, the master database server is the database server connected with the user session, the slave database servers are the rest database servers, the master database server is one in the application process, and the slave database servers can be a plurality of slave database servers. Optionally, the master database server may determine login information of the user logging in the MPP system, where the login information may include a user name, a password, a database server identifier, and other information of the user, the database server corresponding to the database server identifier selects a connected database server for the user session, the database server is referred to as a master database server, and database servers other than the master database server in the MPP system are referred to as slave database servers.
Referring to fig. 1, the method may include the steps of:
and S110, distributing the execution plan tree to a slave database server so that the master database server and the slave database server synchronously execute the execution plan tree.
The execution plan tree is generated by the main database server through analyzing a structured query statement input by a user, and comprises preset condition nodes. And the execution plan tree is used as a main database server to perform syntactic and semantic analysis generation on SQL sentences input by the user. Illustratively, the SQL statement entered by the user is: SELECT FROM T2 WHERE T2.C1 ═ f1(), WHERE T2 is the data table, C1 is the C1 column in the data table T2, and f1() is the function, this SQL statement is used to query all the data rows in the data table T2 that satisfy the C1 column equal to the return value of the function f1 (). The main database server analyzes the SQL statement to generate a corresponding execution plan tree, as shown in fig. 2, fig. 2 is a schematic diagram of an execution plan tree according to an embodiment of the present invention. Different nodes in the execution plan tree represent different execution steps, for example, CSCN, MPP column, SLCT, PRJT, and NSET in fig. 2 represent different nodes in the execution plan tree, and represent different execution steps, where CSCN represents data of the scan data table T2, MPP column represents collection of data belonging to the data table T2 scanned by each database server, SLCT represents performing T2.c1 ═ f1() filtering processing on the collected data, PRJT represents performing projection operation on the filtered data according to a query column, and NSET represents generating a result set and returning the result set to the user. The data scanned by each slave database server belonging to the data table T2 is collected when the master database server is executed to the MPP column node, and accordingly, each slave database server transmits the respective scanned data to the master database server when executed to the MPP column node. The master and slave database servers execute in the order from bottom to top when executing according to the execution plan tree shown in fig. 2.
Optionally, the preset condition node is a function call node and is located in the execution plan tree, where the function call node is a node related to function call or nested call of a function. It should be noted that not all execution plan trees include preset condition nodes, when an SQL statement input by a user relates to a function call or a nested call of a function, the generated execution plan tree includes the preset condition nodes, and when the SQL statement input by the user does not relate to a function call or a nested call of a function, the generated execution plan tree does not include the preset condition nodes, and in the embodiment, the execution plan tree includes the preset condition nodes, as shown in fig. 2, the preset condition nodes are SLCT nodes.
It will be appreciated that the data of the data table T2 is distributed among different database servers in the MPP system, and the master and slave database servers are required to cooperate in determining the result of the query, and for this purpose, the master database server distributes the execution plan tree to each slave database server after generating the execution plan tree, and causes the slave database servers to execute according to the received execution plan tree. In order to ensure the normal operation of the query process and prevent the occurrence of abnormalities such as deadlock in the query process, the master database server and the slave database server need to synchronously execute the execution plan tree.
And S120, when the preset condition node is executed, synchronously executing the operation corresponding to the preset condition node with the slave database server, and returning to execute the execution plan tree after the execution of the operation is finished until the execution of the execution plan tree is finished.
The preset condition node takes a function call node as an example, when the execution plan tree includes the function call node, since the function call may also include SQL statements, in order to avoid the exception of deadlock caused by mismatching of information due to different SQL statements executed by different database servers, when the main database server executes the preset condition node, the execution of the execution plan tree is suspended, the function call operation corresponding to the function call node is executed, after the execution of the function call operation is finished, the execution plan tree is returned to the execution plan tree, and the execution plan tree is continuously executed until the execution of the execution plan tree is finished. Since the master database server and the slave database server synchronously execute the execution plan tree, when the master database server executes to the function call node, the slave database server also executes to the corresponding function call node, and the slave database server also suspends the execution of the execution plan tree, similar to the master database server, and synchronously executes the function call operation corresponding to the function call node with the master database server.
When the main database server executes to the function calling node, the execution of the execution plan tree is suspended, and another execution plan tree corresponding to the function calling operation is generated and sent to the slave database server. And after the master database server and the slave database server synchronously execute another execution plan tree, returning to the original execution plan tree. For convenience of description, the embodiment refers to the execution plan tree generated in advance as a first execution plan tree, and the execution plan tree generated based on the function call operation as a second execution plan tree. When the main database server executes a function call node of the first execution plan tree, the execution environment corresponding to the first execution plan tree is stored in a stack frame corresponding to the first execution plan tree, then a new stack frame is constructed, the execution environment corresponding to the second execution plan tree is constructed in the new stack frame, the execution of the second execution plan tree is completed, after the execution of the second execution plan tree is completed, the execution returns to the first execution plan tree, and the stack frame corresponding to the second execution plan tree can be deleted. The execution from the database server is similar.
S130, summarizing the execution result of executing the execution plan tree from the database server, and sending the execution result to the user.
Taking fig. 2 as an example, since the data in the data table T2 is distributed on each database server, in order to ensure the accuracy of the query result, the execution results of each database server need to be summarized to generate a result meeting the user requirement. The present embodiment collects, by the master database server, execution results of the respective slave database servers executing the first execution plan tree and the second execution plan tree. Wherein the execution results of executing the first execution plan tree and the second execution plan tree from the database server include results generated during the execution.
As shown in fig. 2, according to the execution of the first execution plan tree, data belonging to the data table T2 on each database server is scanned, when the master database server executes to the MPP column node, the data scanned from each database server is collected, then a function is executed to call the corresponding second execution plan tree, a return value of the function f1() is obtained, the collected data is subjected to the filtering process of T2.c1 ═ f1(), and finally, a result set meeting the user requirements is generated and sent to the user. It should be noted that the master and slave database servers are not independent from each other but have a certain data interaction during the execution of the first execution plan tree and the second execution plan tree, for example, when the first execution plan tree is executed, the slave database servers transmit the respective scanned data to the master database server, and when the second execution plan tree corresponding to the function call is executed, the data interaction exists between the database servers, so that the master database server obtains the return value of the function f1 ().
The embodiment of the invention provides a data processing method, which comprises the steps that an execution plan tree is distributed to a slave database server through a master database server, so that the master database server and the slave database server synchronously execute the execution plan tree, when the execution plan tree is executed to a preset condition node, the execution of the execution plan tree is suspended, then the operation corresponding to the preset condition node is synchronously executed with the slave database server, and the execution plan tree is returned after the execution of the operation is finished, so that the execution synchronization of the master database server and the slave database server is ensured, the occurrence of abnormal conditions such as deadlock and the like caused by the execution asynchronization of the master database server and the slave database server is prevented, the normal operation of data processing is ensured, the execution result of the execution plan tree executed by the slave database server is finally summarized and sent to a user, and the requirements of the user are met.
Example two
Fig. 3 is a flowchart of a data processing method according to a second embodiment of the present invention, where the present embodiment is optimized based on the foregoing embodiment, and referring to fig. 3, the method may include the following steps:
s210, distributing the execution plan tree to a slave database server so that the master database server and the slave database server synchronously execute the execution plan tree.
And S220, when the preset condition node is executed, suspending the execution of the execution plan tree and sending a suspension instruction to the slave database server.
Optionally, the preset condition node is a function call node. In order to ensure that the master and slave database servers execute the same SQL, when the master database server executes to a preset condition node, the master database server suspends the execution of the first execution plan tree, generates a second execution plan tree corresponding to the function call operation, and transmits a suspension instruction to the slave database server so that the slave database server also suspends the execution of the first execution plan tree.
Optionally, the pause instruction includes: the stack is a specific storage area or register, one end of the stack is fixed, the other end of the stack is floating, and data storage or data extraction is carried out from the floating end. The saving instruction is used for saving cache data in the execution process of the execution plan tree. The main database server sends a stack-entering instruction and a storage instruction to the slave database server, so that the slave database server stores the execution environment corresponding to the first execution plan tree and cache data generated in the execution process, data loss is prevented, and the accuracy of the query result is ensured.
Optionally, the sending a pause instruction to the slave database server includes:
sending a push instruction to the slave database server;
and when a response result of the push instruction fed back by the slave database server is received, sending a storage instruction to the slave database server.
In order to prevent the loss of intermediate data due to the asynchronous of the database servers and the influence on the accuracy of the query result, the master database server of the embodiment first sends a stack pushing instruction to each slave database server, so that each database server stores the corresponding execution environment into the corresponding stack, and new data is prevented from being generated in the storage process. And when response results of the push instructions fed back by the slave database servers are received, sending a storage instruction to the slave database servers, so that the slave database servers store cache data in the execution process under the condition that no new data is generated, and further finishing the storage of the execution environment and the cache data.
And S230, synchronously executing the operation corresponding to the preset condition node with the slave database server.
And after receiving the response result of the storage instruction fed back by each slave database server, the master database server transmits the generated second execution plan tree to each slave database server so that each slave database server and the master database server synchronously execute the second execution plan tree.
S240, when the operation execution ending result fed back from the database server is received, returning to execute the execution plan tree until the execution of the execution plan tree is finished.
And after the second execution plan tree is executed, feeding back the result of the operation execution completion to the main database server. And after receiving the operation execution ending result fed back by each slave database server, the master database server returns to execute the first execution plan tree until the execution is finished.
When the second execution plan tree is executed, the execution environment corresponding to the first execution plan tree and the generated cache data are both stored in the corresponding stack, and when the second execution plan tree returns to the first execution plan tree and the first execution plan tree is continuously executed, the execution environment and the cache data corresponding to the first execution plan tree need to be restored first. Thus, S240 may include:
when receiving the result of the operation execution end fed back by the slave database server, recovering the cache data generated before the execution plan tree is suspended to the current environment, and sending a data recovery instruction to the slave database server;
and when a response result of the data recovery instruction fed back from the database server is received, recovering the corresponding execution environment before the suspension of the execution plan tree, and sending a pop instruction to the slave database server.
When the execution environment and the cache data corresponding to the first execution plan tree are stored, the corresponding execution environment is stored firstly, then the corresponding cache data are stored, according to the characteristic that the stack is advanced firstly and then withdrawn, when the main database server receives the operation execution end result fed back by the slave database server, the cache data generated before the first execution plan tree is suspended is restored to the current environment firstly, and meanwhile, a data restoration instruction is sent to each slave database server, so that each slave database server restores the stored cache data to the current environment according to the received data restoration instruction. And when the main database server receives a response result of the data recovery instruction fed back by each slave database server, popping the stack frame at the top of the stack, recovering the corresponding execution environment before the pause of the first execution plan tree, and sending a pop instruction to each slave database server, so that each slave database server pops the stack frame at the top of the stack according to the received pop instruction, and recovering the corresponding execution environment before the pause of the first execution plan tree. Thus, the master and slave database servers can continue to execute the first execution plan tree.
And S250, summarizing the execution result of executing the execution plan tree from the database server and sending the execution result to the user.
On the basis of the above embodiment, when the execution of the first execution plan tree is suspended, in order to ensure synchronization between the master database server and the slave database servers and prevent loss of intermediate data, a push instruction is sent first by the master database server, and when a response result of the push instruction fed back by each slave database server is received, a save instruction is sent again, so that new data is prevented from being generated in the saving process, and accuracy of a query result is ensured.
EXAMPLE III
Fig. 4 is a flowchart of a data processing method according to a third embodiment of the present invention, which is applied to a slave database server, and determines a query result required by a user by interacting with a master database server according to the third embodiment of the present invention, so as to meet the requirements of the user. The method may be performed by a data processing apparatus, which may be implemented in software and/or hardware, and may be configured in a slave database server. The slave database server is a database server except the master database server in the MPP system. Referring to fig. 4, the method may include the steps of:
and S310, receiving the execution plan tree sent by the main database server.
The execution plan tree is generated by the main database server through analyzing a structured query statement input by a user, and comprises preset condition nodes. The above embodiments can be referred to in the generation process of the execution plan tree, and details are not repeated here. After the master database server generates the execution plan tree, the execution plan tree is sent to the slave database server so that the master database server and the slave database server synchronously execute the execution plan tree.
And S320, when the preset condition node is executed, synchronously executing the operation corresponding to the preset condition node with the main database server, and returning to execute the execution plan tree after the operation execution is finished until the execution of the execution plan tree is finished.
Optionally, the preset condition node is a function call node. Similar to the master database server, when the slave database server executes the preset condition node, the slave database server stops executing the first execution plan tree, and then synchronously executes the operation corresponding to the preset condition node with the master database, and after the execution of the operation is finished, the slave database server returns to execute the first execution plan tree until the execution of the first execution plan tree is finished. The slave database server of the embodiment keeps synchronous execution with the master database server when executing the received first execution plan tree, and can prevent the occurrence of an exception such as deadlock in the execution process.
S330, sending the execution result of executing the execution plan tree to the main database server.
And when the slave database server executes the first execution plan tree, transmitting an execution result generated in the execution process to the master database server, so that the master database server performs operations such as collection, filtration and the like on the received execution result to form a result set and transmits the result set to a user.
The third embodiment of the invention provides a data processing method, which is implemented synchronously with a main database server by receiving an execution plan tree sent by the main database server, and when a preset condition node is executed, the execution plan tree is executed synchronously with the main database server, and the execution plan tree is returned to be executed after the execution of the operation is finished until the execution of the execution plan tree is finished, so that the synchronization of each database server in the data query process is ensured, the occurrence of conditions such as deadlock is avoided, and the like is avoided.
On the basis of the foregoing embodiment, optionally, the executing the operation corresponding to the preset condition node in synchronization with the master database server, and returning to execute the execution plan tree after the operation execution is finished, includes:
suspending execution of the execution plan tree according to the received suspension instruction;
synchronously executing the operation corresponding to the preset condition node with the main database server;
after the operation corresponding to the preset condition node is executed, feeding back the result of the operation execution completion to the main database server;
responding to a received data recovery instruction, recovering the cache data generated before the execution plan tree is suspended to the current environment, and feeding back a response result to the main database server;
and responding to the received pop instruction, and restoring the corresponding execution environment before the suspension of the execution plan tree.
Specifically, when the suspension instruction is received from the database server, the execution of the first execution plan tree is suspended, and the operation corresponding to the preset condition node is executed synchronously with the main database server. In order to ensure that the master database server and the slave database server can still synchronously execute the first execution plan tree suspended before the operation execution is finished, the slave database server feeds back the result of the operation execution finish to the master database server after the operation execution is finished. When receiving a data recovery instruction from the database server, the master database server responds to the data recovery instruction to recover the cache data generated before the suspension of the first execution plan tree to the current environment, and feeds back a response result to the master database server. And when the pop instruction sent by the main database server is received from the database server, the corresponding execution environment before the pause of the first execution plan tree is recovered in response to the pop instruction, so that the execution of the first execution plan tree is recovered. The data interaction between the master database server and the slave database server ensures the synchronous execution of each execution process, thereby ensuring the correctness of the data in each execution process.
On the basis of the foregoing embodiment, optionally, the pause instruction includes: a push instruction and a save instruction. For the related contents of the stack instruction and the save instruction, reference may be made to the above embodiments, and details are not described here.
On the basis of the foregoing embodiment, optionally, the suspending, according to the received suspension instruction, the execution of the execution plan tree includes:
responding to the received stacking instruction, storing the execution environment corresponding to the execution plan tree into a corresponding stack frame, and feeding back a response result to the main database server;
and responding to the received saving instruction, and saving the cache data generated before the execution plan tree is suspended.
The slave database server firstly responds to the stack-in instruction sent by the master database server according to the sending sequence of the master database server, stores the execution environment corresponding to the first execution plan tree into the corresponding stack frame, and returns a response result to the master database server. And then, in response to a saving instruction sent by the main database server, saving the cache data generated before the first execution plan tree is paused, thereby completing the pausing of the first execution plan tree.
Example four
In this embodiment, an interaction process between the master database server and the slave database server is described on the basis of the above embodiments, and referring to fig. 5, fig. 5 is a structural diagram of a data processing system according to a fourth embodiment of the present invention. The system comprises: the master database server 41 and the slave database server 42, the master database server 41 and the slave database server 42 communicate via ethernet or bus, the number of the master database servers 41 is one, the number of the slave database servers 42 may be one or more, and the embodiment takes one slave database server 42 as an example.
Referring to fig. 6, fig. 6 is a schematic diagram of a process of interaction between a master database server and a slave database server according to a fourth embodiment of the present invention. The master database server 41 parses the SQL statement inputted by the user, generates a corresponding execution plan tree, which is referred to as a first execution plan tree, and distributes the first execution plan tree to the slave database server 42, the master database server 41 and the slave database server 42 synchronously execute the first execution plan tree, when the execution reaches a preset condition node, the master database server suspends the execution of the first execution plan tree, stores the execution environment of the first execution plan tree in a corresponding stack, and transmits a stacking instruction to the slave database server 42, upon receiving the stacking instruction from the slave database server 42, suspends the execution of the first execution plan tree, stores the current execution environment in the stack, and feeds back a response result of the stacking instruction to the master database server 41, the master database server 41 stores cache data generated by the first execution plan tree according to the received response result, and transmits a save instruction to the slave database server 42, saves corresponding cache data after receiving a response instruction from the slave database server 42, and feeds back a response result of the save instruction to the master database server 41, the master database server 41 transmits a second execution plan tree corresponding to a preset condition node to the slave database server 42 after receiving the response result, the slave database server 42 generates an execution environment corresponding to the second execution plan tree according to the received second execution plan tree, executes the second execution plan tree in synchronization with the master database server 41, feeds back an execution end result from the database server 42 after the execution of the second execution plan tree is ended, restores the cache data of the stack and transmits a data restore instruction to the slave database server 42 when the master database server 41 receives the execution end result fed back from the database server 42, the slave database server 42 receives the data recovery command, recovers the cached data stored in the stack, and feeds back the response result of the data recovery command to the master database server 41, after the master database server 41 receives the response result, the corresponding execution environment before suspension is recovered, and at the same time, the slave database server 42 sends the pop-up command, the slave database server 42 receives the pop-up command, and recovers the corresponding execution environment before suspension, and the master database server 41 and the slave database server 42 continue to synchronously execute the corresponding execution plan tree. When the nested call of the function is contained, when one nested is executed, the other nested is continuously executed until the function call is executed, and then the first execution plan tree with the execution pause is returned.
EXAMPLE five
Fig. 7 is a structural diagram of a data processing apparatus according to a fifth embodiment of the present invention, which is disposed in a master database server and is capable of executing the data processing method according to the foregoing embodiment, and referring to fig. 7, the apparatus includes:
a distribution module 510 configured to distribute an execution plan tree to a slave database server so that the master database server and the slave database server synchronously execute the execution plan tree, the execution plan tree being generated by the master database server through parsing of a structured query statement input by a user, the execution plan tree including preset condition nodes;
the execution module 520 is configured to execute the operation corresponding to the preset condition node synchronously with the slave database server when the preset condition node is executed, and return to execute the execution plan tree after the execution of the operation is finished until the execution of the execution plan tree is finished;
a summarizing module 530, configured to summarize an execution result of the execution plan tree from the database server, and send the result to the user.
The fifth embodiment of the present invention provides a data processing apparatus, wherein an execution plan tree is distributed to a slave database server through a master database server, so that the master database server and the slave database server synchronously execute the execution plan tree, when the execution reaches a preset condition node, the execution of the execution plan tree is suspended, then the operation corresponding to the preset condition node is synchronously executed with the slave database server, and the execution plan tree is returned after the execution of the operation is completed, so that the synchronization of the execution of the master database server and the slave database server is ensured, the occurrence of an exception such as deadlock caused by the asynchronous execution of the master database server and the slave database server is prevented, the normal execution of data processing is ensured, and finally, the execution result of the execution plan tree executed by the slave database server is summarized and sent to a user, thereby satisfying the requirements of the user.
On the basis of the above embodiment, the execution module 520 includes:
a sending unit, configured to suspend execution of the execution plan tree, and send a suspension instruction to the slave database server;
the synchronous execution unit is used for synchronously executing the operation corresponding to the preset condition node with the slave database server;
and the return execution unit is used for returning and executing the execution plan tree when receiving the result of the operation execution end fed back from the database server.
On the basis of the above embodiment, the pause instruction includes: a push instruction and a save instruction.
On the basis of the foregoing embodiment, the sending unit is specifically configured to send a push instruction to the slave database server;
and when a response result of the push instruction fed back by the slave database server is received, sending a storage instruction to the slave database server.
On the basis of the foregoing embodiment, the return execution unit is specifically configured to, when receiving a result of the operation execution end fed back from the database server, resume the cached data generated before the execution plan tree is suspended to the current environment, and send a data resume instruction to the slave database server;
and when a response result of the data recovery instruction fed back from the database server is received, recovering the corresponding execution environment before the suspension of the execution plan tree, and sending a pop instruction to the slave database server.
On the basis of the above embodiment, the preset condition node is a function call node.
The data processing device provided by the fifth embodiment of the present invention can execute the data processing method provided by the foregoing embodiment of the present invention, and has functional modules and beneficial effects corresponding to the execution method.
EXAMPLE six
Fig. 8 is a structural diagram of a data processing apparatus according to a sixth embodiment of the present invention, where the apparatus is disposed in a slave database server, and is capable of executing the data processing method according to the foregoing embodiment, and referring to fig. 8, the apparatus includes:
a receiving module 610, configured to receive an execution plan tree sent by a master database server, where the execution plan tree is generated by the master database server through parsing a structured query statement input by a user, and the execution plan tree includes preset condition nodes;
the execution module 620 is configured to execute the operation corresponding to the preset condition node synchronously with the master database server when the preset condition node is executed, and return to execute the execution plan tree after the execution of the operation is finished until the execution of the execution plan tree is finished;
a result transmitting module 630, configured to transmit an execution result of executing the execution plan tree to the master database server.
The sixth embodiment of the present invention provides a data processing apparatus, which receives an execution plan tree sent by a master database server, executes the execution plan tree in synchronization with the master database server, executes an operation corresponding to a preset condition node in synchronization with the master database server when the execution plan tree reaches the preset condition node, and returns to execute the execution plan tree after the execution of the operation is completed until the execution of the execution plan tree is completed, so as to ensure synchronization of each database server in a data query process, avoid occurrence of conditions such as deadlock, and send a generated execution result to the master database server in the execution process of a slave database server, thereby ensuring integrity of the query result.
On the basis of the above embodiment, the execution module 620 includes:
a suspension unit for suspending execution of the execution plan tree according to a received suspension instruction;
the synchronous execution unit is used for synchronously executing the operation corresponding to the preset condition node with the main database server;
the result feedback unit is used for feeding back the result of the operation execution completion to the main database server after the operation execution corresponding to the preset condition node is completed;
a first restoring unit, configured to restore, in response to a received data restoring instruction, cached data generated before suspension of the execution plan tree to a current environment, and feed back a response result to the master database server;
and the second recovery unit is used for responding to the received pop instruction and recovering the corresponding execution environment before the suspension of the execution plan tree.
On the basis of the above embodiment, the pause instruction includes: a push instruction and a save instruction.
On the basis of the foregoing embodiment, the suspension unit is specifically configured to store, in response to a received stack push instruction, an execution environment corresponding to the execution plan tree in a corresponding stack frame, and feed back a response result to the master database server;
and responding to the received saving instruction, and saving the cache data generated before the execution plan tree is suspended.
On the basis of the above embodiment, the preset condition node is a function call node.
The data processing device provided by the sixth embodiment of the invention can execute the data processing method provided by the above embodiments of the invention, and has the corresponding functional modules and beneficial effects of the execution method.
EXAMPLE seven
Fig. 9 is a structural diagram of an apparatus according to a seventh embodiment of the present invention, and referring to fig. 9, the apparatus includes: the device comprises a processor 710, a memory 720, an input device 730 and an output device 740, the number of the processors 710 in the device can be one or more, one processor 710 is taken as an example in fig. 9, the processor 710, the memory 720, the input device 730 and the output device 740 in the device can be connected through a bus or in other ways, and the connection through the bus is taken as an example in fig. 9.
The memory 720, which is a computer-readable storage medium, may be used to store software programs, computer-executable programs, and modules, such as program instructions/modules corresponding to the data processing method in the embodiments of the present invention. The processor 710 executes various functional applications of the device and data processing, i.e., implements the data processing method of the above-described embodiment, by executing software programs, instructions, and modules stored in the memory 720.
The memory 720 mainly includes a program storage area and a data storage area, wherein the program storage area can store an operating system and an application program required by at least one function; the storage data area may store data created according to the use of the terminal, and the like. Further, the memory 720 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some examples, the memory 720 may further include memory located remotely from the processor 710, which may be connected to devices over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 730 may be used to receive input numeric or character information and generate key signal inputs related to user settings and function control of the apparatus. The output device 740 may include a display device such as a display screen, and an audio device such as a speaker and a buzzer.
The seventh embodiment of the present invention provides an apparatus and a data processing method according to the foregoing embodiments, which belong to the same inventive concept, and the technical details that are not described in detail in this embodiment can be referred to in the foregoing embodiments, and this embodiment has the same advantageous effects as the data processing method.
Example eight
An eighth embodiment of the present invention further provides a storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the data processing method according to the foregoing embodiment of the present invention.
Of course, the storage medium provided by the embodiment of the present invention includes computer-executable instructions, and the computer-executable instructions are not limited to the operations in the data processing method described above, and may also perform related operations in the data processing method provided by any embodiment of the present invention, and have corresponding functions and advantages.
From the above description of the embodiments, it is obvious for those skilled in the art that the present invention can be implemented by software and necessary general hardware, and certainly, can also be implemented by hardware, but the former is a better embodiment in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which may be stored in a computer-readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, and includes several instructions for enabling a computer device (which may be a robot, a personal computer, a server, or a network device) to execute the data processing method according to the embodiments of the present invention.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (11)
1. A data processing method is applied to a main database server and comprises the following steps:
distributing an execution plan tree to a slave database server so that the master database server and the slave database server synchronously execute the execution plan tree, the execution plan tree being generated by the master database server through parsing of a structured query statement input by a user, the execution plan tree including preset condition nodes;
when the preset condition node is executed, synchronously executing the operation corresponding to the preset condition node with the slave database server, and returning to execute the execution plan tree after the operation execution is finished until the execution of the execution plan tree is finished;
summarizing the execution result of executing the execution plan tree from the database server and sending the execution result to the user;
the synchronously executing the operation corresponding to the preset condition node with the slave database server, and returning to execute the execution plan tree after the operation execution is finished, includes:
suspending execution of the execution plan tree and sending a suspension instruction to the slave database server; the pause instruction includes: the stack loading instruction is used for storing the execution environment of the first execution plan tree into a stack frame of the stack, and the saving instruction is used for saving cache data in the execution process of the execution plan tree;
synchronously executing the operation corresponding to the preset condition node with the slave database server;
and when receiving the result of the operation execution end fed back from the database server, returning to execute the execution plan tree.
2. The method of claim 1, wherein said sending a pause instruction to said slave database server comprises:
sending a push instruction to the slave database server;
and when a response result of the push instruction fed back by the slave database server is received, sending a storage instruction to the slave database server.
3. The method according to claim 1, wherein returning to execute the execution plan tree when receiving a result of the operation execution end fed back from the database server comprises:
when receiving the result of the operation execution end fed back by the slave database server, recovering the cache data generated before the execution plan tree is suspended to the current environment, and sending a data recovery instruction to the slave database server;
and when a response result of the data recovery instruction fed back from the database server is received, recovering the corresponding execution environment before the suspension of the execution plan tree, and sending a pop instruction to the slave database server.
4. The method according to any one of claims 1 to 3, wherein the preset condition node is a function call node.
5. A data processing method, applied to a slave database server, comprising:
receiving an execution plan tree sent by a main database server, wherein the execution plan tree is generated by the main database server through analyzing a structured query statement input by a user and comprises preset condition nodes;
when the preset condition node is executed, synchronously executing the operation corresponding to the preset condition node with the main database server, and returning to execute the execution plan tree after the operation execution is finished until the execution of the execution plan tree is finished;
transmitting an execution result of executing the execution plan tree to the master database server;
the synchronously executing the operation corresponding to the preset condition node with the main database server, and returning and executing the execution plan tree after the operation execution is finished, includes:
suspending execution of the execution plan tree according to the received suspension instruction; the pause instruction includes: the stack loading instruction is used for storing the execution environment of the first execution plan tree into a stack frame of the stack, and the saving instruction is used for saving cache data in the execution process of the execution plan tree;
synchronously executing the operation corresponding to the preset condition node with the main database server;
after the operation corresponding to the preset condition node is executed, feeding back the result of the operation execution completion to the main database server;
responding to a received data recovery instruction, recovering the cache data generated before the execution plan tree is suspended to the current environment, and feeding back a response result to the main database server;
and responding to the received pop instruction, and restoring the corresponding execution environment before the suspension of the execution plan tree.
6. The method of claim 5, wherein suspending execution of the execution plan tree in accordance with the received suspension instruction comprises:
responding to the received stacking instruction, storing the execution environment corresponding to the execution plan tree into a corresponding stack frame, and feeding back a response result to the main database server;
and responding to the received saving instruction, and saving the cache data generated before the execution plan tree is suspended.
7. The method according to any one of claims 5 to 6, wherein the preset condition node is a function call node.
8. A data processing apparatus provided in a master database server, comprising:
a distribution module for distributing an execution plan tree to a slave database server so that the master database server and the slave database server synchronously execute the execution plan tree, the execution plan tree being generated by the master database server through parsing of a structured query statement input by a user, the execution plan tree including preset condition nodes;
the execution module is used for synchronously executing the operation corresponding to the preset condition node with the slave database server when the preset condition node is executed, and returning to execute the execution plan tree after the execution of the operation is finished until the execution of the execution plan tree is finished;
the summarizing module is used for summarizing the execution result of the execution plan tree executed by the slave database server and sending the execution result to the user;
the execution module includes:
a sending unit, configured to suspend execution of the execution plan tree, and send a suspension instruction to the slave database server; the pause instruction includes: the stack loading instruction is used for storing the execution environment of the first execution plan tree into a stack frame of the stack, and the saving instruction is used for saving cache data in the execution process of the execution plan tree;
the synchronous execution unit is used for synchronously executing the operation corresponding to the preset condition node with the slave database server;
and the return execution unit is used for returning and executing the execution plan tree when receiving the result of the operation execution end fed back from the database server.
9. A data processing apparatus provided in a slave database server, comprising:
the system comprises a receiving module, a query module and a query module, wherein the receiving module is used for receiving an execution plan tree sent by a main database server, the execution plan tree is generated by the main database server through analyzing a structured query statement input by a user and comprises preset condition nodes;
the execution module is used for synchronously executing the operation corresponding to the preset condition node with the main database server when the preset condition node is executed, and returning to execute the execution plan tree after the operation execution is finished until the execution of the execution plan tree is finished;
a result transmitting module for transmitting an execution result of executing the execution plan tree to the master database server;
the execution module includes:
a suspension unit for suspending execution of the execution plan tree according to a received suspension instruction; the pause instruction includes: the stack loading instruction is used for storing the execution environment of the first execution plan tree into a stack frame of the stack, and the saving instruction is used for saving cache data in the execution process of the execution plan tree;
the synchronous execution unit is used for synchronously executing the operation corresponding to the preset condition node with the main database server;
the result feedback unit is used for feeding back the result of the operation execution completion to the main database server after the operation execution corresponding to the preset condition node is completed;
a first restoring unit, configured to restore, in response to a received data restoring instruction, cached data generated before suspension of the execution plan tree to a current environment, and feed back a response result to the master database server;
and the second recovery unit is used for responding to the received pop instruction and recovering the corresponding execution environment before the suspension of the execution plan tree.
10. An apparatus, comprising:
one or more processors;
a memory for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement a data processing method as claimed in any one of claims 1-4 or 5-7.
11. A storage medium on which a computer program is stored, which program, when being executed by a processor, carries out the data processing method of any one of claims 1 to 4 or 5 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910869719.1A CN110569257B (en) | 2019-09-16 | 2019-09-16 | Data processing method, corresponding device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910869719.1A CN110569257B (en) | 2019-09-16 | 2019-09-16 | Data processing method, corresponding device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110569257A CN110569257A (en) | 2019-12-13 |
| CN110569257B true CN110569257B (en) | 2022-04-01 |
Family
ID=68780186
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910869719.1A Active CN110569257B (en) | 2019-09-16 | 2019-09-16 | Data processing method, corresponding device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110569257B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113448967B (en) * | 2021-07-20 | 2022-02-08 | 威讯柏睿数据科技(北京)有限公司 | Method and device for accelerating database operation |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104216894A (en) * | 2013-05-31 | 2014-12-17 | 国际商业机器公司 | Method and system for data query |
| CN105608086A (en) * | 2014-11-17 | 2016-05-25 | 中兴通讯股份有限公司 | Transaction processing method and device of distributed database system |
| CN106446153A (en) * | 2016-09-21 | 2017-02-22 | 广州特道信息科技有限公司 | Distributed newSQL database system and method |
| CN107122357A (en) * | 2016-02-24 | 2017-09-01 | 阿里巴巴集团控股有限公司 | Data base read-write separation method, device and system |
| CN108038215A (en) * | 2017-12-22 | 2018-05-15 | 上海达梦数据库有限公司 | Data processing method and system |
| CN108536692A (en) * | 2017-03-01 | 2018-09-14 | 华为技术有限公司 | A kind of generation method of executive plan, device and database server |
| CN108829735A (en) * | 2018-05-21 | 2018-11-16 | 上海达梦数据库有限公司 | Synchronous method, device, server and the storage medium of parallel executive plan |
| CN109634728A (en) * | 2018-11-16 | 2019-04-16 | 深圳市云智融科技有限公司 | Job scheduling method, device, terminal device and readable storage medium storing program for executing |
| CN109726250A (en) * | 2018-12-27 | 2019-05-07 | 星环信息科技（上海）有限公司 | Data-storage system, metadatabase synchronization and data cross-domain calculation method |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7203672B2 (en) * | 2003-12-16 | 2007-04-10 | Oracle International Corporation | Communicating external expressions using a parallel single cursor model |
| US8984170B2 (en) * | 2011-09-09 | 2015-03-17 | Oracle International Corporation | Idempotence for database transactions |
| CN107438800A (en) * | 2015-02-12 | 2017-12-05 | 格罗弗治公司 | The mobile material in laser processing procedure |
| US10585887B2 (en) * | 2015-03-30 | 2020-03-10 | Oracle International Corporation | Multi-system query execution plan |
| CN109144994B (en) * | 2017-06-19 | 2022-04-29 | 华为技术有限公司 | Index updating method, system and related device |
| CN109299101B (en) * | 2018-10-15 | 2020-12-01 | 上海达梦数据库有限公司 | Data retrieval method, device, server and storage medium |
| CN110166282B (en) * | 2019-04-16 | 2020-12-01 | 苏宁云计算有限公司 | Resource allocation method, device, computer equipment and storage medium |
-
2019
- 2019-09-16 CN CN201910869719.1A patent/CN110569257B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104216894A (en) * | 2013-05-31 | 2014-12-17 | 国际商业机器公司 | Method and system for data query |
| CN105608086A (en) * | 2014-11-17 | 2016-05-25 | 中兴通讯股份有限公司 | Transaction processing method and device of distributed database system |
| CN107122357A (en) * | 2016-02-24 | 2017-09-01 | 阿里巴巴集团控股有限公司 | Data base read-write separation method, device and system |
| CN106446153A (en) * | 2016-09-21 | 2017-02-22 | 广州特道信息科技有限公司 | Distributed newSQL database system and method |
| CN108536692A (en) * | 2017-03-01 | 2018-09-14 | 华为技术有限公司 | A kind of generation method of executive plan, device and database server |
| CN108038215A (en) * | 2017-12-22 | 2018-05-15 | 上海达梦数据库有限公司 | Data processing method and system |
| CN108829735A (en) * | 2018-05-21 | 2018-11-16 | 上海达梦数据库有限公司 | Synchronous method, device, server and the storage medium of parallel executive plan |
| CN109634728A (en) * | 2018-11-16 | 2019-04-16 | 深圳市云智融科技有限公司 | Job scheduling method, device, terminal device and readable storage medium storing program for executing |
| CN109726250A (en) * | 2018-12-27 | 2019-05-07 | 星环信息科技（上海）有限公司 | Data-storage system, metadatabase synchronization and data cross-domain calculation method |
Non-Patent Citations (1)
| Title |
|---|
| 基于MySQL复制改进的多主复制数据库扩展实现;基于MySQL复制改进的多主复制数据库扩展实现;《中国优秀博硕士学位论文全文数据库(硕士)信息科技辑》;20150615(第06期);I138-391 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110569257A (en) | 2019-12-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10013456B2 (en) | Parallel processing database system with a shared metadata store | |
| EP4072097A1 (en) | Method and device for dynamically adding consensus node in blockchain | |
| CN104731956A (en) | Method and system for synchronizing data and related database | |
| US9576026B2 (en) | System and method for distributed SQL join processing in shared-nothing relational database clusters using self directed data streams | |
| US11294934B2 (en) | Command processing method and server | |
| CN110134505A (en) | A kind of distributed computing method of group system, system and medium | |
| CN106095911A (en) | Search system and method for data synchronization | |
| CN109254854A (en) | Asynchronous invoking method, computer installation and storage medium | |
| CN110569257B (en) | Data processing method, corresponding device, equipment and storage medium | |
| CN109361553B (en) | Configuration rollback method and device | |
| CN111541762A (en) | Data processing method, management server, device and storage medium | |
| CN107465725B (en) | Heterogeneous long transaction processing system and method based on client information control system | |
| CN115630122A (en) | Data synchronization method and device, storage medium and computer equipment | |
| CN115357395A (en) | Fault equipment task transfer method and system, electronic equipment and storage medium | |
| CN114791900A (en) | Operator-based Redis operation and maintenance method, device, system and storage medium | |
| US7877422B2 (en) | Method and system for processing 1:N relationships between data object nodes | |
| CN114168594A (en) | Secondary index creating method, device, equipment and storage medium of horizontal partition table | |
| WO2020187021A1 (en) | Data model matching method and apparatus | |
| JP7133037B2 (en) | Message processing method, device and system | |
| CN110750362A (en) | Method and apparatus for analyzing biological information, and storage medium | |
| EP3193482B1 (en) | Message processing method and apparatus | |
| CN111124923B (en) | Running state query method and device, server equipment and storage medium | |
| CN113032131B (en) | Redis-based distributed timing scheduling system and method | |
| CN115599790B (en) | Data storage system, data processing method, electronic equipment and storage medium | |
| CN112351053B (en) | Remote access method, device, equipment and medium for embedded database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |