CN102724295A - Data synchronization method and system - Google Patents
Data synchronization method and system Download PDFInfo
- Publication number
- CN102724295A CN102724295A CN2012101646360A CN201210164636A CN102724295A CN 102724295 A CN102724295 A CN 102724295A CN 2012101646360 A CN2012101646360 A CN 2012101646360A CN 201210164636 A CN201210164636 A CN 201210164636A CN 102724295 A CN102724295 A CN 102724295A
- Authority
- CN
- China
- Prior art keywords
- data
- client
- information
- demand
- maintenance server
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a data synchronization method and system. The method comprises the following steps: using a data maintenance server to determine update data to be synchronized of a data using client according to information of data demands of the data using client when a trigger condition is met; and storing the update data to be synchronized in a database of the data using client for realizing data synchronization after a link is established according to connection information of the database of the data using client, wherein the information of the data demands and the connection information of the database are sent from the data using client to a data maintenance server through an application web page of the data demands, which is issued by the data maintenance server. As the data using client sends the information of the data demands and the connection information of the database to the data maintenance server according to the application web page of data synchronization demands, which is issued by the data maintenance server, the data using client does not need to mount special software, and the workload of maintenance staff when the data using client is increased is greatly reduced.
Description
Technical field
The present invention relates to computer communication technology, relate in particular to method of data synchronization and system.
Background technology
Along with informationization the deepening constantly of units such as government, office, enterprise, colleges and universities, information system integrated becomes a key point gradually.The integrated of data is the integrated bases of software systems, and data sharing is the main means of data integration, and one of common technology means that data sync is data to be shared between different business systems.
A data synchronous system that carries out data sync comprises: data maintenance server and data are used client.Wherein, the data maintenance server is in order to provide data; And the operation system that needs these data is called data use client.The data maintenance server uses client that the demand of these data is pushed data in the data use client according to data.
Usually, a data maintenance server need be that a plurality of data use client that data (as shown in Figure 1) are provided through data sync.In the prior art, the data sync software of adopting third party manufacturer usually and providing carries out data sync.For example, RealSync of the SharePlex of the GoldenGate of Oracle company, Quest company, DSG company etc.The principle that these softwares carry out data sync is the daily record of the software reading of data maintenance server client database of data maintenance server end; Analyze the log acquisition alter operation; And alter operation is sent to data use in the client; The alter operation that uses the software of client that the source end is transmitted by data again is applied in data and uses in the database of client, accomplishes data sync.
But, the method for data synchronization of prior art except needs in data maintenance server install software, also to use client that corresponding software is installed in data.Therefore, use under the more situation of client in data, the software installation workload can workload very big, the system maintenance personnel can be very big.
In addition; When data used the data sync demand of client that change takes place, for example, certain data used client need increase the data sync demand of tables of data W; So; Also need use the client installed software to do the once time synchronization configuration again, influence the normal synchronized that data maintenance server end and this data are used data between the client, and attendant's workload be bigger in the change process data maintenance server end and this data.
In addition, the function that whether specified data uses the needed synchrodata of client to exceed one's powers in the method for data synchronization of prior art also is left to be desired.
In sum, the method for data synchronization of prior art uses under the more situation of client in data, and the software installation workload is very big, causes system maintenance personnel's workload big; When data use the data sync demand of client that change takes place, influence the normal synchronized of data, attendant's workload is bigger; Judge that the function whether synchrodata exceeds one's powers is left to be desired.
Summary of the invention
Embodiments of the invention provide a kind of method of data synchronization and system, needn't use client that corresponding software is installed in data, reduce system maintenance personnel's workload.
According to an aspect of the present invention, a kind of method of data synchronization is provided, has comprised:
The data maintenance server uses the demand data information of client according to data when trigger condition satisfies, confirm these data use client treat Update Information synchronously;
Said data maintenance server uses the database linkage information of client according to said data; After using the database of client to set up to link with said data; With said treat to Update Information synchronously be deposited into said data and use in the database of client, carry out the data sync that said data are used client;
Wherein, Said demand data information and database linkage information are included in the demand data application information, and said demand data application information is to use client to send to said data maintenance server through the demand data application webpage of said data maintenance server issue by said data.
Further, the identification information that also comprises data use client in the said demand data application information; And,
After the demand data application webpage that said data use client to issue through said data maintenance server sends to said data maintenance server with said demand data application information, also comprise:
Said data maintenance server carries out the authority audit according to the pairing data sync authority of identification information of this data use client to said demand data information; If the authority audit is passed through, said data maintenance server passes through said demand data Information sign for audit demand data information; And
The said demand data information of using client according to data; Confirm this data use client treat to Update Information synchronously be specially: use the demand data information that audit is passed through that is masked as of client according to these data, confirm these data use client treat Update Information synchronously.
Wherein, said demand data information specifically comprises the information of synchronization object and last time lock in time of the information that writes down to each synchronization object; And
Saidly use the demand data information of client according to data, confirm these data use client treat to Update Information synchronously specifically comprise:
Said data maintenance server is according to the information of each synchronization object in the said demand data information and last time lock in time of the information of each synchronization object, respectively to each synchronization object, confirm this synchronization object treat Update Information synchronously; And
Said confirm this synchronization object treat Update Information synchronously after, also comprise:
According to the temporal information that Updates Information synchronously treated of this synchronization object, upgrade in the said demand data information last time lock in time of information to this synchronization object record.
The information of said synchronization object comprises that specifically the title of the tables of data that need carry out data sync maybe need carry out the title of the view of data sync.
The information of said synchronization object also comprises: the title that need carry out need carrying out in title or the said tables of data of row of data sync the row of data sync in the said tables of data.
Said database linkage information comprises: said data are used IP address, port numbers, database-name, database user name, the database password of client.
Said trigger condition is specially:
The data sync cycle of setting arrives; Perhaps,
Said data maintenance data in server has data updated in the storehouse; Perhaps,
In the said data maintenance data in server storehouse data updated is arranged in this data sync within cycle, and arrive this data sync cycle.
According to another aspect of the present invention, a kind of data synchronous system is provided also, has comprised: the data maintenance server uses client with at least one data;
Said data maintenance server is used for when trigger condition satisfies, and uses the demand data information of client according to each data, confirm each data use client treat Update Information synchronously; And use the database linkage information of client according to each data; After using the database foundation of client to link with each data respectively; This data are used treating to Update Information synchronously and being deposited into these data and using in the database of client of client, carry out the data sync that these data are used client;
Wherein, Each data uses the demand data information of client and database linkage information to be included in the demand data application information of this data use client, and it is to use client to send to said data maintenance server through the demand data application webpage of said data maintenance server issue by these data that these data are used the demand data application information of client.
Wherein, the identification information that also comprises data use client in the said demand data application information; And,
Said data maintenance server also is used for using according to these data the pairing data sync authority of identification information of client, and said demand data information is carried out the authority audit; If the authority audit is passed through, said data maintenance server is confirmed the data use client that these data use client to pass through as audit; And
Said data maintenance server uses the demand data information of client according to each data, confirm each data use client treat to Update Information synchronously be specially:
The data that said data maintenance server passes through according to each audit are used the demand data information of client, confirm respectively data that each audit is passed through use client treat Update Information synchronously.
Said data maintenance server uses the database linkage information of client according to each data; After using the database foundation of client to link with each data respectively, use the database that is deposited into this data use client of treating to Update Information synchronously of client to be specially these data:
The data that said data maintenance server passes through according to each audit are used the database linkage information of client; After the data of passing through with each audit are respectively used the database of client to set up link, these data are used treating to Update Information synchronously and being deposited in the database of this data use client of client.
The embodiment of the invention is because the data sync demand application webpage that data use client to issue through the data maintenance server sends demand data information and database linkage information to the data maintenance server; And the data maintenance server can use the demand data information and the database linkage information of client transmission according to data; Use client to carry out data sync to data; And needn't use client that special-purpose software is installed in data; Significantly reduced when increasing data use client the work of maintenance personnel amount; When data use client need change the synchrodata demand, also needn't change the software that data are used client, get final product but revise relevant information through data sync demand application webpage, further reduced the work of maintenance personnel amount.
Further; The data maintenance server can also carry out the authority audit to this demand data application information after having obtained the demand data application information that data use client to send through data sync demand application webpage, just uses the client synchrodata to these data after audit is passed through.The more perfect audit function of data synchronous system has guaranteed that data use client to obtain data as required by power, thereby has guaranteed the safe in utilization of data.And, made things convenient for the audit of data being used client, reduced attendant's examination.
Further; Use the needs of client when data and carry out synchronous synchronization object when changing; Only need to revise relevant information, examine getting final product again to data maintenance server transmission demand data application information, and needn't change any software that data are used client at data sync demand application webpage; Or use any software of client to reconfigure to data, further improved service efficiency.
Description of drawings
Fig. 1 is the data synchronous system sketch map of the embodiment of the invention;
Fig. 2 is that the data of the embodiment of the invention use client to send the method flow diagram of demand data application information to the data maintenance server through the webpage of data maintenance server issue;
Fig. 3 uses client to carry out the method flow diagram of data sync for the data maintenance server of the embodiment of the invention to data.
Embodiment
For making the object of the invention, technical scheme and advantage clearer, below with reference to accompanying drawing and enumerate preferred embodiment, to further explain of the present invention.Yet, need to prove that many details of listing in the specification only are in order to make the reader to one or more aspects of the present invention a thorough understanding arranged, even if there are not these specific details also can realize these aspects of the present invention.
Terms such as " module " that the application uses, " system " are intended to comprise the entity relevant with computer, such as but not limited to hardware, firmware, combination thereof, software or executory software.For example, module can be, but be not limited in: the thread of the process of moving on the processor, processor, object, executable program, execution, program and/or computer.For instance, the application program of moving on the computing equipment can be a module with this computing equipment.One or more modules can be positioned at an executory process and/or thread, and module also can be on the computer and/or be distributed between two or more the computers.
Data maintenance server and a plurality of data are used and are adopted the B/S structure between the client in the technical scheme provided by the invention.Data maintenance server distributing data synchronisation requirement application webpage; Each data uses the user of client through this data sync demand application webpage of visit; Send the demand data application information to the data maintenance server; That is to say that the data maintenance server obtains the demand data application information that each data is used client through data sync demand application webpage.Can comprise demand data information and database linkage information in the demand data application information that data use client to send.Comprise mainly in the demand data information that data use client need carry out the information of the synchronization object of data sync, for example need carry out the title of the tables of data of data sync, perhaps need carry out the title of the view of data sync; IP address, port numbers, database-name, database user name, the database password that specifically can comprise data use client in the database linkage information; Can be linked to the database that data are used client according to this database linkage information data maintenance server, and synchrodata is write in the database of data use client.
The data maintenance server is after the demand data information and database linkage information of having obtained data use client; Can be when predefined certain trigger condition satisfies; Can be preset as " the data sync cycle of setting arrives " such as this trigger condition; Then when the data sync cycle of setting arrives, use the demand data information of client according to data, determine these data use client treat Update Information synchronously.For example; The title that comprises tables of data W in the demand data information of data use client; Show that then tables of data W need carry out data sync; Then the data maintenance server is according to the Data Update situation of the tables of data W in the local data base, determine these data use client treat Update Information synchronously, just data use the tables of data W of client to need data in synchronization.The data maintenance server uses the database linkage information of client will treat to Update Information synchronously to be deposited into these data to use in the corresponding data table or view of database of client according to this data, realizes that these data use the data sync of client.In this process; Because the data sync demand application webpage that data use client to issue through the data maintenance server sends demand data information and database linkage information to the data maintenance server; And the data maintenance server can use the demand data information and the database linkage information of client transmission according to data; Use client to carry out data sync to data; And needn't use client that special-purpose software is installed in data, significantly reduced when increasing data use client the work of maintenance personnel amount; When data use client need change the synchrodata demand, also needn't change the software that data are used client, get final product but revise relevant information through data sync demand application webpage, further reduced the work of maintenance personnel amount.
Specify the technical scheme of the embodiment of the invention below in conjunction with accompanying drawing.Comprise in the data synchronous system as shown in Figure 1: data maintenance server 101 uses client 102 with at least one data.Safeguard the local data base of a maintenance server 101 at data maintenance server 101 ends; Each data uses client 102 also all to have a database respectively, and each data uses the database in client 102 to carry out the synchronization object of data sync with the database of data maintenance server 101 maybe be not necessarily identical.For example, data use the data in the client 102 to use the synchronization object that need carry out data sync in the database of customer end A to be tables of data A, and then data use customer end A need obtain the synchrodata of tables of data A from data maintenance server 101.That is to say; If Update Information in the data of database Table A of data maintenance server 101; Then data maintenance server 101 need will Update Information and send to the tables of data A that data are used customer end A, thereby data use the data of database Table A of customer end A to realize data sync.For another example, data use the data in the client 102 to use the synchronization object that need carry out data sync in the database of customer end B to be tables of data B, and then data use customer end B need obtain the synchrodata of tables of data B from data maintenance server 101.That is to say; If Update Information among the data of database table B of data maintenance server 101; Then data maintenance server 101 need will Update Information and send to the tables of data B that data are used customer end B, thereby data use the data of database table B of customer end B to realize data sync.
Each data uses client 102 to send the demand data application information of notebook data use client 102 to data maintenance server 101 through the demand data application webpage of data maintenance server 101 issues.Comprised that in the demand data application information that data use client 102 to send notebook data uses the demand data information and the database linkage information of client 102.
After data maintenance server 101 has obtained the demand data information and database linkage information of each data use client 102; When trigger condition satisfies; Use the demand data information of client 102 according to each data, confirm each data use client 102 treat Update Information synchronously; And use the database linkage information of client 102 according to each data; After using the database foundation of client 102 to link with each data respectively; This data are used treating to Update Information synchronously and being deposited into these data and using in the database of client 102 of client 102, carry out the data sync that these data are used client 102.
As more excellent execution mode, can also comprise that notebook data uses the identification information of client 102 in the demand data application information that data use client 102 to send.Data maintenance server 101 can use the pairing data sync authority of identification information of client 102 according to these data, and said demand data information is carried out the authority audit; Pass through as if the authority audit, data maintenance server 101 uses client 102 to be masked as the data use client 102 that audit is passed through these data, is the demand data information that audit is passed through with this demand data Information sign.So, when trigger condition satisfied, the data that data maintenance server 101 passes through according to each audit were used the demand data information of client 102, confirm respectively data that each audit is passed through use client 102 treat Update Information synchronously; And the data of passing through according to each audit are used the database linkage information of client 102; After the data of passing through with each audit are respectively used the database of client 102 to set up to link; This data are used treating to Update Information synchronously and being deposited into these data and using in the database of client 102 of client 102, carry out the data sync that these data are used client 102.
Use client 102 to be example with one of them data below, introduce these data in detail and use client 102 according to the demand data information of this data use client 102 this data use client 102 to be carried out the process of data sync to data maintenance server 101 transmission demand data information, data maintenance server 101 through the data sync demand application webpage of data maintenance server 101 issues.Flow chart shown in Figure 2 has shown the method flow that these data use client 102 to examine to data maintenance server 101 transmission demand data information, 101 pairs of these demand data information of data maintenance server through the data sync demand application webpage of data maintenance server 101 issues, specifically comprises the steps:
S201: the data sync demand application webpage that data use client 102 to issue through data maintenance server 101 sends the demand data application informations to data maintenance server 101.
The data sync demand application webpage of data maintenance server 101 issues, data use the user of client 102 can from webpage, import the demand data application information.The demand data application information can comprise the demand data information and the database linkage information of this data use client 102.
Comprised specifically in the demand data information that these data use client 102 need carry out the information of each synchronization object of data sync, comprised that such as the information of synchronization object the title of the tables of data that need carry out data sync maybe need carry out the title of the view of data sync; Perhaps, the information of synchronization object also can further comprise the title that need carry out the row of data sync among the tables of data that need carry out data sync, maybe need carry out need carrying out among the tables of data of data sync the title of the row of data sync; Perhaps, the information of synchronization object also can further comprise the title that need carry out the row of data sync among the view that need carry out data sync, maybe need carry out need carrying out among the view of data sync the title of the row of data sync.
For example; The flat data table unit of including 1, unit 2 of storage in the data maintenance server 101 ..., the organization of the n of unit, unit address, WorkPhone, the contact person's of unit data;------need carry out the title of the row of data sync among unit 1 and unit 3, the flat data table---organization, unit address of need carrying out the title of the row of data sync among flat data table, the flat data table that data use client 102 to carry out data sync to organization, the unit address of unit 1 and unit 3, and then these data use the information of synchronization object of the demand data information of client 102 to comprise: the title that need carry out the tables of data of data sync.
Further, can also comprise last time lock in time of information in the demand data information to each synchronization object record, each synchronization object last time lock in time information in order to indicate this synchronization object in the update time of carrying out the last time of latest data during data sync.
S202: the demand data application information that data maintenance server 101 uses client 102 to send according to data is carried out the authority audit; If execution in step S203 is passed through in audit; Otherwise, execution in step S204.
In the demand data application information that data use client 102 to send, also comprise the identification information of this data use client 102, go out this data in order to unique identification and use client 102, show the user's of this data use client 102 identity.This data use the identification information of client 102 can comprise that these data use information such as the user name of client 102, password.
The demand data application information of using client 102 to send to data is carried out the authority audit and both can be examined with manual type through administrative staff, also can be that data maintenance server 101 is examined according to permissions list automatically:
In data maintenance server 101, safeguard a permissions list; In this permissions list to each data use client 102 the identification information corresponding record these data use the data sync authority of client 102, promptly these data use client 102 to be authorized to allow carry out the authority of the synchronization object of data sync.
For example, the information of the synchronization object of the demand data information of above-mentioned data use client 102 comprises: the unit 1 of flat data table, flat data table and unit 3, the organization of flat data table, unit address.If in permissions list, having write down the authority that these data use 102 of clients to be authorized to allow carry out the synchronization object of data sync comprises: the 1-5 of unit of flat data table, flat data table, the organization of flat data table, unit address, WorkPhone.Thus, can confirm that the demand data information of this data use client 102 has the authority of data sync, these data use the demand data application information of client 102 through the authority audit.
If having write down the authority that these data use 102 of clients to be authorized to allow carry out the synchronization object of data sync in the permissions list only comprises: the unit 1 of flat data table, flat data table, the organization of flat data table, unit address.So, can confirm this data use client 102 do not have authority carry out unit 3 related data synchronously, therefore, confirm that these data use the demand data application information of client 102 can not be through the authority audit.
Demand data application information in that 101 pairs of these data of data maintenance server use client 102 to send is carried out in the process of authority audit, and the Status Flag that data maintenance server 101 uses client 102 with these data is for examining.These data use client 102 to inquire this state through the data sync demand application webpage of data maintenance server 101 issues.
S203: after the demand data application information audit that 101 pairs of data uses of data maintenance server client 102 is sent is passed through, use client 102 to be masked as the data use client 102 that audit is passed through these data.
Particularly; After the demand data application information audit that 101 pairs of data of data maintenance server use client 102 to send is passed through; Use the demand data application information of client 102 transmissions to be masked as audit these data and pass through state; Use client 102 to be masked as the data that audit passes through this data and use client 102, the demand data information of these data being used the demand data Information sign of client 102 pass through as audit.These data use client 102 to inquire the state that audit is passed through through the data sync demand application webpage of data maintenance server 101 issues.
S204: the demand data application information that data maintenance server 101 specified datas use client 102 to send is not passed through audit, and the demand data application information of then using client 102 to send data is masked as audit and does not pass through state.These data use client 102 can inquire the unsanctioned state of audit through the data sync demand application webpage of data maintenance server 101 issues.
When data use client 102 to need to revise demand data information, also can revise relevant information through visit data synchronisation requirement application webpage, send the demand data application information to data maintenance server 101 again; Process afterwards is the same with the process of above-mentioned steps S201-S204, repeats no more here.Therefore; Data use the needs of client 102 to carry out synchronous synchronization object when changing; Only need to revise relevant information, examine getting final product again to data maintenance server 101 transmission demand data application informations, and needn't change any software that data are used client 102 at data sync demand application webpage; Or use any software of client 102 to reconfigure to data, further improved service efficiency.
Obtained the demand data information and database linkage information of data use client 102 at data maintenance server 101 after, use client 102 to carry out data sync to these data.More excellent is, data maintenance server 101 has obtained demand data information and the database linkage information that data are used client 102, and after the demand data signal auditing that obtains passed through, uses client 102 to carry out data sync to these data.Fig. 3 shows demand data information and the database linkage information of data maintenance server 101 according to data use client 102, uses client 102 to carry out the concrete grammar flow process of data sync to these data, comprises the steps:
S301: when the preset trigger condition satisfied, data maintenance server 101 began to use client 102 data to carry out synchronously to data according to the demand data information of data use client 102.
Particularly, when the preset trigger condition satisfied, data maintenance server 101 began to use client 102 data to carry out synchronously to each data according to the demand data information of each data use client 102.
Preferably, when the preset trigger condition satisfied, the data that data maintenance server 101 passes through according to each audit were used the demand data information of client 102, began to use client 102 to carry out data sync to the data that each audit is passed through.Below each step use client 102 to carry out data sync with data maintenance server 101 to one of them data to tell about detailed process as example.
Those skilled in the art can preset trigger condition as the case may be.For example, the preset trigger condition is: the data sync cycle of setting arrives; The data sync cycle of promptly setting, data maintenance server 101 began to use client 102 data to carry out synchronously to data according to the demand data information of data use client 102 when arriving.
Perhaps, the preset trigger condition is: the data maintenance data in server has data updated in the storehouse; Be when in the data maintenance data in server storehouse data updated being arranged,, begin to use client 102 data to carry out synchronously data with the demand data information of trigger data maintenance server 101 according to data use client 102.
Perhaps, the preset trigger condition is: in the said data maintenance data in server storehouse data updated is arranged in this data sync within the cycle, and arrive this data sync cycle; Promptly when the data sync cycle arrives; In the data maintenance data in server storehouse data updated is arranged if judge this data sync within cycle; Then trigger data maintenance server 101 begins to use client 102 data to carry out synchronously to data according to the demand data information of data use client 102.
Again perhaps, the preset trigger condition also comprises: the demand data application information that specified data uses client 102 to send is passed through audit; Be specified data when using demand data application information that client 102 sends through audit, trigger data maintenance server 101 uses the demand data information of client 102 according to these data, begins to use client 102 data to carry out synchronously to these data.
S302: data maintenance server 101 uses the demand data information of client 102 according to data, confirm these data use client treat Update Information synchronously.
Particularly, data maintenance server 101 uses the information of each synchronization object in the demand data information of client 102 and last time lock in time of the information of each synchronization object according to data, confirm these data use client treat Update Information synchronously:
For example, data are used unit 1, the organization of flat data table, the unit address of the information of a synchronization object in the demand data information of client 102 as flat data table, flat data table; Last time lock in time of the information of this synchronization object is 2012-3-15.Data maintenance server 101 is determined flat data table corresponding in the local data base according to the information of synchronization object; And according to this synchronization object last time lock in time information with organization, the unit address data of the unit 1 that upgrades later on March 15th, 2012 in the flat data table use as these data client 102 this time treating in data synchronization process Update Information synchronously.In practical application, data maintenance server 101 can be confirmed this updating data time according to the timestamp of data.
Confirmed data use client certain synchronization object treat Update Information synchronously after, data maintenance server 101 treats that according to this these data of time information renovation that Update Information synchronously use in the demand data information of client 102 the last time lock in time information to this synchronization object record.For example, the up-to-date timestamp that Updates Information synchronously of treating that data maintenance server 101 is determined certain synchronization object is 2012-5-15, and then last time lock in time of the information updating with this synchronization object record is 2012-5-15.So when carrying out next data sync; Data maintenance server 101 can be according to last time lock in time of the information of this synchronization object record that is updated to 2012-5-15, and confirm with data updated after on May 15th, 2012 as this synchronization object treat Update Information synchronously.
S303: data maintenance server 101 uses the database of client 102 to set up with these data and links according to the database linkage information of this data use client 102.
Data use the database linkage information of client 102 to comprise: these data use IP address, port numbers, these data of client 102 to use the database-name of client 102, database user name, database password etc.
S304: data maintenance server 101 will be treated to Update Information synchronously and be deposited in the database of this data use client 102, realize the data sync of this data use client 102.
After data maintenance server 101 uses the database foundation of client 102 to link with these data; Treat to Update Information synchronously and be written to these data and use in the tables of data of correspondence of database of client 102 what confirm among the above-mentioned steps S302, thereby realized that these data use the data sync of client 102.
The embodiment of the invention is because the data sync demand application webpage that data use client to issue through the data maintenance server sends demand data information and database linkage information to the data maintenance server; And the data maintenance server can use the demand data information and the database linkage information of client transmission according to data; Use client to carry out data sync to data; And needn't use client that special-purpose software is installed in data; Significantly reduced when increasing data use client the work of maintenance personnel amount; When data use client need change the synchrodata demand, also needn't change the software that data are used client, get final product but revise relevant information through data sync demand application webpage, further reduced the work of maintenance personnel amount.
Further; The data maintenance server can also carry out the authority audit to this demand data application information after having obtained the demand data application information that data use client to send through data sync demand application webpage, just uses client to send synchrodata to these data after audit is passed through.The perfect audit function of data synchronous system has guaranteed that data use client to obtain data as required by power, thereby has guaranteed the safe in utilization of data.And, made things convenient for the audit of data being used client, reduced attendant's examination.
Further; Use the needs of client 102 when data and carry out synchronous synchronization object when changing; Only need to revise relevant information, examine getting final product again to data maintenance server 101 transmission demand data application informations, and needn't change any software that data are used client 102 at data sync demand application webpage; Or use any software of client 102 to reconfigure to data, further improved service efficiency.
One of ordinary skill in the art will appreciate that all or part of step that realizes in the foregoing description method is to instruct relevant hardware to accomplish through program; This program can be stored in the computer read/write memory medium, as: ROM/RAM, magnetic disc, CD etc.
The above only is a preferred implementation of the present invention; Should be pointed out that for those skilled in the art, under the prerequisite that does not break away from the principle of the invention; Can also make some improvement and retouching, these improvement and retouching also should be regarded as protection scope of the present invention.
Claims (10)
1. method of data synchronization comprises:
The data maintenance server uses the demand data information of client according to data when trigger condition satisfies, confirm these data use client treat Update Information synchronously;
Said data maintenance server uses the database linkage information of client according to said data; After using the database of client to set up to link with said data; With said treat to Update Information synchronously be deposited into said data and use in the database of client, carry out the data sync that said data are used client;
Wherein, Said demand data information and database linkage information are included in the demand data application information, and said demand data application information is to use client to send to said data maintenance server through the demand data application webpage of said data maintenance server issue by said data.
2. the method for claim 1 is characterized in that, also comprises the identification information of data use client in the said demand data application information; And,
After the demand data application webpage that said data use client to issue through said data maintenance server sends to said data maintenance server with said demand data application information, also comprise:
Said data maintenance server carries out the authority audit according to the pairing data sync authority of identification information of this data use client to said demand data information; If the authority audit is passed through, said data maintenance server passes through said demand data Information sign for audit demand data information; And
The said demand data information of using client according to data; Confirm this data use client treat to Update Information synchronously be specially: use the demand data information that audit is passed through that is masked as of client according to these data, confirm these data use client treat Update Information synchronously.
3. according to claim 1 or claim 2 method is characterized in that, said demand data information specifically comprises the information of synchronization object and to last time lock in time of the information of each synchronization object record; And
Saidly use the demand data information of client according to data, confirm these data use client treat to Update Information synchronously specifically comprise:
Said data maintenance server is according to the information of each synchronization object in the said demand data information and last time lock in time of the information of each synchronization object, respectively to each synchronization object, confirm this synchronization object treat Update Information synchronously; And
Said confirm this synchronization object treat Update Information synchronously after, also comprise:
According to the temporal information that Updates Information synchronously treated of this synchronization object, upgrade in the said demand data information last time lock in time of information to this synchronization object record.
4. method as claimed in claim 3 is characterized in that, the information of said synchronization object comprises that specifically the title of the tables of data that need carry out data sync maybe need carry out the title of the view of data sync.
5. method as claimed in claim 4 is characterized in that, the information of said synchronization object also comprises: the title that need carry out need carrying out in title or the said tables of data of row of data sync the row of data sync in the said tables of data.
6. method as claimed in claim 3 is characterized in that, said database linkage information comprises: said data are used IP address, port numbers, database-name, database user name, the database password of client.
7. method as claimed in claim 3 is characterized in that, said trigger condition is specially:
The data sync cycle of setting arrives; Perhaps,
Said data maintenance data in server has data updated in the storehouse; Perhaps,
In the said data maintenance data in server storehouse data updated is arranged in this data sync within cycle, and arrive this data sync cycle.
8. a data synchronous system comprises: data maintenance server and at least one data use client;
Said data maintenance server is used for when trigger condition satisfies, and uses the demand data information of client according to each data, confirm each data use client treat Update Information synchronously; And use the database linkage information of client according to each data; After using the database foundation of client to link with each data respectively; This data are used treating to Update Information synchronously and being deposited into these data and using in the database of client of client, carry out the data sync that these data are used client;
Wherein, Each data uses the demand data information of client and database linkage information to be included in the demand data application information of this data use client, and it is to use client to send to said data maintenance server through the demand data application webpage of said data maintenance server issue by these data that these data are used the demand data application information of client.
9. system as claimed in claim 8 is characterized in that, also comprises the identification information of data use client in the said demand data application information; And,
Said data maintenance server also is used for using according to these data the pairing data sync authority of identification information of client, and said demand data information is carried out the authority audit; If the authority audit is passed through, said data maintenance server is confirmed the data use client that these data use client to pass through as audit; And
Said data maintenance server uses the demand data information of client according to each data, confirm each data use client treat to Update Information synchronously be specially:
The data that said data maintenance server passes through according to each audit are used the demand data information of client, confirm respectively data that each audit is passed through use client treat Update Information synchronously.
10. system as claimed in claim 9; It is characterized in that; Said data maintenance server uses the database linkage information of client according to each data; After using the database foundation of client to link with each data respectively, use the database that is deposited into this data use client of treating to Update Information synchronously of client to be specially these data:
The data that said data maintenance server passes through according to each audit are used the database linkage information of client; After the data of passing through with each audit are respectively used the database of client to set up link, these data are used treating to Update Information synchronously and being deposited in the database of this data use client of client.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210164636.0A CN102724295B (en) | 2012-05-24 | 2012-05-24 | Method of data synchronization and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210164636.0A CN102724295B (en) | 2012-05-24 | 2012-05-24 | Method of data synchronization and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102724295A true CN102724295A (en) | 2012-10-10 |
| CN102724295B CN102724295B (en) | 2016-05-18 |
Family
ID=46949956
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210164636.0A Active CN102724295B (en) | 2012-05-24 | 2012-05-24 | Method of data synchronization and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102724295B (en) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104166820A (en) * | 2013-05-16 | 2014-11-26 | 北京畅游天下网络技术有限公司 | Data management method and system |
| CN104252452A (en) * | 2013-06-25 | 2014-12-31 | 腾讯科技（深圳）有限公司 | Data management method and device |
| CN104796389A (en) * | 2014-01-21 | 2015-07-22 | 上海联影医疗科技有限公司 | Basic data sharing system and method thereof |
| CN105025110A (en) * | 2015-07-31 | 2015-11-04 | 中冶南方工程技术有限公司 | Multi-client data modification message accurate push method |
| CN105117423A (en) * | 2015-07-31 | 2015-12-02 | 中冶南方工程技术有限公司 | Independent choice response method of database modification on the basis of intelligent agent |
| CN105468637A (en) * | 2014-09-05 | 2016-04-06 | 北京联嘉众赢网络技术有限公司 | Database updating method and apparatus |
| CN106202387A (en) * | 2016-07-08 | 2016-12-07 | 陈光宇 | A kind of data consistency concurrent maintenance method |
| CN107798038A (en) * | 2017-05-05 | 2018-03-13 | 平安科技（深圳）有限公司 | Data response method and data response apparatus |
| CN108093002A (en) * | 2016-11-21 | 2018-05-29 | 腾讯科技（深圳）有限公司 | Based on the synchronous method and device of the information to be synchronized that data mode determines |
| WO2018126390A1 (en) * | 2017-01-05 | 2018-07-12 | 深圳市前海中康汇融信息技术有限公司 | Trigger-based database synchronization system |
| WO2018126391A1 (en) * | 2017-01-05 | 2018-07-12 | 深圳市前海中康汇融信息技术有限公司 | Trigger-based database synchronization method |
| CN108664497A (en) * | 2017-03-30 | 2018-10-16 | 大有秦鼎（北京）科技有限公司 | The method and apparatus of Data Matching |
| CN111107145A (en) * | 2019-12-17 | 2020-05-05 | 青岛希望鸟科技有限公司 | Online synchronous communication system based on HTML5 webpage |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2007075099A1 (en) * | 2005-12-27 | 2007-07-05 | Siemens Aktiengesellschaft | Automation network, access service proxy for automation network method for transmitting operating between programmable controller remote computer |
| CN102057354A (en) * | 2008-06-08 | 2011-05-11 | 苹果公司 | Techniques for acquiring updates for application programs |
| CN102202073A (en) * | 2010-03-24 | 2011-09-28 | 杭州华三通信技术有限公司 | Distributed system and data synchronization method thereof |
| CN102255967A (en) * | 2011-07-11 | 2011-11-23 | 宇龙计算机通信科技(深圳)有限公司 | Synchronizing method, device, server and synchronizing system |
| CN102469123A (en) * | 2010-11-09 | 2012-05-23 | 腾讯科技（深圳）有限公司 | System and method for synchronizing online game data |
-
2012
- 2012-05-24 CN CN201210164636.0A patent/CN102724295B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2007075099A1 (en) * | 2005-12-27 | 2007-07-05 | Siemens Aktiengesellschaft | Automation network, access service proxy for automation network method for transmitting operating between programmable controller remote computer |
| CN102057354A (en) * | 2008-06-08 | 2011-05-11 | 苹果公司 | Techniques for acquiring updates for application programs |
| CN102202073A (en) * | 2010-03-24 | 2011-09-28 | 杭州华三通信技术有限公司 | Distributed system and data synchronization method thereof |
| CN102469123A (en) * | 2010-11-09 | 2012-05-23 | 腾讯科技（深圳）有限公司 | System and method for synchronizing online game data |
| CN102255967A (en) * | 2011-07-11 | 2011-11-23 | 宇龙计算机通信科技(深圳)有限公司 | Synchronizing method, device, server and synchronizing system |
Cited By (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104166820A (en) * | 2013-05-16 | 2014-11-26 | 北京畅游天下网络技术有限公司 | Data management method and system |
| CN104166820B (en) * | 2013-05-16 | 2017-09-29 | 北京畅游天下网络技术有限公司 | A kind of data managing method and system |
| CN104252452A (en) * | 2013-06-25 | 2014-12-31 | 腾讯科技（深圳）有限公司 | Data management method and device |
| CN104252452B (en) * | 2013-06-25 | 2019-03-15 | 腾讯科技（深圳）有限公司 | The method and device of data management |
| CN104796389A (en) * | 2014-01-21 | 2015-07-22 | 上海联影医疗科技有限公司 | Basic data sharing system and method thereof |
| CN105468637A (en) * | 2014-09-05 | 2016-04-06 | 北京联嘉众赢网络技术有限公司 | Database updating method and apparatus |
| CN105025110A (en) * | 2015-07-31 | 2015-11-04 | 中冶南方工程技术有限公司 | Multi-client data modification message accurate push method |
| CN105117423A (en) * | 2015-07-31 | 2015-12-02 | 中冶南方工程技术有限公司 | Independent choice response method of database modification on the basis of intelligent agent |
| CN105025110B (en) * | 2015-07-31 | 2018-05-08 | 中冶南方工程技术有限公司 | A kind of multi-client data changes the accurate method for pushing of message |
| CN105117423B (en) * | 2015-07-31 | 2018-08-21 | 中冶南方工程技术有限公司 | A kind of autonomous Response to selection method of databases comparison based on intelligent body |
| CN106202387B (en) * | 2016-07-08 | 2019-05-21 | 苏州超块链信息科技有限公司 | A kind of data consistency concurrent maintenance method |
| CN106202387A (en) * | 2016-07-08 | 2016-12-07 | 陈光宇 | A kind of data consistency concurrent maintenance method |
| CN108093002A (en) * | 2016-11-21 | 2018-05-29 | 腾讯科技（深圳）有限公司 | Based on the synchronous method and device of the information to be synchronized that data mode determines |
| CN108093002B (en) * | 2016-11-21 | 2020-09-25 | 腾讯科技（深圳）有限公司 | Synchronization method and device of information to be synchronized based on data state determination |
| WO2018126391A1 (en) * | 2017-01-05 | 2018-07-12 | 深圳市前海中康汇融信息技术有限公司 | Trigger-based database synchronization method |
| WO2018126390A1 (en) * | 2017-01-05 | 2018-07-12 | 深圳市前海中康汇融信息技术有限公司 | Trigger-based database synchronization system |
| CN108664497A (en) * | 2017-03-30 | 2018-10-16 | 大有秦鼎（北京）科技有限公司 | The method and apparatus of Data Matching |
| CN108664497B (en) * | 2017-03-30 | 2020-11-03 | 大有秦鼎（北京）科技有限公司 | Data matching method and device |
| CN107798038A (en) * | 2017-05-05 | 2018-03-13 | 平安科技（深圳）有限公司 | Data response method and data response apparatus |
| CN107798038B (en) * | 2017-05-05 | 2020-02-14 | 平安科技（深圳）有限公司 | Data response method and data response equipment |
| CN111107145A (en) * | 2019-12-17 | 2020-05-05 | 青岛希望鸟科技有限公司 | Online synchronous communication system based on HTML5 webpage |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102724295B (en) | 2016-05-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102724295A (en) | Data synchronization method and system | |
| CN103457905B (en) | Method of data synchronization, system and equipment | |
| US20070208551A1 (en) | Computer networks for providing a test environment | |
| US9477735B2 (en) | Cloud computing-based data sharing system and method | |
| CN111159755B (en) | Cross-link data cooperation method based on alliance link | |
| CN102202073A (en) | Distributed system and data synchronization method thereof | |
| CN105991565B (en) | Method, system and the database proxy server of read and write abruption | |
| CN101071434B (en) | User distributing method, device and system for distributed database system | |
| WO2019228561A3 (en) | Managing blockchain-based centralized ledger systems | |
| CN108833610B (en) | Information updating method, device and system | |
| CN110377416A (en) | Distributed subregion method for scheduling task and device | |
| CN104780202A (en) | End-to-end cloud service database virtualization and management framework and method | |
| CN102316122B (en) | Method for managing intranet security based on cooperative mode | |
| CN113128197A (en) | Method and device for managing application production versions | |
| US20180069762A1 (en) | Device asset tracking and service desk using an external network management system as a data source | |
| CN106341402B (en) | Treating method and apparatus based on multi rack structure distributed caching | |
| JP2023103346A (en) | Method and system for distribution of consistent ledger across multiple blockchains | |
| RU2014132389A (en) | SYSTEM, METHOD AND COMPUTER PROGRAM TO ENSURE TRANSACTIONS | |
| CN105871659A (en) | Monitoring method and device of newly added server | |
| KR20130074227A (en) | Deistributed data management system and method thereof | |
| CN106302473A (en) | The duplication maintaining method of a kind of SQL Server data base and system | |
| CN110019536A (en) | Database system based on medical block chain technology | |
| CN103684825A (en) | Multi-system communication system and maintenance method for same | |
| CN106202373A (en) | Multiple terminals data processing method and data server | |
| CN113610525A (en) | Financial data processing method, device, equipment and medium based on block chain |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |