CN102724295A - Data synchronization method and system - Google Patents

Abstract

The invention discloses a data synchronization method and system. The method includes: when the trigger condition is met, the data maintenance server determines the data to be updated synchronously of the data usage client according to the data demand information of the data usage client; and according to the data usage After the database connection information of the client is linked, store the data to be updated synchronously in the database of the data user client to realize data synchronization; wherein, the data requirement information and the database connection information are maintained by the data user client through data The data request application webpage released by the server is sent to the data maintenance server. Since the data usage client sends the data requirement information and database connection information to the data maintenance server through the data synchronization requirement application web page released by the data maintenance server, it is not necessary to install special software on the data usage client, which greatly reduces the time spent on increasing the data usage client. , The workload of maintenance personnel.

Description

Data Synchronization Method and System

technical field

The invention relates to computer communication technology, in particular to a data synchronization method and system.

Background technique

With the continuous deepening of informatization in government, government agencies, enterprises, universities and other units, the integration of information systems has gradually become a key point. Data integration is the basis of software system integration, data sharing is the main means of data integration, and data synchronization is one of the common technical means for data sharing between different business systems.

A data synchronization system for data synchronization includes: a data maintenance server and a data usage client. Among them, the data maintenance server is used to provide data; and the business system that needs these data is called a data usage client. The data maintenance server pushes the data to the data usage client according to the requirements of the data usage client for the data.

Usually, a data maintenance server needs to provide data for multiple data usage clients through data synchronization (as shown in Figure 1). In the prior art, data synchronization software usually provided by a third-party manufacturer is used for data synchronization. For example, Oracle's GoldenGate, Quest's SharePlex, DSG's RealSync, etc. The principle of data synchronization by these software is that the software on the data maintenance server reads the log of the database on the data maintenance server, analyzes the log to obtain the change operation, and sends the change operation to the data usage client, and then the software of the data usage client sends the source The change operation transmitted from the terminal is applied to the database of the data user client to complete data synchronization.

However, in the data synchronization method of the prior art, in addition to installing software on the data maintenance server, corresponding software also needs to be installed on the data usage client. Therefore, in the case of many clients using data, the software installation workload will be very heavy, and the workload of system maintenance personnel will be heavy.

In addition, when the data synchronization requirements of the data usage client change, for example, a data usage client needs to increase the data synchronization requirements of the data table W, then the data maintenance server and the software installed on the data usage client are also required. Re-doing the synchronization configuration will affect the normal synchronization of data between the data maintenance server and the data usage client, and the workload of the maintenance personnel will be heavy during the change process.

In addition, in the data synchronization method in the prior art, the function of determining whether the synchronization data required by the data usage client exceeds the authority also needs to be improved.

To sum up, in the data synchronization method of the prior art, when there are many clients using data, the workload of software installation is very heavy, resulting in a heavy workload for system maintenance personnel; when the data synchronization requirements of clients using data change , affects the normal synchronization of data, and the workload of maintenance personnel is heavy; the function of judging whether the synchronization data exceeds the authority needs to be improved.

Contents of the invention

The embodiment of the present invention provides a data synchronization method and system, without installing corresponding software on the data usage client, reducing the workload of system maintenance personnel.

According to one aspect of the present invention, a data synchronization method is provided, including:

When the trigger condition is satisfied, the data maintenance server determines the data to be updated synchronously of the data user client according to the data demand information of the data user client;

After the data maintenance server establishes a link with the database of the data usage client according to the database connection information of the data usage client, the data to be updated synchronously is stored in the database of the data usage client, and the The data is synchronized with the data of the client;

Wherein, the data requirement information and database connection information are included in the data requirement application information, and the data requirement application information is sent to the data by the data usage client through the data requirement application webpage published by the data maintenance server. maintenance server.

Further, the data requirement application information also includes identification information of the data usage client; and,

After the data usage client sends the data demand application information to the data maintenance server through the data demand application webpage issued by the data maintenance server, it also includes:

The data maintenance server performs a permission review on the data requirement information according to the data synchronization permission corresponding to the identification information of the data usage client; if the permission review passes, the data maintenance server marks the data requirement information as approved information on data requirements; and

According to the data requirement information of the data usage client, determining the data to be updated synchronously of the data usage client is specifically: according to the data requirement information whose flag of the data usage client is approved, determining the data to be updated synchronously of the data usage client.

Wherein, the data requirement information specifically includes the information of the synchronization object and the previous synchronization time information recorded for each synchronization object; and

According to the data demand information of the data usage client, determining the data to be updated synchronously of the data usage client specifically includes:

The data maintenance server, according to the information of each synchronization object in the data requirement information and the previous synchronization time information of each synchronization object, respectively, for each synchronization object, determines the data to be updated for synchronization of the synchronization object; and

After the determination of the synchronization update data of the synchronization object, it also includes:

The previous synchronization time information recorded for the synchronization object in the data requirement information is updated according to the time information of the synchronization object's data to be updated synchronously.

The information of the synchronization object specifically includes the name of the data table to be synchronized or the name of the view to be synchronized.

The information of the synchronization object further includes: the name of the column in the data table that needs to be synchronized or the name of the row in the data table that needs to be synchronized.

The database connection information includes: the data user's IP address, port number, database name, database user name, and database password.

The trigger conditions are specifically:

The set data synchronization cycle arrives; or,

There is updated data in the database of the data maintenance server; or,

There is updated data in the database of the data maintenance server within this data synchronization period, and this data synchronization period arrives.

According to another aspect of the present invention, a data synchronization system is also provided, including: a data maintenance server and at least one data usage client;

The data maintenance server is used to determine the data to be updated synchronously of each data user client according to the data demand information of each data user client when the trigger condition is met; After the database of the client is used to establish a link, the data to be updated by the client of the data is stored in the database of the client of the data, and the data of the client of the data is synchronized;

Wherein, the data requirement information and database connection information of each data usage client are included in the data requirement application information of the data usage client, and the data requirement application information of the data usage client is provided by the data usage client through the data maintenance server The published web page of data demand application is sent to the data maintenance server.

Wherein, the data requirement application information also includes the identification information of the data usage client; and,

The data maintenance server is further configured to perform permission review on the data requirement information according to the data synchronization permission corresponding to the identification information of the data usage client; if the permission review is passed, the data maintenance server determines that the data usage client is Approved data usage clients; and

According to the data demand information of each data user client, the data maintenance server determines that the data to be updated synchronously of each data user client is specifically:

The data maintenance server respectively determines the data to be updated synchronously of each approved data usage client according to the data requirement information of each approved data usage client.

According to the database connection information of each data user client, the data maintenance server establishes a link with the database of each data user client respectively, and stores the data to be updated synchronously of the data user client into the database of the data user client. Specifically:

The data maintenance server, according to the database connection information of each approved data user client, respectively establishes a link with the database of each approved data user client, and stores the data to be updated synchronously of the data user client into the data user in the client's database.

In the embodiment of the present invention, since the data usage client sends data requirement information and database connection information to the data maintenance server through the data synchronization requirement application web page released by the data maintenance server, the data maintenance server can send the data requirement information and database connection information according to the data usage client. Connection information, data synchronization on the data client, without installing special software on the data client, greatly reducing the workload of maintenance personnel when increasing the data client; when the data client needs to change the synchronization data requirements At the same time, it is not necessary to change the software of the data usage client, but to modify the relevant information through the data synchronization requirement application webpage, which further reduces the workload of maintenance personnel.

Furthermore, after the data maintenance server obtains the data request application information sent by the data user client through the data synchronization request application web page, it can also perform an authority review on the data request application information, and only after the review is passed, the data is synchronized to the data user client. The auditing function of the data synchronization system has been further improved to ensure that data users can obtain data according to their rights and needs, thus ensuring the safety of data use. In addition, it facilitates the auditing of data usage clients and reduces the auditing work of maintenance personnel.

Furthermore, when the synchronization object that needs to be synchronized by the data user client changes, it is only necessary to modify the relevant information on the data synchronization requirement application webpage, and resend the data requirement application information to the data maintenance server for review without changing the data usage client. Any software on the client side, or any software reconfiguration on the client side for data usage, further improves usage efficiency.

Description of drawings

FIG. 1 is a schematic diagram of a data synchronization system according to an embodiment of the present invention;

Fig. 2 is a flow chart of a method for sending data request application information to a data maintenance server by a data usage client through a web page issued by a data maintenance server according to an embodiment of the present invention;

Fig. 3 is a flowchart of a method for data synchronization performed by a data maintenance server to a data usage client according to an embodiment of the present invention.

Detailed ways

In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be described in further detail below with reference to the accompanying drawings and preferred embodiments. However, it should be noted that many of the details listed in the specification are only for readers to have a thorough understanding of one or more aspects of the present invention, and these aspects of the present invention can be implemented even without these specific details.

As used herein, terms such as "module" and "system" are intended to include computer-related entities such as, but not limited to, hardware, firmware, a combination of hardware and software, software, or software in execution. For example, a module may be, but is not limited to being limited to being, a process running on a processor, a processor, an object, an executable, a thread of execution, a program, and/or a computer. For example, both an application running on a computing device and the computing device could be modules. One or more modules can reside within a process and/or thread of execution and a module can be localized on one computer and/or distributed between two or more computers.

In the technical solution provided by the invention, a B/S structure is adopted between the data maintenance server and multiple data usage clients. The data maintenance server publishes the data synchronization requirement application webpage, and the users of each data usage client send the data requirement application information to the data maintenance server by accessing the data synchronization requirement application webpage, that is to say, the data maintenance server obtains each Data usage client's data requirements application information. The data requirement application information sent by the data usage client may include data requirement information and database connection information. The data requirement information mainly includes the information of the synchronization object that the data user client needs to perform data synchronization, such as the name of the data table that needs to be synchronized, or the name of the view that needs to be synchronized; the database connection information can specifically include data usage IP address, port number, database name, database user name, database password of the client; according to the database connection information, the data maintenance server can link to the database of the data usage client, and write the synchronous data into the database of the data usage client.

After the data maintenance server obtains the data demand information and database connection information of the data user client, when a preset trigger condition is met, for example, the trigger condition can be preset as "the set data synchronization cycle arrives", Then, when the set data synchronization period arrives, according to the data demand information of the data usage client, the data to be updated synchronously of the data usage client is determined. For example, if the data request information of the data user client includes the name of the data table W, it indicates that the data table W needs to be synchronized with data, and the data maintenance server determines that the data user needs to update the data of the data table W in the local database. The data to be updated synchronously at the end, that is, the data using the data table W of the client needs to be synchronized. The data maintenance server stores the data to be updated synchronously into the corresponding data table or view of the database of the data user client according to the database connection information of the data user client, so as to realize the data synchronization of the data user client. During this process, since the data usage client sends the data requirement information and database connection information to the data maintenance server through the data synchronization requirement application webpage issued by the data maintenance server, the data maintenance server can send the data requirement information and database connection information according to the data usage client. Database connection information, data synchronization on the data client, without installing special software on the data client, greatly reducing the workload of maintenance personnel when increasing the data client; when the data client needs to change the synchronization data When required, there is no need to change the software of the data usage client, but to modify the relevant information through the data synchronization requirement application webpage, which further reduces the workload of maintenance personnel.

The technical solutions of the embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings. The data synchronization system shown in FIG. 1 includes: a data maintenance server 101 and at least one data usage client 102 . The local database of a maintenance server 101 is maintained at the data maintenance server 101 end, and each data usage client 102 also has a database respectively, and the database in each data usage client 102 needs to carry out data synchronization with the database of the data maintenance server 101 Objects may not necessarily be the same. For example, if the synchronization object in the database of the data usage client A in the data usage client 102 needs to be synchronized with data table A, then the data usage client A needs to obtain the synchronization data of the data table A from the data maintenance server 101 . That is to say, if there is updated data in the data table A of the database of the data maintenance server 101, then the data maintenance server 101 needs to send the updated data to the data table A of the data usage client A, so that the data usage of the database of the client A Data table A implements data synchronization. For another example, the data usage client B in the data usage client 102 needs to synchronize the data table B in the database of the data usage client B, then the data usage client B needs to obtain the synchronization data of the data table B from the data maintenance server 101 . That is to say, if there is updated data in the data table B of the database of the data maintenance server 101, the data maintenance server 101 needs to send the updated data to the data table B of the data usage client B, so that the data usage of the data table B of the client B's database Data table B implements data synchronization.

Each data usage client 102 sends the data requirement application information of the data usage client 102 to the data maintenance server 101 through the data requirement application webpage issued by the data maintenance server 101 . The data requirement application information sent by the data usage client 102 includes the data requirement information and database connection information of the data usage client 102 .

After the data maintenance server 101 has obtained the data requirement information and the database connection information of each data usage client 102, when the trigger condition is satisfied, according to the data requirement information of each data usage client 102, determine each data usage client 102 to be synchronized. Update data; And use the database connection information of client 102 according to each data, after using the database of each data client 102 to set up a link respectively, this data uses client 102 to be stored in this data using client synchronously updated data In the database of the client 102, the data is synchronized using the client 102.

As a more optimal implementation manner, the data request application information sent by the data usage client 102 may also include the identification information of the data usage client 102 . The data maintenance server 101 can perform permission review on the data requirement information according to the data synchronization permission corresponding to the identification information of the data usage client 102; if the permission review is passed, the data maintenance server 101 marks the data usage client 102 as The approved data usage client 102 marks the data requirement information as approved data requirement information. Then, when the trigger condition is satisfied, the data maintenance server 101 determines the data to be updated synchronously of each approved data usage client 102 according to the data demand information of each approved data usage client 102; The data uses the database connection information of the client 102, after setting up a link with the database of each approved data using the client 102 respectively, the data to be updated synchronously of the data using the client 102 is stored in the data using the client 102. In the database, the data is synchronized using the client 102 .

Taking one of the data usage clients 102 as an example below, the data usage client 102 sends the data requirement information to the data maintenance server 101 through the data synchronization demand application webpage issued by the data maintenance server 101, and the data maintenance server 101 uses the data according to the data maintenance server 101. The data requirement information of the client 102 uses the data synchronization process of the client 102 for the data. The flow chart shown in Fig. 2 has shown this data using client 102 to send data demand information to data maintenance server 101 through the data synchronization demand application webpage issued by data maintenance server 101, and the method that data maintenance server 101 checks this data demand information The process includes the following steps:

S201: The data usage client 102 sends data requirement application information to the data maintenance server 101 through the data synchronization requirement application webpage published by the data maintenance server 101 .

The data synchronization requirement application webpage issued by the data maintenance server 101 allows the user of the data usage client 102 to input data requirement application information from the webpage. The data requirement application information may include the data requirement information and database connection information of the data usage client 102 .

The data requirement information specifically includes the information of each synchronization object that the data user client 102 needs to perform data synchronization, for example, the information of the synchronization object includes the name of the data table that needs to be synchronized or the name of the view that needs to be synchronized; or , the information of the synchronization object can further include the name of the column that needs to be synchronized in the data table that needs to be synchronized, or the name of the row that needs to be synchronized in the data table that needs to be synchronized; or, the synchronization object The information may further include the name of the column to be synchronized in the view to be synchronized, or the name of the row to be synchronized in the view to be synchronized.

For example, the unit data table stored in the data maintenance server 101 includes unit 1, unit 2, ..., unit n's unit name, unit address, unit phone number, and unit contact data. 1 and unit 3's unit name and unit address for data synchronization, then the data uses the information of the synchronization object of the data demand information of the client 102 to include: the name of the data table that needs to be synchronized - unit data table, unit data table The name of the row that needs to be synchronized with data - unit 1 and unit 3, the name of the column that needs to be synchronized with data in the unit data table - unit name, unit address.

Further, the data requirement information may also include the previous synchronization time information recorded for each synchronization object, and the previous synchronization time information of each synchronization object is used to indicate the update time of the latest data of the synchronization object during the last data synchronization .

S202: The data maintenance server 101 performs authority verification according to the data requirement application information sent by the data usage client 102; if the verification is passed, execute step S203; otherwise, execute step S204.

The data request application information sent by the data usage client 102 also includes the identification information of the data usage client 102 to uniquely identify the data usage client 102 and indicate the identity of the user of the data usage client 102 . The identification information of the data usage client 102 may include information such as the user name and password of the data usage client 102 .

The permission review of the data demand application information sent by the data usage client 102 can be manually reviewed by managers, or the data maintenance server 101 can automatically review according to the permission list:

A permission list is maintained in the data maintenance server 101, and the identification information of each data usage client 102 is correspondingly recorded in the permission list as the data synchronization permission of the data usage client 102, that is, the data usage client 102 is authorized to allow The permission of the synchronization object for data synchronization.

The data maintenance server 101 checks the authority of the data requirement information in the data requirement application information according to the authority list. Specifically, the data maintenance server 101 finds the corresponding data synchronization permission in the permission list according to the identification information of the data usage client 102, and determines whether the synchronization object of the data requirement information of the data usage client 102 is within the authorized data synchronization permission. within the scope; if yes, then determine that the data request information sent by the data usage client 102 has passed the authority review, and perform step S203; S204.

For example, the above-mentioned synchronization object information of the data requirement information of the data usage client 102 includes: unit data table, unit 1 and unit 3 in the unit data table, unit name and unit address in the unit data table. If it is recorded in the authority list that the authority of the synchronization object authorized by the client 102 to allow data synchronization includes: the unit data table, the unit 1-5 of the unit data table, the unit name of the unit data table, the unit address, work phone. Thus, it can be determined that the data requirement information of the data usage client 102 has the data synchronization authority, and the data requirement application information of the data usage client 102 has passed the authority review.

If the data is recorded in the permission list, the permission of the synchronization object authorized by the client 102 to perform data synchronization only includes: unit data table, unit 1 of the unit data table, unit name and unit address of the unit data table. Then, it can be determined that the data usage client 102 has no authority to synchronize the relevant data of the unit 3, therefore, it is determined that the data requirement application information of the data usage client 102 cannot pass the authority review.

In the process of the data maintenance server 101 checking the authority of the data requirement application information sent by the data usage client 102, the data maintenance server 101 marks the status of the data usage client 102 as under review. The data usage client 102 can query the status through the data synchronization demand application webpage published by the data maintenance server 101 .

S203: After the data maintenance server 101 approves the data demand application information sent by the data usage client 102, it marks the data usage client 102 as a data usage client 102 that has passed the review.

Specifically, after the data maintenance server 101 approves the data requirement application information sent by the data usage client 102, it marks the data requirement application information sent by the data usage client 102 as approved status, and marks the data usage client 102 as approved. For the approved data use client 102, mark the data demand information of the data use client 102 as approved data demand information. The data usage client 102 can query the approval status through the data synchronization requirement application web page published by the data maintenance server 101 .

S204: The data maintenance server 101 determines that the data requirement application information sent by the data usage client 102 has not passed the review, and then marks the data requirement application information sent by the data usage client 102 as a status of not passing the review. The data usage client 102 can inquire about the failed status through the data synchronization requirement application web page published by the data maintenance server 101 .

When the data usage client 102 needs to revise the data requirement information, it can also revise relevant information by accessing the data synchronization requirement application webpage, and resend the data requirement application information to the data maintenance server 101; the subsequent process is the same as that of the above-mentioned steps S201-S204 , which will not be repeated here. Therefore, when the synchronization object that needs to be synchronized by the data user client 102 changes, it is only necessary to modify the relevant information on the data synchronization requirement application webpage, and resend the data requirement application information to the data maintenance server 101 for review without changing the data. Using any software of the client 102, or reconfiguring the data using any software of the client 102, further improves usage efficiency.

After the data maintenance server 101 obtains the data requirement information and the database connection information of the data usage client 102 , it performs data synchronization on the data usage client 102 . Preferably, the data maintenance server 101 obtains the data requirement information and the database connection information of the data usage client 102, and performs data synchronization on the data usage client 102 after the obtained data requirement information is approved. Fig. 3 shows that the data maintenance server 101 performs data synchronization according to the data requirement information and the database connection information of the data usage client 102 by the data maintenance server 101, including the following steps:

S301: When the preset trigger condition is satisfied, the data maintenance server 101 starts to synchronize the data of the data usage client 102 according to the data demand information of the data usage client 102 .

Specifically, when the preset trigger condition is satisfied, the data maintenance server 101 starts to synchronize the data of each data usage client 102 according to the data demand information of each data usage client 102 .

Preferably, when the preset trigger condition is satisfied, the data maintenance server 101 starts data synchronization for each approved data usage client 102 according to the data requirement information of each approved data usage client 102 . The following steps take the data maintenance server 101 performing data synchronization on one of the data using the client 102 as an example to describe the specific process.

Those skilled in the art can preset trigger conditions according to specific situations. For example, the preset trigger condition is: the set data synchronization period arrives; that is, when the set data synchronization period arrives, the data maintenance server 101 starts to use the data of the data usage client 102 according to the data demand information of the data usage client 102. to sync.

Or, the preset trigger condition is: there is updated data in the database of the data maintenance server; that is, when there is updated data in the database of the data maintenance server, the data maintenance server 101 will be triggered to use the data demand information of the client 102 according to the data, Synchronization of data using client 102 data begins.

Alternatively, the preset trigger condition is: there is updated data in the database of the data maintenance server within this data synchronization period, and this data synchronization period arrives; that is, when the data synchronization period arrives, if it is determined that this If there is updated data in the database of the data maintenance server within the second data synchronization period, the data maintenance server 101 is triggered to start synchronizing the data of the data usage client 102 according to the data requirement information of the data usage client 102 .

Alternatively, the preset trigger condition also includes: determining that the data request application information sent by the data usage client 102 has passed the review; Based on the data requirement information of the data usage client 102, the data synchronization of the data usage client 102 starts.

S302: The data maintenance server 101 determines the data to be updated synchronously of the data usage client 102 according to the data demand information of the data usage client 102.

Specifically, the data maintenance server 101 determines, according to the information of each synchronization object in the data demand information of the data usage client 102 and the previous synchronization time information of each synchronization object, the data to be updated by the data usage client:

The data maintenance server 101 determines the corresponding data table or view in the local database according to the synchronization object information in the data demand information of the data usage client 102;

According to the previous synchronization time information of the synchronization object in the data requirement information of the data usage client 102, the data maintenance server 101 can determine from the corresponding data table or view the information that needs to be sent to the data usage client 102 during this data synchronization process. New synchronous data, that is, the data to be updated synchronously.

For example, the information of a synchronization object in the data demand information of the data user client 102 is the unit data table, the unit 1 of the unit data table, the unit name and the unit address of the unit data table; the previous synchronization time information of the synchronization object is 2012-3-15. The data maintenance server 101 determines the corresponding unit data table in the local database according to the information of the synchronization object; The unit name and unit address data are used as the data to be updated during the data synchronization process of the client 102 . In practical applications, the data maintenance server 101 may determine the update time of the data according to the time stamp of the data.

After determining the data to be synchronized and updated of a synchronization object of the data usage client, the data maintenance server 101 updates the previous data recorded for the synchronization object in the data requirement information of the data usage client 102 according to the time information of the data to be synchronized and updated. Secondary synchronization time information. For example, the data maintenance server 101 determines that the latest timestamp of the data to be synchronized and updated for a certain synchronization object is 2012-5-15, and updates the previous synchronization time information recorded by the synchronization object to 2012-5-15. Then, when performing the next data synchronization, the data maintenance server 101 can determine the data updated after May 15, 2012 as the synchronization time information according to the previous synchronization time information of the synchronization object record updated to 2012-5-15. The object's data to be updated synchronously.

S303: The data maintenance server 101 establishes a link with the database of the data usage client 102 according to the database connection information of the data usage client 102 .

The database connection information of the data usage client 102 may include: the IP address and port number of the data usage client 102, the database name of the data usage client 102, the database user name, the database password, and the like.

The data maintenance server 101 can establish a dblink connection (database link) with the database of the data usage client 102 according to the database connection information of the data usage client 102 .

S304: The data maintenance server 101 stores the data to be updated into the database of the data usage client 102, so as to realize the data synchronization of the data usage client 102.

After the data maintenance server 101 establishes a link with the database of the data usage client 102, it writes the data to be updated synchronously determined in the above step S302 into the corresponding data table of the database of the data usage client 102, thereby realizing the Data is synchronized using client 102 data.

In the embodiment of the present invention, since the data usage client sends data requirement information and database connection information to the data maintenance server through the data synchronization requirement application web page released by the data maintenance server, the data maintenance server can send the data requirement information and database connection information according to the data usage client. Connection information, data synchronization on the data client, without installing special software on the data client, greatly reducing the workload of maintenance personnel when increasing the data client; when the data client needs to change the synchronization data requirements At the same time, it is not necessary to change the software of the data usage client, but to modify the relevant information through the data synchronization requirement application webpage, which further reduces the workload of maintenance personnel.

Furthermore, after the data maintenance server obtains the data request application information sent by the data user client through the data synchronization request application web page, it can also perform permission review on the data request application information, and only after the review is passed, it sends the synchronization data to the data user client. The audit function of the data synchronization system has been improved to ensure that data users can obtain data according to their rights and needs, thereby ensuring the safety of data use. In addition, it facilitates the auditing of data usage clients and reduces the auditing work of maintenance personnel.

Furthermore, when the synchronization object that needs to be synchronized by the data user client 102 changes, it is only necessary to modify the relevant information on the data synchronization requirement application webpage, and resend the data requirement application information to the data maintenance server 101 for review, without changing Any software of the data usage client 102, or any software reconfiguration of the data usage client 102, further improves usage efficiency.

Those of ordinary skill in the art can understand that all or part of the steps in the method of the above-mentioned embodiments can be completed by instructing related hardware through a program, and the program can be stored in a computer-readable storage medium, such as: ROM/RAM, Diskettes, CDs, etc.

The above is only a preferred embodiment of the present invention, it should be pointed out that for those of ordinary skill in the art, without departing from the principle of the present invention, some improvements and modifications can also be made, and these improvements and modifications should also be It is regarded as the protection scope of the present invention.

Claims (10)

1. A data synchronization method, comprising: When the trigger condition is satisfied, the data maintenance server determines the data to be updated synchronously of the data user client according to the data demand information of the data user client; After the data maintenance server establishes a link with the database of the data usage client according to the database connection information of the data usage client, the data to be updated synchronously is stored in the database of the data usage client, and the The data is synchronized with the data of the client; Wherein, the data requirement information and database connection information are included in the data requirement application information, and the data requirement application information is sent to the data by the data usage client through the data requirement application webpage published by the data maintenance server. maintenance server. 2. The method according to claim 1, wherein the data requirement application information further includes identification information of the data usage client; and, After the data usage client sends the data demand application information to the data maintenance server through the data demand application webpage issued by the data maintenance server, it also includes: The data maintenance server performs a permission review on the data requirement information according to the data synchronization permission corresponding to the identification information of the data usage client; if the permission review passes, the data maintenance server marks the data requirement information as approved information on data requirements; and According to the data requirement information of the data usage client, determining the data to be updated synchronously of the data usage client is specifically: according to the data requirement information whose flag of the data usage client is approved, determining the data to be updated synchronously of the data usage client. 3. The method according to claim 1 or 2, wherein the data requirement information specifically includes the information of the synchronization object and the previous synchronization time information recorded for each synchronization object; and According to the data demand information of the data usage client, determining the data to be updated synchronously of the data usage client specifically includes: The data maintenance server, according to the information of each synchronization object in the data requirement information and the previous synchronization time information of each synchronization object, respectively, for each synchronization object, determines the data to be updated for synchronization of the synchronization object; and After the determination of the synchronization update data of the synchronization object, it also includes: The previous synchronization time information recorded for the synchronization object in the data requirement information is updated according to the time information of the synchronization object's data to be updated synchronously. 4. The method according to claim 3, wherein the information of the synchronization object specifically includes a name of a data table to be synchronized or a name of a view to be synchronized. 5. The method according to claim 4, wherein the information of the synchronization object further comprises: the name of the column to be synchronized in the data table or the row name of the row to be synchronized in the data table name. 6 . The method according to claim 3 , wherein the database connection information comprises: the IP address, port number, database name, database user name, and database password of the data user client. 7 . 7. The method according to claim 3, wherein the trigger condition is specifically: The set data synchronization cycle arrives; or, There is updated data in the database of the data maintenance server; or, There is updated data in the database of the data maintenance server within this data synchronization period, and this data synchronization period arrives. 8. A data synchronization system, comprising: a data maintenance server and at least one data usage client; The data maintenance server is used to determine the data to be updated synchronously of each data user client according to the data demand information of each data user client when the trigger condition is met; After the database of the client is used to establish a link, the data to be updated by the client of the data is stored in the database of the client of the data, and the data of the client of the data is synchronized; Wherein, the data requirement information and database connection information of each data usage client are included in the data requirement application information of the data usage client, and the data requirement application information of the data usage client is provided by the data usage client through the data maintenance server The published web page of data demand application is sent to the data maintenance server. 9. The system according to claim 8, wherein the data requirement application information further includes identification information of the data usage client; and, The data maintenance server is further configured to perform permission review on the data requirement information according to the data synchronization permission corresponding to the identification information of the data usage client; if the permission review is passed, the data maintenance server determines that the data usage client is Approved data usage clients; and According to the data demand information of each data user client, the data maintenance server determines that the data to be updated synchronously of each data user client is specifically: The data maintenance server respectively determines the data to be updated synchronously of each approved data usage client according to the data requirement information of each approved data usage client. 10. The system according to claim 9, wherein the data maintenance server establishes a link with the database of each data usage client according to the database connection information of each data usage client, and then the data usage client's standby Synchronous update data is stored in the database of the client using the data as follows: According to the database connection information of each approved data user client, the data maintenance server establishes a link with the database of each approved data user client respectively, and stores the data to be updated synchronously of the data user client into the data user in the client's database.

Images