An information synchronization updating method and device, equipment and storage medium

By generating unitized text and processing data files line by line, the problem of low efficiency in information synchronization and updating in distributed databases is solved, and simple and fast information synchronization and updating is achieved.

CN116737739BActive Publication Date: 2026-07-24BANK OF CHINA
View PDF 3 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
BANK OF CHINA
Filing Date
2023-06-19
Publication Date
2026-07-24

AI Technical Summary

Technical Problem

Existing information synchronization and update methods are inefficient in distributed databases, especially when there is a lot of information to update. Sending data via MQ message queues has low reliability, high performance requirements, and consumes a lot of resources to traverse all distributed databases for updates.

Method used

Based on the relationship between the head office and branches, unitized text is generated. After merging the text, the data file is processed line by line. The distributed database of the target branch is determined according to the database sharding and table partitioning rules, and the information is updated synchronously.

Benefits of technology

It simplifies the information synchronization and update process, improves efficiency, and ensures the reliability and ease of information synchronization and update.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN116737739B_ABST
    Figure CN116737739B_ABST
Patent Text Reader

Abstract

The application discloses an information synchronization updating method and device, equipment and a storage medium, which can be applied to the fields of big data or finance. The method is applied to a server, generates unitized texts based on the association relationship between a head office and branch offices and head office updating information, the unitized texts including all branch office updating information, merges the unitized texts to obtain a data file, processes the data file line by line to obtain target branch office updating information, determines a target distributed database according to the target branch office updating information, and performs information synchronization updating on the target distributed database based on the target branch office updating information. The data file containing all branch office updating information is processed line by line to obtain the target branch office updating information, the database where the branch office is located is located based on the target branch office updating information, and the information synchronization updating is performed, so that the operation of the information synchronization updating is simple and fast, and the efficiency of the information synchronization updating can be improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This application relates to the field of big data, specifically to a method, apparatus, device, and storage medium for information synchronization and updating. Background Technology

[0002] With the rapid development of information technology, the amount of data generated by various business operations is increasing, leading to the widespread application of distributed databases. These databases are suitable for distributed, modular system architectures, improving system reliability, availability, and performance. Headquarters information and branch office information are distributed across different databases; if there are updates at headquarters, all branches need to be notified to synchronize these updates.

[0003] Currently, the synchronization update methods used are either through a message queue (MQ) or by traversing all distributed databases for updates. However, when there is a large amount of update information, sending large amounts of data via an MQ message queue has low reliability and high performance requirements; performing multiple queries and updates by connecting to all distributed databases consumes significant update resources; resulting in low update efficiency for branch offices synchronizing updates with headquarters. Summary of the Invention

[0004] In view of this, this application provides an information synchronization update method, apparatus, device and storage medium, which can improve the efficiency of information synchronization update.

[0005] To solve the above problems, the technical solution provided in this application is as follows:

[0006] In a first aspect, this application provides an information synchronization and update method, the method being applied to a server, comprising:

[0007] Based on the relationship between the head office and branches and the head office's update information, a unitized text is generated, which includes all branch update information;

[0008] The unitized text is merged to obtain a data file;

[0009] The data file is processed line by line to obtain the target branch office update information;

[0010] The target distributed database of the target branch is determined based on the updated information of the target branch.

[0011] The target distributed database is synchronized and updated based on the updated information of the target branch.

[0012] In one possible implementation, the target branch office update information includes target branch office coding information, and the step of determining the target distributed database of the target branch office based on the target branch office update information includes:

[0013] The target distributed database of the target branch is determined based on the target branch's coding information.

[0014] In one possible implementation, determining the target distributed database of the target branch office based on the target branch office coding information includes:

[0015] The target business table of the target branch is determined based on the target branch coding information, and the target business table is stored in the target distributed database;

[0016] The target branch update information also includes target branch update data;

[0017] The step of synchronizing and updating the target distributed database based on the target branch office update information includes:

[0018] The target business table is updated synchronously based on the updated data of the target branch.

[0019] In one possible implementation, the process of processing the data file line by line to obtain the target branch office update information includes:

[0020] The data file is processed row by row according to the database sharding and table splitting rules to obtain the target branch office update information.

[0021] In one possible implementation, the method further includes:

[0022] Get information and update results synchronously;

[0023] If the information synchronization update result indicates that the information synchronization update has failed, a prompt message will be generated.

[0024] Secondly, this application provides an information synchronization and update device, which is applied to a server and includes:

[0025] The generation module is used to generate unitized text based on the relationship between the head office and branch offices and the head office's update information. The unitized text includes update information for all branch offices.

[0026] The merging module is used to merge the unitized text to obtain a data file;

[0027] The processing module is used to process the data file line by line to obtain the target branch office update information;

[0028] The determination module is used to determine the target distributed database of the target branch based on the target branch update information;

[0029] The information synchronization and update module is used to synchronize and update the target distributed database based on the update information of the target branch.

[0030] In one possible implementation, the target branch office update information includes target branch office coding information, and the determining module includes:

[0031] The determination submodule is used to determine the target distributed database of the target branch based on the target branch's coding information.

[0032] In one possible implementation, the determining submodule is specifically used to: determine the target business table of the target branch based on the target branch coding information, wherein the target business table is stored in the target distributed database;

[0033] The target branch update information also includes target branch update data;

[0034] The information synchronization and update module is specifically used to: synchronize and update the target business table based on the updated data of the target branch.

[0035] In one possible implementation, the processing module is specifically used to: process the data file line by line according to the database sharding and table splitting rules to obtain the target branch office update information.

[0036] In one possible implementation, the device further includes an acquisition module, which is also configured to acquire information synchronization update results; the generation module is also configured to generate a prompt message if the information synchronization update results indicate that the information synchronization update has failed.

[0037] Thirdly, this application provides an information synchronization and update device, including: a processor, a memory, and a system bus;

[0038] The processor and the memory are connected via the system bus;

[0039] The memory is used to store one or more programs, the one or more programs including instructions that, when executed by the processor, cause the processor to perform the information synchronization update method described in the first aspect above.

[0040] Fourthly, this application provides a computer-readable storage medium storing instructions that, when executed on a device, cause the device to perform the information synchronization update method described in the first aspect.

[0041] Therefore, this application has the following beneficial effects:

[0042] This application provides an information synchronization and update method applied to a server. First, based on the association between the head office and branch offices and the head office's update information, a unitized text is generated. This unitized text includes update information from all branch offices. The unitized text is then merged to obtain a data file. Next, the data file is processed line by line to obtain the target branch office's update information. Based on the target branch office's update information, the target distributed database for that branch office is determined. Finally, the target distributed database is synchronized and updated based on the target branch office's update information. In this way, the data file containing update information from all branch offices is read line by line to obtain the target branch office's update information. The database containing the branch office's update information is then located to perform the information synchronization and update. This method is simple and fast, improving the efficiency of information synchronization and update.

[0043] This application also provides an apparatus corresponding to the above method, which has the same beneficial effects as the above method. Attached Figure Description

[0044] Figure 1 A flowchart illustrating an information synchronization and update method provided in an embodiment of this application;

[0045] Figure 2 This application provides a schematic diagram of a server cluster unitization.

[0046] Figure 3 This is a schematic diagram of the structure of an information synchronization and update device provided in an embodiment of this application;

[0047] Figure 4 This is a schematic diagram of the structure of an information synchronization and update device provided in an embodiment of this application. Detailed Implementation

[0048] The technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, and not all embodiments. Based on the embodiments of this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0049] In this application, the terms "comprising," "including," or any other variations thereof are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes said element.

[0050] With the rapid development of information technology, the amount of data generated by various business operations is increasing. Using distributed databases to store this data is suitable for distributed, modular system architectures, and can improve system reliability, availability, and performance. However, with distributed databases, head office information and branch office information are distributed across different databases. If there are updates at head office, all branches need to be notified for synchronization, which is cumbersome.

[0051] Currently, the synchronous update methods used are either through a message queue (MQ) or by iterating through all distributed databases. When updating a large amount of information, using an MQ to send large amounts of data results in low reliability and high performance requirements; while iterating through all distributed databases for multiple queries consumes significant resources and is unsuitable for online scenarios. The current synchronous update methods also tend to lead to low update efficiency when branch offices synchronize updates with headquarters.

[0052] Based on this, embodiments of this application provide an information synchronization update method, apparatus, device, and storage medium. The method is applied to a server, generating unitized text based on the association between the head office and branch offices and the head office's update information. This unitized text is then merged to obtain a data file, where the unitized text includes update information from all branch offices. The data file is processed line by line using database sharding and table partitioning rules to obtain the target branch office's update information. The target distributed database for the target branch office is determined based on its update information. Finally, the target distributed database is synchronized and updated based on the target branch office's update information. In this way, the data file containing update information from all branch offices is processed line by line to obtain the target branch office's update information. The database containing the branch office's update information is located based on this information to perform the information synchronization update. This method is simple and fast, improving the efficiency of information synchronization updates.

[0053] To facilitate understanding of the technical solutions provided in the embodiments of this application, the following description, in conjunction with the accompanying drawings, illustrates an information synchronization and updating method, apparatus, device, and storage medium provided in the embodiments of this application.

[0054] See Figure 1 , Figure 1 This is a flowchart illustrating an information synchronization and update method provided in an embodiment of this application. The method specifically includes steps S101-S105. It should be noted that this method can be applied to a server or system, and this embodiment does not limit its application.

[0055] S101: Generate unitized text based on the relationship between the head office and branch offices and the head office update information, wherein the unitized text includes update information of all branch offices.

[0056] For large volumes of data related to headquarters and branch offices, a database sharding and table partitioning approach was used. (See also...) Figure 2 , Figure 2 This application provides a schematic diagram of a server cluster unitization. For example, databases and tables are sharded according to the unique coding information of the head office and branches. This coding information can be the organization's customer number. Based on the last three digits of the organization's customer number, the data can be split into 100 databases from 00 to 99. The last digit is used as the shard number. The server cluster is then divided into 10 units, each processing data from 10 distributed databases to improve data processing speed. That is, unit R00 needs to process distributed databases numbered 00-09.

[0057] However, the above approach may have the following issues: a head office may have multiple associated branches, but the head office's coding information differs from that of the branches. Taking the organization's customer number as an example, if the last three digits of the head office's customer number are not identical to the last three digits of the branch's customer number, then the head office and branches will be split into different units. For instance, if the head office located in unit R00 has updated information, such as updated contact information, the corresponding branch needs to synchronously update the head office's contact information. The branch might be located in unit R00, unit R03, unit R06, or other units. Due to the loose coupling requirement of the unit-based architecture, different units can only make service calls and cannot directly access the distributed database. This means that the distributed database information of unit R03 cannot be obtained from unit R00, and therefore the distributed database of the branch cannot be directly accessed, i.e., update operations cannot be performed.

[0058] Since the head office and branch offices are not in the same unit, to achieve synchronized updates of information between the head office and branch offices, unitized text can be generated based on the relationship between the head office and branch office structures and the updated information of the head office. In one possible implementation, multiple unitized texts are stored in a preset path, which can be Network Attached Storage (NAS), to facilitate the merging of unitized texts. The merged data file is then stored, and the data file is processed line by line through service calls.

[0059] On a given date, if existing transactions need to be modified, all transactions involving changes to the head office must be recorded in update details. After the head office completes the information update, the updated information will be recorded in an update details table. The update details table records the head office's update details data, and its structure includes: the name of the target table to be modified, the primary key of the target table to be modified, and the record after the change. Head office code information and branch office update information can be obtained from this update details table.

[0060] After the change, the records are separated by a specific delimiter and have different formats according to different business types, as illustrated below.

[0061] 1. Personnel Relationship Table: Relationship / Role | Relationship Person's Customer Number | Legal Entity Code | ... | Latest Modified Teller Number | Modified Teller Organization Number.

[0062] 2. Shareholder Information Table: Shareholder Customer Number | Legal Entity Code | Shareholder Type Code | ... | Create Teller Institution Number | Latest Modified Teller Number | Modified Teller Institution Number.

[0063] Based on the above, if the head office has updated information, the information of all branches under the head office can be obtained through the relationship table, and the specific content of this update can be obtained through the update details table. Using the relationships and update information, unitized text is generated. The unitized text can include branch update information (update information corresponding to branches in the head office update information). This branch update information can include branch update data and branch code information. Specifically, the branch update data includes the information fields where the branch has changed and the change details of the branch information fields. Each branch corresponding to the head office is located based on the relationships; the branch update information generated here is the update information corresponding to all branches.

[0064] It should be noted that when initially implementing distributed data storage, the relationship between the financial institution's headquarters and branches can be pre-stored using a relationship table. This table can be used to retrieve the relationships between the head office and branches. This relationship table stores business fields such as the head office customer number, branch customer number, head office organization number, due diligence process type code for branch customer numbers, and city code for branch customer numbers. Transactions involving modifications to the head office organization number, due diligence process type code, or city code require updating the reverse relationship in the relationship table, meaning all branches under the head office need their information updated. The aforementioned relationship table and update detail table must be maintained.

[0065] S102: Merge the unitized text to obtain a data file.

[0066] S103: Process the data file line by line to obtain the target branch office update information.

[0067] If multiple headquarters change their information on the same date, and these headquarters may be distributed across different units, resulting in 10 unitized files generated from 10 units, this application embodiment uses a text merging method, requiring two service calls: text merging and line-by-line text processing. Without merging the text, 10 file splitting service calls would be needed, processing 10 separate files. The steps of merging the unitized text to obtain a data file, and then performing line-by-line analysis of the data file's content, reduce the frequency of service calls, reduce the number of small files on the server, and improve the efficiency of information synchronization and updates.

[0068] In one possible implementation, processing the data file line by line to obtain the target branch office update information includes: processing the data file line by line according to the database sharding and table partitioning rules to obtain the target branch office update information.

[0069] Specifically, based on the database sharding and table partitioning rules, the data in each row of data is read and retrieved according to the last three digits of the branch organization code information in the data file. Then, the corresponding unit, distributed database and business table are located, and the corresponding field content of the business table is updated according to the data content retrieved row by row.

[0070] S104: Determine the target distributed database of the target branch based on the target branch update information.

[0071] In one possible implementation, the target branch office update information includes target branch office coding information, and determining the target distributed database of the target branch office based on the target branch office update information includes: determining the target distributed database of the target branch office based on the target branch office coding information.

[0072] The system maintains a relationship table between the head office and branches. The head office code information can be determined first, and then the branch customer number information corresponding to all the head offices can be obtained from the relationship table through the head office code information, such as the unique head office customer number.

[0073] In one possible implementation, determining the target distributed database of the target branch based on the target branch's coding information includes: determining the target business table of the target branch based on the target branch's coding information, the target business table being stored in the target distributed database; the target branch update information further includes target branch update data; and synchronizing and updating the target distributed database based on the target branch update information includes: synchronizing and updating the target business table based on the target branch update data.

[0074] After obtaining the branch office customer number information (branch office code information), the database information of the branch office can be obtained according to the rules of database sharding and table partitioning, based on the last three digits of the customer number. The distributed database uses a distributed architecture to split the data into 10 units based on the last three digits of the branch office customer number, with each of the 10 units connecting to 10 databases, resulting in a total of 100 databases from 00 to 99. Business table sharding is based on distributed database sharding. The last three digits of the branch office's unique code are used to obtain the corresponding database from 00 to 99 (100 databases in total). The last digit is used as the shard number, corresponding to one of the 10 shards for each table in a single database. For example, if the last two digits are 123, the first two digits are 12, so the database is in unit R01 (unit R01 contains databases 10-19, and 123 is in database 12). The last digit of 123 is 3, so the record is in the third shard of the business table, for example: t_basic_info_123 shard. By using the last digit of the branch number, one can locate the unit, database, and specific business table shard where the branch information is located.

[0075] S105: Based on the updated information of the target branch, perform information synchronization and update of the target distributed database.

[0076] The data file is processed line by line, parsing each line to obtain the target branch office update information. This update information includes the target branch office code and the target branch office update data. Based on the code, the target business table for the target branch office is determined, and this table is stored in the target distributed database. The update data includes the fields that need to be updated, details of the updated fields, etc. Based on this update data, the target business table is synchronously updated.

[0077] In one possible implementation, the method further includes: obtaining the information synchronization update result; if the information synchronization update result indicates that the information synchronization update has failed, generating a prompt message. Based on the prompt message, the reason for the update failure is determined, and then the update is performed again to ensure that the information synchronization update can be completed.

