WO2017201970A1

WO2017201970A1 - Branch base database system and routing method therefor

Info

Publication number: WO2017201970A1
Application number: PCT/CN2016/104282
Authority: WO
Inventors: 李秋伟
Original assignee: 乐视控股（北京）有限公司; 乐视电子商务（北京）有限公司
Priority date: 2016-05-21
Filing date: 2016-11-01
Publication date: 2017-11-30
Also published as: CN106055587A

Abstract

Disclosed are a branch base database system and a routing method therefor. The branch base database system comprises L fragmentation databases and N branch base servers, wherein both L and N are natural numbers greater than 1. The routing method for the branch base database system comprises: when an operation request is received from a client, various branch base servers parsing and obtaining a query condition carried by the operation request (201, 301); when a target fragmentation database needs to be calculated, positioning, according to the query condition, the target fragmentation database in a local cache (202, 302); various branch base servers saving the correlation between the query condition and the target fragmentation database (207, 307), and synchronously updating the correlation to at least one branch base server, which does not process the operation request, in the branch base database system (208); and sending the operation request to the target fragmentation database (209). The branch base database system and the routing method therefor solve the problem of multiple calculations of fragmentation routing by reducing repetitive calculation of the fragmentation routing, thereby improving the processing efficiency of the branch base database system.

Description

Sub-database database system and routing method thereof

The present application claims priority to Chinese Patent Application No. 20161034234, the entire disclosure of which is hereby incorporated by reference.

Technical field

The patent application relates to the field of database technology, and in particular relates to a database database system and a routing method thereof.

Background technique

In the Internet network application, as the business grows, the database accumulates more and more data. When dealing with a large number of user access and high concurrent requests, the processing bottleneck of a single database will soon be revealed. The database will soon be unable to meet the application requirements, so the current database partitioning scheme is often used to improve database performance.

The traditional sub-division scheme is generally to set a fragmentation field in a database table, and configure the fragmentation strategy of the sub-library. When used, the calculation is based on the value of the application and the fragmentation strategy. The fragmentation node (ie, the target fragmentation database), from which it can be seen that the fragmentation field plays a key role in the routing of the target fragmentation database in the sub-database database system. In addition to setting the fragmentation field, you can also set a primary key field. The primary key field is the conditional field that is frequently operated by this database table. When the primary key field is used for querying, updating, etc., the database system will set the value of the primary key field. Corresponding to the target fragment database, the key value pair is stored in the local cache of the database server, and the corresponding target fragment database can be directly obtained from the local cache when used next time. Referring now to Figure 1, the routing method of the traditional sub-database database is described, which includes the following steps:

Step 101: Parse the query condition from the request from the client. For example, the parsed query condition includes a fragmentation field and/or a primary key field.

Step 102: Determine whether to hit the target fragment database in the local cache according to the parsed query condition. If the target is hit in the local cache, step 105 is performed; otherwise, if the corresponding data is not cached in the local cache (ie, the correspondence between the query condition and the target fragment database), step 103 is performed.

Step 103: Calculate the target fragment database according to the parsed query condition. In this step, the target fragment database may be calculated according to the incoming value of the fragmentation field and the fragmentation strategy of the database database system, or may be executed in the entire database according to the primary key field, and the target fragmentation database is obtained.

Step 104: Save the correspondence between the target fragment database and the request to the local cache, so that the target fragment database can be directly hit in the local cache when the next operation request is performed.

Step 105: Send an operation request to the target shard database.

In the process of implementing the present invention, the inventor of the present application finds that in the prior art, in order to prevent a single point problem, a clustering method is generally used to deploy a sub-database, and then a sub-database database system includes a plurality of sub-library servers, and each sub-library The server is respectively configured to calculate the target fragment database according to the query condition parsed in the operation request sent from the client. If the system's multiple sub-library servers are highly available, that is, each sub-library server is performing the routing task of the target fragmentation database at the same time, there will inevitably be multiple calculations or execution problems of the target fragmentation database, resulting in valuable CPU. Waste, reducing the effective utilization of hardware resources.

Summary of the invention

The purpose of some embodiments of the present invention is to provide a database database system and a routing method thereof, which can improve the processing efficiency of the database database system by reducing the repeated calculation of the target fragment database, thereby improving the system hardware usage efficiency.

In a first aspect, an embodiment of the present invention provides a routing method of a database database system, where The sub-database database system includes: L fragment databases and N sub-database servers, wherein the L and N are natural numbers greater than 1, and the method includes the following steps: the sub-database servers receive the client-side When the operation request is performed, the query condition carried by the operation request is obtained; when the target fragment database is to be calculated, the fragment database corresponding to the operation request is calculated according to the query condition; wherein each of the sub-database servers is stored Corresponding relationship between the query condition and the target fragment database, and synchronously updating the correspondence to at least one of the database servers in the database database that does not process the operation request; sending the operation request to the target Fragment database.

In a second aspect, the embodiment of the present invention provides a sub-database database system, including: L fragment databases and N sub-database servers, wherein the L and N are natural numbers greater than 1; the sub-library server includes parsing a module, a calculation module, a saving module, a synchronization module, and a sending module; the parsing module is configured to parse the query condition carried by the operation request when the sub-database server receives an operation request from the client; For calculating a target fragment database corresponding to the operation request according to the query condition when the target fragment database needs to be calculated; the saving module is configured to use the query condition and the target calculated by the calculation module Corresponding relationship of the fragmentation database is saved to the local cache of the sub-database server; the synchronization module is configured to synchronously update the correspondence relationship to at least one sub-database server in the sub-database database system that does not process the operation request; The sending module is configured to send the operation request to the target fragment database.

In a third aspect, an embodiment of the present invention provides a computer program, which is applied to a sub-database database system, where the computer program is configured to: when each sub-library server receives an operation request from a client, parsing the The query condition carried by the operation request; when the target fragment database needs to be calculated, the target fragment database corresponding to the operation request is calculated according to the query condition; and each of the database servers saves the query condition and the target fragment database Corresponding the relationship, and synchronously updating the corresponding relationship to at least one of the sub-database database systems that does not process the operation request; and sending the operation request to the target fragment database.

In a fourth aspect, an embodiment of the present invention provides a non-volatile computer storage medium, where Computer executable instructions, the computer executable instructions being applied to a library database system, the computer executable instructions being configured to: when each of the database servers receives an operation request from a client, parse the operation request to carry a query condition; when the target fragment database is to be calculated, the target fragment database corresponding to the operation request is calculated according to the query condition; and each of the database servers stores a correspondence between the query condition and the target fragment database. And updating the corresponding relationship to at least one of the sub-database database systems that does not process the operation request; and sending the operation request to the target fragment database.

In a fifth aspect, an embodiment of the present invention provides a database server system, including: L fragment databases and N database servers, wherein the L and N are natural numbers greater than 1; the library server includes: a first communication component, at least one first processor communicatively coupled to the first communication component; and a first memory communicatively coupled to the at least one first processor; wherein the first memory is a first instruction executed by the at least one first processor, the first instruction being executed by the at least one first processor to enable the at least one first processor to: pass the first communication When the component receives the operation request from the client, the query obtains the query condition carried by the operation request; when the target fragment database needs to be calculated, the target fragment database corresponding to the operation request is calculated according to the query condition; Querying a correspondence between the condition and the target fragmentation database, and transmitting the correspondence by the first communication component to synchronously update the correspondence to At least one sub-library server that does not process the operation request in the sub-database database system in which the library server is located; the operation request is sent by the first communication component to process the operation request by the target fragment database; the fragmentation The database includes: a second communication component, at least one second processor communicatively coupled to the second communication component; and a second memory communicatively coupled to the at least one second processor; wherein the second memory Storing a second instruction executable by the at least one second processor, the second instruction being executed by the at least one second processor to enable the at least one second processor to: pass the The second communication component receives and processes the operation request.

The sub-database database system and the routing method thereof provided by the embodiments of the present invention are provided according to requirements The operation request of the client is calculated and processed to be routed to the target shard database, and the corresponding relationship between the calculated operation request and the target shard database is locally saved, and simultaneously updated to at least one unprocessed operation in the database system. The requested sub-library server reduces the double counting of the same operation request by means of data synchronization between the plurality of sub-database servers in the sub-database database system, which helps to improve the processing efficiency of the sub-database database system.

In an embodiment, the corresponding relationship is synchronously updated to the at least one of the sub-database servers in the sub-database database system that does not process the operation request, and the corresponding relationship is synchronously updated to the sub-database database system. All sub-library servers for this operation request are not processed. Thereby the system has higher operating efficiency.

In an embodiment, updating the corresponding relationship to the at least one of the sub-databases in the sub-database database system that does not process the operation request, specifically: the sub-library server synchronously updates the corresponding relationship to the centralized a cache server; the centralized cache server synchronously updates the updated correspondence to at least one of the sub-library database systems that does not process the operation request. Data update relaying through the centralized cache server is beneficial to reduce the burden on each database server, and on the other hand, it is beneficial to save the calculation results for a long time.

In an embodiment, the centralized cache server synchronously updates the updated correspondence to at least one of the sub-database database systems that does not process the operation request, and specifically includes: the centralized cache The server issues an update message about the corresponding relationship; at least one of the database servers in the database database that has not processed the operation request performs synchronous update when listening to the update message issued by the centralized cache server. This allows data updates between the various library servers to be quickly synchronized.

DRAWINGS

1 is a flow chart of a routing method of a database system according to the prior art;

2 is a flow chart of a routing method of a database database system according to an embodiment of the present invention;

3 is a flow chart of a routing method of a binary database system according to an embodiment of the present invention;

4 is a schematic structural diagram of a three-part database system according to an embodiment of the present invention;

FIG. 5 is a schematic structural diagram of each of the sub-database servers of the three-part database system according to an embodiment of the present invention; FIG.

6 is a schematic structural diagram of a four-base database system according to an embodiment of the present invention;

7 is a schematic structural diagram of a four-branch server according to an embodiment of the present invention;

FIG. 8 is a schematic structural diagram of a five-pack library server according to an embodiment of the present invention; FIG.

9 is a block diagram showing the structure of a five-slice database according to an embodiment of the present invention.

detailed description

In order to make the objects, technical solutions and advantages of the present application more clear, some embodiments of the present invention will be described in detail below with reference to the accompanying drawings. However, it will be apparent to those skilled in the art that, in the various embodiments of the present invention, numerous technical details are set forth in order to provide a better understanding of the application. However, the technical solutions claimed in the present application can be implemented without these technical details and various changes and modifications based on the following embodiments.

Embodiment 1 of the present invention relates to a routing method of a database database system. By way of example and not limitation, the routing method of the database database system can be applied to applications of e-commerce, finance, telecommunications, and the like. The sub-database database system includes: L fragment databases and N branch servers, and L and N are natural numbers greater than 1. The N sub-database servers adopt the cluster deployment mode to route the target fragmentation database to the received operation request.

As shown in FIG. 2, the routing method of the database database system includes the following steps:

Step 201: When receiving the operation request from the client, each of the database servers parses the query condition carried by the operation request. For example, the operation request may carry an operation value for indicating an operation, a query condition for routing the fragmentation database, and a value corresponding to the query condition, etc. However, those skilled in the art will be aware of other variations of the information carried by the operational request.

Step 202: Locating the target fragment database in the local cache of the branch server according to the query condition.

Step 203: Determine whether the target fragment database is hit in the local cache.

Specifically, in the local cache of the database server, for example, a key value pair in which the value of the primary key field and the corresponding relationship of the fragment are stored, when the value passed in is the primary key value and the corresponding target fragment database is available, Hit the target fragment database corresponding to the operation request in the local cache. In this embodiment, if the target fragment database is not hit in the local cache of the database server according to the query condition, step 204 is performed; if the target fragment database is hit in the local cache of the database server according to the query condition, step 209 is performed. .

Step 204: Determine whether the query condition includes a primary key field. If the query condition includes the primary key field, step 206 is performed. In this embodiment, if the query condition does not include the primary key field, and the default query condition includes the segmentation route, step 205 is performed.

Step 205: Calculate the target fragment database according to the field value of the fragmentation route and the fragmentation policy supported by the database server.

Step 206: Calculate a target fragment database corresponding to the query condition according to the input value of the primary key field.

Those skilled in the art are aware that in the

steps

205, 206, the calculation method of the existing database database routing can be used for route calculation, and details are not described herein again. It is worth mentioning that when the target fragment database corresponding to the query condition is calculated according to the input value of the primary key field, the correspondence between the primary key field and the target fragment database is saved as a key value pair.

Step 207: Each sub-database server saves the correspondence between the query condition and the fragment database. In this embodiment, each of the database servers saves the correspondence between the query condition and the target fragment database to the local cache. That is, the correspondence between the query condition and the target fragment database is saved according to the calculation result of step 205 or step 206.

Step 208: Synchronously update the correspondence to at least one of the sub-database servers in the sub-database database system that does not process the operation request.

By way of example and not limitation, in this embodiment, the correspondence is synchronously updated to all the sub-database servers in the sub-database database system that have not processed the operation request. In other words, the correspondence is updated synchronously to the L-1 database servers that have not processed the operation request. In a clustered sub-library deployment scenario, the more sub-database servers, the stronger the routing capability of the database system and the faster the response. By synchronizing the operation request calculated by each sub-database server in real time with the corresponding result of the fragment database to other sub-library servers in the system, the number of repeated calculations when the system processes the same request can be reduced, which is equivalent to the synchronization to improve other sub-libraries. The processing speed of the server when processing the same request, thereby improving the processing speed of the system, and effectively saving valuable CPU resources and increasing the utilization rate of hardware resources in the case of high concurrent access.

Step 209: Send the operation request to the target shard database. That is, according to the operation request, the corresponding operations of adding, deleting, checking, changing, etc. are performed in the corresponding target fragment database (ie, a database in which the data tables are actually stored in the L fragment databases).

It should be noted that, in this embodiment, the client request may be forwarded by the load balancer to the branch server, so that the processing tasks of each branch server are better coordinated in a high concurrent scenario.

It is worth mentioning that, in this embodiment, the routing method of the database database system further includes the following steps: dynamically cleaning the local cache of the database server according to the frequency of use of the updated correspondence in the database server. Due to the limited storage capacity of the local cache of each sub-database server, and the local cache of a sub-database server is also synchronized with the calculation results of other sub-library servers, the amount of data stored in the sub-library server will increase rapidly, when the data in the local cache is cached. When the data is accumulated to a certain extent, the update cannot be synchronized. Therefore, the data in the local cache needs to be cleaned up in time. In this embodiment, the data is cleaned according to the frequency of use of the data in the local cache, and other local caches are known to those skilled in the art. Cleanup strategy, no longer repeat here.

In this embodiment, when the operation from the client is not hit in the local cache of the database server, please When the target fragment database is obtained, the calculation is performed according to the query condition parsed by the operation request, thereby obtaining the target fragment database corresponding to the query condition. In this embodiment, not only can the calculation result be locally cached, but also the calculation result can be synchronously updated to other sub-database servers, so that in the case of high concurrency, the same operation request can be performed once, which greatly reduces the amount of repetitive calculation. In turn, the task volume of each sub-database server is reduced, thereby facilitating the processing efficiency of the sub-database database system.

Embodiment 2 of the present invention relates to a routing method of a database database system. The second embodiment is substantially the same as the first embodiment. The main difference is that in the first embodiment, the synchronization between the query condition and the target server is directly updated between the database servers. In the second embodiment, the usage is centralized. The cache server updates the correspondence between the request and the fragment database to other sub-library servers.

As shown in FIG. 3, in this embodiment, steps 301 to 307 are the same as steps 201 to 207 in the first embodiment, and step 309 is the same as step 209 in the second embodiment. In step 308, in the step of synchronously updating the correspondence to at least one of the sub-database servers in the sub-database system that does not process the operation request, the following sub-steps are included:

Sub-step 3080: Each of the library servers synchronizes the correspondence to the centralized cache server.

Sub-step 3081: Synchronously update the correspondence of the centralized cache server update to at least one of the sub-library database systems that does not process the operation request.

In sub-step 3080, each of the library servers may save the correspondence to the centralized cache server in real time, and in sub-step 3081, the centralized cache server issues an update message regarding the corresponding relationship, which is not processed in the database system. All the sub-library servers of the operation request synchronize updates when they listen to the update message issued by the centralized cache server. Since the centralized cache server is added in this embodiment, the newly added correspondence in the local cache of each branch server can be conveniently updated to the concentrator cache server, and the centralized cache server is responsible for synchronizing the correspondence to Other sub-library servers that have not processed the operation request, thereby freeing each sub-library server from the burden of data synchronization between other sub-library servers in real time, reducing the sub-library services The complexity of server data synchronization.

It should be noted that, in this embodiment, the data (the corresponding relationship of the storage) in the centralized cache server is increased, which results in a large amount of disk space. Therefore, in this embodiment, the centralized The corresponding relationship saved by the cache server is cleaned up. Specifically, the following preset conditions may be adopted, such as: reaching a preset cleaning period or reaching a preset amount of saved data. When the preset condition is that the preset cleaning period is reached, the preset cleaning setting can be set to 1 month, so that the data in the centralized cache server is cleaned every month, when the preset condition is the preset save. When the amount of data is limited, the preset amount of data is, for example, 500 GB, so that the amount of data in the centralized cache server is prevented from being excessive.

In this embodiment, the centralized cache server saves the calculation result of each sub-database server, and then releases the update message to other sub-library servers, and the other sub-library servers can update the local cache when they are relatively idle, thereby making each Work can be done more harmoniously between the library servers. Moreover, due to the addition of the centralized cache server, the correspondence between the fragment database and the fragmentation field in a certain sub-database server may be changed when the entire sub-database database system performs sub-database and sub-table expansion. You can synchronize changes in one sub-library server to other sub-library servers through a centralized caching server.

The steps of the above various methods are divided for the sake of clarity of description. The implementation may be combined into one step or split into certain steps and decomposed into multiple steps, as long as the inclusion of the same logical relationship is within the scope of protection of this patent. The core design of adding insignificant modifications or introducing insignificant designs to an algorithm or process without changing its algorithms and processes is within the scope of this patent.

A third embodiment of the present invention relates to a sub-database database system, comprising: L fragment databases 1 and N branch servers 2, wherein L and N are natural numbers greater than one. As shown in FIGS. 4 and 5, the branch server 2 includes a parsing module 20, a computing module 21, a saving module 22, a synchronizing module 23, a transmitting module 24, and a local cache 25.

The parsing module is configured to parse the query condition carried by the operation request when the sub-database server receives the operation request from the client. The calculation module is configured to calculate a target fragment database, in this embodiment, the calculation module is configured to calculate a target corresponding to the operation request according to the query condition when the database server does not hit the target fragment database in the local cache. Fragment database. The saving module is configured to save the correspondence between the query condition and the target fragment database calculated by the calculation module to the local cache 25 of the branch server. The synchronization module is configured to synchronously update the correspondence to at least one of the sub-library database systems that does not process the operation request. In this embodiment, the synchronization module is configured to synchronously update the corresponding relationship to all the sub-database servers in the sub-database database system that have not processed the operation request. The sending module is used to send an operation request to the target shard database.

It is not difficult to find that the embodiment is a system embodiment corresponding to the first embodiment, and the embodiment can be implemented in cooperation with the first embodiment. The related technical details mentioned in the first embodiment are still valid in this embodiment, and are not described herein again in order to reduce the repetition. Correspondingly, the related technical details mentioned in this embodiment can also be applied in the first embodiment.

It is worth mentioning that each module involved in this embodiment is a logic module. In practical applications, a logical unit may be a physical unit, a part of a physical unit, or multiple physical entities. A combination of units is implemented. In addition, in order to highlight the innovative part of the present invention, the unit which is not closely related to solving the technical problem proposed by the present invention is not introduced in this embodiment, but this does not mean that there are no other units in this embodiment.

Embodiment 4 of the present invention relates to a sub-database database system. The fourth embodiment is substantially the same as the third embodiment. The main difference is that in the third embodiment, the database servers directly synchronize with each other. In the fourth embodiment, as shown in FIG. 6, the database database system further includes Centralized cache server 3. The synchronization module of each sub-database server 2 is configured to synchronously update the correspondence between the query condition and the target fragmentation database 1 to the centralized cache server 3, and synchronously update the corresponding relationship of the centralized cache server 3 update to the sub-database database system. All sub-library servers 2 for this operation request are not processed.

Since the second embodiment and the embodiment correspond to each other, the embodiment can be matched with the second embodiment. Implementation. The technical details mentioned in the second embodiment are still effective in this embodiment, and the technical effects that can be achieved in the second embodiment can also be implemented in the embodiment. To reduce the repetition, details are not described herein again. Correspondingly, the related technical details mentioned in this embodiment can also be applied in the second embodiment.

In a practical application, as shown in FIG. 7, the branch server may include: a processor, a memory, and a transceiver, and the memory and the transceiver are both connected to the processor. When the database server receives the operation request from the client, the processor parses the query condition from the operation request, and accesses the memory to determine whether the target fragment database corresponding to the query condition is stored in the memory, and is not checked in the memory. When the target fragment database corresponding to the query condition is obtained, the processor calculates the target fragment database according to the query condition. For example, the processor calculates the target fragment according to the incoming value of the fragment field in the query condition and the fragmentation strategy. The database or the target fragment database is calculated according to the incoming value of the primary key field in the query condition, and the processor sends the operation request to the corresponding target fragment database through the transceiver. At the same time, the processor saves the correspondence between the query condition and the calculated target fragment database into the memory, and sends the correspondence to the centralized cache server through the transceiver, and the processor sends the correspondence to the centralized cache. server. The centralized cache server stores the corresponding relationship and issues a message about the storage event to the other database server in the database database system that does not process the operation request, and the database server that listens to the message storing the event is centralized. The corresponding relationship is obtained in the cache server, and the corresponding relationship is stored in the local storage.

A fifth embodiment of the present invention relates to a library server system, comprising: L fragment databases and N database servers, wherein L and N are natural numbers greater than one.

As shown in FIG. 8, the branch server 800 includes: a first communication component 801, at least one first processor 802 communicatively coupled to the first communication component 801; and a first communication connection with the at least one first processor 801 Memory 803. One processor 802 is taken as an example in FIG. The processor 802, the memory 803, and the first communication component 801 may be connected by a bus or other means, and the bus connection is taken as an example in FIG.

The first memory 803 stores a first instruction that can be executed by one less first processor 802, and the first instruction is executed by the at least one first processor 802, so that the at least one first processor 802 can: pass the When the communication component 801 receives the operation request from the client, it parses the query condition carried by the operation request. When the target fragment database needs to be calculated, the target fragment database corresponding to the operation request is calculated according to the query condition. The corresponding relationship between the query condition and the target fragment database is saved, and the corresponding relationship is sent by the first communication component 801 to synchronously update the correspondence relationship, and at least one of the sub-database database systems in which the sub-database server is located does not process the operation request. . An operation request is sent by the first communication component to process the operation request by the target shard database.

The first memory 803 is used as a non-volatile computer readable storage medium, and can be used for storing a non-volatile software program, a non-volatile computer executable program, and a module, as in the routing method in the embodiment of the present invention. Corresponding program instructions/modules (for example, parsing module 20, computing module 21, saving module 22, synchronization module 23, and transmitting module 24 shown in FIG. 5). The processor 802 executes various functional applications and data processing of the library server by running the non-volatile software programs, instructions, and modules stored in the first memory 803, that is, the processing method of the routing method of the foregoing method embodiment.

The first memory 803 may include a storage program area and an storage data area, wherein the storage program area may store an operating system, an application required for at least one function; the storage data area may store data created by a processing method for the routing method, and the like. . Further, the first memory 803 may include a high speed random access memory, and may also include a nonvolatile memory such as at least one magnetic disk storage device, flash memory device, or other nonvolatile solid state storage device. The first communication component includes a high speed local area network.

The one or more modules are stored in the first memory 803, and when executed by the one or more first processors 802, perform a processing method of the routing method in any of the above method embodiments.

As shown in FIG. 9, the fragment database 900 includes: a second communication component 901, at least one second processor 903 communicatively coupled to the second communication component 902; and, with at least one second processor 902 is communicatively coupled to the second memory 903. The second memory 903 stores a second instruction executable by the at least one second processor 902, and the second instruction is executed by the at least one second processor 902 to enable the at least one second processor 902 to: pass the second The communication component receives and processes the operation request. The one or more second processors 902 and the second memory 903 are exemplified by a second processor 902 in FIG. The second processor 902, the second memory 903, and the second communication component 901 may be connected by a bus or other means, as exemplified by a bus connection in FIG.

The above product can perform the method provided by the embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method. For technical details that are not described in detail in this embodiment, reference may be made to the method provided by the embodiments of the present invention.

In this embodiment, when the target fragment database of the operation request from the client is not hit in the local cache of the database server, the query condition parsed according to the operation request is calculated, thereby obtaining the target fragment database corresponding to the query condition. In this embodiment, not only can the calculation result be locally cached, but also the calculation result can be synchronously updated to other sub-database servers, so that in the case of high concurrency, the same operation request can be performed once, which greatly reduces the amount of repetitive calculation. In turn, the task volume of each sub-database server is reduced, thereby facilitating the processing efficiency of the sub-database database system.

A ninth embodiment of the present invention is directed to a nonvolatile computer storage medium storing computer executable instructions that can execute the processing method of the routing method in any of the above method embodiments.

In this embodiment, not only can the calculation result be locally cached, but also the calculation result can be synchronously updated to other sub-database servers, so that in the case of high concurrency, the same operation request can be performed once, which greatly reduces the amount of repetitive calculation. In turn, the task volume of each sub-database server is reduced, thereby facilitating the processing efficiency of the sub-database database system.

A tenth embodiment of the present invention relates to a computer program capable of executing the routing method in any of the above method embodiments.

This embodiment can not only locally cache the calculation result, but also update the calculation result to other sub-library servers synchronously, so that in the case of high concurrency, the same operation request is performed once. The calculation can be done, which greatly reduces the amount of repetitive calculation, thereby reducing the task amount of each sub-database server, thereby facilitating the processing efficiency of the sub-database database system.

The device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separate, and the components displayed as units may or may not be physical units, ie may be located A place, or it can be distributed to multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the embodiment.

Through the description of the above embodiments, those skilled in the art can clearly understand that the various embodiments can be implemented by means of software plus a general hardware platform, and of course, by hardware. Based on such understanding, the above technical solutions may be embodied in the form of software products in essence or in the form of software products, which may be stored in a computer readable storage medium such as a ROM/RAM or a disk. , an optical disk, etc., includes instructions for causing a computer device (which may be a personal computer, server, or network device, etc.) to perform the methods described in various embodiments or portions of the embodiments.

It should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and are not limited thereto; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that The technical solutions described in the foregoing embodiments are modified, or the equivalents of the technical features are replaced. The modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

A routing method of a sub-database database system is applied to a sub-database database system, the sub-database database system comprises: L fragment databases and N sub-database servers, wherein the L and N are natural numbers greater than 1;

The routing method includes:

When receiving the operation request from the client, each of the database servers parses the query condition carried by the operation request;

When the target fragment database needs to be calculated, the target fragment database corresponding to the operation request is calculated according to the query condition; the each database server stores the correspondence between the query condition and the target fragment database, and the The corresponding relationship is synchronously updated to at least one of the sub-database servers in the sub-database database system that does not process the operation request;

The operation request is sent to the target shard database.
The routing method of the database database system according to claim 1, wherein

Updating the corresponding relationship to the at least one of the sub-database servers in the sub-database database system that does not process the operation request, and updating the corresponding relationship to the un-processed database system All sub-library servers.
The routing method of the sub-database database system according to claim 1 or 2, wherein the updating of the correspondence to the at least one of the sub-databases in the sub-database database system that does not process the operation request comprises:

The branch server synchronously updates the correspondence to a centralized cache server;

The centralized cache server synchronously updates the updated correspondence to at least one of the sub-database databases that does not process the operation request.
The routing method of the database database system according to claim 3, wherein

The centralized cache server synchronously updates the updated correspondence to at least one of the sub-library database systems that does not process the operation request, and specifically includes:

The centralized cache server issues an update message regarding the correspondence relationship;

At least one of the sub-database servers in the database database system that does not process the operation request performs synchronous update when listening to the update message issued by the centralized cache server.
The routing method of the database database system according to any one of claims 1 to 4, further comprising:

After the parsing obtains the query condition carried by the operation request, locate the target fragment database in a local cache of the branch server according to the query condition;

If the target fragment database is not hit in the local cache according to the query condition, the target fragment database needs to be calculated;

