CN103699580A - Database synchronization method and database synchronization device - Google Patents
Database synchronization method and database synchronization device Download PDFInfo
- Publication number
- CN103699580A CN103699580A CN201310641728.8A CN201310641728A CN103699580A CN 103699580 A CN103699580 A CN 103699580A CN 201310641728 A CN201310641728 A CN 201310641728A CN 103699580 A CN103699580 A CN 103699580A
- Authority
- CN
- China
- Prior art keywords
- database
- data variation
- data
- variation information
- synchronization
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
Abstract
The invention provides a database synchronization method and a database synchronization device. The method includes the following steps: the log of a source database is monitored, and the data change information of the source database is captured; the type of each target database to be synchronized is determined; according to the type of each target database, a synchronization rule corresponding to the type of each target database is obtained; according to the data change information and the synchronization rule corresponding to each target database, the data of each target database and the source database are synchronized. In the invention, the different synchronization rules are established for the different types of target databases in advance, the data of each target database and the source database are synchronized on the basis of the synchronization rule corresponding to each target database and the data charge information after the data charge information of the source database is obtained, consequently, the problem that the data change information of the source database needs to be collected for multiple times in the prior art is overcome, resource waste is reduced, and moreover, the efficiency of synchronization between the databases is increased.
Description
Technical field
The present invention relates to data processing technique, relate in particular to a kind of database synchronization method and device.
Background technology
For same information handling system, based on source database and different user demand, for this information handling system is set up a plurality of databases.When the data in source database change, guarantee that other databases of setting up based on source database synchronize with the data between source database, just need to other databases, carry out data according to the data variation of source database synchronous.
But because the user demand of each data is different, the synchronisation requirement between each database is not identical yet accordingly.For each database, correspondingly from source data, obtain and the corresponding data variation information of each database at present, and then the data variation information based on is separately synchronized to data variation in each database.Existing database synchronization method is the data variation information to source database repeatedly, not only causes the wasting of resources, and makes the synchronous efficiency between database lower.
Summary of the invention
The invention provides a kind of database synchronization method and device, to solve, need the data variation of multi collect source database information, not only cause the wasting of resources, and make the lower problem of synchronous efficiency between database.
To achieve these goals, the invention provides a kind of database synchronization method, comprising:
Monitor the daily record of source database, catch the data variation information of described source database;
Determine the type for the treatment of each synchronous target database;
Obtain the synchronization rules corresponding with the type of each target database;
According to described data variation information and described synchronization rules corresponding to each target database, each target database and described source database are carried out to data and synchronize.
To achieve these goals, the invention provides a kind of database synchronization device, comprising:
Trapping module, for monitoring the daily record of source database, catches the data variation information of described source database;
Determination module, for determining the type for the treatment of each synchronous target database;
Acquisition module, for according to the type of each target database, obtains the synchronization rules corresponding with the type of each target database;
Synchronization module, for according to the described synchronization rules of described data variation information and each target database, carries out data by described target database and described source database and synchronizes.
A kind of database synchronization method provided by the invention and device, monitor the daily record of source database, catch the data variation information of described source database, determine the type for the treatment of each synchronous target database, according to the type of each target database, obtain the synchronization rules corresponding with the type of each target database, according to described data variation information and described synchronization rules corresponding to each target database, described target database and described source database are carried out to data and synchronize.In the present invention, for dissimilar target database, set up different synchronization rules, after getting the data variation information of source database, based on synchronization rules corresponding to each target database and data variation information, target database and source database are carried out to data synchronizes, overcome the data variation Information Problems that needs multi collect source database in prior art, reduce the wasting of resources, and improved the synchronous efficiency between database.
Accompanying drawing explanation
The schematic flow sheet of a kind of database synchronization method that Fig. 1 provides for the embodiment of the present invention;
The structural representation of a kind of database synchronization device that Fig. 2 provides for the embodiment of the present invention;
The structural representation of a kind of database synchronous system that Fig. 3 provides for the embodiment of the present invention.
Embodiment
Below by drawings and Examples, technical scheme of the present invention is described in further detail.
The schematic flow sheet of a kind of database synchronization method that Fig. 1 provides for the embodiment of the present invention.In the present embodiment, the executive agent of the method can be database synchronization device.As shown in Figure 1, the method comprises the following steps:
101, monitor the daily record of source database, catch the data variation information of described source database.
Particularly, database synchronization device is monitored the daily record of source database, and when the daily record of source database changes, database synchronization device captures the data variation information of this source database.For example, source database can be structured query sentence (Structured Query Language is called for short SQL) database, and corresponding, data variation information can be SQL data variation statement.
102, determine the type for the treatment of each synchronous target database.
In practical application, database synchronization device can be connected with a plurality of databases, and after getting data variation information, database synchronization device can be determined the type for the treatment of each synchronous target database.In the present embodiment, the type of target database comprises: the complete backup database of source database, the incremental backup database of source database, for store data variation information document data bank, with the database of source database isomery, in the present embodiment, source database is relevant database, and with the database of source database isomery be internal memory type database.For the ease of expressing and distinguishing dissimilar database, the incremental backup database that in the present embodiment, the complete backup database of source database is called to the first database, source database is called the second database, internal memory type database is called the 3rd database and will be called the 4th database for storing the document data bank of data variation information.
103, obtain the synchronization rules corresponding with the type of each target database.
In the present embodiment, synchronization rules corresponding to pre-stored all types of target database in database synchronization device.After determining the type of target database, database synchronization device, according to the type of each target database, obtains and the corresponding synchronization rules of all types of target database.Particularly, mapping relations in database synchronization device between the type identification of pre-stored target database and synchronization rules sign, after determining the type of target database, according to the type identification for the treatment of each synchronous target database, inquire about above-mentioned mapping relations, can get the synchronization rules sign corresponding with each target database, the synchronization rules sign corresponding according to each target database, obtains the synchronization rules corresponding with each target database.
104, according to described data variation information and described synchronization rules corresponding to each target database, each target database and described source database are carried out to data and synchronize.
Particularly, if treat that the type of synchronous target database is the first database, during the database of i.e. the first database backup completely that is source database, the synchronization rules corresponding with the first database getting is: according to the data variation information getting, all data variation in source database are synchronized in this first database.
If treat that the type of synchronous target database is the second database, the incremental backup that the second database is source database, the synchronization rules corresponding with the second database getting is: from data variation information, obtain the first data variation information corresponding with the second database, data variation corresponding to the first data variation information is synchronized in the second database.
If treat that the type of synchronous target database is the 3rd database, wherein, source database is relevant database, the 3rd database is internal memory type database, the synchronization rules corresponding with the 3rd database getting comprises in default source database the mapping relations between tables of data in tables of data and the 3rd database, obtain the second data variation information relevant to tables of data in source database, according to described the second data variation information and this mapping relations, data variation corresponding to the second data variation information is synchronized in the 3rd database.
If treat that the type of synchronous target database is the 4th database, the 4th database is that the synchronization rules corresponding with the 4th database getting is: data variation information is stored in the 4th database for storing the file based database application of data variation information.
Correspondingly, when target database is the first database, database synchronization device, according to this data variation information and synchronization rules corresponding to the first database, is synchronized to all data variation in source database in this first database.
Correspondingly, when target database is the second database, database synchronization device obtains the first data variation information that this second database is corresponding from data variation information, then data variation corresponding to the first data variation information is synchronized in the second database.For example, the second database is the backup database of some subsets in source database, the data variation information that database synchronization device obtains this subset from data variation information i.e. the first data variation information, then according to this first data variation information, the data variation of this subset is synchronized in the second database, so just can guarantees synchronizeing of the second database and this subset in source database.
Correspondingly, when target database is the 3rd database, mapping relations between tables of data in tables of data and the 3rd database in source database in synchronization rules corresponding to database synchronization device inquiry the 3rd database, based on tables of data in source database in mapping relations, obtain the second data variation information relevant to tables of data in source database, according to this second data variation information and above-mentioned mapping relations, data variation corresponding to the second data variation information is synchronized in the tables of data in the 3rd database.The present embodiment has been realized synchronizeing of relevant database and internal memory type database.
Correspondingly, when target database is the 4th database, database synchronization device is synchronized to data variation information in the 4th database.
Further, database synchronization device can also carry out in synchronizing process at source database and target database, and whether monitoring data sync break occurs, for example, target database, because hardware or network failure cause data synchronously cannot carry out, will cause the synchronous interruption of data.When monitoring described data sync break, record the point of interruption that described data sync break occurs, after described data sync break is recovered, the data variation after the described point of interruption is synchronized in described target database guaranteeing.
Further, database synchronization device, after getting data variation information, can also carry out pre-service to data change information, for example, when data variation information is SQL data variation statement, this SQL data variation statement is resolved, obtain data variation information.
Database synchronization device can also get the key word of each data variation information, then according to key word, data change information is filtered, and to reduce, treats synchronous data volume.In the present embodiment, a list for data change information is filtered is set in database synchronization device, in this list, store the key word for filtering, when key word that data variation information that database synchronization device listens to comprises is in this list during key word, this data variation information filtering is fallen, treat that so synchronous data variation information just can be simplified, thereby reduced the data volume for the treatment of synchronous data, reduce the wasting of resources, improve the synchronous efficiency between database.Wherein above-mentioned list can be arranged according to the actual requirements flexibly by managerial personnel.
And database synchronization device can adopt message queue mechanism, data variation information is sent in Message queue, database synchronization device is based on message queue to all data variation information, and the data between fulfillment database are synchronous.Alternatively, database synchronization device can also carry out buffer memory to data change information, to avoid the loss of data variation information.
The database synchronization method that the present embodiment provides can be applied in Railway Passenger Ticket System, and Railway Passenger Ticket System comprises Railway Passenger Ticket System and the internet Railway Passenger Ticket System based on internal memory type database based on traditional relational database at present.Database synchronization method hardware or software that execution the present embodiment is provided, be arranged between the database and the database in internet Railway Passenger Ticket System in traditional railway Ticketing and Reservation System, using the database in traditional railway Ticketing and Reservation System wherein as source database, database synchronization device is monitored the data variation information of source database, then determine the type of database in internet Railway Passenger Ticket System, and then obtain corresponding synchronization rules, based on synchronization rules and data variation information, data variation is synchronized in the database of this internet Railway Passenger Ticket System, so just realizing traditional railway Ticketing and Reservation System synchronizes with the data between internet Ticketing and Reservation System.
The database synchronization method that the present embodiment provides, monitor the daily record of source database, catch the data variation information of source database, determine the type for the treatment of each synchronous target database, according to the type of each target database, obtain the synchronization rules corresponding with the type of each target database, according to data variation information and synchronization rules corresponding to each target database, each target database and source database are carried out to data and synchronize.In the present embodiment, for dissimilar target database, set up different synchronization rules, after getting the data variation information of source database, based on synchronization rules corresponding to each target database, target database and source database are carried out to data synchronizes, overcome the data variation Information Problems that needs multi collect source database in prior art, reduce the wasting of resources, and improved the synchronous efficiency between database.
The structural representation of a kind of database synchronization device that Fig. 2 provides for the embodiment of the present invention.As shown in Figure 2, this database synchronization device comprises: trapping module 21, determination module 22, acquisition module 23 and synchronization module 24.
Particularly, the daily record of 21 pairs of source databases of trapping module is monitored, and when the daily record of source database changes, can capture the data variation information of this source database.For example, source database can be SQL database, and corresponding, data variation information can be SQL data variation statement.
In practical application, database synchronization device can be connected with a plurality of databases.Trapping module 21 is connected with determination module 22, and after getting data variation information, determination module 22 can be determined the type for the treatment of each synchronous target database.In the present embodiment, the type of target database comprises: the complete backup database of source database, the incremental backup database of source database, for store data variation information document data bank, with the database of source database isomery, in the present embodiment, source database is relevant database, and with the database of source database isomery be internal memory type database.For the ease of expressing and distinguishing dissimilar database, the incremental backup database that in the present embodiment, the complete backup database of source database is called to the first database, source database is called the second database, internal memory type database is called the 3rd database and will be called the 4th database for storing the document data bank of data variation information.
In the present embodiment, synchronization rules corresponding to pre-stored all types of target database in database synchronization device.Determination module 22 is connected with acquisition module 23, determines after the type of target database at determination module 22, and acquisition module 23, according to the type of each target database, obtains and the corresponding synchronization rules of all types of target database.Particularly, mapping relations in database synchronization device between the type identification of pre-stored target database and synchronization rules sign, after determining the type of target database, acquisition module 23 is according to treating that the type identification of each synchronous target database inquires about above-mentioned mapping relations, can get the synchronization rules sign corresponding with each target database, the synchronization rules sign corresponding according to each target database, obtains the synchronization rules corresponding with each target database.
Particularly, if treat that the type of synchronous target database is the first database, during the database of i.e. the first database backup completely that is source database, the synchronization rules corresponding with the first database getting is: according to the data variation information getting, all data variation in source database are synchronized in this first database.
If treat that the type of synchronous target database is the second database, the incremental backup that the second database is source database, the synchronization rules corresponding with the second database getting is: from data variation information, obtain the first data variation information corresponding with the second database, data variation corresponding to the first data variation information is synchronized in the second database.
If treat that the type of synchronous target database is the 3rd database, wherein, source database is relevant database, the 3rd database is internal memory type database, the synchronization rules corresponding with the 3rd database getting comprises in default source database the mapping relations between tables of data in tables of data and the 3rd database, obtain the second data variation information relevant to tables of data in source database, according to described the second data variation information and this mapping relations, data variation corresponding to the second data variation information is synchronized in the 3rd database.
If treat that the type of synchronous target database is the 4th database, the 4th database is that the synchronization rules corresponding with the 4th database getting is: data variation information is stored in the 4th database for storing the file based database application of data variation information.
In the present embodiment, acquisition module 23 is connected with synchronization module 24.At acquisition module 23, get after synchronization rules corresponding to each target database, synchronization module 24, according to the synchronization rules of data variation information and each target database, carries out data by each target database and source database and synchronizes.
Correspondingly, when target database is the first database, synchronization module 24, according to the data variation information and synchronization rules corresponding to the first database that get, is synchronized to all data variation in source database in this first database.
Correspondingly, when target database is the second database, synchronization module 24 obtains the first data variation information corresponding with this second database from data variation information, then data variation corresponding to the first data variation information is synchronized in the second database.For example, the second database is the backup database of some subsets in source database, the data variation information that database synchronization device obtains this subset from data variation information i.e. the first data variation information, then according to this first data variation information, the data variation of this subset is synchronized in the second database, so just can guarantees synchronizeing of the second database and this subset in source database.
Correspondingly, when target database is the 3rd database, mapping relations between tables of data in tables of data and the 3rd database in source database in synchronization rules corresponding to synchronization module 24 inquiry the 3rd databases, based on tables of data in source database in mapping relations, obtain the second data variation information relevant to tables of data in source database, according to this second data variation information and above-mentioned mapping relations, data variation corresponding to the second data variation information is synchronized in the tables of data in the 3rd database.The present embodiment has been realized synchronizeing of relevant database and internal memory type database.
Correspondingly, when target database is the 4th database, synchronization module 24 is synchronized to data variation information in the 4th database.
Further, database synchronization device can also carry out in synchronizing process at source database and target database, by synchronization module 24 monitorings, whether there is data sync break, for example, target database, because hardware or network failure cause data synchronously cannot carry out, will cause the synchronous interruption of data.When monitoring described data sync break, and record the point of interruption that described data sync break occurs, after described data sync break is recovered, the data variation after the described point of interruption is synchronized in described target database guaranteeing.
Further, after getting data variation information, trapping module 21 can also carry out pre-service to data change information, for example, when data variation information is SQL data variation statement, this SQL data variation statement is resolved, and obtains data variation information.
And synchronous device 24 can adopt message queue mechanism, data variation information is sent in Message queue, then based on message queue to all data variation information, the data between fulfillment database are synchronous.Alternatively, database synchronization device can also carry out buffer memory to data change information, to avoid the loss of data variation information.
At present Railway Passenger Ticket System comprises Railway Passenger Ticket System based on traditional relational database and the railway internet Ticketing and Reservation System based on memory database.The database synchronization device that the present embodiment provides, can be applied in Railway Passenger Ticket System.Executing data synchronous device is arranged between traditional railway Ticketing and Reservation System and internet Railway Passenger Ticket System, using the database in traditional railway Ticketing and Reservation System wherein as source database, database synchronization device is monitored the data variation information of source database, then determine the type of database in internet Railway Passenger Ticket System, obtain corresponding synchronization rules, based on synchronization rules and data variation information, data variation is synchronized in the database in this internet Railway Passenger Ticket System, so just realizing traditional railway Ticketing and Reservation System synchronizes with the data between internet Ticketing and Reservation System.
The database synchronization device that the present embodiment provides, monitor the daily record of source database, catch the data variation information of source database, determine the type for the treatment of each synchronous target database, according to the type of each target database, obtain the synchronization rules corresponding with the type of each target database, according to described data variation information and described synchronization rules corresponding to each target database, each target database and described source database are carried out to data and synchronize.In the present invention, for dissimilar target database, set up different synchronization rules in advance, after getting the data variation information of source database, based on synchronization rules corresponding to each target database and data variation information, each target database and source database are carried out to data synchronizes, overcome the data variation Information Problems that needs multi collect source database in prior art, reduce the wasting of resources, and improved the synchronous efficiency between database.
The structural representation of a kind of database synchronous system that Fig. 3 provides for the embodiment of the present invention.As shown in Figure 3, this database synchronous system comprises: database synchronization device 1, source database 2 and at least one target database 3.
Wherein, database synchronization device 1 is the database synchronization device that above-described embodiment provides, and is arranged between source database 2 and target database 3, for realizing source database 2, synchronizes with the data of target database 3.Relevant introduction about database synchronization device 1 can, referring to the record of related content in above-described embodiment, repeat no more herein.
In the present embodiment, for dissimilar target database, set up different synchronization rules in advance, after getting the data variation information of source database, based on synchronization rules corresponding to each target database, target database is carried out to data synchronous, overcome the data variation Information Problems that needs multi collect source database in prior art, reduce the wasting of resources, and improved the synchronous efficiency between database.
Finally it should be noted that: each embodiment, only in order to technical scheme of the present invention to be described, is not intended to limit above; Although the present invention is had been described in detail with reference to aforementioned each embodiment, those of ordinary skill in the art is to be understood that: its technical scheme that still can record aforementioned each embodiment is modified, or some or all of technical characterictic is wherein equal to replacement; And these modifications or replacement do not make the essence of appropriate technical solution depart from the scope of various embodiments of the present invention technical scheme.
Claims (10)
1. a database synchronization method, is characterized in that, comprising:
Monitor the daily record of source database, catch the data variation information of described source database;
Determine the type for the treatment of each synchronous target database;
Obtain the synchronization rules corresponding with the type of each target database;
According to described data variation information and described synchronization rules corresponding to each target database, each target database and described source database are carried out to data and synchronize.
2. database synchronization method according to claim 1, is characterized in that, if the type of described target database is the first database; Wherein, the backup completely that described the first database is described source database; The described synchronization rules corresponding with described the first database is: according to described data variation information, all data variation in described source database are synchronized in described the first database.
3. database synchronization method according to claim 1, is characterized in that, if the type of described target database is the second database, and the incremental backup that wherein said the second database is described source database; The described synchronization rules corresponding with described the second database is: from described data variation information, obtain the first data variation information corresponding with described the second database, data variation corresponding to described the first data variation information is synchronized in described the second database.
4. database synchronization method according to claim 1, is characterized in that, if the type of described target database is the 3rd database, described source database is relevant database, and described the 3rd database is internal memory type database; The described synchronization rules corresponding with described the 3rd database comprises in default described source database the mapping relations between tables of data in tables of data and described the 3rd database, obtain the second data variation information relevant to tables of data in described source database, according to described the second data variation information and described mapping relations, data variation corresponding to described the second data variation information is synchronized in described the 3rd database.
5. according to the database synchronization method described in claim 1-4 any one, it is characterized in that, if the type of described target database is the 4th database, wherein said the 4th database is for storing the file based database application of described data variation information; The described synchronization rules corresponding with described the 4th database is: described data variation information is stored in described the 4th database.
6. a database synchronization device, is characterized in that, comprising:
Trapping module, for monitoring the daily record of source database, catches the data variation information of described source database;
Determination module, for determining the type for the treatment of each synchronous target database;
Acquisition module, for obtaining the synchronization rules corresponding with the type of each target database;
Synchronization module, for according to described data variation information and described synchronization rules corresponding to each target database, carries out data by each target database and source database and synchronizes.
7. database synchronization device according to claim 6, is characterized in that, if the type of described target database is the first database; Wherein, the backup completely that described the first database is described source database; The described synchronization rules corresponding with described the first database is: according to described data variation information, all data variation in described source database are synchronized in described the first database.
8. database synchronization device according to claim 6, is characterized in that, if the type of described target database is the second database, and the incremental backup that wherein said the second database is described source database; The described synchronization rules corresponding with described the second database, for to obtain the first data variation information corresponding with described the second database from described data variation information, is synchronized to data variation corresponding to described the first data variation information in described the second database.
9. database synchronization device according to claim 6, is characterized in that, if the type of described target database is the 3rd database, described source database is relevant database, and described the 3rd database is internal memory type database; The described synchronization rules corresponding with described the 3rd database comprises in default described source database the mapping relations between tables of data in tables of data and described the 3rd database, obtain the second data variation information relevant to tables of data in described source database, according to described the second data variation information and described mapping relations, data variation corresponding to described the second data variation information is synchronized in described the 3rd database.
10. according to the database synchronization device described in claim 6-9 any one, it is characterized in that, if the type of described target database is the 4th database, wherein said the 4th database is for storing the file based database application of described data variation information; The described synchronization rules corresponding with described the 4th database is: described data variation information is stored in described the 4th database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310641728.8A CN103699580B (en) | 2013-12-03 | 2013-12-03 | Database synchronization method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310641728.8A CN103699580B (en) | 2013-12-03 | 2013-12-03 | Database synchronization method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103699580A true CN103699580A (en) | 2014-04-02 |
| CN103699580B CN103699580B (en) | 2016-08-24 |
Family
ID=50361108
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310641728.8A Active CN103699580B (en) | 2013-12-03 | 2013-12-03 | Database synchronization method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103699580B (en) |
Cited By (28)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105554017A (en) * | 2015-12-31 | 2016-05-04 | 北京致远协创软件有限公司 | Monitoring methods and apparatuses |
| CN105574109A (en) * | 2015-12-10 | 2016-05-11 | 青岛海信传媒网络技术有限公司 | Database synchronizing method and equipment and system |
| CN105787077A (en) * | 2016-03-02 | 2016-07-20 | 百度在线网络技术（北京）有限公司 | Data synchronizing method and device |
| CN105868361A (en) * | 2016-03-29 | 2016-08-17 | 中国银行股份有限公司 | Data updating method and device |
| CN106095944A (en) * | 2016-06-15 | 2016-11-09 | 深圳海带宝网络科技股份有限公司 | A kind of cross-border electricity business's global metadata synchronizes system |
| CN106503216A (en) * | 2016-11-03 | 2017-03-15 | 用友网络科技股份有限公司 | Support the metadata synchronization method and metadata synchronization device of layering |
| CN106557592A (en) * | 2016-12-02 | 2017-04-05 | 中铁程科技有限责任公司 | Method of data synchronization, device and server cluster |
| CN106598977A (en) * | 2015-10-15 | 2017-04-26 | 北京国双科技有限公司 | Data migration method and device |
| CN106649378A (en) * | 2015-11-02 | 2017-05-10 | 北大方正集团有限公司 | Data synchronizing method and device |
| CN107145562A (en) * | 2017-05-02 | 2017-09-08 | 北京奇艺世纪科技有限公司 | A kind of method of data synchronization, apparatus and system |
| CN107291790A (en) * | 2016-03-31 | 2017-10-24 | Ls 产电株式会社 | The method of DB between the duplexing EMS Server of management |
| CN107391635A (en) * | 2017-06-30 | 2017-11-24 | 北京奇虎科技有限公司 | Data synchronous system and method |
| CN107729175A (en) * | 2016-11-15 | 2018-02-23 | 西安艾润物联网技术服务有限责任公司 | Backup method and device of the database in cloud platform under line |
| CN108228814A (en) * | 2017-12-29 | 2018-06-29 | 泰康保险集团股份有限公司 | Method of data synchronization and device |
| WO2018120681A1 (en) * | 2016-12-30 | 2018-07-05 | 平安科技（深圳）有限公司 | Data synchronization method, device and system, data processing server, and storage medium |
| CN108664520A (en) * | 2017-04-01 | 2018-10-16 | 北京京东尚科信息技术有限公司 | Safeguard method, apparatus, electronic equipment and the readable storage medium storing program for executing of data consistency |
| CN108763387A (en) * | 2018-05-20 | 2018-11-06 | 湖北九州云仓科技发展有限公司 | Big data fusion method, electronic equipment, storage medium and the system of heterogeneous platform |
| CN108984743A (en) * | 2018-07-16 | 2018-12-11 | 广州友米科技有限公司 | The synchronous method of cross-border data is realized based on local and overseas data centers |
| CN109033268A (en) * | 2018-07-10 | 2018-12-18 | 安心财产保险有限责任公司 | Method of data synchronization, device, equipment and storage medium |
| WO2019000629A1 (en) * | 2017-06-25 | 2019-01-03 | 平安科技（深圳）有限公司 | Multi-data-source data synchronizing method and system, application server and computer readable storage medium |
| CN109271442A (en) * | 2018-07-27 | 2019-01-25 | 东软集团股份有限公司 | Database synchronization restoration methods, device, computer readable storage medium and electronic equipment |
| CN109857809A (en) * | 2019-01-31 | 2019-06-07 | 浙江小泰科技有限公司 | A kind of raw data base data are synchronized to the synchronous method and system of target database |
| CN109976968A (en) * | 2017-12-27 | 2019-07-05 | 航天信息股份有限公司 | A kind of method, apparatus, medium and equipment obtaining database variation table data |
| CN110019873A (en) * | 2017-12-25 | 2019-07-16 | 深圳市优必选科技有限公司 | Human face data processing method, device and equipment |
| CN110263052A (en) * | 2019-06-25 | 2019-09-20 | 苏宁消费金融有限公司 | One kind automating simultaneous techniques innovative approach based on big data Hadoop platform ODS |
| CN112000646A (en) * | 2020-08-25 | 2020-11-27 | 北京浪潮数据技术有限公司 | Database initialization method and device, electronic equipment and storage medium |
| CN112883040A (en) * | 2021-02-04 | 2021-06-01 | 中国工商银行股份有限公司 | Data synchronization method, device and equipment |
| CN113535478A (en) * | 2021-07-15 | 2021-10-22 | 中国电信股份有限公司 | Data backup method and device, storage medium and electronic equipment |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108009252A (en) * | 2017-12-04 | 2018-05-08 | 传神语联网网络科技股份有限公司 | The method and device of data synchronization |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102129478B (en) * | 2011-04-26 | 2012-10-03 | 广州从兴电子开发有限公司 | Database synchronization method and system thereof |
| CN102184251B (en) * | 2011-05-25 | 2013-03-27 | 盛趣信息技术（上海）有限公司 | Data sheet synchronizing system and method |
| CN102542007B (en) * | 2011-12-13 | 2014-06-25 | 中国电子科技集团公司第十五研究所 | Method and system for synchronization of relational databases |
| CN102929946A (en) * | 2012-09-27 | 2013-02-13 | 山东中创软件工程股份有限公司 | Data synchronization method, device and system |
-
2013
- 2013-12-03 CN CN201310641728.8A patent/CN103699580B/en active Active
Cited By (39)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106598977A (en) * | 2015-10-15 | 2017-04-26 | 北京国双科技有限公司 | Data migration method and device |
| CN106649378B (en) * | 2015-11-02 | 2020-07-14 | 北大方正集团有限公司 | Data synchronization method and device |
| CN106649378A (en) * | 2015-11-02 | 2017-05-10 | 北大方正集团有限公司 | Data synchronizing method and device |
| CN105574109A (en) * | 2015-12-10 | 2016-05-11 | 青岛海信传媒网络技术有限公司 | Database synchronizing method and equipment and system |
| CN105554017B (en) * | 2015-12-31 | 2019-06-04 | 北京致远互联软件股份有限公司 | Monitor method and device |
| CN105554017A (en) * | 2015-12-31 | 2016-05-04 | 北京致远协创软件有限公司 | Monitoring methods and apparatuses |
| CN105787077A (en) * | 2016-03-02 | 2016-07-20 | 百度在线网络技术（北京）有限公司 | Data synchronizing method and device |
| CN105787077B (en) * | 2016-03-02 | 2020-05-15 | 百度在线网络技术（北京）有限公司 | Data synchronization method and device |
| CN105868361A (en) * | 2016-03-29 | 2016-08-17 | 中国银行股份有限公司 | Data updating method and device |
| CN107291790B (en) * | 2016-03-31 | 2022-04-15 | Ls 产电株式会社 | Method for managing DB between duplex EMS servers |
| CN107291790A (en) * | 2016-03-31 | 2017-10-24 | Ls 产电株式会社 | The method of DB between the duplexing EMS Server of management |
| CN106095944A (en) * | 2016-06-15 | 2016-11-09 | 深圳海带宝网络科技股份有限公司 | A kind of cross-border electricity business's global metadata synchronizes system |
| CN106503216A (en) * | 2016-11-03 | 2017-03-15 | 用友网络科技股份有限公司 | Support the metadata synchronization method and metadata synchronization device of layering |
| CN107729175A (en) * | 2016-11-15 | 2018-02-23 | 西安艾润物联网技术服务有限责任公司 | Backup method and device of the database in cloud platform under line |
| CN106557592A (en) * | 2016-12-02 | 2017-04-05 | 中铁程科技有限责任公司 | Method of data synchronization, device and server cluster |
| WO2018120681A1 (en) * | 2016-12-30 | 2018-07-05 | 平安科技（深圳）有限公司 | Data synchronization method, device and system, data processing server, and storage medium |
| CN108664520B (en) * | 2017-04-01 | 2021-02-26 | 北京京东尚科信息技术有限公司 | Method and device for maintaining data consistency, electronic equipment and readable storage medium |
| CN108664520A (en) * | 2017-04-01 | 2018-10-16 | 北京京东尚科信息技术有限公司 | Safeguard method, apparatus, electronic equipment and the readable storage medium storing program for executing of data consistency |
| CN107145562A (en) * | 2017-05-02 | 2017-09-08 | 北京奇艺世纪科技有限公司 | A kind of method of data synchronization, apparatus and system |
| CN107145562B (en) * | 2017-05-02 | 2020-07-28 | 北京奇艺世纪科技有限公司 | Data synchronization method, device and system |
| WO2019000629A1 (en) * | 2017-06-25 | 2019-01-03 | 平安科技（深圳）有限公司 | Multi-data-source data synchronizing method and system, application server and computer readable storage medium |
| CN107391635A (en) * | 2017-06-30 | 2017-11-24 | 北京奇虎科技有限公司 | Data synchronous system and method |
| CN110019873A (en) * | 2017-12-25 | 2019-07-16 | 深圳市优必选科技有限公司 | Human face data processing method, device and equipment |
| CN109976968A (en) * | 2017-12-27 | 2019-07-05 | 航天信息股份有限公司 | A kind of method, apparatus, medium and equipment obtaining database variation table data |
| CN108228814B (en) * | 2017-12-29 | 2022-02-15 | 泰康保险集团股份有限公司 | Data synchronization method and device |
| CN108228814A (en) * | 2017-12-29 | 2018-06-29 | 泰康保险集团股份有限公司 | Method of data synchronization and device |
| CN108763387A (en) * | 2018-05-20 | 2018-11-06 | 湖北九州云仓科技发展有限公司 | Big data fusion method, electronic equipment, storage medium and the system of heterogeneous platform |
| CN109033268A (en) * | 2018-07-10 | 2018-12-18 | 安心财产保险有限责任公司 | Method of data synchronization, device, equipment and storage medium |
| CN108984743B (en) * | 2018-07-16 | 2021-04-13 | 广州天高软件科技有限公司 | Method for realizing cross-border data synchronization based on internal and external data centers |
| CN108984743A (en) * | 2018-07-16 | 2018-12-11 | 广州友米科技有限公司 | The synchronous method of cross-border data is realized based on local and overseas data centers |
| CN109271442A (en) * | 2018-07-27 | 2019-01-25 | 东软集团股份有限公司 | Database synchronization restoration methods, device, computer readable storage medium and electronic equipment |
| CN109857809A (en) * | 2019-01-31 | 2019-06-07 | 浙江小泰科技有限公司 | A kind of raw data base data are synchronized to the synchronous method and system of target database |
| CN110263052A (en) * | 2019-06-25 | 2019-09-20 | 苏宁消费金融有限公司 | One kind automating simultaneous techniques innovative approach based on big data Hadoop platform ODS |
| CN110263052B (en) * | 2019-06-25 | 2021-07-20 | 苏宁消费金融有限公司 | Automatic synchronization technology innovation method based on big data Hadoop platform ODS |
| CN112000646A (en) * | 2020-08-25 | 2020-11-27 | 北京浪潮数据技术有限公司 | Database initialization method and device, electronic equipment and storage medium |
| CN112000646B (en) * | 2020-08-25 | 2022-08-02 | 北京浪潮数据技术有限公司 | Database initialization method and device, electronic equipment and storage medium |
| CN112883040A (en) * | 2021-02-04 | 2021-06-01 | 中国工商银行股份有限公司 | Data synchronization method, device and equipment |
| CN113535478A (en) * | 2021-07-15 | 2021-10-22 | 中国电信股份有限公司 | Data backup method and device, storage medium and electronic equipment |
| CN113535478B (en) * | 2021-07-15 | 2024-01-02 | 天翼云科技有限公司 | Data backup method and device, storage medium and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103699580B (en) | 2016-08-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103699580A (en) | Database synchronization method and database synchronization device | |
| CN107544984B (en) | Data processing method and device | |
| CN110347746B (en) | Heterogeneous database synchronous data consistency checking method and device | |
| CN104219288B (en) | Distributed Data Synchronization method and its system based on multithreading | |
| CN110019267A (en) | A kind of metadata updates method, apparatus, system, electronic equipment and storage medium | |
| CN104516989B (en) | Incremental data supplying system and method | |
| CN105005618A (en) | Data synchronization method and system among heterogeneous databases | |
| CN103778136A (en) | Cross-room database synchronization method and system | |
| CN104750855B (en) | A kind of big data storage optimization method and device | |
| CN103699638A (en) | Method for realizing cross-database type synchronous data based on configuration parameters | |
| CN103631623A (en) | Method and device for allocating application software in trunking system | |
| CN103716384A (en) | Method and device for realizing cloud storage data synchronization in cross-data-center manner | |
| CN110647531A (en) | Data synchronization method, device, equipment and computer readable storage medium | |
| CN104834700A (en) | Method for capturing movement data increment based on track change | |
| CN105306581A (en) | Router and cloud disk based data synchronization method | |
| CN109344034A (en) | A kind of method and apparatus for managing log | |
| CN111737355A (en) | MongoDB metadata management-based heterogeneous data source synchronization method and system | |
| CN107870982B (en) | Data processing method, system and computer readable storage medium | |
| CN111177254A (en) | Method and device for data synchronization between heterogeneous relational databases | |
| CN105159820A (en) | Transmission method and device of system log data | |
| US8756312B2 (en) | Multi-tier message correlation | |
| CN101645072A (en) | Changed data extracting method realized by being based on Oracle CDC technique | |
| CN105760485A (en) | Financial data extraction method and system | |
| CN109657000B (en) | Real-time data synchronization method and device of rail transit comprehensive monitoring system | |
| CN110704442A (en) | Real-time acquisition method and device for big data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| ASS | Succession or assignment of patent right |
Owner name: CHINA RAILWAY TRIP SCIENCE AND TECHNOLOGY CO., LTD Effective date: 20150908 Owner name: CHINA RAILWAY CORPORATION Free format text: FORMER OWNER: CHINA RAILWAY TRIP SCIENCE AND TECHNOLOGY CO., LTD. Effective date: 20150908 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20150908 Address after: 10 Fuxing Road, Beijing, No. 100844 Applicant after: CHINA RAILWAY CORPORATION Applicant after: CHINA RAILWAY TRIP SCIENCE AND TECHNOLOGY CO., LTD. Address before: 100081 Beijing city Haidian District a two or three storey building of Daliushu Road No. 2 Applicant before: CHINA RAILWAY TRIP SCIENCE AND TECHNOLOGY CO., LTD. |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |