Cross-database data synchronizing system and method

A data synchronization and database technology, applied in the database field, can solve problems such as consumption costs, and achieve the effect of reducing investment, reducing risks, and reducing times

Active Publication Date: 2015-01-28
北京思特奇信息技术股份有限公司
View PDF5 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Even if the above processing method is a very simple problem, the maintenance personnel of the two systems need to write the script file twice or three times, and execute it in the three databases respectively to achieve the goal, which is very costly

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Cross-database data synchronizing system and method
  • Cross-database data synchronizing system and method
  • Cross-database data synchronizing system and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0051] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0052] Such as figure 1 As shown, a cross-database data synchronization system includes a source database 100, a synchronization message transmission module 200, and a destination database 300; the source database 100 is used to verify an SQL request using a configuration table, and the SQL request is used for Modify the source database data (including adding, deleting, modifying, etc.), obtain synchronization information and source database interface table information according to the SQL request, traverse the corresponding fields of the data table to be synchronized, generate a synchronization message and insert it into the source database interface In the table; the synchronous message transmission module 200, w...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to a cross-database synchronizing system and method. The system comprises a source database, a synchronization message transmission module and a target database. The method includes: the source database uses a configuration table to verify an SQL request, synchronization information and source database interface table information are acquired according to the SQL request, the corresponding fields of a to-be-synchronized data table are traversed to splice and generate a synchronization message, and the synchronization message is inserted into the source database interface table; the synchronization message transmission module carries the synchronization message in the source database interface table to the interface table of the target database; the target database performs parsing falling on the synchronization message in the interface table of the target database, and data falls into the corresponding data table. By the system and the method, cross-database data synchronization flow steps are simplified, system maintenance staff input is reduced, SQL scripts compiling times are reduced, the message is automatically spliced and transmitted to the target database, the target database parses the message, risks caused by manual execution are reduced greatly, and error rate and cost consumption are lowered.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a cross-database data synchronization system and method. Background technique [0002] At present, telecom companies use the NGBOSS system to realize the business and data decoupling between the CRM system and the BOSS system. Therefore, after the CRM accepts the business, it is necessary to synchronize the corresponding data increment to the BOSS system, so as to realize billing actions such as free tariff donation and monthly rent deduction on the BOSS side. For example: the user goes to the business hall to open an account. The salesperson handles the account opening business in the CRM system and selects a certain package of GSM, and pre-stores a certain amount of phone charges. This business data needs to be recorded in the CRM database first, and then synchronized to the BOSS database for billing. . [0003] In the process of actually handling user complaints and operat...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
CPCG06F16/27G06F16/275
Inventor 王伟
Owner 北京思特奇信息技术股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap