CN103136231A - Data synchronization method and system for heterogeneous databases - Google Patents
Data synchronization method and system for heterogeneous databases Download PDFInfo
- Publication number
- CN103136231A CN103136231A CN2011103819923A CN201110381992A CN103136231A CN 103136231 A CN103136231 A CN 103136231A CN 2011103819923 A CN2011103819923 A CN 2011103819923A CN 201110381992 A CN201110381992 A CN 201110381992A CN 103136231 A CN103136231 A CN 103136231A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- source
- target
- application layer
- 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
Abstract
Provided is a data synchronization method and a system for heterogeneous databases. Two heterogeneous databases respectively set the same unique identifier for related control data of the same application level transaction. A source database triggers modification of the related control data, with the unique identifier, of the same application level transaction. Modification information is set in a source data synchronization table in the source database. The source data synchronization process in a data synchronization execution system reads the modification information in the source data synchronization table, and the modification information is converted into a standard text file to store. The target database synchronization process in the data synchronization execution system reads the standard text file, and the standard text file is converted into the modification information of the related control target data, with the unique identifier, of the same application level transaction. The modification information is written into a target data synchronization table in a target database. The related target data in the target database is modified after the modification information of the related control target data in the target data synchronization table. According to the data synchronization method and the system for heterogeneous databases, data synchronization between databases with different data storage structures is achieved.
Description
Technical field
The present invention relates to database field, particularly the method for data synchronization between a kind of heterogeneous database and system.
Background technology
Along with the development of database technology, the database of different pieces of information storage organization has appearred, how the data in the database of different pieces of information storage organization carried out synchronously becoming a problem demanding prompt solution.
Lift an object lesson explanation, data are synchronous such as carrying out between business support system (CRM) database and business operation support system (BOSS) database, and these data are synchronous for the data of supporting affairs to control.CRM mainly is responsible for realizing the user at the service handling of each channel and open-minded, and BOSS mainly is responsible for realizing the charging to the user.When BOSS will carry out charging to the user, the BOSS database just need to obtain the control information of user's application layer affairs from the CRM database, such as user's service order relation, user pays out relation of relation, user and group etc.BOSS database and CRM database are separate, and data each other can not be shared, and therefore, just need a kind of method of data synchronization, are synchronized in the BOSS database with regard to liking the data in that CRM database.
in order to make synchronously success of data, the CRM database adopts identical data store organisation with the BOSS database, identical list structure namely is set, after the list item field in the CRM database is modified, this modification information is got by the synchronous executive system of data, the synchronous executive system indication of data BOSS database is carried out identical list item field and is revised, the synchronous executive system of data adopts Structured Query Language (SQL) (SQL) to complete said process usually, after the synchronous executive system of data is revised the relevant entries field in the BOSS database, can't revise the data list item and cancel.
Carrying out data when synchronous in order to make the synchronous executive system of data, can inquire about CRM database and BOSS database, the SQL message that can the recognition data synchronous executive system of CRM database and BOSS database sends, therefore, needing CRM database and BOSS database is the database of identical storage organization and identical version.
Adopt aforesaid way to realize the data synchronization process of CRM database and BOSS database, just need to guarantee that these two databases have identical storage organization and identical version, can there be some shortcomings in this: the related control data of application layer affairs need to be decomposed into a plurality of db transactions, also with regard to a plurality of list items in corresponding CRM database, also corresponding a plurality of db transaction when being synchronized to the BOSS database.When the CRM database will be revised the related control data of a certain application layer affairs, just need to revise a plurality of list items in the CRM database, at this moment, also need corresponding a plurality of list items of modification in the BOSS database, more loaded down with trivial details and easily make mistakes.In addition, when being synchronized in the BOSS database due to an application layer affairs related control data, be split as a plurality of list items, and these a plurality of list items do not show relevant application layer affairs, and the BOSS database is not preserved the data before synchronous yet, so in the time will carrying out the cancelling of application layer affairs related control data, also be difficult to cancel fully simply.
Therefore, present method of data synchronization and the system that does not also have between a kind of heterogeneous database.
Summary of the invention
In view of this, the invention provides the method for data synchronization between a kind of heterogeneous database, the method can make that to carry out data between the database of different pieces of information storage organization synchronous.
The present invention also provides a kind of data synchronous system of heterogeneous database spare, and this system can make that to carry out data between the database of different pieces of information storage organization synchronous.
For achieving the above object, technical scheme of the invention process specifically is achieved in that
Method of data synchronization between a kind of heterogeneous database, source database synchronized process and target database synchronized process are set in the synchronous executive system of data, the related control data of the same application layer affairs of source database and target data library storage is arranged identical unique identification, and the method also comprises:
The modification of the relevant control source data of the application layer affairs in the trigger trigger source database of source database, the modification information that will have the relevant control source data of these these application layer affairs of application layer affairs uniquely identified is written in the source data synchronous meter;
The source database synchronized process reads the modification information of the relevant control source data of these application layer affairs in this source data synchronous meter, with the modification information of the relevant control source data of these application layer affairs in this source data synchronous meter, carry out obtaining the received text file after the conversion of received text and be stored in the synchronous executive system of data;
The target database synchronized process reads and resolves the received text file, after this received text file being converted to the modification information of the relevant control target data with these these application layer affairs of application layer affairs uniquely identified of target database identification, be written in the target data synchronous meter in target database, call the modification information of the relevant control target data of these application layer affairs, this application layer affairs uniquely identified target data relevant that has of storing in this target database is modified.
Data synchronous system between a kind of heterogeneous database, this system comprises: source database, the synchronous executive system of data and target database, wherein,
Source database, source adapter and trigger are set, after being used for adopting the modification of trigger triggering to the relevant control source data of uniquely identified application layer affairs that arranges, by source adapter calling by the source database synchronized process in the synchronous executive system of data, after modification information being stored in the source data synchronous meter of setting, read from the source data synchronous meter by the source database synchronized process;
The synchronous executive system of data, comprise source database synchronized process and target database synchronized process, be used for adopting the source database synchronized process to call source database, adopt the modification information of the relevant control source data of uniquely identified application layer affairs to store the source data synchronous meter into, read this modification information in this source data synchronous meter, carry out obtaining the received text file after the conversion of received text and be stored in the synchronous executive system of data; After adopting the target database synchronized process to read and resolve the received text file, after this received text file being converted to the modification information of relevant control target data of employing uniquely identified application layer affairs of target database identification, be written in the target data synchronous meter in target database, the modification information in invocation target data synchronous meter is modified to the target data relevant of storing in this target database;
Target database, the Offered target adapter, by destination adapter calling by the target database synchronized process in the synchronous executive system of data, the modification information of the relevant control target data of uniquely identified application layer affairs will be adopted, write in the target data synchronous meter, after modification information according to this relevant control target data in the target data synchronous meter, the target data relevant of storing in this target database is modified.
can be found out by such scheme, the present invention is respectively same application layer affairs in two heterogeneous databases related control data arranges identical unique identification, source database synchronized process and target database synchronized process are set in the synchronous executive system of data, after source database triggers the modification of the relevant control source data that adopts uniquely identified application layer affairs, modification information is arranged in source data synchronous meter in source database, then the source database synchronized process reads this modification information in this source data synchronous meter, carrying out obtaining the received text file after the conversion of received text is stored in the synchronous executive system of data, after the target database synchronized process reads and resolves the received text file, after this received text file being converted to the modification information of relevant control target data of employing uniquely identified application layer affairs of target database identification, be written in the target data synchronous meter in target database, after calling again the modification information of this relevant control target data in this target data synchronous meter, the target data relevant of storing in this target database is modified.There are two different synchronized process in the synchronous executive system of data due to the present invention, respectively the modification information of the relevant control source data of the different employing uniquely identified application layer affairs of storage organization is carried out the conversion of received text, reach the modification information that received text is converted to the relevant control target data that adopts uniquely identified application layer affairs, like this, just can be synchronous so that carry out data between the database of different pieces of information storage organization.
Description of drawings
Fig. 1 is the method for data synchronization process flow diagram between a kind of heterogeneous database provided by the invention;
Fig. 2 is the data synchronous system structural representation that the invention provides between a kind of heterogeneous database;
Fig. 3 is the method for data synchronization embodiment schematic diagram between a kind of heterogeneous database provided by the invention.
Embodiment
For making purpose of the present invention, technical scheme and advantage clearer, referring to the accompanying drawing embodiment that develops simultaneously, the present invention is described in further detail.
Can find out from background technology, the basic reason that synchronously exists a lot of shortcomings for the data between fulfillment database is to need source database and target database to adopt the database of identical version and identical storage organization, therefore, how to realize that the data between the database of different storage organizations synchronously become the key point that overcomes shortcoming in background technology.
therefore, the present invention is respectively same application layer affairs in two heterogeneous databases related control data arranges identical unique identification, source database synchronized process and target database synchronized process are set in the synchronous executive system of data, after source database triggers the modification of the relevant control source data that adopts uniquely identified application layer affairs, modification information is arranged in source data synchronous meter in source database, then the source database synchronized process reads this modification information in this source data synchronous meter, carrying out obtaining the received text file after the conversion of received text is stored in the synchronous executive system of data, after the target database synchronized process reads and resolves the received text file, after this received text file being converted to the modification information of relevant control target data of employing uniquely identified application layer affairs of target database identification, be written in the target data synchronous meter in target database, after calling again the modification information of this relevant control target data in this target data synchronous meter, the target data relevant of storing in this target database is modified.
There are two different synchronized process in the synchronous executive system of data due to the present invention, respectively the modification information of the relevant control source data of the different employing uniquely identified application layer affairs of storage organization is carried out the conversion of received text, reach the modification information that received text is converted to the relevant control target data that adopts uniquely identified application layer affairs, like this, just can be synchronous so that carry out data between the database of different pieces of information storage organization.
In the present invention, be provided with trigger in source database, the relevant control source data that adopts uniquely identified application layer affairs is used for when will be revised, after the synchronous executive system of data adopts this trigger to trigger to adopt the modification of relevant control source data of uniquely identified application layer affairs, this modification information is arranged in source data synchronous meter in source database.
In the present invention, also be provided with source adapter in source database, the source database synchronized process that is used for synchronizeing with data executive system is complementary, and carries out the modification Information Access of relevant control source data.
In the present invention, target database also is provided with destination adapter, and the target database synchronized process that is used for synchronizeing with data executive system is complementary, and carries out the modification Information Access of relevant control target data.
Fig. 1 is the method for data synchronization process flow diagram between a kind of heterogeneous database provided by the invention, source database synchronized process and target database synchronized process are set in the synchronous executive system of data, the related control data of the same application layer affairs of source database and target data library storage is arranged identical unique identification, and the method also comprises:
The modification of the relevant control source data of the application layer affairs in the trigger trigger source database of step 101, source database, the modification information that will have the relevant control source data of these these application layer affairs of application layer affairs uniquely identified is written in the source data synchronous meter;
Here, modification information has comprised the unique identification of these application layer affairs, such as sequence number OID, relevant control source data changing content and variation pattern, the unique identification to the synchronous flowing water of modification of the relevant control source data of these application layer affairs in this source data synchronous meter is identical;
Here, variation pattern is for increasing, delete, revise or cancel etc.;
Here, source database disposes source adapter, can be directly and the source database synchronized process carry out data interaction;
Here, target database disposes destination adapter, can be directly and the target database synchronized process carry out data interaction;
Here, this process is also completed by destination adapter;
Here, the service logic of target database synchronized process combining target database is resolved, to revise information analysis is the Data Update action, before target data was revised, the amended value of value, target data and corresponding unique identification before target data can being revised were synchronized in set log sheet.
At this moment, if source database is cancelled the modification of the relevant control source data of these application layer affairs, the synchronous executive system of data initiates to carry the modification cancel an order of relevant control target data of these application layer affairs of uniquely identified to target database, at this moment, target database just can be inquired about set log sheet, determine that according to unique identification the modification of the relevant control target data of these application layer affairs cancels, revert to original target data.
The data of like this, just having completed between heterogeneous database are synchronous.
After the target data modification of target database was completed, the method can also comprise:
Fig. 2 is the data synchronous system structural representation that the invention provides between a kind of heterogeneous database, comprising: source database, the synchronous executive system of data and target database, wherein,
Source database, source adapter and trigger are set, after being used for adopting the trigger that arranges to trigger the modification of the relevant control source data that adopts uniquely identified application layer affairs, by source adapter calling by the source database synchronized process in the synchronous executive system of data, after modification information being stored in the source data synchronous meter of setting, read from the source data synchronous meter by the source database synchronized process;
The synchronous executive system of data, comprise source database synchronized process and target database synchronized process, be used for adopting the source database synchronized process to call source database, adopt the modification information of the relevant control source data of uniquely identified application layer affairs to store the source data synchronous meter into, read this modification information in this source data synchronous meter, carry out obtaining the received text file after the conversion of received text and be stored in the synchronous executive system of data; After adopting the target database synchronized process to read and resolve the received text file, after this received text file being converted to the modification information of relevant control target data of employing uniquely identified application layer affairs of target database identification, be written in the target data synchronous meter in target database, the modification information in invocation target data synchronous meter is modified to the target data relevant of storing in this target database;
Target database, the Offered target adapter, by destination adapter calling by the target database synchronized process in the synchronous executive system of data, the modification information of the relevant control target data of uniquely identified application layer affairs will be adopted, write in the target data synchronous meter, after modification information according to this relevant control target data in the target data synchronous meter, the target data relevant of storing in this target database is modified.
In this system, the synchronous executive system of described data also is used for adopting target database synchronized process generated data syn ack file, and file has comprised unique identification and the answer codes of these application layer affairs; Adopt the source database synchronized process to read and resolution data syn ack file, according to flowing water state and the flowing water code in the modification information of relevant control source data in the source data synchronous meter in the unique identification renewal source database of these application layer affairs in this document;
Described source database also is used for according to the calling of source database synchronized process, the flowing water state in the modification information of relevant control source data in the source data synchronous meter and flowing water code being upgraded.
In this system, the synchronous executive system of described data, also be used for adopting the target database synchronized process before target data is revised, the amended value of value, target data and corresponding unique identification before target data is revised are synchronized in set log sheet, can carry out cancelling of target data modification.
Below lift a specific embodiment explanation the present invention, suppose that source database is the CRM database, target database is the BOSS database, and the data store organisation that the CRM database adopts is different from the data store organisation that the BOSS database adopts.
In this embodiment; suppose that being revised as of application layer affairs shut down transactions modify to a certain user and be this user's the affairs of answering a pager's call; in the CRM database; the relevant control source data that relates to these application layer affairs is kept in the table 1 of source, and namely the source state table, identify this user's state for shutting down; and in the table 2 of source; be balance sheet, the remaining sum that identifies this user is-20 yuan, and this user of source table 1 and source table 2 identifies with unique identification.
This user is being shut down transactions modify answering a pager's call during affairs for this user; as shown in Figure 3; the CRM database trigger triggers to be revised; this User Status in the table 1 of source is changed to answer a pager's call; the remaining sum of this user in the table 2 of source is revised as 40 yuan; then will be to the modification information of relevant control source data that should user ID, comprise that status modifier and the remaining sum of carrying out this user revise, store in the source data synchronous meter.
Source database synchronized process in the synchronous executive system of data calls the source data synchronous meter by the adapter of CRM database, get the modification information to relevant control source data that should user ID, then carry out received text conversion, obtain the received text file to the modification information of relevant control source data that should user ID.
Target database synchronized process in the synchronous executive system of data reads the received text file to the modification information of relevant control source data that should user ID, change, be converted to the modification information to relevant control target data that should user ID, store in the target data synchronous meter.
target database synchronized process in the synchronous executive system of data gets the modification information to relevant control target data that should user ID from the target data synchronous meter, this modification information for change in object table 1 to state and remaining sum that should user ID, the state to should user ID in object table 1 is revised as " 1 " by " 0 ", expression is changed to by shutdown and answers a pager's call, then remaining sum is revised and be revised as "+40.00 yuan " from " 20.00 yuan ", then the target data in the object table 1 before and after revising all is stored in log sheet, in order to follow-uply can cancel modification.
After modification is completed, the all right generated data syn ack file of target database synchronized process in the synchronous executive system of data, comprise this user ID and answer codes, after the source database synchronized process reads, state in the modification information of this user ID in the source data synchronous meter is upgraded, and upgrade answer codes.
The present invention can support that by the use of data synchronizing process adapter the data between heterogeneous database are synchronous; What the present invention was transmitted between heterogeneous database is modification information, comprise revised context and alter mode, make synchrodata generation, the target database of source database all separate with actuating logic the parsing of synchrodata, guarantee that source database and target database can adopt different data storage methods; The present invention adopts unique identification sign to have the application layer affairs of a plurality of related control datas, and the modification of synchronous applications level affairs or when cancelling between heterogeneous database guarantees the modification of related control data or the consistance of cancelling.
Above act preferred embodiment; the purpose, technical solutions and advantages of the present invention are further described; institute is understood that; the above is only preferred embodiment of the present invention; not in order to limit the present invention; within the spirit and principles in the present invention all, any modification of doing, be equal to and replace and improvement etc., within all should being included in protection scope of the present invention.
Claims (8)
1. the method for data synchronization between a heterogeneous database, it is characterized in that, source database synchronized process and target database synchronized process are set in the synchronous executive system of data, the related control data of the same application layer affairs of source database and target data library storage is arranged identical unique identification, and the method also comprises:
The modification of the relevant control source data of the application layer affairs in the trigger trigger source database of source database, the modification information that will have the relevant control source data of these these application layer affairs of application layer affairs uniquely identified is written in the source data synchronous meter;
The source database synchronized process reads the modification information of the relevant control source data of these application layer affairs in this source data synchronous meter, with the modification information of the relevant control source data of these application layer affairs in this source data synchronous meter, carry out obtaining the received text file after the conversion of received text and be stored in the synchronous executive system of data;
The target database synchronized process reads and resolves the received text file, after this received text file being converted to the modification information of the relevant control target data with these these application layer affairs of application layer affairs uniquely identified of target database identification, be written in the target data synchronous meter in target database, call the modification information of the relevant control target data of these application layer affairs, this application layer affairs uniquely identified target data relevant that has of storing in this target database is modified.
2. the method for claim 1, is characterized in that, the modification information of the relevant control source data of described these application layer affairs comprises the unique identification of these application layer affairs, relevant control source data changing content and variation pattern.
3. the method for claim 1, it is characterized in that, described source database is provided with source adapter, and the source database synchronized process reads the modification information of the relevant control source data of these application layer affairs in this source data synchronous meter to be undertaken by this source adapter;
Described target database is provided with destination adapter, target database will have the target data synchronous meter that the modification information of the relevant control target data of these these application layer affairs of application layer affairs uniquely identified is written in target database and be undertaken by this destination adapter, the described modification information of calling the relevant control target data of these application layer affairs is modified and is undertaken by this destination adapter this application layer affairs uniquely identified target data relevant that has of storing in this target database.
4. as claim 1,2 or 3 described methods, it is characterized in that, the method also comprises:
Synchronously before target data was revised, the amended value of value, target data and corresponding unique identification before target data is revised were synchronized in set log sheet target database.
5. as claim 1,2 or 3 described methods, it is characterized in that, the method can also comprise:
Target database synchronized process generated data syn ack file, file has comprised unique identification and the answer codes of these application layer affairs;
Resolve after source database synchronized process reading out data syn ack file, upgrade the flowing water state in the modification information of relevant control source data in source data synchronous meter in source database according to the unique identification of these application layer affairs in this document and upgrade the flowing water code.
6. the data synchronous system between a heterogeneous database, is characterized in that, this system comprises: source database, the synchronous executive system of data and target database, wherein,
Source database, source adapter and trigger are set, after being used for adopting the modification of trigger triggering to the relevant control source data of uniquely identified application layer affairs that arranges, by source adapter calling by the source database synchronized process in the synchronous executive system of data, after modification information being stored in the source data synchronous meter of setting, read from the source data synchronous meter by the source database synchronized process;
The synchronous executive system of data, comprise source database synchronized process and target database synchronized process, be used for adopting the source database synchronized process to call source database, adopt the modification information of the relevant control source data of uniquely identified application layer affairs to store the source data synchronous meter into, read this modification information in this source data synchronous meter, carry out obtaining the received text file after the conversion of received text and be stored in the synchronous executive system of data; After adopting the target database synchronized process to read and resolve the received text file, after this received text file being converted to the modification information of relevant control target data of employing uniquely identified application layer affairs of target database identification, be written in the target data synchronous meter in target database, the modification information in invocation target data synchronous meter is modified to the target data relevant of storing in this target database;
Target database, the Offered target adapter, by destination adapter calling by the target database synchronized process in the synchronous executive system of data, the modification information of the relevant control target data of uniquely identified application layer affairs will be adopted, write in the target data synchronous meter, after modification information according to this relevant control target data in the target data synchronous meter, the target data relevant of storing in this target database is modified.
7. system as claimed in claim 6, is characterized in that, the synchronous executive system of described data also is used for adopting target database synchronized process generated data syn ack file, and file has comprised unique identification and the answer codes of these application layer affairs; Adopt the source database synchronized process to read and resolution data syn ack file, according to flowing water state and the flowing water code in the modification information of relevant control source data in the source data synchronous meter in the unique identification renewal source database of these application layer affairs in this document;
Described source database also is used for according to the calling of source database synchronized process, the flowing water state in the modification information of relevant control source data in the source data synchronous meter and flowing water code being upgraded.
8. system as described in claim 6 or 7, it is characterized in that, the synchronous executive system of described data, also be used for adopting the target database synchronized process before target data is revised, the amended value of value, target data and corresponding unique identification before target data is revised are synchronized in set log sheet.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110381992.3A CN103136231B (en) | 2011-11-25 | 2011-11-25 | Method of data synchronization between a kind of heterogeneous database and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110381992.3A CN103136231B (en) | 2011-11-25 | 2011-11-25 | Method of data synchronization between a kind of heterogeneous database and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103136231A true CN103136231A (en) | 2013-06-05 |
| CN103136231B CN103136231B (en) | 2016-03-02 |
Family
ID=48496066
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110381992.3A Active CN103136231B (en) | 2011-11-25 | 2011-11-25 | Method of data synchronization between a kind of heterogeneous database and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103136231B (en) |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103744906A (en) * | 2013-12-26 | 2014-04-23 | 乐视网信息技术（北京）股份有限公司 | System, method and device for data synchronization |
| CN103761140A (en) * | 2013-11-29 | 2014-04-30 | 北京中启智源数字信息技术有限责任公司 | Method for implementing transaction processing in isomeric relational database |
| CN104317921A (en) * | 2014-10-29 | 2015-01-28 | 北京思特奇信息技术股份有限公司 | Cross-database data synchronizing system and method |
| CN104572672A (en) * | 2013-10-15 | 2015-04-29 | 北大方正集团有限公司 | Heterogeneous database synchronization method and application system |
| CN104834635A (en) * | 2014-02-07 | 2015-08-12 | 中国移动通信集团广东有限公司 | Data processing method and device |
| CN105183860A (en) * | 2015-09-10 | 2015-12-23 | 北京京东尚科信息技术有限公司 | Data synchronization method and system |
| CN105659226A (en) * | 2013-08-01 | 2016-06-08 | Oms软件股份有限公司 | Method and system for synchronising data |
| CN103701913B (en) * | 2013-12-30 | 2017-02-22 | 广州爱九游信息技术有限公司 | Data synchronization method and device |
| CN107357791A (en) * | 2016-05-10 | 2017-11-17 | 中兴通讯股份有限公司 | A kind of data sharing method and device |
| CN107544999A (en) * | 2016-06-28 | 2018-01-05 | 百度在线网络技术（北京）有限公司 | Sychronisation and synchronous method, searching system and method for searching system |
| CN108900497A (en) * | 2018-06-25 | 2018-11-27 | 江苏欧软信息科技有限公司 | Method of data synchronization and system between a kind of heterogeneous system |
| CN109558448A (en) * | 2018-10-10 | 2019-04-02 | 北京海数宝科技有限公司 | Data processing method, device, computer equipment and storage medium |
| CN109656936A (en) * | 2018-11-30 | 2019-04-19 | 金蝶软件（中国）有限公司 | Method of data synchronization, device, computer equipment and storage medium |
| CN109818998A (en) * | 2017-11-22 | 2019-05-28 | 中国电信股份有限公司 | Information synchronization method and device |
| CN111061745A (en) * | 2019-10-10 | 2020-04-24 | 望海康信(北京)科技股份公司 | Data synchronization system and method |
| CN114153659A (en) * | 2021-11-29 | 2022-03-08 | 众和空间(北京)科技有限责任公司 | Dual-mode data storage and synchronization system |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105930493A (en) * | 2016-05-04 | 2016-09-07 | 北京思特奇信息技术股份有限公司 | Method and system for data synchronization between different databases |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050228765A1 (en) * | 2004-01-16 | 2005-10-13 | Taiwan Semiconductor Manufacturing Co. | Mechanism for synchronizing manafacturing information systems and document content management systems data |
| US20060095477A1 (en) * | 2004-10-26 | 2006-05-04 | Via Technologies, Inc. | Database synchronizing system and method |
| CN101615199A (en) * | 2009-07-31 | 2009-12-30 | 深圳市珍爱网信息技术有限公司 | Heterogeneous database synchronization method and system |
| CN101706795A (en) * | 2009-11-30 | 2010-05-12 | 上海世范软件技术有限公司 | Method for synchronizing data of database in active/standby server |
| US20100174681A1 (en) * | 2006-11-23 | 2010-07-08 | Serlive | Method and device for heterogeneous database synchronization |
| CN101944114A (en) * | 2010-09-16 | 2011-01-12 | 深圳天源迪科信息技术股份有限公司 | Data synchronization method between memory database and physical database |
-
2011
- 2011-11-25 CN CN201110381992.3A patent/CN103136231B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050228765A1 (en) * | 2004-01-16 | 2005-10-13 | Taiwan Semiconductor Manufacturing Co. | Mechanism for synchronizing manafacturing information systems and document content management systems data |
| US20060095477A1 (en) * | 2004-10-26 | 2006-05-04 | Via Technologies, Inc. | Database synchronizing system and method |
| US20100174681A1 (en) * | 2006-11-23 | 2010-07-08 | Serlive | Method and device for heterogeneous database synchronization |
| CN101615199A (en) * | 2009-07-31 | 2009-12-30 | 深圳市珍爱网信息技术有限公司 | Heterogeneous database synchronization method and system |
| CN101706795A (en) * | 2009-11-30 | 2010-05-12 | 上海世范软件技术有限公司 | Method for synchronizing data of database in active/standby server |
| CN101944114A (en) * | 2010-09-16 | 2011-01-12 | 深圳天源迪科信息技术股份有限公司 | Data synchronization method between memory database and physical database |
Non-Patent Citations (1)
| Title |
|---|
| 孟雷: "基于P2P的异构数据库数据同步研究", 《山东大学学报》 * |
Cited By (22)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105659226B (en) * | 2013-08-01 | 2019-05-31 | Oms软件股份有限公司 | The method and system for keeping data synchronous |
| CN105659226A (en) * | 2013-08-01 | 2016-06-08 | Oms软件股份有限公司 | Method and system for synchronising data |
| CN104572672A (en) * | 2013-10-15 | 2015-04-29 | 北大方正集团有限公司 | Heterogeneous database synchronization method and application system |
| CN104572672B (en) * | 2013-10-15 | 2018-10-02 | 北大方正集团有限公司 | The synchronous method and application system of heterogeneous database |
| CN103761140A (en) * | 2013-11-29 | 2014-04-30 | 北京中启智源数字信息技术有限责任公司 | Method for implementing transaction processing in isomeric relational database |
| CN103761140B (en) * | 2013-11-29 | 2018-04-13 | 北京中启智源数字信息技术有限责任公司 | A kind of method that issued transaction is realized in isomeric relationship type database |
| CN103744906A (en) * | 2013-12-26 | 2014-04-23 | 乐视网信息技术（北京）股份有限公司 | System, method and device for data synchronization |
| CN103701913B (en) * | 2013-12-30 | 2017-02-22 | 广州爱九游信息技术有限公司 | Data synchronization method and device |
| CN104834635A (en) * | 2014-02-07 | 2015-08-12 | 中国移动通信集团广东有限公司 | Data processing method and device |
| CN104317921A (en) * | 2014-10-29 | 2015-01-28 | 北京思特奇信息技术股份有限公司 | Cross-database data synchronizing system and method |
| CN104317921B (en) * | 2014-10-29 | 2017-10-17 | 北京思特奇信息技术股份有限公司 | A kind of integration across database data synchronous system and method |
| CN105183860A (en) * | 2015-09-10 | 2015-12-23 | 北京京东尚科信息技术有限公司 | Data synchronization method and system |
| CN105183860B (en) * | 2015-09-10 | 2018-10-19 | 北京京东尚科信息技术有限公司 | Method of data synchronization and system |
| CN107357791A (en) * | 2016-05-10 | 2017-11-17 | 中兴通讯股份有限公司 | A kind of data sharing method and device |
| CN107544999A (en) * | 2016-06-28 | 2018-01-05 | 百度在线网络技术（北京）有限公司 | Sychronisation and synchronous method, searching system and method for searching system |
| CN109818998A (en) * | 2017-11-22 | 2019-05-28 | 中国电信股份有限公司 | Information synchronization method and device |
| CN108900497A (en) * | 2018-06-25 | 2018-11-27 | 江苏欧软信息科技有限公司 | Method of data synchronization and system between a kind of heterogeneous system |
| CN109558448A (en) * | 2018-10-10 | 2019-04-02 | 北京海数宝科技有限公司 | Data processing method, device, computer equipment and storage medium |
| CN109656936A (en) * | 2018-11-30 | 2019-04-19 | 金蝶软件（中国）有限公司 | Method of data synchronization, device, computer equipment and storage medium |
| CN111061745A (en) * | 2019-10-10 | 2020-04-24 | 望海康信(北京)科技股份公司 | Data synchronization system and method |
| CN114153659A (en) * | 2021-11-29 | 2022-03-08 | 众和空间(北京)科技有限责任公司 | Dual-mode data storage and synchronization system |
| CN114153659B (en) * | 2021-11-29 | 2022-09-20 | 众和空间(北京)科技有限责任公司 | Dual-mode data storage and synchronization system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103136231B (en) | 2016-03-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103136231B (en) | Method of data synchronization between a kind of heterogeneous database and system | |
| CN107291948B (en) | Access method of distributed newSQL database | |
| CN105487864B (en) | The method and apparatus of Code automatic build | |
| CN103092970A (en) | Database operation method and device | |
| CN102073490A (en) | Method and device for translating database language | |
| CN103049251B (en) | A kind of data base persistence layer device and database operation method | |
| CN102542382A (en) | Method and device for managing business rule | |
| CN102087594B (en) | Management method and device for extension point and plugins | |
| CN103853543A (en) | Method used for quickly constructing forms in enterprise information system development process | |
| CN104750472B (en) | The resource package management method and device of a kind of terminal applies | |
| CN100517229C (en) | Data version upgrading method | |
| CN102567399A (en) | Method and device for accessing database | |
| CN103020058A (en) | Multi-version data acquisition method and device | |
| CN105677805A (en) | Data storing and reading method and device using protobuf | |
| CN110941629A (en) | Metadata processing method, device, equipment and computer readable storage medium | |
| CN111026756A (en) | Method for dynamically generating form and associated query | |
| CN101174204A (en) | Device for upgrading data version | |
| CN102508673A (en) | System and method for rapidly developing and configuring platform software | |
| CN113094039A (en) | Automatic code generation system based on database table | |
| CN116049193A (en) | Data storage method and device | |
| CN101470602A (en) | Software development method depending on relational database | |
| CN113448942B (en) | Database access method, device, equipment and storage medium | |
| CN104199675A (en) | System capable of quick system development based on database parameter utilization | |
| CN103809915A (en) | Read-write method and device of magnetic disk files | |
| CN113177059A (en) | Method and device for generating matching platform SQL script |
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 |