Method and apparatus for unified synchronization management of multiple service databases

Abstract

The present disclosure relates to the technical field of data processing, and provides a method and device for unified synchronization management of multiple business databases. The method includes: real-time monitoring whether the data in multiple business databases under a target user changes, and determining the changed data in each business database; when the mark of the changed data in each business database is important data, synchronizing the changed data in each business database to a unified management database under the target user; when the mark of the changed data in each business database is ordinary data and the data volume of the changed data in each business database is greater than a preset data volume, synchronizing the changed data in each business database to a unified management database under the target user. By adopting the above technical means, the problem that multiple business databases of the same user cannot be unified and synchronously managed in the prior art is solved.

Description

Technical Field

[0001] The present disclosure relates to the technical field of data processing, and in particular, to a method and apparatus for unified synchronization management of multiple service databases. Background Art

[0002] Currently, most companies have diversified businesses, numerous systems, and a large number of corresponding technology stacks, so they use a large number of databases. Usually, each business has a business database, and a company with multiple businesses needs to run multiple business databases. When the business data in a business database changes, the company's technical personnel usually only focus on whether their own business is running healthily and do not pay attention to other businesses. When it is necessary to synchronize the changed data, they only synchronize the changed data of their own business database. However, in fact, each business database is the data asset of the company. There is an urgent need for a method for unified synchronization management of multiple business databases of the same user.

[0003] In the process of implementing the concept of the present disclosure, the inventors found that there are at least the following technical problems in the related art: the problem that multiple business databases of the same user cannot be unified and synchronously managed. Summary of the Invention

[0004] In view of this, embodiments of the present disclosure provide a method, apparatus, electronic device, and computer-readable storage medium for unified synchronization management of multiple service databases to solve the problem in the prior art that multiple service databases of the same user cannot be unified and synchronously managed.

[0005] In a first aspect of the embodiments of the present disclosure, a method for unified synchronization management of multiple service databases is provided, including: real-time monitoring whether the data in multiple service databases under a target user changes, and determining the changed data in each service database; when the mark of the changed data in each service database is important data, synchronizing the changed data in each service database to a unified management database under the target user; when the mark of the changed data in each service database is normal data and the data volume of the changed data in each service database is greater than a preset data volume, synchronizing the changed data in each service database to a unified management database under the target user.

[0006] In a second aspect of the embodiments of the present disclosure, there is provided an apparatus for unified synchronization management of multiple service databases, including: a monitoring module configured to monitor in real time whether the data in multiple service databases under a target user has changed, and determine the changed data in each service database; a first synchronization module configured to, when the marked changed data in each service database is important data, synchronize the changed data in each service database to a unified management database under the target user; a second synchronization module configured to, when the marked changed data in each service database is ordinary data and the data volume of the changed data in each service database is greater than a preset data volume, synchronize the changed data in each service database to a unified management database under the target user.

[0007] In a third aspect of the embodiments of the present disclosure, there is provided an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the steps of the above method are implemented.

[0008] In a fourth aspect of the embodiments of the present disclosure, there is provided a computer-readable storage medium storing a computer program, and when the computer program is executed by a processor, the steps of the above method are implemented.

[0009] The beneficial effects of the embodiments of the present disclosure compared with the prior art are as follows: monitoring in real time whether the data in multiple service databases under a target user has changed, and determining the changed data in each service database; when the marked changed data in each service database is important data, synchronizing the changed data in each service database to a unified management database under the target user; when the marked changed data in each service database is ordinary data and the data volume of the changed data in each service database is greater than a preset data volume, synchronizing the changed data in each service database to a unified management database under the target user. By adopting the above technical means, the problem that multiple service databases of the same user cannot be unified and synchronized for management in the prior art can be solved, and thus a method for unified synchronization management of multiple service databases is provided. BRIEF DESCRIPTION OF THE DRAWINGS

[0010] In order to more clearly illustrate the technical solutions in the embodiments of the present disclosure, the following will briefly introduce the drawings required for use in the embodiments or the description of the prior art. Obviously, the following drawings are only some embodiments of the present disclosure. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative efforts.

[0011] Figure 1 It is a schematic diagram of the application scenario of the embodiments of the present disclosure;

[0012] Figure 2 It is a schematic flowchart of a method for unified synchronization management of multiple service databases provided by an embodiment of the present disclosure;

[0013] Figure 3 It is a schematic structural diagram of a device for unified synchronization management of multiple service databases provided by an embodiment of the present disclosure;

[0014] Figure 4 It is a schematic structural diagram of an electronic device provided by an embodiment of the present disclosure. Detailed implementation manners

[0015] In the following description, specific details such as specific system structures and technologies are presented for the purpose of illustration rather than limitation, so as to thoroughly understand the embodiments of the present disclosure. However, those skilled in the art should clearly understand that the present disclosure can also be implemented in other embodiments without these specific details. In other cases, detailed descriptions of well-known systems, devices, circuits, and methods are omitted to avoid unnecessary details from interfering with the description of the present disclosure.

[0016] A method and a device for unified synchronization management of multiple service databases according to an embodiment of the present disclosure will be described in detail below with reference to the accompanying drawings.

[0017] Figure 1 It is a schematic diagram of an application scenario of an embodiment of the present disclosure. The application scenario may include terminal devices 101, 102, and 103, a server 104, and a network 105.

[0018] The terminal devices 101, 102, and 103 may be hardware or software. When the terminal devices 101, 102, and 103 are hardware, they may be various electronic devices with a display screen and supporting communication with the server 104, including but not limited to smart phones, robots, laptop computers, and desktop computers, etc. (for example, 102 may be a robot); when the terminal devices 101, 102, and 103 are software, they may be installed in the above-mentioned electronic devices. The terminal devices 101, 102, and 103 may be implemented as multiple software or software modules, or may be implemented as a single software or software module, and the embodiments of the present disclosure do not limit this. Further, various applications may be installed on the terminal devices 101, 102, and 103, such as data processing applications, instant messaging tools, social platform software, search applications, shopping applications, etc.

[0019] Server 104 may be a server that provides various services. For example, it may be a background server that receives requests sent by terminal devices with which it establishes a communication connection. The background server can receive and analyze requests sent by terminal devices and generate processing results. Server 104 may be a single server, a server cluster composed of several servers, or a cloud computing service center. The embodiments of the present disclosure do not limit this.

[0020] It should be noted that server 104 may be hardware or software. When server 104 is hardware, it may be various electronic devices that provide various services for terminal devices 101, 102, and 103. When server 104 is software, it may be multiple software or software modules that provide various services for terminal devices 101, 102, and 103, or a single software or software module that provides various services for terminal devices 101, 102, and 103. The embodiments of the present disclosure do not limit this.

[0021] Network 105 may be a wired network connected by coaxial cables, twisted pairs, and optical fibers, or a wireless network that can interconnect various communication devices without wiring, such as Bluetooth, Near Field Communication (NFC), Infrared, etc. The embodiments of the present disclosure do not limit this.

[0022] The target user can establish a communication connection with server 104 via terminal devices 101, 102, and 103 through network 105 to receive or send information, etc. It should be noted that the specific types, quantities, and combinations of terminal devices 101, 102, and 103, server 104, and network 105 can be adjusted according to the actual needs of the application scenario. The embodiments of the present disclosure do not limit this.

[0023] Figure 2 It is a schematic flowchart of a method for unified synchronization management of multiple service databases provided by the embodiments of the present disclosure. Figure 2 The method for unified synchronization management of multiple service databases can be executed by Figure 1 the terminal device or server of Figure 2 As shown in

[0024] S201, real-time monitor whether the data in multiple service databases under the target user has changed, and determine the changed data in each service database;

[0025] S202, when the mark of the changed data in each business database is important data, synchronize the changed data in each business database to the unified management database under the target user;

[0026] S203, when the mark of the changed data in each business database is ordinary data and the data volume of the changed data in each business database is greater than the preset data volume, synchronize the changed data in each business database to the unified management database under the target user.

[0027] For example, the target user is a company providing robot services. The operations of this company include: the business of delivering items using robots, the business of cleaning the environment using robots, and the business of interacting with people using robots. Then this company has three business databases: the robot delivery business database, the robot cleaning business database, and the robot interaction business database. The prior art can only synchronize and manage the changed data in each business database separately. The embodiment of the present disclosure is to add a unified management database that can aggregate the data of all business databases, and then use the unified management database to uniformly synchronize and manage the changed data in all business databases under the target user.

[0028] For any one of the business databases: regardless of how much the important data changes, it needs to be synchronized to the unified management database under the target user in a timely manner, while only when the changed data volume of the ordinary data is greater than the preset data volume, will it be synchronized to the unified management database under the target user. Through this technical means, the efficiency of synchronizing data can be improved.

[0029] According to the technical solution provided by the embodiment of the present disclosure, monitor in real time whether the data in multiple business databases under the target user has changed, and determine the changed data in each business database; when the mark of the changed data in each business database is important data, synchronize the changed data in each business database to the unified management database under the target user; when the mark of the changed data in each business database is ordinary data and the data volume of the changed data in each business database is greater than the preset data volume, synchronize the changed data in each business database to the unified management database under the target user. By adopting the above technical means, the problem that multiple business databases of the same user cannot be uniformly synchronized and managed in the prior art can be solved, and thus a method for uniformly synchronizing and managing multiple business databases is provided.

[0030] Before synchronizing the changed data in each business database to the unified management database under the target user, the method further includes: generating, in the unified management database, an information table book corresponding to the business database according to the identification number of each business database, where each information table book includes multiple sub-tables, and the sub-table identifier of each sub-table is determined by the identification number of the business database corresponding to the sub-table and the sub-table index; extracting the business data stored in the business database from each business database; and storing the business data extracted from each business database into the information table book corresponding to the business database.

[0031] In the unified management database, each business database corresponds to an information table book and multiple sub-tables in the corresponding information table book. Each time there is changed data in the business database, only the sub-table corresponding to the changed data needs to be processed. In the embodiments of the present disclosure, by storing a part of the data in one sub-table, the workload of synchronizing data each time is reduced, and the efficiency of synchronizing data is improved.

[0032] Synchronizing the changed data in each business database to the unified management database under the target user includes: for each business database: when the type of the changed data in the business database is new data, creating a new sub-table in the unified management database for the changed data and storing the changed data in the newly created sub-table; when the type of the changed data in the business database is deleted data, deleting the sub-table storing the changed data in the unified management database; when the type of the changed data in the business database is modified data, modifying the sub-table storing the changed data in the unified management database.

[0033] Synchronizing the changed data in each business database to the unified management database under the target user includes: for each business database: determining the first starting position of the changed data of the business database in the business database and determining the identification number of the business database; dividing the first starting position by a preset sub-table size to obtain a sub-table index, taking the remainder of the first starting position with respect to the preset sub-table size to obtain a storage offset, determining a sub-table identifier using the identification number of the business database and the sub-table index, and determining the second starting position in the target sub-table corresponding to the sub-table identifier where the changed data of the business database is to be stored according to the storage offset; and synchronizing the changed data of the business database starting from the second starting position in the target sub-table.

[0034] The first starting position is the starting position of the changed data in the business database, and the second starting position is the starting position where the changed data is stored in the target sub-table in the information table corresponding to the business database in the unified management database. For example, if the first starting position is the 2000th data and the preset sub-table size is 500 data, then the sub-table index can be 0004. The preset sub-table size indicates the maximum number of data that a sub-table can store. The identification number of the business database is, for example, 0012, then the sub-table identification is 00120004, and the target sub-table corresponding to 00120004 is the sub-table corresponding to the changed data.

[0035] In an alternative embodiment, it includes: determining whether the data in the currently polled business database has changed through a polling mechanism, and when the data in the currently polled business database has changed, determining the changed data in the currently polled business database; determining whether the changed data in the currently polled business database meets a preset condition, and when the preset condition is met, synchronizing the changed data in the currently polled business database to the unified management database under the target user; continuing to synchronize the changed data of the next polled business database through the polling mechanism until all the changed data of all business databases is synchronized through the polling mechanism.

[0036] Determining whether the changed data in the currently polled business database meets a preset condition includes: when the mark of the changed data in the currently polled business database is important data, determining that the changed data in the currently polled business database meets the preset condition; when the mark of the changed data in the currently polled business database is ordinary data, but the data volume of the changed data in the currently polled business database is greater than the preset data volume, determining that the changed data in the currently polled business database meets the preset condition.

[0037] When the mark of the changed data in the currently polled business database is ordinary data, but the data volume of the changed data in the currently polled business database is less than or equal to the preset data volume, it is determined that the changed data in the currently polled business database does not meet the preset condition.

[0038] In an alternative embodiment, it includes: when the marks of the changed data in each business database are ordinary data and the data volumes of the changed data in each business database are less than or equal to the preset data volume, ignoring the changed data in each business database and not synchronizing the changed data in each business database to the unified management database under the target user.

[0039] All the above alternative technical solutions can be combined arbitrarily to form alternative embodiments of the present application, which will not be elaborated here one by one.

[0040] The following are embodiments of the disclosed apparatus, which can be used to implement the embodiments of the disclosed method. For details not disclosed in the embodiments of the disclosed apparatus, please refer to the embodiments of the disclosed method.

[0041] Figure 3 It is a schematic diagram of an apparatus for unified synchronization management of multiple service databases provided by an embodiment of the present disclosure. As Figure 3 shown, the apparatus for unified synchronization management of multiple service databases includes:

[0042] A monitoring module 301, configured to monitor in real time whether the data in multiple service databases under a target user has changed, and determine the changed data in each service database;

[0043] A first synchronization module 302, configured to synchronize the changed data in each service database to a unified management database under the target user when the flag of the changed data in each service database is important data;

[0044] A second synchronization module 303, configured to synchronize the changed data in each service database to a unified management database under the target user when the flag of the changed data in each service database is ordinary data and the data volume of the changed data in each service database is greater than a preset data volume.

[0045] For example, the target user is a company providing robot services. The operations of the company include: the business of delivering items using robots, the business of cleaning the environment using robots, and the business of interacting with people using robots. Then the company has three service databases: the robot delivery service database, the robot cleaning service database, and the robot interaction service database. The prior art can only synchronize and manage the changed data in each service database separately. The embodiments of the present disclosure add a unified management database that can aggregate the data of all service databases, and then use the unified management database to uniformly synchronize and manage the changed data in all service databases under the target user.

[0046] For any one of the service databases: regardless of how much the important data changes, it needs to be synchronized to the unified management database under the target user in a timely manner, while only when the changed data volume of the ordinary data is greater than the preset data volume, will it be synchronized to the unified management database under the target user. Through this technical means, the efficiency of synchronizing data can be improved.

[0047] According to the technical solution provided by the embodiments of the present disclosure, it is to monitor in real time whether the data in multiple business databases under the target user changes, and determine the changed data in each business database; when the label of the changed data in each business database is important data, synchronize the changed data in each business database to the unified management database under the target user; when the label of the changed data in each business database is ordinary data, and the data volume of the changed data in each business database is greater than the preset data volume, synchronize the changed data in each business database to the unified management database under the target user. By adopting the above technical means, the problem that multiple business databases of the same user cannot be uniformly synchronized and managed in the prior art can be solved, and thus a method for uniformly synchronizing and managing multiple business databases is provided.

[0048] Optionally, the first synchronization module 302 is further configured to generate an information table book corresponding to the business database in the unified management database according to the identification number of each business database, where each information table book includes multiple sub-tables, and the sub-table identifier of each sub-table is determined by the identification number of the business database corresponding to the sub-table and the sub-table index; extract the business data stored in the business database from each business database; and store the business data extracted from each business database into the information table book corresponding to the business database.

[0049] In the unified management database, each business database corresponds to an information table book, corresponding to the multiple sub-tables in the information table book. Each time there is changed data in the business database, only the sub-table corresponding to the changed data needs to be processed. The embodiments of the present disclosure reduce the workload of synchronizing data each time and improve the efficiency of synchronizing data by storing a part of the data in one sub-table.

[0050] Optionally, the first synchronization module 302 is further configured to, for each business database: when the type of the changed data in the business database is new data, create a new sub-table in the unified management database for the changed data, and store the changed data into the newly created sub-table; when the type of the changed data in the business database is deleted data, delete the sub-table storing the changed data in the unified management database; when the type of the changed data in the business database is modified data, modify the sub-table storing the changed data in the unified management database.

[0051] Optionally, the first synchronization module 302 is further configured to, for each service database: determine a first starting position of the changed data of the service database in the service database, and determine an identification number of the service database; divide the first starting position by a preset sub-table size to obtain a sub-table index, take the remainder of the first starting position with respect to the preset sub-table size to obtain a storage offset, determine a sub-table identifier using the identification number of the service database and the sub-table index, and determine a second starting position in the target sub-table corresponding to the sub-table identifier where the changed data of the service database is to be stored according to the storage offset; synchronize the changed data of the service database starting from the second starting position in the target sub-table.

[0052] The first starting position is the starting position of the changed data in the service database, and the second starting position is the starting position in the target sub-table of the information table corresponding to the service database in the unified management database where the changed data is stored. For example, if the first starting position is the 2000th data and the preset sub-table size is 500 data, then the sub-table index can be 0004, and the preset sub-table size indicates the maximum number of data that a sub-table can store. The identification number of the service database is, for example, 0012, then the sub-table identifier is 00120004, and the target sub-table corresponding to 00120004 is the sub-table corresponding to the changed data.

[0053] Optionally, the first synchronization module 302 is further configured to determine whether the data in the currently polled service database has changed through a polling mechanism, and when the data in the currently polled service database has changed, determine the changed data in the currently polled service database; determine whether the changed data in the currently polled service database meets a preset condition, and when the preset condition is met, synchronize the changed data in the currently polled service database to the unified management database under the target user; continue to synchronize the changed data of the next polled service database through the polling mechanism until all the changed data of all service databases is synchronized through the polling mechanism.

[0054] Optionally, the first synchronization module 302 is further configured to determine that the changed data in the currently polled service database meets the preset condition when the mark of the changed data in the currently polled service database is important data; determine that the changed data in the currently polled service database meets the preset condition when the mark of the changed data in the currently polled service database is normal data, but the data volume of the changed data in the currently polled service database is greater than the preset data volume.

[0055] When the mark of the changed data in the currently polled service database is normal data, but the data volume of the changed data in the currently polled service database is less than or equal to the preset data volume, it is determined that the changed data in the currently polled service database does not meet the preset condition.

[0056] Optionally, the first synchronization module 302 is further configured to ignore the changed data in each service database and not synchronize the changed data in each service database to the unified management database under the target user when the flag of the changed data in each service database is normal data and the data volume of the changed data in each service database is less than or equal to a preset data volume.

[0057] It should be understood that the sequence numbers of the steps in the above embodiments do not mean the order of execution. The execution order of each process should be determined according to its function and internal logic, and should not constitute any limitation to the implementation process of the embodiments of the present disclosure.

[0058] Figure 4 is a schematic diagram of the electronic device 4 provided by the embodiments of the present disclosure. As Figure 4 shown, the electronic device 4 of this embodiment includes: a processor 401, a memory 402, and a computer program 403 stored in the memory 402 and executable on the processor 401. When the processor 401 executes the computer program 403, the steps in the above method embodiments are implemented. Alternatively, when the processor 401 executes the computer program 403, the functions of each module / unit in the above device embodiments are implemented.

[0059] Exemplarily, the computer program 403 may be divided into one or more modules / units. The one or more modules / units are stored in the memory 402 and executed by the processor 401 to complete the present disclosure. The one or more modules / units may be a series of computer program instruction segments capable of performing specific functions, and the instruction segments are used to describe the execution process of the computer program 403 in the electronic device 4.

[0060] The electronic device 4 may be a desktop computer, a notebook, a palm computer, a cloud server, or other electronic devices. The electronic device 4 may include, but is not limited to, the processor 401 and the memory 402. Those skilled in the art can understand that Figure 4 merely examples of the electronic device 4 do not constitute a limitation to the electronic device 4, and may include more or fewer components than shown in the figure, or combine some components, or different components. For example, the electronic device may further include input / output devices, network access devices, a bus, etc.

