CN116361396A - Database parameter synchronization method, apparatus, device, medium and program product - Google Patents

Abstract

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

Description

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

Technical Field

The present disclosure relates to the field of computers and finances, and more particularly, to a database parameter synchronization method, apparatus, device, medium, and program product.

Background

In a banking system, four independent databases are deployed in four areas of Asia, european, american and Dagao, and in practical service application, parameters of the four areas are required to be kept synchronous so as to complete service management. With the development of post-overseas services, the situation of increasing areas and changing database types from a host platform occurs, so that parameters need to be kept synchronous among a plurality of databases, and the type databases need not to be kept synchronous.

At present, in order to synchronize a plurality of database parameters, the parameters are required to be manually released for maintenance, so that the operation is repeated and complicated, and the problem that the service is abnormal due to the parameters is easy to occur.

Disclosure of Invention

In view of the foregoing, embodiments of the present disclosure provide a database parameter synchronization method, apparatus, device, medium, and program product that improve database parameter synchronization maintenance efficiency and accuracy.

According to a first aspect of an embodiment of the present disclosure, there is provided a database parameter synchronization method, including: acquiring identification information respectively corresponding to at least one target area in a plurality of databases; configuring a reference database, wherein the reference database comprises a template area; configuring a parameter text of a template area, wherein update data is configured in the parameter text; checking updated data in the parameter text based on the database script; and based on the batch file server, adding the update data to the parameter table corresponding to each target area according to the update data and the identification information.

According to an embodiment of the present disclosure, obtaining identification information corresponding to at least one target area in a plurality of databases includes: codes respectively corresponding to each target area are generated based on the area identification of each target area, and the codes are determined as identification information.

According to an embodiment of the present disclosure, obtaining identification information corresponding to at least one target area in the plurality of databases, respectively, further includes: generating an updated code according to the region identification of the updated target region in response to the updating of the target region; and adding the updated target area and the corresponding updated code to the identification information.

According to an embodiment of the present disclosure, based on a batch file server, adding update data to a parameter table corresponding to each target area according to the update data and the identification information includes: calling a batch program of a reference database, reading a parameter text, generating a template parameter file, and storing the template parameter file on a batch file server; the template parameter file contains information of parameter text; calling batch programs of a plurality of non-reference databases, and reading template parameter files of a batch file server; calling batch programs of a reference database and a non-reference database, and respectively reading template parameter files to obtain updated data; and calling a batch program of the database, and adding the updated data into a parameter table of the target area corresponding to the current identification information.

According to an embodiment of the present disclosure, wherein invoking a batch program of a plurality of non-reference databases, reading a template parameter file of a batch file server includes: and calling batch programs of a plurality of non-reference databases, accessing a batch file server in a file transfer protocol mode, and obtaining a template parameter file, wherein file transfer is carried out among the plurality of non-reference databases through the batch file server.

According to an embodiment of the present disclosure, wherein verifying the update data based on the database script comprises: acquiring metadata management data corresponding to each database, wherein each metadata management data stores primary key data of at least one target area parameter table in each database; based on the metadata management data, it is determined whether the update data satisfies a check condition.

According to an embodiment of the present disclosure, wherein determining whether the update data satisfies the check condition based on the metadata management data includes: configuring an operation identifier, wherein the operation identifier comprises information of association between update data and metadata management data; based on the operation identification, judging the association condition of the update data and the data in the metadata management data.

According to an embodiment of the present disclosure, determining, based on the operation identifier, a relationship between the update data and the data in the metadata management data includes: generating prompt information through cyclic redundancy check based on a plurality of operation identifiers; the operation identifiers are respectively used for representing newly added, updated and deleted information; under the condition that the new addition is determined, updating data exists in the metadata management data, and a new addition prompt is carried out; under the condition that the update is determined, the metadata management data does not contain update data, and update prompt is carried out; and under the condition that deletion is determined, updating data does not exist in the metadata management data, and deletion prompt is carried out.

According to an embodiment of the present disclosure, wherein determining whether the update data satisfies the check condition based on the metadata management data further includes: the existence of a table name of a parameter text corresponding to the update data in the metadata management data is determined.

According to an embodiment of the present disclosure, wherein determining whether the update data satisfies the check condition based on the metadata management data further includes: and determining the blank condition and the repeated condition of the primary key data of the update data in the metadata management data.

According to an embodiment of the present disclosure, further comprising: in response to determining whether the update data is associated with all of the target areas, the parameter text is configured with the update data if the update data is associated with all of the target areas, and the corresponding target area parameter table is configured with the update data if the update data is not associated with all of the target areas.

A second aspect of an embodiment of the present disclosure provides a database parameter synchronization apparatus, including: the acquisition module is used for acquiring identification information corresponding to at least one target area in the databases respectively; the first configuration module is used for configuring a reference database and configuring a template area in the reference database; the second configuration module is used for configuring a parameter text of the template area, wherein update data is configured in the parameter text; the verification module is used for verifying the updated data based on the database script; and the synchronization module is used for adding the update data to the parameter table corresponding to each target area based on the batch file servers according to the update data and the identification information.

A third aspect of the disclosed embodiments provides an electronic device, comprising: one or more processors; and a memory for storing one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the database parameter synchronization method described above.

A fourth aspect of the disclosed embodiments also provides a computer-readable storage medium having stored thereon executable instructions that, when executed by a processor, cause the processor to perform the database parameter synchronization method described above.

A fifth aspect of the disclosed embodiments also provides a computer program product comprising a computer program which, when executed by a processor, implements the database parameter synchronization method described above.

Drawings

The foregoing and other objects, features and advantages of the disclosure will be more apparent from the following description of embodiments of the disclosure with reference to the accompanying drawings, in which:

FIG. 1 schematically illustrates an application scenario diagram of database parameter synchronization methods, apparatus, devices, media and program products according to embodiments of the present disclosure;

FIG. 2 schematically illustrates a flow chart of a database parameter synchronization method according to an embodiment of the present disclosure;

FIG. 3 schematically illustrates a flowchart for obtaining identification information corresponding to a target area in a plurality of databases according to an embodiment of the disclosure;

FIG. 4 schematically illustrates a decision flow diagram for the case of updating data associated with a target area in accordance with an embodiment of the present disclosure;

FIG. 5 schematically illustrates a flow chart of updating a parameter table corresponding to a target area based on update data and identification information in an embodiment of the present disclosure;

FIG. 6 schematically illustrates a flow chart for verifying update data in an embodiment in accordance with the disclosure;

FIG. 7 schematically illustrates a flow chart for verifying update data based on an operation identification in an embodiment of the disclosure;

FIG. 8 schematically illustrates a flow diagram for generating hint information based on operation identifiers in an embodiment of the present disclosure;

FIG. 9 schematically illustrates a flow chart for verifying update data in accordance with another embodiment of the present disclosure;

FIG. 10 schematically illustrates a block diagram of a database parameter synchronization apparatus according to an embodiment of the present disclosure; and

fig. 11 schematically illustrates a block diagram of an electronic device adapted to implement a database parameter synchronization method according to an embodiment of the disclosure.

Detailed Description

Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. It should be understood that the description is only exemplary and is not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the present disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. In addition, in the following description, descriptions of well-known structures and techniques are omitted so as not to unnecessarily obscure the concepts of the present disclosure.

The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. The terms "comprises," "comprising," and/or the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.

All terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art unless otherwise defined. It should be noted that the terms used herein should be construed to have meanings consistent with the context of the present specification and should not be construed in an idealized or overly formal manner.

Where expressions like at least one of "A, B and C, etc. are used, the expressions should generally be interpreted in accordance with the meaning as commonly understood by those skilled in the art (e.g.," a system having at least one of A, B and C "shall include, but not be limited to, a system having a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.).

It should be noted that, the method and the device for synchronizing database parameters of the present disclosure may be used for cross-border database parameter synchronization in the financial field, and may also be used for cross-database parameter synchronization in any field other than the financial field, where the application field of the method and the device for database parameter synchronization of the present disclosure is not limited.

In the technical scheme of the disclosure, the related processes of collecting, storing, using, processing, transmitting, providing, disclosing, applying and the like of the personal information of the user all conform to the regulations of related laws and regulations, necessary security measures are adopted, and the public order harmony is not violated.

In the technical scheme of the disclosure, the authorization or consent of the user is obtained before the personal information of the user is obtained or acquired.

The embodiment of the disclosure provides a database parameter synchronization method, which comprises the following steps: acquiring identification information respectively corresponding to at least one target area in a plurality of databases; configuring a reference database, wherein the reference database comprises a template area; configuring a parameter text of a template area, wherein update data is configured in the parameter text; checking updated data in the parameter text based on the database script; and based on the batch file server, adding the update data to the parameter table corresponding to each target area according to the update data and the identification information.

Fig. 1 schematically illustrates an application scenario diagram of a database parameter synchronization method, apparatus, device, medium and program product according to an embodiment of the present disclosure.

As shown in fig. 1, an 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 is a medium used to provide 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, wireless communication links, or fiber optic cables, among others.

The user may interact with the server 105 via the network 104 using the first terminal device 101, the second terminal device 102, the third terminal device 103, to receive or send messages etc. Various communication client applications, such as a shopping class application, a web browser application, a search class application, an instant messaging tool, a mailbox client, social platform software, etc. (by way of example only) may be installed on the first terminal device 101, the second terminal device 102, and the third terminal device 103.

The first terminal device 101, the second terminal device 102, the third terminal device 103 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablets, laptop and desktop computers, and the like.

The server 105 may be a server providing various services, such as a background management server (by way of example only) providing support for websites browsed by the user using the first terminal device 101, the second terminal device 102, and the third terminal device 103. The background management server may analyze and process the received data such as the user request, and feed back the processing result (e.g., the web page, information, or data obtained or generated according to the user request) to the terminal device.

It should be noted that the credit adjustment method provided in the embodiments of the present disclosure may be generally executed by the server 105. Accordingly, the credit adjustment device provided in the embodiments of the present disclosure may be generally disposed in the server 105. The credit adjustment method provided by the embodiments of the present disclosure may also be performed by a server or a server cluster that is different from the server 105 and is capable of communicating with the first terminal device 101, the second terminal device 102, the third terminal device 103, and/or the server 105. Accordingly, the credit adjustment apparatus provided in the embodiments of the present disclosure may also be provided in a server or a server cluster that is different from the server 105 and is capable of communicating with the first terminal device 101, the second terminal device 102, the third terminal device 103, and/or the server 105.

It should be understood that the number of terminal devices, networks and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.

The database parameter synchronization method of the disclosed embodiment will be described in detail below with reference to fig. 2 to 9 based on the scenario described in fig. 1.

Fig. 2 schematically illustrates a flowchart of a database parameter synchronization method according to an embodiment of the present disclosure.

As shown in fig. 2, the database parameter synchronization method of this embodiment includes operations S200 to S600.

In operation S200, identification information corresponding to at least one target area in the plurality of databases is acquired.

The method for acquiring the identification information corresponding to at least one target area in the multiple databases comprises the following steps: generating codes respectively corresponding to each target area based on the area identification of each target area, and determining the codes as identification information

In some embodiments, the plurality of databases may be multiple independent databases of financial institutions distributed across different continents, for example, the plurality of databases may be four independent IBM DB2 databases deployed for four large regions of asia, euler, america, and the large row. The target area is an area where at least one service terminal in the database is located, for example, one country may be divided into one target area, and the target area in the asian database may include china, japan, korea, etc.

The identification information corresponding to the target area may be a digital code set for the target area, taking the target area in the asian database as an example, chinese line 001, japanese line 002, korean line 003, etc. Generating a region number table according to codes of target regions in different databases, wherein each database corresponds to one region number table, and the region number table comprises the target region and the codes corresponding to the target region.

It should be noted that, in each database in the embodiment of the present disclosure, the rule of dividing the target area is not specifically limited. Meanwhile, the setting mode of the target area identification information is not particularly limited, letters, characters and the like can be used as the identification to distinguish a plurality of target areas.

In operation S300, a reference database is configured, wherein the reference database includes a template area therein.

In some embodiments, one database is selected from the plurality of databases as the reference database. For example, asian databases are selected as the reference databases in the disclosed embodiments. The selection of the reference database is based on the database to which the template area belongs, i.e. the database to which the template area belongs is used as the reference database.

The template area is a region for setting in a certain database different from any one of the target areas in the database. The identification information (digital code) corresponding to the template area is set to 0 in the embodiment of the present disclosure.

In operation S400, a parametric text of a template area is configured, wherein update data is configured in the parametric text.

In some embodiments, the text is a computer file made up of lines of characters. Text files exist in computer file systems, which may contain plain text. Generally, computers can be divided into two categories, text files and binary files. Text is a document type of a computer. Such documents are used primarily for recording and storing text information, rather than image, sound, and formatting data. Common text documents are expanded by txt, doc, doc, wps, etc.

The parametric text may be character-type data contained in the text. Under the condition that parameter synchronization is needed, when the edition is first transmitted, a technician maintains the parameter text to obtain the parameter text containing updated data.

In operation S500, update data in the parameter text is checked based on the database script.

In some embodiments, a database script is a collection of statements used to create a database object. The specific verification process may refer to the descriptions of the steps from operation S801 to operation S803, and in order to avoid repetition, the description is omitted here.

In operation S600, based on the batch file server, the update data and the identification information are added to the parameter table corresponding to each target area.

In some embodiments, a batch file server is shared among multiple databases. Each target area contains a table of parameters. And at the end of the day (running at night every day), the batch file server updates the parameter text of the template area between the reference database and the non-reference database, namely, the updated parameters are inserted into the parameter table corresponding to each target area, and the parameter table is updated in time.

It can be understood that the parameter synchronization among a plurality of databases can be realized by setting the identification information to generate the area code table, simultaneously, manually maintaining the parameter text of the template area according to the identification information, automatically copying the parameter text of the template area through batch programs, inserting the update data in the parameter text into the parameter table of the target area according to the area code table, and replacing a manual one-by-one maintenance mode through a batch parameter automatic maintenance mode, thereby greatly reducing manual work, improving the parameter synchronization efficiency and reducing the probability of service problems caused by untimely parameter synchronization.

Fig. 3 schematically illustrates a flowchart for acquiring identification information corresponding to a target area in a plurality of databases according to an embodiment of the present disclosure.

As shown in fig. 3, the obtaining of the identification information corresponding to the at least one target area in the plurality of databases according to this embodiment further includes operations S201 to S202.

In operation S201, in response to the update of the target area, an updated code is generated according to the region identification of the updated target area.

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

In some embodiments, in the event that an increase or decrease occurs in the target area in at least one database. For example, when india is added as a target region in an asian database, codes different from other target regions are generated for india target regions, such as: india 004. The information of India 004 is added into the area code table to finish updating the area code table. When the parameter copying and updating are carried out by the daily terminal batch program, the updated parameters can be added into the parameter table corresponding to the target area india according to the updated area number table.

It can be understood that, for increasing or decreasing the target area, parameters can be automatically configured in the newly added target area by only maintaining the area code table and increasing or decreasing the corresponding target area.

Fig. 4 schematically illustrates a decision flow diagram for the case where update data is associated with a target area in an embodiment of the present disclosure.

As shown in fig. 4, the method of this embodiment further includes operations S900 to S902.

In operation S900, in response to determining whether the update data is associated with all the target areas.

In operation S901, in the case where update data is associated with each of a plurality of target areas, a parameter text is configured with the update data.

In operation S902, in the case where the update data is not associated with all the target areas, the corresponding target area parameter table is configured with the update data.

Under the condition that the update parameters correspond to the parameter tables of all the target areas, the parameter update can be performed by adopting the method; and under the condition that the updating parameters are updated only in one or more target areas, the parameter text of the template area is not required to be maintained, only the parameter table of one or more target areas corresponding to the updating parameters is required to be maintained, and the automatic complement function is not required to be triggered.

Fig. 5 schematically illustrates a flowchart of updating a parameter table corresponding to a target area based on update data and identification information in an embodiment according to the present disclosure.

