Database parameter synchronization method, apparatus, device, medium, and program product

Abstract

The present disclosure provides a database parameter synchronization method, device, equipment, medium and program product, which can be applied to the fields of computer and financial technology. The database parameter synchronization method comprises: acquiring identification information corresponding to at least one target region in a plurality of databases; configuring a reference database, wherein the reference database comprises a template region; configuring a parameter text of the template region, wherein the parameter text is configured with update data; checking the update data in the parameter text based on a database script; and adding the update data to a parameter table corresponding to each target region based on a batch file server according to the update data and the identification information.

Description

Technical Field

[0001] This disclosure relates to the fields of computers and finance, and more specifically to a method, apparatus, device, medium, and program product for synchronizing database parameters. Background Technology

[0002] In the banking system, four independent databases are deployed across four major regions: Asia, Europe and Africa, the Americas, and major banks. In actual business applications, parameters across these four regions need to be synchronized to complete business management. With the subsequent development of overseas business, there have been continuous additions of regions and changes in database types due to the transition from mainframe to platform. Therefore, it is necessary not only to keep parameters synchronized across multiple databases, but also between databases of different types.

[0003] Currently, in order to synchronize parameters across multiple databases, parameters need to be manually published for maintenance. This is not only repetitive and tedious, but also prone to causing business anomalies due to incorrect parameters. Summary of the Invention

[0004] In view of the above problems, this disclosure provides a database parameter synchronization method, apparatus, device, medium, and program product to improve the efficiency and accuracy of database parameter synchronization maintenance.

[0005] According to a first aspect of the present disclosure, a database parameter synchronization method is provided, comprising: acquiring identification information corresponding to at least one target region in multiple databases; configuring a reference database, wherein the reference database includes a template region; configuring parameter text in the template region, wherein the parameter text contains updated data; verifying the updated data in the parameter text based on a database script; and adding updated data to a parameter table corresponding to each target region based on the updated data and identification information using a batch file server.

[0006] According to an embodiment of this disclosure, obtaining identification information corresponding to at least one target region from multiple databases includes: generating a code corresponding to each target region based on the region identifier of each target region, and determining the code as identification information.

[0007] According to embodiments of this disclosure, obtaining identification information corresponding to at least one target region from multiple databases further includes: in response to an update of the target region, generating an updated code based on the updated region identifier of the target region; and adding the updated target region and the corresponding updated code to the identification information.

[0008] According to embodiments of this disclosure, adding updated data to the parameter table corresponding to each target area based on the updated data and identification information, using a batch file server, includes: calling a batch program of a reference database to read parameter text, generating a template parameter file, and storing the template parameter file on the batch file server; wherein the template parameter file contains parameter text information; calling multiple batch programs of non-reference databases to read the template parameter file from the batch file server; calling batch programs of both the reference database and non-reference databases to read the template parameter file respectively and obtain the updated data; and calling a batch program of the database to add the updated data to the parameter table of the target area corresponding to the current identification information.

[0009] According to embodiments of this disclosure, calling batch programs of multiple non-reference databases to read template parameter files from a batch file server includes: calling batch programs of multiple non-reference databases, accessing the batch file server via a file transfer protocol, and obtaining template parameter files, wherein file transfer is performed between the multiple non-reference databases through the batch file server.

[0010] According to embodiments of this disclosure, verifying updated data based on database scripts includes: obtaining metadata management data corresponding to each database, wherein each metadata management data stores primary key data of at least one target region parameter table in each database; and determining whether the updated data meets the verification conditions based on the metadata management data.

[0011] According to embodiments of this disclosure, determining whether updated data meets the verification conditions based on metadata management data includes: configuring an operation identifier, wherein the operation identifier contains information indicating that the updated data is associated with the metadata management data; and determining the association between the updated data and the data in the metadata management data based on the operation identifier.

[0012] According to embodiments of this disclosure, determining the association between updated data and data in metadata management data based on operation identifiers includes: generating prompt information based on multiple operation identifiers through cyclic redundancy check; wherein the multiple operation identifiers are used to represent information added, updated, and deleted respectively; if it is determined that an update is added, then updated data already exists in the metadata management data, and an update prompt is given; if it is determined that an update is added, then updated data does not exist in the metadata management data, and an update prompt is given; if it is determined that a deletion is made, then updated data does not exist in the metadata management data, and a deletion prompt is given.

[0013] According to embodiments of this disclosure, determining whether updated data meets the verification conditions based on metadata management data further includes: determining the existence of the table name of the parameter text corresponding to the updated data in the metadata management data.

[0014] According to embodiments of this disclosure, determining whether updated data meets the verification conditions based on metadata management data further includes: determining whether the primary key data of the updated data is missing or duplicated in the metadata management data.

[0015] According to embodiments of this disclosure, the method further includes: in response to determining whether the updated data is associated with all target areas, configuring parameter text using the updated data when the updated data is associated with multiple target areas, and configuring a parameter table for the corresponding target area using the updated data when the updated data is not associated with any target area.

[0016] A second aspect of this disclosure provides a database parameter synchronization apparatus, comprising: an acquisition module for acquiring identification information corresponding to at least one target region from multiple databases; a first configuration module for configuring a reference database and configuring a template region in the reference database; a second configuration module for configuring parameter text in the template region, wherein the parameter text contains updated data; a verification module for verifying the updated data based on a database script; and a synchronization module for adding updated data to a parameter table corresponding to each target region based on the updated data and identification information from a batch file server.

[0017] A third aspect of this disclosure provides an electronic device, including: one or more processors; and a memory for storing one or more programs, wherein when the one or more programs are executed by the one or more processors, the one or more processors perform the database parameter synchronization method described above.

[0018] A fourth aspect of this disclosure also provides a computer-readable storage medium having executable instructions stored thereon, which, when executed by a processor, cause the processor to perform the aforementioned database parameter synchronization method.

[0019] A fifth aspect of this disclosure also provides a computer program product, including a computer program that, when executed by a processor, implements the above-described database parameter synchronization method. Attached Figure Description

[0020] The foregoing contents, as well as other objects, features, and advantages of this disclosure, will become clearer from the following description of embodiments with reference to the accompanying drawings, in which:

[0021] Figure 1 The illustration schematically depicts application scenarios of database parameter synchronization methods, apparatuses, devices, media, and program products according to embodiments of the present disclosure.

[0022] Figure 2 A flowchart illustrating a database parameter synchronization method according to an embodiment of the present disclosure is shown schematically.

[0023] Figure 3 This schematically illustrates a flowchart for obtaining identification information corresponding to target regions in multiple databases according to an embodiment of the present disclosure;

[0024] Figure 4 The flowchart illustrating the determination of the association between updated data and the target area according to an embodiment of this disclosure is shown in the illustration.

[0025] Figure 5 This illustration schematically shows a flowchart of updating the parameter table corresponding to the target area based on updated data and identification information according to an embodiment of this disclosure;

[0026] Figure 6 A flowchart illustrating the verification and updating of data according to one embodiment of the present disclosure is shown schematically;

[0027] Figure 7 A flowchart illustrating the data update based on operation identifier verification according to an embodiment of this disclosure is shown schematically;

[0028] Figure 8 A flowchart illustrating the generation of prompt information based on an operation identifier according to an embodiment of this disclosure is shown schematically;

[0029] Figure 9 A flowchart illustrating the verification and updating of data is shown schematically according to another embodiment of this disclosure;

[0030] Figure 10 A schematic block diagram of a database parameter synchronization device according to an embodiment of the present disclosure is shown; and

[0031] Figure 11 A block diagram schematically illustrates an electronic device suitable for implementing a database parameter synchronization method according to an embodiment of the present disclosure. Detailed Implementation

[0032] The embodiments of the present disclosure will now be described with reference to the accompanying drawings. However, it should be understood that these descriptions are exemplary only and are not intended to limit the scope of the disclosure. In the following detailed description, numerous specific details are set forth to provide a thorough understanding of the embodiments of the present disclosure for ease of explanation. However, it will be apparent that one or more embodiments may be practiced without these specific details. Furthermore, descriptions of well-known structures and techniques are omitted in the following description to avoid unnecessarily obscuring the concepts of the present disclosure.

[0033] The terminology used herein is for the purpose of describing particular embodiments only and is not intended to limit this disclosure. The terms “comprising,” “including,” etc., as used herein indicate the presence of the stated features, steps, operations, and / or components, but do not exclude the presence or addition of one or more other features, steps, operations, or components.

[0034] All terms used herein (including technical and scientific terms) have the meanings commonly understood by those skilled in the art, unless otherwise defined. It should be noted that the terms used herein are to be interpreted in a manner consistent with the context of this specification, and not in an idealized or overly rigid way.

[0035] When using expressions such as "at least one of A, B, and C", they should generally be interpreted in accordance with the meaning that is commonly understood by a person skilled in the art (e.g., "a system having at least one of A, B, and C" should include, but is not limited to, a system having A alone, a system having B alone, a system having C alone, a system having A and B, a system having A and C, a system having B and C, and / or a system having A, B, and C, etc.).

[0036] It should be noted that the database parameter synchronization method and apparatus disclosed herein can be used for cross-border database parameter synchronization in the financial field, and can also be used for parameter synchronization across multiple databases in any field other than the financial field. The application fields of the database parameter synchronization method and apparatus disclosed herein are not limited.

[0037] In the technical solution disclosed herein, the collection, storage, use, processing, transmission, provision, disclosure, and application of user personal information comply with the provisions of relevant laws and regulations, necessary confidentiality measures have been taken, and there is no violation of public order and good morals.

[0038] In the technical solution disclosed herein, the user's authorization or consent is obtained before acquiring or collecting the user's personal information.

[0039] Embodiments of this disclosure provide a database parameter synchronization method, comprising: obtaining identification information corresponding to at least one target region from multiple databases; configuring a reference database, wherein the reference database includes a template region; configuring parameter text of the template region, wherein the parameter text contains updated data; verifying the updated data in the parameter text based on a database script; and adding updated data to the parameter table corresponding to each target region based on the updated data and identification information from a batch file server.

[0040] Figure 1 The illustration shows an application scenario diagram of a database parameter synchronization method, apparatus, device, medium, and program product according to embodiments of the present disclosure.

[0041] like Figure 1As shown, application scenario 100 according to this embodiment may include a first terminal device 101, a second terminal device 102, a third terminal device 103, a network 104, and a server 105. The network 104 serves as a medium for providing a communication link between the first terminal device 101, the second terminal device 102, the third terminal device 103, and the server 105. The network 104 may include various connection types, such as wired or wireless communication links, or fiber optic cables, etc.

[0042] Users can use the first terminal device 101, the second terminal device 102, and the third terminal device 103 to interact with the server 105 via the network 104 to receive or send messages, etc. Various communication client applications can be installed on the first terminal device 101, the second terminal device 102, and the third terminal device 103, such as shopping applications, web browser applications, search applications, instant messaging tools, email clients, social media platform software, etc. (for example only).

[0043] The first terminal device 101, the second terminal device 102, and the third terminal device 103 can be various electronic devices with displays and support web browsing, including but not limited to smartphones, tablets, laptops, and desktop computers.

[0044] Server 105 can be a server that provides various services, such as a backend management server that supports websites browsed by users using the first terminal device 101, the second terminal device 102, and the third terminal device 103 (this is just an example). The backend management server can analyze and process data such as received user requests, and feed back the processing results (such as web pages, information, or data obtained or generated according to user requests) to the terminal devices.

[0045] It should be noted that the credit limit adjustment method provided in this embodiment can generally be executed by server 105. Correspondingly, the credit limit adjustment device provided in this embodiment can generally be located in server 105. The credit limit adjustment method provided in this embodiment can also be executed by a server or server cluster that is different from server 105 and capable of communicating with the first terminal device 101, the second terminal device 102, the third terminal device 103, and / or server 105. Correspondingly, the credit limit adjustment device provided in this embodiment can also be located in a server or server cluster that is different from server 105 and capable of communicating with the first terminal device 101, the second terminal device 102, the third terminal device 103, and / or server 105.

[0046] It should be understood that Figure 1The number of terminal devices, networks, and servers shown is merely illustrative. Depending on implementation needs, any number of terminal devices, networks, and servers can be included.

[0047] The following will be based on Figure 1 The described scene, through Figures 2-9 The database parameter synchronization method of the disclosed embodiments is described in detail.

[0048] Figure 2 A flowchart illustrating a database parameter synchronization method according to an embodiment of the present disclosure is shown schematically.

[0049] like Figure 2 As shown, the database parameter synchronization method in this embodiment includes operations S200 to S600.

[0050] In operation S200, identification information corresponding to at least one target area is obtained from multiple databases.

[0051] The step of obtaining identification information corresponding to at least one target region from multiple databases includes: generating a code corresponding to each target region based on the region identifier of each target region, and determining the code as identification information.

[0052] In some embodiments, the multiple databases can be multiple independent databases distributed across different continents by a financial institution. For example, the multiple databases can be four independent IBM DB2 databases deployed in four major regions: Asia, Europe and Africa, the Americas, and major banks. The target region is the region where at least one service terminal in the database is located. For example, a country can be designated as a target region, and the target regions in the Asian database can include China, Japan, South Korea, etc.

[0053] The identification information corresponding to the target area can be a numerical code set for the target area. Taking the target areas in the aforementioned Asian database as an example, China branch 001, Japan branch 002, South Korea branch 003, etc. A region code table is generated based on the codes of the target areas in different databases. Each database corresponds to one region code table, and the region code table contains the target area and its corresponding code.

[0054] It should be noted that the rules for dividing the target area in each database in this embodiment of the disclosure are not specifically limited. Similarly, the method for setting the target area identification information is not specifically limited; letters, characters, etc., can be used instead of numbers as identifiers to distinguish multiple target areas.

[0055] When operating the S300, configure the reference database, which includes a template area.

[0056] In some embodiments, among multiple databases, one database is selected as a reference database. For example, in this embodiment of the disclosure, an Asian database is selected as the reference database. The selection of the reference database is based on the database to which the template region belongs; that is, the database containing the template region is used as the reference database.

[0057] A template region is a region set in a database that differs from any other target region in that database. In this embodiment, the identifier information (numeric code) corresponding to the template region is set to 0.

[0058] When operating S400, configure the parameter text in the template area, where the parameter text contains updated data.

[0059] In some embodiments, text is a computer file consisting of several lines of characters. Text files exist in the computer's file system and can contain plain text. Generally, computers can be divided into two categories: text files and binary files. Text is a type of document on a computer. This type of document is mainly used to record and store text information, rather than images, sounds, or formatted data. Common file extensions for text documents include txt, doc, wps, etc.

[0060] Parameter text can be character data contained within a text file. When parameter synchronization is required, during the initial release, technical staff maintain the parameter text to obtain parameter text containing updated data.

[0061] When operating the S500, based on a database script, update the data in the parameter text.

[0062] In some embodiments, a database script is a collection of statements used to create database objects. The specific verification process can be found in the descriptions of steps S801 to S803; to avoid repetition, it will not be repeated here.

[0063] When operating the S600, based on the batch file server, update data is added to the parameter table corresponding to each target area according to the update data and identification information.

[0064] In some embodiments, multiple databases share a single batch file server. Each target region contains a parameter table. At the end of the day (running every night), the batch file server updates the parameter text of the template region between the reference database and the non-reference database, that is, it inserts the updated parameters into the parameter table corresponding to each target region, thus updating the parameter table in a timely manner.

[0065] Understandably, by setting identification information to generate a region code table, and then manually maintaining the parameter text of the template region, the parameters can be automatically copied through a batch program after the region code table is set. The updated data in the parameter text can then be inserted into the parameter table of the target region, thus achieving parameter synchronization between multiple databases. This batch automatic parameter maintenance method replaces the manual maintenance method, greatly reducing manual work, improving parameter synchronization efficiency, and reducing the probability of business problems caused by untimely parameter synchronization.

[0066] Figure 3 The flowchart illustrating the process of obtaining identification information corresponding to target regions in multiple databases according to an embodiment of the present disclosure is shown.

[0067] like Figure 3 As shown, the acquisition of identification information corresponding to at least one target region in multiple databases in this embodiment also includes operations S201 to S202.

[0068] In operation S201, in response to an update of the target area, an updated code is generated based on the updated region identifier of the target area.

[0069] In operation S202, the updated target area and the corresponding updated code are added to the identification information.

[0070] In some embodiments, when a target region is added or removed from at least one database, for example, when India is added as a target region to the Asian database, a different code is generated for the India target region, such as India 004. The information for India 004 is added to the region code table, completing the update of the region code table. During the end-of-day batch processing of parameter copy updates, the updated parameters can be added to the parameter table corresponding to the target region India based on the updated region code table.

[0071] Understandably, adding or removing target regions can be achieved simply by maintaining the region code table and adding or removing the corresponding target regions, which will automatically configure parameters for the newly added target regions.

[0072] Figure 4 The flowchart illustrating the determination of the association between updated data and the target area according to an embodiment of this disclosure is shown in the illustration.

[0073] like Figure 4 As shown, the method in this embodiment also includes operations S900 to S902.

[0074] In operation S900, the response is to determine whether the updated data is associated with all target areas.

[0075] When operating S901, if the updated data is associated with multiple target areas, the updated data is used to configure parameter text.

[0076] In operation S902, when the updated data is not associated with any target area, the parameter table of the corresponding target area is configured using the updated data.

[0077] When the updated parameters correspond to the parameter tables of all target regions, the above method can be used to update the parameters; however, when the updated parameters are only updated in one or a few target regions, it is not necessary to maintain the parameter text of the template region, but only to maintain the parameter table of one or a few target regions corresponding to the updated parameters, without triggering the auto-completion function.

[0078] Figure 5 The flowchart illustrating the updating of the parameter table corresponding to the target area based on updated data and identification information according to an embodiment of this disclosure is shown.

[0079] like Figure 5 As shown, this embodiment is based on a batch file server, and adds updated data to the parameter table corresponding to each target area according to the updated data and identification information, including operations S601 to S604.

[0080] When operating S601, the batch program of the reference database is called to read the parameter text, generate a template parameter file, and store the template parameter file on the batch file server; the template parameter file contains parameter text information.

[0081] In some embodiments, taking the Asia region mentioned above as an example, the batch program reads the parameter text of the template area to generate a template parameter file, and stores the template parameter file on the batch file server via the File Transfer Protocol (FTP).

[0082] FTP uses the Internet standard file transfer protocol. The FTP user interface provides users with a set of applications for managing file transfers between computers.

[0083] When operating S602, multiple batch programs from non-reference databases are called to read template parameter files from a batch file server.

[0084] The process of calling batch programs from multiple non-reference databases to read template parameter files from a batch file server includes: calling batch programs from multiple non-reference databases to access the batch file server via a file transfer protocol to obtain template parameter files, wherein file transfer between the multiple non-reference databases is performed through the batch file server.

[0085] In some embodiments, through file transfer, the batch program corresponding to each database accesses the batch file server via FTP to obtain the template parameter file, so that the template parameter file containing updated data (parameters) is mapped to the database of each region.

[0086] When operating S603, the batch program for the reference database and the non-reference database is called to read the template parameter file and obtain the updated data.

[0087] In some embodiments, batch programs using both reference and non-reference databases read template parameter files to obtain updated data, so as to insert the corresponding updated data into the parameter table of the target area in the database.

[0088] In operation S604, the database batch program is invoked to add updated data to the parameter table of the target area corresponding to the current identification information.

[0089] In some embodiments, at the end of the day, a batch program is used to add updated data to the parameter table of the target region by using the updated data in the template parameter file as a template and referring to the region code table, so as to complete the update of the target region parameter table between multiple databases and realize the synchronous update of parameters of multiple databases.

[0090] Figure 6 A flowchart illustrating the verification and updating of data is shown in one embodiment of the present disclosure.

[0091] like Figure 6 As shown, to verify whether the insertion of updated data in the parameter text will cause problems, this embodiment is based on a database script, and the verification of updated data includes operations S501 to S502.

[0092] In operation S501, the metadata management data corresponding to each database is obtained. Each metadata management data store contains the primary key data of at least one target area parameter table in each database.

[0093] In some embodiments, each database corresponds to a metadata management table, which stores primary key data for multiple target region parameter tables within the corresponding database. Primary key data refers to one or more columns whose values ​​uniquely identify each row in the table, thus enforcing entity integrity of the table. Primary keys are primarily used for foreign key associations with other tables, and for modifying and deleting text records. A primary key is created by defining a PRIMARY KEY constraint when a table is created or modified. A table can only have one PRIMARY KEY constraint, and columns within a PRIMARY KEY constraint cannot accept null values. Because PRIMARY KEY constraints ensure unique data, they are often used to define identity columns.

[0094] In operation S502, data is managed based on metadata to determine whether updated data meets the verification conditions.

[0095] In some embodiments, the updated data is verified against the metadata management data. If the updated data meets the verification conditions, subsequent operations are performed. If the updated data does not meet the verification conditions, it is returned for manual modification. After modification, the data is verified again until the verification passes.

[0096] Figure 7 A flowchart illustrating the data update based on operation identifier verification according to an embodiment of this disclosure is shown.

[0097] like Figure 7 As shown, in this embodiment, determining whether updated data meets the verification conditions based on metadata management data includes operations S5021 to S5022.

[0098] In operation S5021, configure the operation identifier, which contains information about the relationship between the updated data and the metadata management data.

[0099] In operation S5022, based on the operation identifier, the association between the updated data and the data in the metadata management data is determined.

[0100] The specific operation identifier verification refers to the following operations S700 to S703.

[0101] Figure 8 A flowchart illustrating the generation of prompt information based on an operation identifier is shown in an embodiment of this disclosure.

[0102] like Figure 8 As shown, in this embodiment, the determination of the association between updated data and data in metadata management data based on operation identifiers includes operations S700 to S703.

[0103] When operating the S700, prompt information is generated based on multiple operation identifiers through cyclic redundancy check.

[0104] Among them, multiple operation identifiers are used to represent newly added, updated, and deleted information;

[0105] 0: Add new data. If updated data already exists in the metadata management database, adding new data will result in an error.

[0106] 1: If there is no updated data in the metadata management data, an update error will occur;

[0107] 2: Deletion. If there is no updated data in the metadata management data, a deletion error will occur.

[0108] If prompted to add new data, the updated data already exists and no further action is needed; if prompted to update data, the updated data does not exist and can be updated; if prompted to delete data, the updated data previously existed and was deleted, and it is necessary to verify whether the update needs to be performed again.

[0109] When operating S701, if the addition is confirmed, the updated data already exists in the metadata management data, and a prompt to add the data will be displayed.

[0110] When operating S702, if an update is confirmed, and there is no updated data in the metadata management data, an update prompt will be displayed.

[0111] When operating S703, if deletion is confirmed, and there is no updated data in the metadata management data, a deletion prompt will be displayed.

[0112] Figure 9 A flowchart illustrating the verification and updating of data is shown in another embodiment of this disclosure.

[0113] like Figure 9 As shown, this embodiment manages data based on metadata and determines whether the updated data meets the verification conditions, including operations S801 to S803.

[0114] In operation S801, based on the operation identifier, the association between the updated data and the data in the metadata management data is determined.

[0115] Operation S801 is the same as operation S5022 above. Here, in order to better reflect the unity of the three steps of verification, operation S5022 is changed to operation S801.

[0116] In operation S801, determine the existence of the table name corresponding to the parameter text of the updated data in the metadata management data.

[0117] In some embodiments, parameter text table name validation is performed so that the parameter table for the entire region (all target areas) needs to be updated during verification; if the update of the parameter table for the entire region is not required, then adding new data to the template region parameter text is prohibited. If the update of the parameter table for the entire region is required, then adding new data to the template region parameter text is allowed.

[0118] In operation S803, determine the absence and duplication of primary key data in the metadata management data for the updated data.

[0119] In some embodiments, for example, if the cleanup parameters are: the primary key data is the cleanup indication, the target area encoding, and the cleanup conditions, then in the metadata management data, the three fields of the cleanup parameters cannot be empty or duplicated.

[0120] It should be noted that the above three verifications can be performed individually as operation identifier verification, table name verification, or sequential data verification, or they can be combined in pairs. This embodiment does not impose specific limitations on the order and type of verification, and those skilled in the art can adjust them according to specific applications.

[0121] Based on the above-described database parameter synchronization method, this disclosure also provides a database parameter synchronization device. The following will be combined with... Figure 10 The device is described in detail.

[0122] Figure 10 A schematic block diagram of a database parameter synchronization device according to an embodiment of the present disclosure is shown.

[0123] like Figure 10 As shown, the database parameter synchronization device 800 of this embodiment includes an acquisition module 810, a first configuration module 820, a second configuration module 830, a verification module 840, and a synchronization module 850.

[0124] The acquisition module 810 is used to acquire identification information corresponding to at least one target region from multiple databases. In one embodiment, the acquisition module 810 can be used to perform the operation S200 described above, which will not be repeated here.

[0125] The first configuration module 820 is used to configure the reference database and configure template areas within the reference database. In one embodiment, the first configuration module 820 can be used to perform the operation S300 described above, which will not be repeated here.

[0126] The second configuration module 830 is used to configure the parameter text of the template area, wherein the parameter text contains updated data. In one embodiment, the second configuration module 830 can be used to perform the operation S400 described above, which will not be repeated here.

[0127] The verification module 830 is used to verify updated data based on a database script. In one embodiment, the verification module 830 can be used to perform the operation S500 described above, which will not be repeated here.

[0128] The synchronization module 830 is used to add updated data to the parameter table corresponding to each target area based on the updated data and identification information, using a batch file server. In one embodiment, the synchronization module 830 can be used to perform the operation S600 described above, which will not be repeated here.

[0129] According to embodiments of this disclosure, any plurality of modules among the acquisition module 810, the first configuration module 820, the second configuration module 830, the verification module 840, and the synchronization module 850 can be combined into one module, or any one of these modules can be split into multiple modules. Alternatively, at least part of the functionality of one or more of these modules can be combined with at least part of the functionality of other modules and implemented in one module. According to embodiments of this disclosure, at least one of the acquisition module 810, the first configuration module 820, the second configuration module 830, the verification module 840, and the synchronization module 850 can be at least partially implemented as hardware circuitry, such as a field-programmable gate array (FPGA), a programmable logic array (PLA), a system-on-a-chip, a system-on-a-substrate, a system-on-package, an application-specific integrated circuit (ASIC), or implemented in hardware or firmware by any other reasonable means of integrating or packaging the circuitry, or implemented in any one of the three implementation methods of software, hardware, and firmware, or in a suitable combination of any of these. Alternatively, at least one of the acquisition module 810, the first configuration module 820, the second configuration module 830, the verification module 840, and the synchronization module 850 may be implemented at least partially as a computer program module, which can perform corresponding functions when the computer program module is run.

[0130] Figure 11 A block diagram schematically illustrates an electronic device suitable for implementing a database parameter synchronization method according to an embodiment of the present disclosure.

[0131] like Figure 11 As shown, an electronic device 900 according to an embodiment of the present disclosure includes a processor 901, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 902 or a program loaded from a storage portion 908 into a random access memory (RAM) 903. The processor 901 may include, for example, a general-purpose microprocessor (e.g., a CPU), an instruction set processor and / or an associated chipset and / or a special-purpose microprocessor (e.g., an application-specific integrated circuit (ASIC)), etc. The processor 901 may also include onboard memory for caching purposes. The processor 901 may include a single processing unit or multiple processing units for performing different actions of the method flow according to an embodiment of the present disclosure.

[0132] RAM 903 stores various programs and data required for the operation of electronic device 900. Processor 901, ROM 902, and RAM 903 are interconnected via bus 904. Processor 901 performs various operations of the method flow according to embodiments of the present disclosure by executing programs in ROM 902 and / or RAM 903. It should be noted that programs may also be stored in one or more memories other than ROM 902 and RAM 903. Processor 901 may also perform various operations of the method flow according to embodiments of the present disclosure by executing programs stored in one or more memories.

[0133] According to embodiments of this disclosure, the electronic device 900 may further include an input / output (I / O) interface 905, which is also connected to a bus 904. The electronic device 900 may also include one or more of the following components connected to the I / O interface 905: an input section 906 including a keyboard, mouse, etc.; an output section 907 including a cathode ray tube (CRT), liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 908 including a hard disk, etc.; and a communication section 909 including a network interface card such as a LAN card, modem, etc. The communication section 909 performs communication processing via a network such as the Internet. A drive 910 is also connected to the I / O interface 905 as needed. A removable medium 911, such as a disk, optical disk, magneto-optical disk, semiconductor memory, etc., is installed on the drive 910 as needed so that computer programs read from it can be installed into the storage section 908 as needed.

[0134] This disclosure also provides a computer-readable storage medium, which may be included in the device / apparatus / system described in the above embodiments; or it may exist independently and not assembled into the device / apparatus / system. The computer-readable storage medium carries one or more programs that, when executed, implement the method according to the embodiments of this disclosure.

[0135] According to embodiments of this disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium, such as including, but not limited to: portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof. In this disclosure, the computer-readable storage medium may be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. For example, according to embodiments of this disclosure, the computer-readable storage medium may include ROM 902 and / or RAM 903 and / or one or more memories other than ROM 902 and RAM 903 described above.

[0136] Embodiments of this disclosure also include a computer program product comprising a computer program containing program code for performing the methods shown in the flowchart. When the computer program product is run on a computer system, the program code is used to cause the computer system to implement the item recommendation method provided in the embodiments of this disclosure.

[0137] When the computer program is executed by the processor 901, it performs the functions defined in the system / apparatus of this disclosure embodiments. According to embodiments of this disclosure, the systems, apparatuses, modules, units, etc., described above can be implemented by computer program modules.

[0138] In one embodiment, the computer program may rely on a tangible storage medium such as an optical storage device or a magnetic storage device. In another embodiment, the computer program may also be transmitted and distributed in the form of signals over a network medium, and downloaded and installed via the communication section 909, and / or installed from a removable medium 911. The program code contained in the computer program can be transmitted using any suitable network medium, including but not limited to: wireless, wired, etc., or any suitable combination thereof.

[0139] In such an embodiment, the computer program can be downloaded and installed from a network via the communication section 909, and / or installed from the removable medium 911. When the computer program is executed by the processor 901, it performs the functions defined in the system of this disclosure embodiment. According to embodiments of this disclosure, the systems, devices, apparatuses, modules, units, etc., described above can be implemented by computer program modules.

[0140] According to embodiments of this disclosure, program code for executing the computer programs provided in embodiments of this disclosure can be written in any combination of one or more programming languages. Specifically, these computational programs can be implemented using high-level procedural and / or object-oriented programming languages, and / or assembly / machine languages. Programming languages ​​include, but are not limited to, languages ​​such as Java, C++, Python, "C", or similar programming languages. The program code can execute entirely on the user's computing device, partially on the user's device, partially on a remote computing device, or entirely on a remote computing device or server. In cases involving remote computing devices, the remote computing device can be connected to the user's computing device via any type of network, including a local area network (LAN) or a wide area network (WAN), or it can be connected to an external computing device (e.g., via the Internet using an Internet service provider).

[0141] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this disclosure. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in a block diagram or flowchart, and combinations of blocks in a block diagram or flowchart, may be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.

[0142] Those skilled in the art will understand that the features described in the various embodiments and / or claims of this disclosure can be combined or combined in various ways, even if such combinations or combinations are not explicitly described in this disclosure. In particular, the features described in the various embodiments and / or claims of this disclosure can be combined or combined in various ways without departing from the spirit and teachings of this disclosure. All such combinations and / or combinations fall within the scope of this disclosure.

[0143] The embodiments of this disclosure have been described above. However, these embodiments are for illustrative purposes only and are not intended to limit the scope of this disclosure. Although various embodiments have been described above, this does not mean that the measures in the various embodiments cannot be used advantageously in combination. The scope of this disclosure is defined by the appended claims and their equivalents. Various substitutions and modifications can be made by those skilled in the art without departing from the scope of this disclosure, and all such substitutions and modifications should fall within the scope of this disclosure.

Claims

1. A database parameter synchronization method, comprising: Obtain identification information from multiple databases that corresponds to at least one target region; Configure a reference database, wherein the reference database includes a template region, the template region being configured as a virtual region different from any of the target regions; Configure the parameter text of the template area, wherein the parameter text contains updated data; In response to determining whether the updated data is associated with all of the target regions, if the updated data is associated with multiple target regions, the updated data is used to configure parameter text; if the updated data is not associated with any of the target regions, the updated data is used to configure the corresponding target region parameter table. Based on the database script, the updated data in the parameter text is verified, including obtaining the metadata management data corresponding to each database, whereby each metadata management data stores the primary key data of at least one target region parameter table in each database; based on the metadata management data, it is determined whether the updated data meets the verification conditions; and Based on the batch file server, the updated data is added to the parameter table corresponding to each target region according to the updated data and the identification information.

2. The method according to claim 1, wherein, The step of obtaining the identification information corresponding to at least one target region from multiple databases includes: Generate a code corresponding to each target region based on the region identifier of each target region, and determine the code as the identifier information.

3. The method according to claim 2, wherein, Obtaining the identification information corresponding to at least one target region from multiple databases further includes: In response to an update of the target region, an updated code is generated based on the region identifier of the updated target region; The updated target area and the corresponding updated code are added to the identification information.

4. The method according to claim 2, wherein, The step of adding the updated data to the parameter table corresponding to each target region based on the batch file server, according to the updated data and the identification information, includes: The batch program of the reference database is invoked to read the parameter text, generate a template parameter file, and store the template parameter file on the batch file server; wherein, the template parameter file contains information of the parameter text; A batch program that invokes multiple non-reference databases is used to read the template parameter file from the batch file server. The batch program for the reference database and the non-reference database is invoked to read the template parameter file respectively and obtain the updated data; The batch program of the database is invoked to add the updated data to the parameter table of the target area corresponding to the current identification information.

5. The method according to claim 4, wherein, The process of calling multiple non-reference databases in a batch program to read the template parameter file from the batch file server includes: A batch program for multiple non-reference databases is invoked to access the batch file server via a file transfer protocol to obtain the template parameter file, wherein file transfer between the multiple non-reference databases is performed through the batch file server.

6. The method according to claim 1, wherein, The step of determining whether the updated data meets the verification conditions based on the metadata management data includes: Configure an operation identifier, wherein the operation identifier contains information indicating that the updated data is associated with the metadata management data; Based on the operation identifier, determine the association between the updated data and the data in the metadata management data.

7. The method according to claim 6, wherein, The step of determining the association between the updated data and the data in the metadata management data based on the operation identifier includes: Based on multiple operation identifiers, a prompt message is generated through cyclic redundancy check; The multiple operation identifiers are used to represent newly added, updated, and deleted information, respectively; If the addition is confirmed, the updated data already exists in the metadata management data, and a notification for the addition will be given. If the update is confirmed, then the updated data does not exist in the metadata management data, and an update prompt is issued; If the deletion is confirmed, the updated data will not exist in the metadata management data, and a deletion prompt will be issued.

8. The method according to claim 1, wherein, The step of determining whether the updated data meets the verification conditions based on the metadata management data further includes: Determine whether the table name corresponding to the parameter text of the updated data exists in the metadata management data.

9. The method according to claim 1, wherein, The step of determining whether the updated data meets the verification conditions based on the metadata management data further includes: Determine whether the primary key data of the updated data is missing or duplicated in the metadata management data.

10. A database parameter synchronization device, comprising: The acquisition module is used to acquire identification information corresponding to at least one target region from multiple databases. The first configuration module is used to configure a reference database and configure a template region in the reference database. The template region is configured as a virtual region that is different from any of the target regions. The second configuration module is used to configure the parameter text of the template area, wherein the parameter text contains updated data; it is also used to configure the parameter text using the updated data in response to determining whether the updated data is associated with all the target areas, if the updated data is associated with multiple target areas, and if the updated data is not associated with any of the target areas, configure the corresponding target area parameter table using the updated data. The verification module is used to verify the updated data based on a database script, including obtaining metadata management data corresponding to each database, each metadata management data storing primary key data of at least one target region parameter table in each database; determining whether the updated data meets the verification conditions based on the metadata management data; and The synchronization module is used to add the updated data to the parameter table corresponding to each target area based on the updated data and the identification information, using a batch file server.

11. An electronic device, comprising: One or more processors; Storage device for storing one or more programs. Wherein, when the one or more programs are executed by the one or more processors, the one or more processors perform the method according to any one of claims 1 to 9.

12. A computer-readable storage medium having stored thereon executable instructions that, when executed by a processor, cause the processor to perform the method according to any one of claims 1 to 9.

13. A computer program product comprising a computer program that, when executed by a processor, implements the method according to any one of claims 1 to 9.

Images