If the target shard database is hit in the local cache according to the query condition, the operation request is sent to the target shard database.
The routing method of the database database system according to any one of claims 1 to 5, further comprising: before calculating the target fragment database corresponding to the operation request according to the query condition,

Determining whether the query condition includes a primary key field;

If the query condition does not include a primary key field, the target fragment database is calculated according to the field value of the fragmentation route in the query condition and the fragmentation policy supported by the database server;

If the query condition includes a primary key field, the target fragment database corresponding to the primary key field is calculated according to the incoming value of the primary key field.
The routing method of the database database system according to claim 6, wherein

Calculating target fragment data corresponding to the primary key field according to an incoming value of the primary key field After the library, it also includes:

The target fragment database corresponding to the primary key field and the primary key field is saved as a key value pair.
The routing method of the sub-database database system according to any one of claims 3 to 7, wherein after the correspondence is synchronously updated to at least one of the sub-database servers in the sub-database system that has not processed the operation request ,Also includes:

The corresponding relationship saved by the centralized cache server is cleared according to a preset condition, where the preset condition includes: reaching a preset cleaning period or reaching a preset saved data amount.
A sub-database database system, comprising: L fragment databases and N sub-database servers, wherein the L and N are natural numbers greater than 1; wherein the sub-database server comprises a parsing module, a computing module, a saving module, Synchronization module and transmission module;

The parsing module is configured to parse the query condition carried by the operation request when receiving an operation request from a client;

The calculating module is configured to calculate, according to the query condition, a target fragment database corresponding to the operation request when the target fragment database needs to be calculated;

The saving module is configured to save the correspondence between the query condition calculated by the calculating module and the target fragment database to the local cache of the library server;

The synchronization module is configured to synchronously update the correspondence relationship to at least one of the sub-database database systems that does not process the operation request;

The sending module is configured to send the operation request to the target fragment database.
The sub-database database system according to claim 9, wherein said sub-database database system further comprises a centralized cache server;

The synchronization module is configured to synchronously update the correspondence to a centralized cache server, and the centralized cache server synchronously updates the updated correspondence to at least one unprocessed operation request in the database system. Sub-library server.
A computer program for use in a sub-database database system for controlling:

When receiving the operation request from the client, each of the database servers parses the query condition carried by the operation request;

When the target fragment database needs to be calculated, the target fragment database corresponding to the operation request is calculated according to the query condition; the each database server stores the correspondence between the query condition and the target fragment database, and the The corresponding relationship is synchronously updated to at least one of the sub-database servers in the sub-database database system that does not process the operation request;

The operation request is sent to the target shard database.
A non-volatile computer storage medium storing computer-executable instructions, the computer-executable instructions being applied to a sub-database database system, the computer-executable instructions being set to:

When receiving the operation request from the client, each of the database servers parses the query condition carried by the operation request;

When the target fragment database needs to be calculated, the target fragment database corresponding to the operation request is calculated according to the query condition; the each database server stores the correspondence between the query condition and the target fragment database, and the The corresponding relationship is synchronously updated to at least one of the sub-database servers in the sub-database database system that does not process the operation request;

The operation request is sent to the target shard database.
A library server system, comprising: L fragment databases and N database servers,

The L and N are both natural numbers greater than one;

The library server includes: a first communication component, at least one first processor communicatively coupled to the first communication component; and a first memory communicatively coupled to the at least one first processor;

The first memory stores a first instruction executable by the at least one first processor, The first instruction is executed by the at least one first processor to enable the at least one first processor to:

When receiving an operation request from the client by using the first communication component, parsing the query condition carried by the operation request;

When the target fragment database needs to be calculated, the target fragment database corresponding to the operation request is calculated according to the query condition;

Saving a correspondence between the query condition and the target fragment database, and sending the correspondence by the first communication component to synchronously update the correspondence to at least one of the database system in which the database server is located The sub-library server that did not process the operation request;

Transmitting the operation request by the first communication component to process the operation request by the target fragment database;

The fragment database includes: a second communication component, at least one second processor communicatively coupled to the second communication component; and a second memory communicatively coupled to the at least one second processor;

The second memory stores a second instruction executable by the at least one second processor, the second instruction being executed by the at least one second processor to enable the at least one second processor to :

The operation request is received and processed by the second communication component.