[0061] The processor 401 can be a Central Processing Unit (CPU), or other general-purpose processors, Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field-Programmable Gate Arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor can be a microprocessor or any conventional processor, etc.

[0062] The memory 402 can be an internal storage unit of the electronic device 4, for example, the hard disk or memory of the electronic device 4. The memory 402 can also be an external storage device of the electronic device 4, for example, a plug-in hard disk equipped on the electronic device 4, a Smart Media Card (SMC), a Secure Digital (SD) card, a Flash Card, etc. Further, the memory 402 can also include both the internal storage unit and the external storage device of the electronic device 4. The memory 402 is used to store computer programs and other programs and data required by the electronic device. The memory 402 can also be used to temporarily store data that has been output or will be output.

[0063] Those skilled in the art can clearly understand that, for the convenience and brevity of description, only the above division of each functional unit and module is used as an example. In actual applications, the above functions can be allocated to different functional units and modules as needed, that is, the internal structure of the device is divided into different functional units or modules to complete all or part of the functions described above. Each functional unit and module in the embodiments can be integrated into a processing unit, or each unit can exist physically alone, or two or more units can be integrated into one unit. The above integrated units can be implemented in the form of hardware or in the form of software functional units. In addition, the specific names of each functional unit and module are only for the convenience of mutual distinction and do not limit the protection scope of this application. The specific working processes of the units and modules in the above system can refer to the corresponding processes in the foregoing method embodiments and will not be elaborated herein.

[0064] In the above embodiments, the descriptions of the various embodiments have their own emphases. For the parts not detailed or recorded in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0065] Those of ordinary skill in the art will realize that the units and algorithm steps of each example described in combination with the embodiments disclosed herein can be implemented by electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are executed in hardware or software depends on the specific application and design constraints of the technical solution. A professional technician can use different methods for each specific application to implement the described functions, but such implementation should not be considered to exceed the scope of this disclosure.

[0066] In the embodiments provided in this disclosure, it should be understood that the disclosed apparatus / electronic device and method can be implemented in other ways. For example, the apparatus / electronic device embodiments described above are merely illustrative. For example, the division of modules or units is only a logical function division. In actual implementation, there may be other division methods. Multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the displayed or discussed coupling or direct coupling or communication connection between each other can be through some interfaces. The indirect coupling or communication connection of the apparatus or unit can be in an electrical, mechanical or other form.

[0067] The units described as separate components may or may not be physically separated. The components displayed as units may or may not be physical units, that is, they can be located in one place, or they can be distributed to multiple network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0068] In addition, the functional units in each embodiment of this disclosure can be integrated into one processing unit, or each unit can exist physically alone, or two or more units can be integrated into one unit. The above integrated units can be implemented in the form of hardware or in the form of software functional units.

[0069] When the integrated module / unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on such understanding, to implement all or part of the processes in the above-described embodiment methods of the present disclosure, it can also be completed by instructing relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium. When the computer program is executed by a processor, the steps of the above-described various method embodiments can be implemented. The computer program can include computer program code, and the computer program code can be in the form of source code, object code, executable file, or some intermediate form, etc. The computer-readable medium can include: any entity or device capable of carrying the computer program code, recording medium, USB flash drive, mobile hard disk, magnetic disk, optical disc, computer memory, read-only memory (ROM), random access memory (RAM), electrical carrier signal, telecommunication signal, and software distribution medium, etc. It should be noted that the content included in the computer-readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practice within the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, the computer-readable medium does not include electrical carrier signals and telecommunication signals.

[0070] The above embodiments are only used to illustrate the technical solutions of the present disclosure, rather than to limit them; although the present disclosure has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that: they can still modify the technical solutions recorded in the foregoing embodiments, or perform equivalent replacements for some of the technical features; and these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the various embodiments of the present disclosure, and should all be included within the protection scope of the present disclosure.

Claims

