CN104317921B - A kind of integration across database data synchronous system and method - Google Patents
A kind of integration across database data synchronous system and method Download PDFInfo
- Publication number
- CN104317921B CN104317921B CN201410594738.5A CN201410594738A CN104317921B CN 104317921 B CN104317921 B CN 104317921B CN 201410594738 A CN201410594738 A CN 201410594738A CN 104317921 B CN104317921 B CN 104317921B
- Authority
- CN
- China
- Prior art keywords
- sync message
- database
- data
- module
- sql request
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of integration across database data synchronous system and method, including source database, sync message transport module and purpose database；Source database verifies SQL request using allocation list, and synchronizing information and source database interface table information are obtained according to SQL request, travels through tables of data respective field splicing generation sync message to be synchronized and is inserted into source database interface table；Sync message in source database interface table is transported in purpose database interface table by sync message transport module；Sync message in purpose database interface table is carried out parsing landing by the purpose database, and data are fallen into corresponding data table.This invention simplifies the process step of integration across database data syn-chronization, the input of system maintenance personnel is reduced；Reduce the number of times for writing SQL scripts, automatic assembling message and then be sent to purpose database, then parsed by purpose database, greatly reduce the risk for artificially performing and bringing, reduce error rate and cost consumption.
Description
Technical field
The present invention relates to database technical field, more particularly to a kind of integration across database data synchronous system and method.
Background technology
Current telecommunications enterprise realizes crm system and the business and data decoupler of BOSS systems using NGBOSS systems.Cause
This, it is necessary to corresponding data increment is synchronized into BOSS systems, realizes that the free rate of BOSS sides are given after CRM accepts business
Send, the charging action such as monthly rent deduction.For example：User will carry out account-opening to business hall, and shop assistant handles in crm system and opened an account
Business simultaneously selects Global Link set meal, and prestore certain telephone expenses, and this business datum needs first to be landed in CRM database, so
After be re-synchronised in BOSS storehouses and realize charging.
During actual treatment customer complaint and operational system, if to be needed by the direct processing data in backstage
The data in two storehouses, the also corresponding memory bank of charging are handled simultaneously.For example：Shop assistant is ordered due to operational error to user
One A set meal, this problem needs the background process data A set meals are adjusted to B set meals, it is necessary to by the handling process such as Fig. 6.
CRM attendant writes CRM script files and is sent to CRM storehouses processing corresponding data, while notifying BOSS to safeguard people
Member, and the CRM script files write are sent to BOSS attendant, BOSS attendant writes according to CRM script files
BOSS script files and memory bank script file are sent respectively to BOSS storehouses and memory bank, and then change corresponding data, realize
Data syn-chronization.
Even if above-mentioned processing method handles a very simple question, it is also desirable to which the attendant of two systems writes to arrive twice
Three script files, perform in three databases get to purpose, very consuming cost respectively.
Therefore, need badly it is a kind of can realize the method for data synchronization and system of integration across database, reduce attendant's manpower and throw
Enter, simplify operating procedure, reduce error rate, reduce cost consumption.
The content of the invention
The technical problems to be solved by the invention are that there is provided a kind of integration across database data syn-chronization in view of the shortcomings of the prior art
System and method, solving integration across database data syn-chronization in the prior art needs repeatedly to write script, and the cumbersome of database is performed a plurality of times
Operation, reduces error rate, reduces cost consumption.
The technical scheme that the present invention solves above-mentioned technical problem is as follows：A kind of integration across database data synchronous system, including source
Database, sync message transport module and purpose database；
The source database, it is used to verify SQL request using allocation list, and synchronizing information and source are obtained according to SQL request
Database interface table information, traversal tables of data respective field splicing to be synchronized, which generates sync message and is inserted into source database, to be connect
In oral thermometer；
The sync message transport module, it is used to the sync message in source database interface table being transported to purpose data
In bank interface table, the integration across database transmission of sync message is realized；
The purpose database, it is used to carry out parsing landing to the sync message in purpose database interface table, disassembled
Sync message obtains synchrodata, and synchrodata is fallen into corresponding data table.
The beneficial effects of the invention are as follows：This invention simplifies the process step of integration across database data syn-chronization, eliminate to each
The operation respectively of individual database, reduces the input of system maintenance personnel；Reduce the number of times for writing SQL scripts, automatic assembling
Message and then purpose database is sent to, then is parsed by purpose database, greatly reduce the risk for artificially performing and bringing,
Reduce error rate and cost consumption.
On the basis of above-mentioned technical proposal, the present invention can also do following improvement.
Further, the source database includes SQL request receiving module, SQL request authentication module, sync message generation mould
Block and sync message sending module；
The SQL request receiving module, it is used to receive SQL request and parsed, the SQL request of parsing is sent to
SQL request authentication module；
Told SQL request authentication module, is stored with allocation list, for being verified to SQL request, is verified then
Synchronizing information is obtained, corresponding source database interface table information is obtained according to synchronizing information；
The sync message generation module, its SQL format string being used to disassemble in SQL request, according to the SQL forms disassembled
The respective field splicing generation sync message of string traversal tables of data to be synchronized, is sent to sync message by sync message and sends mould
Block；
The sync message sending module, it is used to sync message is inserted into corresponding source database according to synchronizing information
In interface table.
Further, the purpose database disassembles module and synchrodata including sync message receiving module, sync message
Insert module；
The sync message receiving module, it is used to the sync message of reception being inserted into purpose database interface table；
The sync message disassembles module, and its sync message for being used to disassembling reception obtains synchrodata, and by same step number
Module is inserted according to synchrodata is sent to；
The synchrodata inserts module, and it is used to the synchrodata of acquisition being inserted into purpose database and source database
In corresponding tables of data.
Another technical scheme that the present invention solves above-mentioned technical problem is as follows：A kind of integration across database method of data synchronization, bag
Include following steps：
Step 1, write SQL request and be sent to source database；
Step 2, source database receives and parses through SQL request, and then verifies SQL request according to allocation list, is verified then
Synchronizing information is obtained, corresponding source database interface table information is obtained according to synchronizing information；
Step 3, tables of data respective field splicing generation sync message to be synchronized is traveled through, sync message is passed through into synchronous report
Literary transport module is sent to corresponding purpose database；
Step 4, the sync message that purpose connection is received carries out parsing landing, disassembles sync message and obtains same step number
According to synchrodata is fallen into corresponding data table.
On the basis of above-mentioned technical proposal, the present invention can also do following improvement.
Further, the synchronizing information includes tables of data to be synchronized and purpose database.
Further, the step 2 is implemented as：
Step 21, source database receives SQL request and parsed；
Step 22, inquire about tables of data to be synchronized according to allocation list whether there is, if there is step 23 is performed, otherwise exist
Report an error record in daily record, modification SQL request file return to step 21；
Step 23, corresponding source database interface table is searched according to synchronizing information, finds source database interface table and then hold
Row step 3, is otherwise recorded in the daily record that reports an error, modification SQL request file return to step 21.
Further, the step 3 is implemented as：
Step 31, the SQL format strings in SQL request are disassembled, tables of data to be synchronized is traveled through according to the SQL format strings disassembled
Respective field, splicing generation sync message；
Step 32, the sync message of splicing is inserted into source database interface table according to synchronizing information；
Step 33, sync message is transported to by purpose database from source database interface table by sync message transport module
In interface table.
Further, the step 4 is implemented as：
Step 41, the sync message of reception is inserted into purpose database interface table；
Step 42, the sync message for disassembling reception obtains synchrodata；
Step 43, the synchrodata of acquisition is inserted into the purpose database tables of data corresponding with source database.
Brief description of the drawings
Fig. 1 is a kind of integration across database data synchronous system block diagram of the present invention；
Fig. 2 is a kind of integration across database method of data synchronization flow chart of the present invention；
Fig. 3 implements flow chart for step 2 of the present invention；
Fig. 4 implements flow chart for step 3 of the present invention；
Fig. 5 implements flow chart for step 4 of the present invention；
Fig. 6 is data syn-chronization scheme schematic diagram between CRM storehouses, BOSS storehouses and memory bank in the prior art；
Fig. 7 is to realize data syn-chronization scheme schematic diagram between CRM storehouses, BOSS storehouses and memory bank using the present invention.
In accompanying drawing, the list of parts representated by each label is as follows：
100th, source database, 200, sync message transport module, 300, purpose database, 101, SQL request receiving module,
102nd, SQL request authentication module, 103, sync message generation module, 104, sync message sending module, 301, sync message connects
Receive module, 302, sync message disassemble module, 303 synchrodatas insertion module.
Embodiment
The principle and feature of the present invention are described below in conjunction with accompanying drawing, the given examples are served only to explain the present invention, and
It is non-to be used to limit the scope of the present invention.
As shown in figure 1, a kind of integration across database data synchronous system, including source database 100, sync message transport module
200 and purpose database 300；The source database 100, it is used to verify SQL request using allocation list, and the SQL request is used
The operation of processing such as (including) increasing, delete, changing, synchronizing information and source are obtained according to SQL request in being made an amendment to source database data
Database interface table information, traversal tables of data respective field splicing to be synchronized, which generates sync message and is inserted into source database, to be connect
In oral thermometer；The sync message transport module 200, it is used to the sync message in source database interface table being transported to purpose number
Transmitted according to the integration across database in bank interface table, realizing sync message；The purpose database 300, it is used for purpose database
Sync message in interface table carries out parsing landing, disassembles sync message and obtains synchrodata, synchrodata is fallen into respective counts
According in table.
Wherein, the source database 100 include SQL request receiving module 101, it is SQL request authentication module 102, same
Walk message generation module 103 and sync message sending module 104；The SQL request receiving module 101, it is used to receiving SQL please
Ask and parsed, the SQL request of parsing is sent to SQL request authentication module 102；Told SQL request authentication module 102,
Allocation list is stored with, for being verified to SQL request, is verified, obtains synchronizing information, obtained according to synchronizing information
Take corresponding source database interface table information；The sync message generation module 103, its SQL lattice being used to disassemble in SQL request
Formula string, the respective field splicing generation sync message of tables of data to be synchronized is traveled through according to the SQL format strings disassembled, by synchronous report
Text is sent to sync message sending module 104；The sync message sending module 104, it is used for will be synchronous according to synchronizing information
Message is inserted into corresponding source database interface table.The authentication module checks table name, word according to allocation list and SQL request
Section, whether major key etc. is correct.
The purpose database 300 includes sync message receiving module 301, sync message and disassembles module 302 and same step number
According to insertion module 303；The sync message receiving module 301, it is used to the sync message of reception being inserted into purpose database
In interface table；The sync message disassembles module 302, and its sync message for being used to disassemble reception obtains synchrodata, and will be same
Step data is sent to synchrodata insertion module 303；The synchrodata inserts module 303, and it is used for the same step number of acquisition
In the tables of data corresponding with source database according to purpose database is inserted into.It can splice history lists while sync message is generated
Message.
As shown in Fig. 2 a kind of integration across database method of data synchronization, comprises the following steps：
Step 1, write SQL request and be sent to source database；
Step 2, source database receives and parses through SQL request, and then verifies SQL request according to allocation list, is verified then
Synchronizing information is obtained, corresponding source database interface table information is obtained according to synchronizing information；
Step 3, tables of data respective field splicing generation sync message to be synchronized is traveled through, sync message is passed through into synchronous report
Literary transport module is sent to corresponding purpose database；
Step 4, the sync message that purpose connection is received carries out parsing landing, disassembles sync message and obtains same step number
According to synchrodata is fallen into corresponding data table.
Wherein, the synchronizing information includes tables of data to be synchronized and purpose database.
As shown in figure 3, the step 2 is implemented as：
Step 21, source database receives SQL request and parsed；
Step 22, inquire about tables of data to be synchronized according to allocation list whether there is, if there is step 23 is performed, otherwise exist
Report an error record in daily record, modification SQL request file return to step 21；
Step 23, corresponding source database interface table is searched according to synchronizing information, finds source database interface table and then hold
Row step 3, is otherwise recorded in the daily record that reports an error, modification SQL request file return to step 21.
As shown in figure 4, the step 3 is implemented as：
Step 31, the SQL format strings in SQL request are disassembled, tables of data to be synchronized is traveled through according to the SQL format strings disassembled
Respective field, splicing generation sync message；
Step 32, the sync message of splicing is inserted into source database interface table according to synchronizing information；
Step 33, sync message is transported to by purpose database from source database interface table by sync message transport module
In interface table.
As shown in figure 5, the step 4 is implemented as：
Step 41, the sync message of reception is inserted into purpose database interface table；
Step 42, the sync message for disassembling reception obtains synchrodata；
Step 43, the synchrodata of acquisition is inserted into the purpose database tables of data corresponding with source database.
The present invention is applied into, attendant without two storehouse different with the data in BOSS storehouses from the CRM storehouses of telecommunication system
Script file is all write, only needs CRM storehouses attendant to write the response data in script file, modification CRM storehouses, CRM storehouses are automatic
Synchronizing information is obtained, by synchrodata automatic synchronization to BOSS storehouses.And memory database is then according to the synchronous increasing of BOSS physical libraries
Measure data and carry out automatic conversion, be inserted into memory database and data syn-chronization can be achieved to memory bank.
In the present embodiment, the SQL format strings of SQL request, table name ##s of mode of operation (I/U/D) ## without point table number is carried
Divide history table name ##sql sentences of the table name ## with point table number of table number.In input SQL format strings, operation CRM data is synchronously sent out
Send after program, by query configuration table, combination needs synchronous tables of data and synchronous purpose database, according to these information
Judge the interface table name for needing to insert.After sync message is combined, insert in corresponding interface table.
UR_CBAINTERFACE_INFO (CRM storehouses are synchronized to the interface table in BOSSA storehouses)
UR_CBBINTERFACE_INFO (CRM storehouses are synchronized to the interface table in BOSSB storehouses)
Newly-increased operation needs configuration BS_BUSIREVERSAL_DICT to control which table to need synchronization, if newly-built
Table, then also need to configure the row of OR_TABCOLUMNS_INFO allocation lists, and major key.
BS_BUSIREVERSAL_DICT is introduced：
It is to need to be synchronized to BOSS which table the table configures mainly according to OP_CODE and SYNCH_FLAG, is passed through
SYNCH_FLAG first judgement, if 1, then needs to be synchronized to BOSS, if 0, then need not be synchronized to BOSS.
With the continuous extension of telecommunication service, there is multiple services decoupling, for example, marketed in real time through point in real time,
Policy control, resource, form, boss etc. is required for the information for some business that crm accepts, therefore synchronization program supports horizontal
To extension, newly-increased object library data syn-chronization is realized in synchronous configuration.
OP_CODE represents the type of service that user handles, for example：Open an account, cancellation, order quits the subscription of rate etc..
SYNCH_FLAG has 14 at present, and each represents an object library, can support extension.Synchronization program passes through
OP_CODE inquires the corresponding SYNCH_FLAG fields of table name, and traveling through the field and obtaining needs which synchronous object library.
For example：01011000000110 represents to need synchronous five object libraries.
When traveling through sync id position, if it is 1 to encounter second, OR_INTERFACETABLENAME_ will be searched
RD tables, take out TABLE_NAME row, exactly need synchronous interface table.
OR_INTERFACETABLENAME_RD literary name section explanations：
SERI_NO correspondences SYNCH_FLAG represents which position of position；
DATABASE_NAME represents target data library name；
TABLE_NAME represents interface table name；
TABLE_TYPE 0：Interface table is represented, 1 represents successfully history lists, and 2 represent failure history lists.
When the data of sync cap table are to object library, if can successfully recorded successfully ephemeris, it can unsuccessfully recorded
Failure table.
OR_TABCOLUMNS_INFO is introduced：
The table stores the field of synchronization entity, and type, major key information increases table newly if necessary to synchronous, it is necessary to configure this
The row and major key of table.In data synchronization process, the field of entity is all obtained from the table, if table does not have major key, then program is straight
Connect throw exception.
The foregoing is only presently preferred embodiments of the present invention, be not intended to limit the invention, it is all the present invention spirit and
Within principle, any modification, equivalent substitution and improvements made etc. should be included in the scope of the protection.
Claims (6)
1. a kind of integration across database data synchronous system, it is characterised in that including source database, sync message transport module and purpose
Database；
The source database, it is used to verify SQL request using allocation list, and synchronizing information and source data are obtained according to SQL request
Bank interface table information, travels through tables of data respective field to be synchronized, and splicing generation sync message is simultaneously inserted into source database interface
In table；
The sync message transport module, it, which is used to the sync message in source database interface table being transported to purpose database, connects
In oral thermometer, the integration across database transmission of sync message is realized；
The purpose database, it is used to carry out parsing landing to the sync message in purpose database interface table, disassembles synchronization
Receive message synchrodata, synchrodata is fallen into corresponding data table；
The source database includes SQL request receiving module, SQL request authentication module, sync message generation module and synchronous report
Literary sending module；
The SQL request receiving module, it is used to receive SQL request and parsed, and the SQL request of parsing is sent into SQL
Requests verification module；
Told SQL request authentication module, is stored with allocation list, for being verified to SQL request, is verified, obtains
Synchronizing information, corresponding source database interface table information is obtained according to synchronizing information；
The sync message generation module, its SQL format string being used to disassemble in SQL request, according to the SQL format strings time disassembled
The respective field of tables of data to be synchronized is gone through, sync message is sent to sync message sending module by splicing generation sync message；
The sync message sending module, it is used to sync message is inserted into corresponding source database interface according to synchronizing information
In table.
2. a kind of integration across database data synchronous system according to claim 1, it is characterised in that the synchronizing information includes treating
Synchronous tables of data and purpose database.
3. a kind of integration across database data synchronous system according to claim 1, it is characterised in that the purpose database includes
Sync message receiving module, sync message disassemble module and synchrodata insertion module；
The sync message receiving module, it is used to the sync message of reception being inserted into purpose database interface table；
The sync message disassembles module, and its sync message for being used to disassemble reception obtains synchrodata, and synchrodata is sent out
Give synchrodata insertion module；
The synchrodata inserts module, and it is used to the synchrodata of acquisition being inserted into purpose database relative with source database
In the tables of data answered.
4. a kind of integration across database method of data synchronization, it is characterised in that comprise the following steps：
Step 1, write SQL request and be sent to source database；
Step 2, source database receives and parses through SQL request, and then verifies SQL request according to allocation list, is verified, obtains
Synchronizing information, corresponding source database interface table information is obtained according to synchronizing information；
Step 3, tables of data respective field splicing generation sync message to be synchronized is traveled through, sync message is passed by sync message
Defeated module is sent to corresponding purpose database；
Step 4, the sync message that purpose connection is received carries out parsing landing, disassembles sync message and obtains synchrodata, will
Synchrodata is fallen into corresponding data table；
The step 2 is implemented as：
Step 21, source database receives SQL request and parsed；
Step 22, inquire about tables of data to be synchronized according to allocation list whether there is, if there is step 23 is performed, otherwise reporting an error
Recorded in daily record, modification SQL request file return to step 21；
Step 23, corresponding source database interface table is searched according to synchronizing information, finds source database interface table and then perform step
Rapid 3, otherwise recorded in the daily record that reports an error, modification SQL request file return to step 21；
The step 3 is implemented as：
Step 31, the SQL format strings in SQL request are disassembled, the phase of tables of data to be synchronized is traveled through according to the SQL format strings disassembled
Answer field, splicing generation sync message；
Step 32, the sync message of splicing is inserted into source database interface table according to synchronizing information；
Step 33, sync message is transported to by purpose database interface from source database interface table by sync message transport module
In table.
5. a kind of integration across database method of data synchronization according to claim 4, it is characterised in that the synchronizing information includes treating
Synchronous tables of data and purpose database.
6. a kind of integration across database method of data synchronization according to claim 4, it is characterised in that the specific reality of the step 4
It is now：
Step 41, the sync message of reception is inserted into purpose database interface table；
Step 42, the sync message for disassembling reception obtains synchrodata；
Step 43, the synchrodata of acquisition is inserted into the purpose database tables of data corresponding with source database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410594738.5A CN104317921B (en) | 2014-10-29 | 2014-10-29 | A kind of integration across database data synchronous system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410594738.5A CN104317921B (en) | 2014-10-29 | 2014-10-29 | A kind of integration across database data synchronous system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104317921A CN104317921A (en) | 2015-01-28 |
| CN104317921B true CN104317921B (en) | 2017-10-17 |
Family
ID=52373153
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410594738.5A Active CN104317921B (en) | 2014-10-29 | 2014-10-29 | A kind of integration across database data synchronous system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104317921B (en) |
Families Citing this family (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105117441A (en) * | 2015-08-11 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Data work order processing method and system |
| CN105187682A (en) * | 2015-08-11 | 2015-12-23 | 北京思特奇信息技术股份有限公司 | Batch data processing method and system |
| CN107689949B (en) * | 2017-03-31 | 2020-03-17 | 平安科技（深圳）有限公司 | Database authority management method and system |
| CN107679232A (en) * | 2017-10-24 | 2018-02-09 | 安徽马钢自动化信息技术有限公司 | A kind of synchronous method of SAP HANA source databases and other databases |
| CN110807037B (en) * | 2018-08-03 | 2022-09-27 | 中国移动通信集团广东有限公司 | Data modification method and device, electronic equipment and storage medium |
| CN109614440A (en) * | 2018-10-25 | 2019-04-12 | 深圳壹账通智能科技有限公司 | Method of data synchronization and relevant device based on big data |
| CN109829016B (en) * | 2019-01-25 | 2021-06-01 | 网宿科技股份有限公司 | Data synchronization method and device |
| CN109933630B (en) * | 2019-03-19 | 2021-11-23 | 武汉达梦数据库股份有限公司 | Real-time database data synchronization method and device |
| CN111831755B (en) * | 2020-07-23 | 2024-01-16 | 北京思特奇信息技术股份有限公司 | Cross-database data synchronization method, system, medium and device |
| CN112306994A (en) * | 2020-11-10 | 2021-02-02 | 北京沃东天骏信息技术有限公司 | Database data migration method and device and storage medium |
| CN113326316A (en) * | 2021-04-14 | 2021-08-31 | 深圳新贝奥数字科技有限公司 | Rapid data synchronization method for heterogeneous system |
| CN114077601A (en) * | 2021-11-26 | 2022-02-22 | 山东福生佳信科技股份有限公司 | Operation method of data synchronization system suitable for different databases |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102387213A (en) * | 2011-10-25 | 2012-03-21 | 中兴通讯股份有限公司 | Data synchronization method and device |
| CN102970373A (en) * | 2012-12-03 | 2013-03-13 | 亚信联创科技（中国）有限公司 | Data synchronization method, device and system |
| CN103067483A (en) * | 2012-12-25 | 2013-04-24 | 广东邮电职业技术学院 | Remote data increment synchronization method and device based on data package |
| CN103136231A (en) * | 2011-11-25 | 2013-06-05 | 中国移动通信集团江苏有限公司 | Data synchronization method and system for heterogeneous databases |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050149582A1 (en) * | 2003-12-29 | 2005-07-07 | Wissmann Joseph T. | Method and system for synchronization of copies of a database |
-
2014
- 2014-10-29 CN CN201410594738.5A patent/CN104317921B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102387213A (en) * | 2011-10-25 | 2012-03-21 | 中兴通讯股份有限公司 | Data synchronization method and device |
| CN103136231A (en) * | 2011-11-25 | 2013-06-05 | 中国移动通信集团江苏有限公司 | Data synchronization method and system for heterogeneous databases |
| CN102970373A (en) * | 2012-12-03 | 2013-03-13 | 亚信联创科技（中国）有限公司 | Data synchronization method, device and system |
| CN103067483A (en) * | 2012-12-25 | 2013-04-24 | 广东邮电职业技术学院 | Remote data increment synchronization method and device based on data package |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104317921A (en) | 2015-01-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104317921B (en) | A kind of integration across database data synchronous system and method | |
| AU2020201652B2 (en) | Method and system for blockchain variant using digital signatures | |
| US11663090B2 (en) | Method and system for desynchronization recovery for permissioned blockchains using bloom filters | |
| CN114944932B (en) | Method and system for adding blocks to licensed blockchains | |
| CN111181946A (en) | Credible traceability system and method based on block chain and Internet of things | |
| CN111031036A (en) | Block chain-based vaccine information monitoring method and device and computer equipment | |
| CN109542865A (en) | Distributed cluster system configuration file synchronous method, device, system and medium | |
| CN106097058A (en) | E-commerce platform heterogeneous data processing method and system | |
| CN111667368B (en) | Anti-money laundering monitoring system and method | |
| CN103914526A (en) | Interface method and interface device for SAP ERP (enterprise resource planning) system and ORACLE ERP system | |
| CN105791401B (en) | Client and server-side data interactive method, system under net and off-network state | |
| CN103593384A (en) | Method and system for data transfer optimization through destination analytics and data de-duplication | |
| EP4071697A1 (en) | Data management system, management method, and management program | |
| CN107844588A (en) | A kind of processing method of data dictionary, device, storage medium and processor | |
| CN104301149A (en) | Multi-data-center permission management method and system | |
| KR101954304B1 (en) | Method for tracking and tracing distribution route of tobacco, and tobacco tracking and tracing server using the same | |
| CN104298761A (en) | Implementation method for master data matching between heterogeneous software systems | |
| CN106454767A (en) | Business data synchronization method, device and system | |
| CN106453213B (en) | Call method and device between a kind of system | |
| CN109607341A (en) | Elevator operation information management system based on block chain | |
| CN110083501A (en) | Interface calls method of counting and device | |
| US8561132B2 (en) | Access control apparatus, information management apparatus, and access control method | |
| WO2014172564A1 (en) | Synchronized resource planning | |
| CN109558417B (en) | Data processing method and system | |
| WO2016058462A1 (en) | Method and system for configuring extensible cross-network element service |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |