Method and system for converting or synchronizing databases

A data synchronization and database technology, applied in the computer field, can solve problems such as cumbersome operation and waste of space, and achieve the effect of improving efficiency

Active Publication Date: 2013-02-06
SHENZHEN HONGDIAN TECH CORP
View PDF3 Cites 35 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If the intermediate database mode needs to establish an intermediate database, the operation is cumbersome and wastes space

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 converting or synchronizing databases
  • Method and system for converting or synchronizing databases
  • Method and system for converting or synchronizing databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] Such as figure 1 As shown, the database conversion or synchronization method of an embodiment of the present invention includes the following steps:

[0035] Step S103, read the data conversion and synchronization strategy step: read the data conversion and synchronization strategy set corresponding to the corresponding target data in the configuration file;

[0036] Step S105, open the target database step: poll the target database connection information in the configuration file, and open the target database;

[0037] Step S107, the step of reading the source database: read the data conversion and synchronization strategy, organize according to the data conversion and synchronization strategy to read the SQL statement of the source database, and read the source data from the source database according to the SQL statement of the source database ;

[0038] Step S109, synchronization step: inserting the source data read from the source database into the target database...

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 discloses a method and system for converting or synchronizing databases. The method comprises the following steps of: reading a data conversion and synchronization strategy set corresponding to a target database from a configuration file; polling target database connection information in the configuration file, and opening the target database; reading the synchronization strategy, reading SQL (structured query language) statements in a source database according to the organization of the synchronous strategy, and reading source data from the source database according to the SQL statements; and inserting the data read from the source database into the target database to carry out synchronization. According to the method and system for converting or synchronizing databases, disclosed by the invention, a mode of actively inserting the data stored in the source database and subjected to reading or conversion into the target database is adopted, so that the method and system disclosed by the invention can be applied to a multi-source heterogeneous situation and a situation that the structure of the source database is inconsistent with the structure of the target database, and also can be used under the condition that the source data is in a weak trend status but the target database is in a strong trend status, thereby adapting to different conversion modes; and based on the method or system for synchronizing databases, the structures of the source database and the target database are not destroyed.

Description

technical field [0001] The invention relates to the field of computers, in particular to a database conversion or synchronization method and system. Background technique [0002] Existing computer systems store and maintain data mainly through databases, and each application system obtains data or maintains relevant data by accessing the database. Now all kinds of databases are pouring into the market, free, charged, large and small, such as: MySQL, SQLServer, Oracle, PgSQL and so on. [0003] In order to ensure the consistency of data between application systems, database synchronization is often required. At present, in the field of database synchronization, there are relatively complete methods for database synchronization between similar databases, such as data replication and release of SQL Server. There are also many ways to synchronize heterogeneous databases, such as the unified intermediate database of heterogeneous database data, SQL-based data synchronization of...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 钟静袁源张敬超
Owner SHENZHEN HONGDIAN TECH CORP
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