CN103136231B - Method of data synchronization between a kind of heterogeneous database and system - Google Patents
Method of data synchronization between a kind of heterogeneous database and system Download PDFInfo
- Publication number
- CN103136231B CN103136231B CN201110381992.3A CN201110381992A CN103136231B CN 103136231 B CN103136231 B CN 103136231B CN 201110381992 A CN201110381992 A CN 201110381992A CN 103136231 B CN103136231 B CN 103136231B
- 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.)
- Active
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Method of data synchronization between a kind of heterogeneous database and system, the related control data that two heterogeneous databases are respectively same application layer affairs arranges identical unique identification, source database triggers the amendment of the relevant control source data adopting uniquely identified application layer affairs, amendment information to be arranged in source database in source data synchronous meter, source database synchronized process in data syn-chronization executive system reads this amendment information in source data synchronous meter, be converted to received text file to store, in data syn-chronization executive system, target database synchronized process reads received text file, be converted to the amendment information of the relevant control target data adopting uniquely identified application layer affairs, be written to the target data synchronous meter in target database, after calling the amendment information of this relevant control target data in this target data synchronous meter, to the target data relevant amendment stored in this target database.The invention enables between the database of different pieces of information storage organization and carry out data syn-chronization.
Description
Technical field
The present invention relates to database field, the method for data synchronization particularly between a kind of heterogeneous database and system.
Background technology
Along with the development of database technology, there is the database of different pieces of information storage organization, how the data in the database of different pieces of information storage organization have been carried out synchronously, becoming a problem demanding prompt solution.
Lift an object lesson to illustrate, such as carry out data syn-chronization between business support system (CRM) database and business operation support system (BOSS) database, these data are support the data syn-chronization of transaction controlling.CRM primary responsibility realizes user at the service handling of each channel and open-minded, and BOSS primary responsibility realizes the charging to user.When BOSS will carry out charging to user, BOSS database just needs the control information obtaining the application layer affairs of user from CRM database, and the service order relation of such as user, user pay out the relation etc. of relation, user and group.BOSS database and CRM database separate, data each other can not be shared, and therefore, just need a kind of method of data synchronization, by the data syn-chronization in CRM database in BOSS database.
In order to make data syn-chronization success, CRM database and BOSS database adopt identical data store organisation, identical list structure is namely set, after the list item field in CRM database is modified, this amendment information is got by data syn-chronization executive system, data syn-chronization executive system instruction BOSS database performs identical list item field amendment, data syn-chronization executive system adopts Structured Query Language (SQL) (SQL) to complete said process usually, after data syn-chronization executive system is to the relevant entries field amendment in BOSS database, cannot cancel data table items amendment.
In order to make data syn-chronization executive system when carrying out data syn-chronization, CRM database and BOSS database can be inquired about, CRM database and BOSS database can the SQL message that send of the synchronous executive system of identification data, therefore, CRM database and BOSS database is needed to be the database of identical storage organization and identical version.
Aforesaid way is adopted to realize the data synchronization process of CRM database and BOSS database, just need to ensure that these two databases have identical storage organization and identical version, can be there are some shortcomings in this: the related control data of application layer affairs needs to be decomposed into multiple db transaction, also the multiple list items just in corresponding CRM database, also corresponding multiple db transaction when being synchronized to BOSS database.When CRM database will revise the related control data of a certain application layer affairs, just need to revise multiple list item in CRM database, at this moment, in BOSS database, also need the corresponding multiple list item of amendment, more loaded down with trivial details and easily make mistakes.In addition, due to an application layer affairs related control data be synchronized in BOSS database time, be split as multiple list item, and this multiple list item does not show the application layer affairs of being correlated with, and BOSS database is not also preserved synchronous front data, so when the cancelling of application layer affairs related control data will be carried out, be also difficult to cancel completely simply.
Therefore, the method for data synchronization between a kind of heterogeneous database and system is not also had at present.
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 to carry out data syn-chronization between the database of different pieces of information storage organization.
The present invention also provides a kind of data synchronous system of heterogeneous database part, and this system can make to carry out data syn-chronization between the database of different pieces of information storage organization.
For achieving the above object, technical scheme of the invention process is specifically 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 data syn-chronization executive system, 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 amendment of the relevant control source data of the application layer affairs in the trigger trigger source database of source database, is written in source data synchronous meter by the amendment information of the relevant control source data with these these application layer affairs of application layer affairs uniquely identified;
Source database synchronized process reads the amendment information of the relevant control source data of these application layer affairs in this source data synchronous meter, by the amendment information of the relevant control source data of these application layer affairs in this source data synchronous meter, obtain received text file after carrying out the conversion of received text and be stored in data syn-chronization executive system;
Target database synchronized process reads and resolves received text file, by this received text file transform be target database identification there is the amendment information of the relevant control target data of these these application layer affairs of application layer affairs uniquely identified after, be written in the target data synchronous meter in target database, call the amendment information of the relevant control target data of these application layer affairs, this application layer affairs uniquely identified target data relevant that has stored in this target database is modified.
A data synchronous system between heterogeneous database, this system comprises: source database, data syn-chronization executive system and target database, wherein,
Source database, source adapter and trigger are set, after triggering the amendment to the relevant control source data of uniquely identified application layer affairs for adopting the trigger of setting, by source adapter calling by the source database synchronized process in data syn-chronization executive system, amendment information is stored into after in the source data synchronous meter of setting, is read from source data synchronous meter by source database synchronized process;
Data syn-chronization executive system, comprise source database synchronized process and target database synchronized process, source database is called for adopting source database synchronized process, the amendment information of the relevant control source data of uniquely identified application layer affairs is adopted to be stored into source data synchronous meter, read this amendment information in this source data synchronous meter, obtain received text file after carrying out the conversion of received text and be stored in data syn-chronization executive system; Target database synchronized process is adopted to read and after resolving received text file, be after the amendment information of the relevant control target data of the employing uniquely identified application layer affairs of target database identification by this received text file transform, be written in the target data synchronous meter in target database, the amendment information in invocation target data syn-chronization table is modified to the target data relevant stored in this target database;
Target database, Offered target adapter, by destination adapter calling by the target database synchronized process in data syn-chronization executive system, the amendment information of the relevant control target data of uniquely identified application layer affairs will be adopted, in write target data synchronous meter, after amendment information according to this relevant control target data in target data synchronous meter, the target data relevant stored in this target database is modified.
As can be seen from the above scheme, the related control data that the present invention is respectively same application layer affairs in two heterogeneous databases arranges identical unique identification, source database synchronized process and target database synchronized process are set in data syn-chronization executive system, after source database triggers the amendment of the relevant control source data adopting uniquely identified application layer affairs, amendment information is arranged in the source data synchronous meter in source database, then source database synchronized process reads this amendment information in this source data synchronous meter, obtaining received text file after carrying out the conversion of received text is stored in data syn-chronization executive system, target database synchronized process reads and after resolving received text file, be after the amendment information of the relevant control target data of the employing uniquely identified application layer affairs of target database identification by this received text file transform, be written in the target data synchronous meter in target database, after calling the amendment information of this relevant control target data in this target data synchronous meter again, the target data relevant stored in this target database is modified.Because the present invention exists two different synchronized process in data syn-chronization executive system, respectively the amendment information of the relevant control source data of the different employing uniquely identified application layer affairs of storage organization is carried out to the conversion of received text, and received text is converted to the amendment information of the relevant control target data adopting uniquely identified application layer affairs, like this, just can make to carry out data syn-chronization between the database of different pieces of information storage organization.
Accompanying drawing explanation
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 object of the present invention, technical scheme and advantage clearly understand, to develop simultaneously embodiment referring to accompanying drawing, the present invention is described in further detail.
As can be seen from background technology, the basic reason that there is a lot of shortcoming in order to the data syn-chronization between fulfillment database needs source database to adopt identical version and the database of identical storage organization with target database, therefore, the data syn-chronization between the database how realizing different storage organization becomes the key point overcoming shortcoming in background technology.
Therefore, the related control data that the present invention is respectively same application layer affairs in two heterogeneous databases arranges identical unique identification, source database synchronized process and target database synchronized process are set in data syn-chronization executive system, after source database triggers the amendment of the relevant control source data adopting uniquely identified application layer affairs, amendment information is arranged in the source data synchronous meter in source database, then source database synchronized process reads this amendment information in this source data synchronous meter, obtaining received text file after carrying out the conversion of received text is stored in data syn-chronization executive system, target database synchronized process reads and after resolving received text file, be after the amendment information of the relevant control target data of the employing uniquely identified application layer affairs of target database identification by this received text file transform, be written in the target data synchronous meter in target database, after calling the amendment information of this relevant control target data in this target data synchronous meter again, the target data relevant stored in this target database is modified.
Because the present invention exists two different synchronized process in data syn-chronization executive system, respectively the amendment information of the relevant control source data of the different employing uniquely identified application layer affairs of storage organization is carried out to the conversion of received text, and received text is converted to the amendment information of the relevant control target data adopting uniquely identified application layer affairs, like this, just can make to carry out data syn-chronization between the database of different pieces of information storage organization.
In the present invention, trigger is provided with in source database, for when adopting the relevant control source data of uniquely identified application layer affairs to revise, this amendment information is arranged in the source data synchronous meter in source database after adopting this trigger to trigger the amendment of the relevant control source data of employing uniquely identified application layer affairs by data syn-chronization executive system.
In the present invention, in source database, being also provided with source adapter, for matching with the source database synchronized process of data syn-chronization executive system, carrying out the amendment Information Access of relevant control source data.
In the present invention, target database is also provided with destination adapter, for matching with the target database synchronized process of data syn-chronization executive system, carries out the amendment 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 data syn-chronization executive system, 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 amendment of the relevant control source data of the application layer affairs in the trigger trigger source database of step 101, source database, is written in source data synchronous meter by the amendment information of the relevant control source data with these these application layer affairs of application layer affairs uniquely identified;
Here, amendment information includes the unique identification of these application layer affairs, such as sequence number OID, relevant control source data changing content and variation pattern are identical to the unique identification of the synchronous flowing water of amendment of the relevant control source data of these application layer affairs in this source data synchronous meter;
Here, variation pattern is for increase, delete, revise or to cancel;
Step 102, source database synchronized process read the amendment information of the relevant control source data of these application layer affairs in this source data synchronous meter;
Here, source database is configured with source adapter, can directly and source database synchronized process carry out data interaction;
Step 103, source database synchronized process, by the amendment information of the relevant control source data of these application layer affairs in this source data synchronous meter, obtain received text file and are stored in data syn-chronization executive system after carrying out the conversion of received text;
Step 104, target database synchronized process read and resolve received text file, be after the amendment information of the relevant control target data of these application layer affairs of target database identification by this received text file transform, be written in the target data synchronous meter in target database;
Here, target database is configured with destination adapter, can directly and target database synchronized process carry out data interaction;
Step 105, target database synchronized process call the amendment information of the relevant control target data of these application layer affairs, modify to this application layer affairs uniquely identified target data relevant that has stored in this target database;
Here, this process is also completed by destination adapter;
Here, the service logic of target database synchronized process combining target database is resolved, be Data Update action by amendment information analysis, before target data amendment, the unique identification of value, the amended value of target data and correspondence before target data being revised is synchronized in set log sheet.
At this moment, if the amendment of source database to the relevant control source data of these application layer affairs is cancelled, then the initiation of data syn-chronization executive system carries the amendment cancel an order of the relevant control target data of these application layer affairs of uniquely identified to target database, at this moment, target database just can inquire about set log sheet, determine that according to unique identification the amendment of the relevant control target data of these application layer affairs is cancelled, revert to original target data.
Like this, the data syn-chronization between heterogeneous database is just completed.
After the target data of target database has been revised, the method can also comprise:
Step 106, target database synchronized process generate data syn-chronization answer file, include unique identification and the answer codes of these application layer affairs in file, for source database feedback data synchronized result;
Step 107, source database synchronized process read data syn-chronization answer file;
Step 108, source database synchronized process resolve the data syn-chronization answer file read, the flowing water state in the amendment information of relevant control source data in the source data synchronous meter in source database is upgraded according to the unique identification of these application layer affairs in this file, and upgrade flowing water code, represent and synchronously complete.
Fig. 2 is the data synchronous system structural representation that the invention provides between a kind of heterogeneous database, comprising: source database, data syn-chronization executive system and target database, wherein,
Source database, source adapter and trigger are set, adopt the amendment of the relevant control source data of uniquely identified application layer affairs for adopting the trigger of setting to trigger after, by source adapter calling by the source database synchronized process in data syn-chronization executive system, amendment information is stored into after in the source data synchronous meter of setting, is read from source data synchronous meter by source database synchronized process;
Data syn-chronization executive system, comprise source database synchronized process and target database synchronized process, source database is called for adopting source database synchronized process, the amendment information of the relevant control source data of uniquely identified application layer affairs is adopted to be stored into source data synchronous meter, read this amendment information in this source data synchronous meter, obtain received text file after carrying out the conversion of received text and be stored in data syn-chronization executive system; Target database synchronized process is adopted to read and after resolving received text file, be after the amendment information of the relevant control target data of the employing uniquely identified application layer affairs of target database identification by this received text file transform, be written in the target data synchronous meter in target database, the amendment information in invocation target data syn-chronization table is modified to the target data relevant stored in this target database;
Target database, Offered target adapter, by destination adapter calling by the target database synchronized process in data syn-chronization executive system, the amendment information of the relevant control target data of uniquely identified application layer affairs will be adopted, in write target data synchronous meter, after amendment information according to this relevant control target data in target data synchronous meter, the target data relevant stored in this target database is modified.
Within the system, described data syn-chronization executive system, also for adopting target database synchronized process to generate data syn-chronization answer file, includes unique identification and the answer codes of these application layer affairs in file; Adopt source database synchronized process to read and resolution data syn ack file, upgrade the flowing water state in the amendment information of relevant control source data in the source data synchronous meter in source database and flowing water code according to the unique identification of these application layer affairs in this file;
Described source database, also for calling according to source database synchronized process, upgrades the flowing water state in the amendment information of relevant control source data in source data synchronous meter and flowing water code.
Within the system, described data syn-chronization executive system, also for adopting target database synchronized process before target data amendment, the unique identification of value, the amended value of target data and correspondence before target data being revised is synchronized in set log sheet, can carry out cancelling of target data amendment.
Below lift a specific embodiment and the present invention is described, suppose that source database is CRM database, target database is BOSS database, and the data store organisation that CRM database adopts is different from the data store organisation that BOSS database adopts.
In this embodiment; suppose that being revised as of application layer affairs shuts down to a certain user the affairs of answering a pager's call that transactions modify is this user; in CRM database; the relevant control source data relating to these application layer affairs is kept in the table 1 of source, i.e. source state table, identifies the state of this user for shutting down; and in the table 2 of source; i.e. balance sheet, the remaining sum identifying this user is-20 yuan, and this user of source table 1 and source table 2 identifies with unique identification.
This user is shut down transactions modify be this user answer a pager's call affairs time; as shown in Figure 3; CRM database trigger triggers amendment; this User Status in the table 1 of source is changed to and answers a pager's call; the remaining sum of this user in the table 2 of source is revised as 40 yuan; then by should the amendment information of relevant control source data of user ID, comprise the status modifier and remaining sum amendment that carry out this user, be stored in source data synchronous meter.
Source database synchronized process in data syn-chronization executive system calls source data synchronous meter by the adapter of CRM database, get should the amendment information of relevant control source data of user ID, then carry out received text conversion, obtain should the received text file of amendment information of relevant control source data of user ID.
Target database synchronized process in data syn-chronization executive system reads should the received text file of amendment information of relevant control source data of user ID, change, be converted to should the amendment information of relevant control target data of user ID, be stored in target data synchronous meter.
Target database synchronized process in data syn-chronization executive system gets should the amendment information of relevant control target data of user ID from target data synchronous meter, this amendment information be in change object table 1 to should the state of user ID and remaining sum, then by object table 1 to should the state of user ID be revised as " 1 " by " 0 ", expression is changed to by shutdown and answers a pager's call, then remaining sum amendment is revised as "+40.00 yuan " from "-20.00 yuan ", then the target data in the object table 1 before and after amendment is all stored in log sheet, amendment can be cancelled so that follow-up.
After amendment completes, target database synchronized process in data syn-chronization executive system can also generate data syn-chronization answer file, comprise this user ID and answer codes, after source database synchronized process reads, state in the amendment information of this user ID in source data synchronous meter is upgraded, and upgrades answer codes.
The present invention, by the use of data synchronizing process adapter, can support the data syn-chronization between heterogeneous database; What the present invention was transmitted between heterogeneous database is amendment information, comprise revised context and alter mode, make that the synchrodata of source database generates, the parsing of target database to synchrodata is all separated with actuating logic, ensure that source database and target database can adopt different data storage methods; The present invention adopts unique identification to have the application layer affairs of multiple related control data, between heterogeneous database synchronous applications level affairs amendment or when cancelling, ensure the amendment of related control data or the consistance cancelled.
More than lift preferred embodiment; the object, technical solutions and advantages of the present invention are further described; be understood that; the foregoing 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 amendment done, equivalent replacement and improvement etc., all should be included within protection scope of the present invention.
Claims (7)
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 data syn-chronization executive system, 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 amendment of the relevant control source data of the application layer affairs in the trigger trigger source database of source database, is written in source data synchronous meter by the amendment information of the relevant control source data with these these application layer affairs of application layer affairs uniquely identified;
Source database synchronized process reads the amendment information of the relevant control source data of these application layer affairs in this source data synchronous meter, by the amendment information of the relevant control source data of these application layer affairs in this source data synchronous meter, obtain received text file after carrying out the conversion of received text and be stored in data syn-chronization executive system;
Target database synchronized process reads and resolves received text file, by this received text file transform be target database identification there is the amendment information of the relevant control target data of these these application layer affairs of application layer affairs uniquely identified after, be written in the target data synchronous meter in target database, the amendment information calling the relevant control target data of these application layer affairs is modified to this application layer affairs uniquely identified target data relevant that has stored in this target database;
Described source database is provided with source adapter, and the amendment information that source database synchronized process reads the relevant control source data of these application layer affairs in this source data synchronous meter is undertaken by this source adapter;
Described target database is provided with destination adapter, the target data synchronous meter that the amendment information of the relevant control target data with these these application layer affairs of application layer affairs uniquely identified is written in target database is undertaken by this destination adapter by target database, the described amendment information calling the relevant control target data of these application layer affairs, is modified to be undertaken by this destination adapter this application layer affairs uniquely identified target data relevant that has stored in this target database.
2. the method for claim 1, is characterized in that, the amendment information of the relevant control source data of these application layer affairs described comprises the unique identification of these application layer affairs, relevant control source data changing content and variation pattern.
3. method as claimed in claim 1 or 2, it is characterized in that, the method also comprises:
Target database synchronized process is before target data amendment, and the unique identification of value, the amended value of target data and correspondence before target data being revised is synchronized in set log sheet.
4. method as claimed in claim 1 or 2, it is characterized in that, the method also comprises:
Target database synchronized process generates data syn-chronization answer file, includes unique identification and the answer codes of the application layer affairs of these application layer affairs in file;
Source database synchronized process is resolved after reading data syn-chronization answer file, upgrades the flowing water state in the amendment information of relevant control source data in the source data synchronous meter in source database and upgrade flowing water code according to the unique identification of these application layer affairs in this file.
5. the data synchronous system between heterogeneous database, is characterized in that, this system comprises: source database, data syn-chronization executive system and target database, wherein,
Source database, source adapter and trigger are set, for adopting the amendment of trigger triggering to the relevant control source data of uniquely identified application layer affairs of setting, amendment information is called by the source database synchronized process in data syn-chronization executive system by source adapter, be stored into after in the source data synchronous meter of setting, read from source data synchronous meter by source database synchronized process;
Data syn-chronization executive system, comprise source database synchronized process and target database synchronized process, source database is called for adopting source database synchronized process, the amendment information of the relevant control source data adopting uniquely identified application layer affairs is stored into source data synchronous meter, obtain received text file after this amendment information read in this source data synchronous meter carries out the conversion of received text, described received text file is stored in data syn-chronization executive system; Target database synchronized process is adopted to read and after resolving received text file, be after the amendment information of the relevant control target data of the employing uniquely identified application layer affairs of target database identification by this received text file transform, be written in the target data synchronous meter in target database, the amendment information in invocation target data syn-chronization table is modified to the target data relevant stored in this target database;
Target database, Offered target adapter, by destination adapter calling by the target database synchronized process in data syn-chronization executive system, by adopting in the amendment information write target data synchronous meter of the relevant control target data of uniquely identified application layer affairs, according to the amendment information of this relevant control target data in target data synchronous meter, the target data relevant stored in this target database is modified.
6. system as claimed in claim 5, is characterized in that, described data syn-chronization executive system, also for adopting target database synchronized process to generate data syn-chronization answer file, includes unique identification and the answer codes of these application layer affairs in file; Adopt source database synchronized process to read and resolution data syn ack file, upgrade the flowing water state in the amendment information of relevant control source data in the source data synchronous meter in source database and flowing water code according to the unique identification of these application layer affairs in this file;
Described source database, also for calling according to source database synchronized process, upgrades the flowing water state in the amendment information of relevant control source data in source data synchronous meter and flowing water code.
7. the system as described in claim 5 or 6, it is characterized in that, described data syn-chronization executive system, also for adopting target database synchronized process before target data amendment, the unique identification of the application layer affairs of value, the amended value of target data and correspondence before target data being revised is 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 CN103136231A (en) | 2013-06-05 |
| CN103136231B true 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 (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 |
Families Citing this family (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| DE102013108306A1 (en) * | 2013-08-01 | 2015-02-05 | OMS Software GMBH | Method and system for the synchronization of data |
| CN104572672B (en) * | 2013-10-15 | 2018-10-02 | 北大方正集团有限公司 | The synchronous method and application system of heterogeneous 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 |
| CN104317921B (en) * | 2014-10-29 | 2017-10-17 | 北京思特奇信息技术股份有限公司 | A kind of integration across database data synchronous system and method |
| CN105183860B (en) * | 2015-09-10 | 2018-10-19 | 北京京东尚科信息技术有限公司 | Method of data synchronization and system |
| CN107357791B (en) * | 2016-05-10 | 2021-10-15 | 中兴通讯股份有限公司 | Data sharing method and device |
| CN107544999B (en) * | 2016-06-28 | 2022-10-21 | 百度在线网络技术（北京）有限公司 | Synchronization device and synchronization method for retrieval system, and retrieval system and method |
| CN109818998B (en) * | 2017-11-22 | 2021-05-25 | 中国电信股份有限公司 | Information synchronization method and device |
| CN108900497B (en) * | 2018-06-25 | 2021-11-02 | 江苏欧软信息科技有限公司 | Data synchronization method and system between heterogeneous systems |
| CN109558448B (en) * | 2018-10-10 | 2021-04-06 | 北京海数宝科技有限公司 | Data processing method, data processing 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 |
| CN112749227A (en) * | 2019-10-30 | 2021-05-04 | 北京国双科技有限公司 | Data synchronization method and device |
| CN114153659B (en) * | 2021-11-29 | 2022-09-20 | 众和空间(北京)科技有限责任公司 | Dual-mode data storage and synchronization system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (3)
| 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 |
| TWI344604B (en) * | 2004-10-26 | 2011-07-01 | Via Tech Inc | Network heterogeneous database synchronizing system and method |
| FR2909203B1 (en) * | 2006-11-23 | 2009-02-27 | Serlive Soc Par Actions Simpli | METHOD AND DEVICE FOR SYNCHRONIZATION OF HETEROGENEOUS DATABASES |
-
2011
- 2011-11-25 CN CN201110381992.3A patent/CN103136231B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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的异构数据库数据同步研究;孟雷;《山东大学学报》;20081130;第43卷(第11期);61-71 * |
Cited By (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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103136231A (en) | 2013-06-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103136231B (en) | Method of data synchronization between a kind of heterogeneous database and system | |
| US9344833B2 (en) | Data component in a mobile application framework | |
| US8412746B2 (en) | Method and system for federated querying of data sources | |
| CN102073490B (en) | Method and device for translating database language | |
| US8307015B2 (en) | Decorated model architecture for efficient model-driven application development | |
| CN103092970A (en) | Database operation method and device | |
| CN105487864A (en) | Method and device for automatically generating code | |
| CN103049251B (en) | A kind of data base persistence layer device and database operation method | |
| CN102087594B (en) | Management method and device for extension point and plugins | |
| CN100517229C (en) | Data version upgrading method | |
| CN110019111B (en) | Data processing method, data processing device, storage medium and processor | |
| CN107273176A (en) | The Compilation Method and device of a kind of adaptive hardware framework | |
| CN102929853B (en) | Based on DCS project data generation system and the method for the association of Excel list | |
| CN101174204A (en) | Device for upgrading data version | |
| US20180246931A1 (en) | Sqlscript compilation tracing system | |
| EP2466461B1 (en) | System and method for modular business applications | |
| CN110399386A (en) | A kind of SQL UPDATE method and control system based on Presto | |
| US11855910B2 (en) | Configuration management of cloud resources for multiple providers and frameworks | |
| CN116450660A (en) | Method and device for processing primary key conflict in data synchronization | |
| US10262054B2 (en) | Database and service upgrade without downtime | |
| CN104199675A (en) | System capable of quick system development based on database parameter utilization | |
| CN103186576B (en) | Heterogeneous system data are carried out to method and the cooperative system of associated treatment | |
| US20080022258A1 (en) | Custom database system and method of building and operating the same | |
| CN111400396A (en) | Method and device for generating data synchronization script and computer readable storage medium | |
| CN105787013A (en) | Type name distributing method and system for heterogeneous 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 | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |