Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and system for data synchronization between different databases

A data synchronization and database technology, applied in the field of data synchronization between different databases, can solve problems such as database performance impact, complex design, and less source code

Inactive Publication Date: 2016-09-07
北京思特奇信息技术股份有限公司
View PDF4 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The existing database synchronization schemes mainly focus on the following types: first, DBLINK-based level data synchronization requires the establishment of DBLINK in the target database, which is not safe and may easily cause the restart of the linked database to fail; second, log-based synchronization , generally is the hot backup synchronization tool that comes with the ORACLE database, which is a heavyweight solution, the mechanism is too complicated, and has an impact on the performance of both databases; third, the synchronization tool provided by a third party, this type of tool is compatible with a variety of type of database, the design is relatively complicated, and it is also a heavyweight solution; the present invention provides a lightweight database synchronization solution with less source code and less dependence on the system, which has a good application prospect

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
  • Method and system for data synchronization between different databases
  • Method and system for data synchronization between different databases
  • Method and system for data synchronization between different databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0084] Embodiment: The process of Sichuan Radio and Television from the basic domain system synchronization configuration table to the BOSS business domain:

[0085] The project requires the program to have three execution modes:

[0086] 1. For table name synchronization: the applicable scenario is that after the salesperson configures a piece of configuration data, the configuration data must be applied immediately. The operation method is: synTable dblink_src dblink_aim tal e_name; where dblink is the database connection string, and tale_name is the name of the table to be synchronized;

[0087] 2. Synchronization according to the time period: the applicable scenario is that after a salesperson centrally configures a batch of configuration data (involving multiple tables and multiple time periods) within a certain period (such as within a week), it is necessary to synchronize all the tables operated within this week. : synTable dblink_src dblink_aim 7; where 7 is the time i...

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 present invention relates to a method and a system for data synchronization between different databases. The method comprises the steps of S1. reading to-be-synchronized table data in a source database to a first text file, and reading to-be-synchronized table data with the same name in a target database to a second text file; S2. carrying out data comparison between the first text file and the second text file according to a unique indexing manner, so as to obtain a comparison result; S3. carrying out data synchronization on the comparison result so as to obtain a data synchronization result; and S4. outputting the data synchronization result. The present invention provides a scheme for implementing table data synchronization between different ORACLE databases based on the fourth dynamic SQL of an ORACLE PROC language, so that synchronization can be carried out on three dimensions of the time quantum, the total amount and the table name according to production requirements, and can be extended to more processes, in the absence of table information, only knowing the name of the to-be-synchronized table can complete synchronization, and different synchronization logics can be implemented and different business scenarios can be satisfied.

Description

technical field [0001] The invention relates to the field of database synchronization, in particular to a method and system for data synchronization between different databases. Background technique [0002] For large-scale IT systems, global configuration data is often generated in a configuration data management system, and then synchronized to other business systems for use. This type of IT system has the characteristics of complex data models and large data volumes, resulting in many system configuration tables. It is necessary to build a bureau data management system to ensure the accuracy and controllability of configuration data. Data configuration is performed in the bureau data management system, and then synchronized to other business systems. Synchronization requires data accuracy, timeliness, and traceability of the synchronization process sex. [0003] The existing database synchronization schemes mainly focus on the following types: first, DBLINK-based level d...

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/284G06F16/27
Inventor 李波
Owner 北京思特奇信息技术股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com