As shown in fig. 5, the batch-based file server according to the embodiment adds update data to the parameter table corresponding to each target area according to the update data and the identification information, and the operations include operations S601 to S604.

In operation S601, a batch program of the reference database is called, a parameter text is read, a template parameter file is generated, and the template parameter file is stored on a batch file server; the template parameter file contains information of parameter text.

In some embodiments, taking the asian large area 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 a batch file server by means of a file transfer protocol (File Transfer Protocol, FTP).

FTP uses the user interface of the Internet standard file transfer protocol FTP to provide a set of applications for managing file transfers between computers.

In operation S602, a batch program of a plurality of non-reference databases is called, and a template parameter file of a batch file server is read.

The method for calling the batch program of the plurality of non-reference databases to read the template parameter files of the batch file server comprises the following steps: and calling batch programs of a plurality of non-reference databases, accessing a batch file server in a file transfer protocol mode, and obtaining a template parameter file, wherein file transfer is carried out among the plurality of non-reference databases through the batch file server.

In some embodiments, the batch program corresponding to each database accesses the batch file server through the file transfer mode, and obtains the template parameter file, so that the template parameter file containing the updated data (parameters) corresponds to the database of each large area.

In operation S603, batch programs of the reference database and the non-reference database are called, and the template parameter files are read respectively to obtain updated data.

In some embodiments, a batch program referencing a database and a non-referencing database reads the template parameter file to obtain update data to insert corresponding update data in a parameter table of a target region in the database.

In operation S604, a batch program of the database is called, and update data is added to the parameter table of the target area corresponding to the current identification information.

In some embodiments, the day end uses the update data in the template parameter file as a template and refers to the area code table, and adds the update data in the parameter table of the target area to complete the update of the parameter table of the target area among a plurality of databases, so as to realize the synchronous update of a plurality of database parameters.

FIG. 6 schematically illustrates a flow chart for verifying update data in an embodiment in accordance with the disclosure.

As shown in fig. 6, in order to check whether the insertion of update data in the parameter text causes a problem. The verification of the update data based on the database script of this embodiment includes operations S501 to S502.

In operation S501, metadata management data corresponding to each database is acquired, and each metadata management data stores primary key data of at least one target area parameter table in each database.

In some embodiments, each database corresponds to a metadata management table in which primary key data corresponding to a plurality of target region parameter tables in the database is stored. Primary key data, referring to a column or combination of columns, whose value can uniquely identify each row in a table, by which the physical integrity of the table can be enforced. The primary key is mainly associated with foreign keys of other tables, and the modification and deletion of text records. The primary key may be created by defining PRIMARY KEY constraints when creating or modifying the table. A table can only have one PRIMARY KEY constraint and columns in the PRIMARY KEY constraint cannot accept null values. Since PRIMARY KEY constraints ensure unique data, identification columns are often defined.

In operation S502, it is determined whether the update data satisfies a check condition based on the metadata management data.

In some embodiments, the update data and the metadata management data are checked, if the update data meets the check condition, the subsequent operation is performed, if the update data does not meet the check condition, the manual modification is returned, and the check is performed again after the modification until the check is passed.

FIG. 7 schematically illustrates a flow chart for verifying update data based on an operation identification in an embodiment of the disclosure.

As shown in fig. 7, determining whether the update data satisfies the check condition based on the metadata management data of this embodiment includes operations S5021 to S5022.

In operation S5021, an operation identifier is configured, where the operation identifier includes information that update data and metadata management data are associated with each other.

In operation S5022, the association of the update data with the data in the metadata management data is determined based on the operation identification.

The specific operation identifier verification refers to operations S700 to S703 described below.

FIG. 8 schematically illustrates a flow diagram for generating hint information based on operation identifiers in an embodiment of the present disclosure.

As shown in fig. 8, the judgment of the association of the update data with the data in the metadata management data based on the operation identification of this embodiment includes operations S700 to S703.

In operation S700, hint information is generated through cyclic redundancy check based on a plurality of operation identities.

The operation identifiers are respectively used for representing newly added, updated and deleted information;

0: newly-added metadata management data are updated, and then new errors are reported;

1: updating, namely updating and reporting errors if the metadata management data does not contain updated data;

2: deleting, namely deleting the error reporting if the metadata management data does not have updated data.

When the new addition is prompted, updated data is already present, and repeated operation is not needed; when the update is prompted, the update data does not exist, and the update can be performed; when deletion is prompted, the update data is present before and deleted, and it is necessary to verify whether the update needs to be performed again.

In operation S701, when it is determined that the metadata is newly added, update data already exists in the metadata management data, and a new addition instruction is performed.

In operation S702, if an update is determined, update data does not exist in the metadata management data, and an update presentation is performed.

In operation S703, when deletion is determined, update data does not exist in the metadata management data, and a deletion prompt is made.

Fig. 9 schematically illustrates a flow chart for verifying update data in accordance with another embodiment of the present disclosure.

As shown in fig. 9, determining whether the update data satisfies the check condition based on the metadata management data of this embodiment includes operations S801 to S803.

In operation S801, the association of the update data with the data in the metadata management data is determined based on the operation identification.

Here, the operation S801 is the same as the operation S5022 described above, and the operation S5022 is changed to the operation S801 in order to embody the three-step integration of the verification.

In operation S801, the existence of a table name of a parameter text corresponding to update data in metadata management data is determined.

In some embodiments, the parameter text table name verification is performed for verification purposes requiring an update of the all-region (all target regions) parameter table; and if the updating of the all-region parameter table is not needed, prohibiting the template region parameter text from carrying out new updating data. And if the whole area parameter table is required to be updated, allowing the template area parameter text to carry out new addition of update data.

In operation S803, a blank condition and a repeated condition of the primary key data of the update data in the metadata management data are determined.

In some embodiments, for example, the cleaning parameters: and if the primary key data is a cleaning indication, the coding of the target area and the cleaning condition, three fields of the cleaning parameters in the metadata management data cannot be vacant and repeated.

It should be noted that, the three checks may be performed separately for operation identification check or table name check or gradual data check, or may be combined two by two, and the embodiment of the present disclosure does not specifically limit the order and kind of check, and a technician may adjust according to a specific application.

Based on the database parameter synchronization method, the disclosure also provides a database parameter synchronization device. The device will be described in detail below in connection with fig. 10.

Fig. 10 schematically illustrates a block diagram of a database parameter synchronization apparatus according to an embodiment of the present disclosure.

As shown in fig. 10, the database parameter synchronization apparatus 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.

The obtaining module 810 is configured to obtain identification information corresponding to at least one target area in the multiple databases. In an embodiment, the obtaining module 810 may be configured to perform the operation S200 described above, which is not described herein.

The first configuration module 820 is configured to configure a reference database and configure a template region in the reference database. In an embodiment, the first configuration module 820 may be used to perform the operation S300 described above, which is not described herein.

The second configuration module 830 is configured to configure a parameter text of the template area, where update data is configured in the parameter text. In an embodiment, the second configuration module 830 may be configured to perform the operation S400 described above, which is not described herein.

The verification module 830 is configured to verify the update data based on the database script. In an embodiment, the verification module 830 may be configured to perform the operation S500 described above, which is not described herein.

The synchronization module 830 is configured to add update data to a parameter table corresponding to each target area based on the batch file server according to the update data and the identification information. In an embodiment, the synchronization module 830 may be configured to perform the operation S600 described above, which is not described herein.

According to embodiments of the present disclosure, any 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 combined in one module to be implemented, or any of the modules may be split into a plurality of modules. Alternatively, at least some of the functionality of one or more of the modules may be combined with at least some of the functionality of other modules and implemented in one module. According to embodiments of the present 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 may be implemented at least in part 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 a package, an Application Specific Integrated Circuit (ASIC), or may be implemented in hardware or firmware in any other reasonable manner of integrating or packaging the circuitry, or in any one of or a suitable combination of any of the three implementations of software, hardware, and firmware. 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 at least partially implemented as computer program modules that, when executed, perform the corresponding functions.

Fig. 11 schematically illustrates a block diagram of an electronic device adapted to implement a database parameter synchronization method according to an embodiment of the disclosure.

As shown in fig. 11, an electronic device 900 according to an embodiment of the present disclosure includes a processor 901 that 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)), or the like. Processor 901 may also include on-board memory for caching purposes. Processor 901 may include a single processing unit or multiple processing units for performing the different actions of the method flows according to embodiments of the present disclosure.

In the RAM 903, various programs and data necessary for the operation of the electronic device 900 are stored. The processor 901, the ROM 902, and the RAM 903 are connected to each other by a bus 904. The processor 901 performs various operations of the method flow according to the embodiments of the present disclosure by executing programs in the ROM 902 and/or the RAM 903. Note that the program may be stored in one or more memories other than the ROM 902 and the RAM 903. The 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.

According to an embodiment of the disclosure, the electronic device 900 may also include an input/output (I/O) interface 905, the input/output (I/O) interface 905 also being connected to the 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, a mouse, and the like; an output portion 907 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and a speaker; a storage portion 908 including a hard disk or the like; and a communication section 909 including a network interface card such as a LAN card, a modem, or the like. The communication section 909 performs communication processing via a network such as the internet. The drive 910 is also connected to the I/O interface 905 as needed. A removable medium 911 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is installed as needed on the drive 910 so that a computer program read out therefrom is installed into the storage section 908 as needed.

The present disclosure also provides a computer-readable storage medium that may be embodied in the apparatus/device/system described in the above embodiments; or may exist alone without being assembled into the apparatus/device/system. The computer-readable storage medium carries one or more programs which, when executed, implement methods in accordance with embodiments of the present disclosure.

According to embodiments of the present disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium, which may include, for example, but is not limited to: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this disclosure, a computer-readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. For example, according to embodiments of the present 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.

Embodiments of the present disclosure also include a computer program product comprising a computer program containing program code for performing the methods shown in the flowcharts. The program code, when executed in a computer system, causes the computer system to implement the item recommendation method provided by embodiments of the present disclosure.

The above-described functions defined in the system/apparatus of the embodiments of the present disclosure are performed when the computer program is executed by the processor 901. The systems, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the disclosure.

In one embodiment, the computer program may be based on a tangible storage medium such as an optical storage device, a magnetic storage device, or the like. In another embodiment, the computer program may also be transmitted, distributed, and downloaded and installed in the form of a signal on a network medium, via communication portion 909, and/or installed from removable medium 911. The computer program may include program code that may be transmitted using any appropriate network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the foregoing.

In such an embodiment, the computer program may be downloaded and installed from the network via the communication portion 909 and/or installed from the removable medium 911. The above-described functions defined in the system of the embodiments of the present disclosure are performed when the computer program is executed by the processor 901. The systems, devices, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the disclosure.

According to embodiments of the present disclosure, program code for performing computer programs provided by embodiments of the present disclosure may be written in any combination of one or more programming languages, and in particular, such computer programs may be implemented in high-level procedural and/or object-oriented programming languages, and/or assembly/machine languages. Programming languages include, but are not limited to, such as Java, c++, python, "C" or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of remote computing devices, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., connected via the Internet using an Internet service provider).

The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

Those skilled in the art will appreciate that the features recited in the various embodiments of the disclosure and/or in the claims may be provided in a variety of combinations and/or combinations, even if such combinations or combinations are not explicitly recited in the disclosure. In particular, the features recited in the various embodiments of the present disclosure and/or the claims may be variously combined and/or combined without departing from the spirit and teachings of the present disclosure. All such combinations and/or combinations fall within the scope of the present disclosure.

The embodiments of the present disclosure are described above. However, these examples are for illustrative purposes only and are not intended to limit the scope of the present disclosure. Although the embodiments are described above separately, this does not mean that the measures in the embodiments cannot be used advantageously in combination. The scope of the disclosure is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be made by those skilled in the art without departing from the scope of the disclosure, and such alternatives and modifications are intended to fall within the scope of the disclosure.

Claims (15)

1. A database parameter synchronization method, comprising:

acquiring identification information respectively corresponding to at least one target area in a plurality of databases;

Configuring a reference database, wherein the reference database comprises a template area;

configuring a parameter text of the template area, wherein update data is configured in the parameter text;

checking the updated data in the parameter text based on a database script; and

based on a batch file server, adding the update data to a parameter table corresponding to each target area according to the update data and the identification information.

2. The method of claim 1, wherein the obtaining identification information corresponding to at least one target area in the plurality of databases, respectively, comprises:

and generating codes respectively corresponding to each target area based on the area identification of each target area, and determining the codes as the identification information.

3. The method of claim 2, wherein obtaining identification information in the plurality of databases corresponding to at least one target area, respectively, further comprises:

generating an updated code according to the region identification of the updated target region in response to the updating of the target region;

and adding the updated target area and the corresponding updated code to the identification information.

4. The method of claim 2, wherein the adding the update data to the parameter table corresponding to each target area based on the batch file server according to the update data and the identification information comprises:

invoking a batch program of the reference database, reading the parameter text, generating a template parameter file, and storing the template parameter file on the batch file server; the template parameter file contains information of the parameter text;

calling batch programs of a plurality of non-reference databases, and reading template parameter files of the batch file servers;

invoking batch programs of the reference database and the non-reference database, and respectively reading the template parameter files to obtain the updated data;

and calling a batch program of the database, and adding the updated data into a parameter table of the target area corresponding to the current identification information.

5. The method of claim 4, wherein the calling a batch program of a plurality of non-reference databases, reading a template parameter file of the batch file server comprises:

and calling batch programs of the non-reference databases, accessing the batch file servers in a file transfer protocol mode, and obtaining the template parameter files, wherein file transfer is performed among the non-reference databases through the batch file servers.

6. The method of claim 1, wherein the verifying the update data based on a database script comprises:

acquiring metadata management data corresponding to each database, wherein each metadata management data stores primary key data of at least one target area parameter table in each database;

based on the metadata management data, it is determined whether the update data satisfies a check condition.

7. The method of claim 6, wherein the determining whether the update data satisfies a check condition based on the metadata management data comprises:

configuring an operation identifier, wherein the operation identifier comprises information of association between the update data and the metadata management data;

and judging the association condition of the update data and the data in the metadata management data based on the operation identification.

8. The method of claim 7, wherein the determining, based on the operation identifier, a relationship of the update data to data in the metadata management data comprises:

generating prompt information through cyclic redundancy check based on a plurality of operation identifiers;

the operation identifiers are respectively used for representing newly added, updated and deleted information;

Under the condition that the new addition is determined, the update data is already existing in the metadata management data, and a new addition prompt is carried out;

under the condition that the update is determined, the metadata management data does not contain the update data, and update prompt is carried out;

and under the condition that the deletion is determined, the update data does not exist in the metadata management data, and a deletion prompt is carried out.

9. The method of claim 6, wherein the determining whether the update data satisfies a check condition based on the metadata management data further comprises:

and determining the existence condition of the table name of the parameter text corresponding to the updated data in the metadata management data.

10. The method of claim 6, wherein the determining whether the update data satisfies a check condition based on the metadata management data further comprises:

and determining the blank condition and the repeated condition of the primary key data of the update data in the metadata management data.

11. The method of claim 1, further comprising:

in response to determining whether the update data is associated with all of the target areas, configuring a parameter text with the update data if the update data is associated with a plurality of the target areas, and configuring a corresponding target area parameter table with the update data if the update data is not associated with all of the target areas.

12. A database parameter synchronization apparatus, comprising:

the acquisition module is used for acquiring identification information corresponding to at least one target area in the databases;

the first configuration module is used for configuring a reference database and configuring a template area in the reference database;

the second configuration module is used for configuring the parameter text of the template area, wherein the parameter text is configured with update data;

the verification module is used for verifying the updated data based on the database script; and

and the synchronization module is used for adding the update data to the parameter table corresponding to each target area based on the batch file servers according to the update data and the identification information.

13. An electronic device, comprising:

one or more processors;

storage means for storing one or more programs,

wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the method of any of claims 1-11.

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

15. A computer program product comprising a computer program which, when executed by a processor, implements the method according to any one of claims 1 to 11.

Images