[0078] Based on the above, we know that the code information of all branches under the head office with updated information is determined from the relationship table between the head office and branches. The head office code information can also be used to query the head office update information from the update details table. Combining the relationship table and the update details table, we obtain the data to be processed: branch office update information, which is obtained based on the relationship table and the head office update information. The data to be processed is written to the unit's file, and the data from 10 units is merged into one data file. The data file content is read line by line and processed. When a line of data is read, it contains the head office code information, branch office code information, and head office update information. The branch office code information can be used to locate the database and business table shard where the branch office is located, and then the corresponding column values ​​of the branch office are updated according to the head office update information. It's important to clarify that data file sharding doesn't mean splitting the entire data file; rather, it involves extracting a single record. Based on the unique identifier within each record, the unit containing that information is determined. Then, through microservice calls across distributed units, the retrieved record is passed as a request parameter to the target unit where the branch office is located. The target unit then uses the branch office's coding information to locate the specific database and business table for information synchronization. This process continues reading the data file until all rows have been processed. By maintaining historical processing records during data processing and leveraging distributed database sharding rules to process the data file containing update information from all branches line by line to obtain the target branch's update information, and then determining the branch's database based on that information for synchronization, reliability is ensured. The information synchronization operation is simple, fast, and efficient.

[0079] It should be noted that the information synchronization and updating method, apparatus, device, and storage medium provided in this application can be used in the fields of big data or finance. The above are merely examples and do not limit the application areas of the information synchronization and updating method, apparatus, device, and storage medium provided in this application.

[0080] The foregoing embodiments of this application provide an information synchronization and update method based on the above description. Next, an information synchronization and update apparatus is also provided in the embodiments of this application. This apparatus is applied to a server and performs the aforementioned... Figure 1 The method is shown below. The function of the information synchronization and update device will be explained next. A schematic diagram of the information synchronization and update device is shown below. Figure 3 As shown, it includes a generation module 301, a merging module 302, a processing module 303, a determination module 304, and an information synchronization and update module 305.

[0081] The generation module 301 is used to generate unitized text based on the relationship between the head office and the branch offices and the head office update information, wherein the unitized text includes all branch office update information;

[0082] Merging module 302 is used to merge the unitized text to obtain a data file;

[0083] Processing module 303 is used to process the data file line by line to obtain the target branch office update information;

[0084] The determination module 304 is used to determine the target distributed database of the target branch based on the target branch update information;

[0085] The information synchronization update module 305 is used to perform information synchronization updates on the target distributed database based on the update information of the target branch.

[0086] In one possible implementation, the target branch office update information includes target branch office coding information, and the determining module 304 includes:

[0087] The determination submodule is used to determine the target distributed database of the target branch based on the target branch's coding information.

[0088] In one possible implementation, the determining submodule is specifically used to: determine the target business table of the target branch based on the target branch coding information, wherein the target business table is stored in the target distributed database;

[0089] The target branch update information also includes target branch update data;

[0090] The information synchronization update module 305 is specifically used to: synchronize and update the target business table based on the updated data of the target branch.

[0091] In one possible implementation, the processing module 303 is specifically used to: process the data file line by line according to the database sharding and table splitting rules to obtain the target branch office update information.

[0092] In one possible implementation, the device further includes an acquisition module, which is also configured to acquire information synchronization update results; the generation module is also configured to generate a prompt message if the information synchronization update results indicate that the information synchronization update has failed.

[0093] This application provides an information synchronization and update device applied to a server, including a generation module, a merging module, a processing module, a determining module, and an information synchronization and update module. The generation module generates unitized text based on the association between the head office and branch offices and the head office's update information. The unitized text includes update information from all branch offices. The merging module merges the unitized text to obtain a data file. The processing module processes the data file line by line to obtain the target branch office's update information. The determining module determines the target distributed database of the target branch office based on the target branch office's update information. The information synchronization and update module performs information synchronization and update on the target distributed database based on the target branch office's update information. Thus, by processing the data file containing update information from all branch offices line by line to obtain the target branch office's update information, and determining the database where the branch office is located based on the target branch office's update information, information synchronization and update can be performed. This makes the information synchronization and update operation simple and fast, improving the efficiency of information synchronization and update.

[0094] Based on the information synchronization and update method provided in the above embodiments, this application also provides an information synchronization and update device. See also... Figure 4 , Figure 4 A schematic diagram of an information synchronization and update device provided in an embodiment of this application includes: a processor, a memory, and a system bus;

[0095] The processor and the memory are connected via the system bus;

[0096] The memory is used to store one or more programs, the one or more programs including instructions, which, when executed by the processor, cause the processor to perform the information synchronization update method described in any of the above embodiments.

[0097] Based on the information synchronization and update method provided in the above-described method embodiments, this application also provides a computer-readable storage medium storing instructions that, when executed on a device, cause the device to perform the information synchronization and update method described in any of the above embodiments.

[0098] The various embodiments in this specification are described in a progressive manner. Similar or identical parts between embodiments can be referred to mutually. Each embodiment focuses on describing the differences from other embodiments. In particular, for apparatus or apparatus embodiments, since they are basically similar to method embodiments, the description is relatively simple; relevant parts can be referred to the descriptions in the method embodiments. The apparatus and apparatus embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. Those skilled in the art can understand and implement this without creative effort.

[0099] Those skilled in the art will further recognize that the units and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of both. To clearly illustrate the interchangeability of hardware and software, the components and steps of the various examples have been generally described in terms of functionality in the foregoing description. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementation should not be considered beyond the scope of this application.

[0100] The above description of the disclosed embodiments enables those skilled in the art to make or use this application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of this application. Therefore, this application is not to be limited to the embodiments shown herein, but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for synchronizing and updating information, characterized in that, The method is applied to a server and includes: Based on the relationship between the head office and branches and the head office's update information, a unitized text is generated, which includes all branch update information; The unitized text is merged to obtain a data file; Based on the database sharding and table splitting rules, the data in each row of the data file is read and called according to the last three digits of the branch organization code information. Then, the corresponding unit, distributed database and business table are located. According to the data content called row by row, the corresponding field content of the business table is updated to obtain the target branch organization update information. The target distributed database of the target branch is determined based on the updated information of the target branch. The target distributed database is synchronized and updated based on the updated information of the target branch.

2. The method according to claim 1, characterized in that, The target branch office update information includes target branch office coding information, and the step of determining the target distributed database of the target branch office based on the target branch office update information includes: The target distributed database of the target branch is determined based on the target branch's coding information.

3. The method according to claim 2, characterized in that, The step of determining the target distributed database of the target branch based on the target branch's coding information includes: The target business table of the target branch is determined based on the target branch coding information, and the target business table is stored in the target distributed database; The target branch update information also includes target branch update data; The step of synchronizing and updating the target distributed database based on the target branch office update information includes: The target business table is updated synchronously based on the updated data of the target branch.

4. The method according to claim 1, characterized in that, The method further includes: Get information and update results synchronously; If the information synchronization update result indicates that the information synchronization update has failed, a prompt message will be generated.

5. An information synchronization and update device, characterized in that, The device is used in a server and includes: The generation module is used to generate unitized text based on the relationship between the head office and branch offices and the head office's update information. The unitized text includes update information for all branch offices. The merging module is used to merge the unitized text to obtain a data file; The processing module is used to read and call the data of each row of data in the data file based on the splitting rules of the database and the last three digits of the branch organization code information in each row of data, and then locate the corresponding unit, distributed database and business table. Based on the data content called row by row, the corresponding field content of the business table is updated to obtain the target branch organization update information. The determination module is used to determine the target distributed database of the target branch based on the target branch update information; The information synchronization and update module is used to synchronize and update the target distributed database based on the update information of the target branch.

6. The apparatus according to claim 5, characterized in that, The target branch office update information includes target branch office coding information, and the determining module includes: The determination submodule is used to determine the target distributed database of the target branch based on the target branch's coding information.

7. The apparatus according to claim 6, characterized in that, The determining submodule is specifically used to: determine the target business table of the target branch based on the target branch coding information, wherein the target business table is stored in the target distributed database; The target branch update information also includes target branch update data; The information synchronization and update module is specifically used to: synchronize and update the target business table based on the updated data of the target branch.

8. An information synchronization and update device, comprising: Processor, memory, system bus; The processor and the memory are connected via the system bus; The memory is used to store one or more programs, the one or more programs including instructions that, when executed by the processor, cause the processor to perform the information synchronization update method according to any one of claims 1 to 4.

9. A computer-readable storage medium storing instructions that, when executed on a device, cause the device to perform the information synchronization update method according to any one of claims 1 to 4.