1. A method for unified synchronization management of multiple service databases, characterized in that, Including: Real-time monitor whether the data in multiple business databases under the target user has changed, and determine the changed data in each business database; When the marked changed data in each business database is important data, synchronize the changed data in each business database to the unified management database under the target user; When the marked changed data in each business database is ordinary data and the data volume of the changed data in each business database is greater than the preset data volume, synchronize the changed data in each business database to the unified management database under the target user; The synchronizing the changed data in each business database to the unified management database under the target user includes: For each business database: Determine the first starting position of the changed data of the business database in the business database, and determine the identification number of the business database; Divide the first starting position by the preset sub-table size to obtain a sub-table index, take the remainder of the first starting position with respect to the preset sub-table size to obtain a storage offset, determine a sub-table identifier using the identification number of the business database and the sub-table index, and determine the second starting position in the target sub-table corresponding to the sub-table identifier in the unified management database where the changed data of the business database is to be stored according to the storage offset; Synchronize the changed data of the business database starting from the second starting position in the target sub-table.

2. The method according to claim 1, characterized in that, The synchronizing the changed data in each business database to the unified management database under the target user includes: For each business database: When the type of the changed data in the business database is new data, create a new sub-table for the changed data in the unified management database and store the changed data in the newly created sub-table; When the type of the changed data in the business database is deleted data, delete the sub-table storing the changed data in the unified management database; When the type of the changed data in the business database is modified data, modify the sub-table storing the changed data in the unified management database.

3. The method according to claim 1, characterized in that, Before synchronizing the changed data in each business database to the unified management database under the target user, the method further includes: Generate an information table book corresponding to the business database in the unified management database according to the identification number of each business database, where each information table book contains multiple sub-tables, and the sub-table identifier of each sub-table is determined by the identification number of the business database corresponding to the sub-table and the sub-table index; Extract the business data stored in each business database from each business database; Store the business data extracted from each business database into the information table book corresponding to the business database.

4. The method according to claim 1, wherein Including: Judge whether the data in the currently polled business database has changed through a polling mechanism, and when the data in the currently polled business database has changed, determine the changed data in the currently polled business database; Determine whether the changed data in the business database polled currently meets the preset conditions. When the preset conditions are met, synchronize the changed data in the business database polled currently to the unified management database under the target user; Continue to synchronize the changed data of the next polled business database through the polling mechanism until all the changed data of all business databases are synchronized through the polling mechanism.

5. The method according to claim 4, wherein The determination of whether the changed data in the business database polled currently meets the preset conditions includes: When the label of the changed data in the business database polled currently is important data, determine that the changed data in the business database polled currently meets the preset conditions; When the label of the changed data in the business database polled currently is ordinary data, but the data volume of the changed data in the business database polled currently is greater than the preset data volume, determine that the changed data in the business database polled currently meets the preset conditions.

6. The method according to claim 1, wherein Include: When the label of the changed data in each business database is ordinary data, and the data volume of the changed data in each business database is less than or equal to the preset data volume, ignore the changed data in each business database and do not synchronize the changed data in each business database to the unified management database under the target user.

7. An apparatus for unified synchronization management of multiple service databases, characterized in that, Include: A monitoring module, configured to monitor in real time whether the data in multiple business databases under the target user has changed, and determine the changed data in each business database; A first synchronization module, configured to synchronize the changed data in each business database to the unified management database under the target user when the label of the changed data in each business database is important data; A second synchronization module, configured to synchronize the changed data in each business database to the unified management database under the target user when the label of the changed data in each business database is ordinary data, and the data volume of the changed data in each business database is greater than the preset data volume; Among them, the synchronization of the changed data in each business database to the unified management database under the target user includes: for each business database: determine the first starting position of the changed data of the business database in the business database, and determine the identification number of the business database; divide the first starting position by the preset sub-table size to obtain a sub-table index, take the remainder of the first starting position with respect to the preset sub-table size to obtain a storage offset, determine a sub-table identifier using the identification number of the business database and the sub-table index, and determine the second starting position in the target sub-table corresponding to the sub-table identifier in the unified management database where the changed data of the business database is to be stored according to the storage offset; synchronize the changed data of the business database starting from the second starting position in the target sub-table.

8. An electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the computer program, it implements the steps of the method according to any one of claims 1 to 6.

9. A computer-readable storage medium storing a computer program, characterized in that, When the computer program is executed by the processor, it implements the steps of the method according to any one of claims 1 to 6.

Images