Unlock instant, AI-driven research and patent intelligence for your innovation.

Data synchronous method and device based on SQL

A data synchronization and data technology, applied in the field of data processing, can solve problems in the system, the system cannot run normally, affect the scalability of the system, etc., and achieve the effect of convenient maintenance

Active Publication Date: 2007-07-18
HUAWEI TECH CO LTD
View PDF0 Cites 30 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] Although data synchronization can be performed through the configuration file, the information in the configuration file is the database connection information, and the data synchronization operation statement still needs to be hard-coded to achieve; and because the interface of the external system is called in the code, when the external system When the interface of the system is changed, it will cause problems in the system. For example, the external interface originally called in the code is receiving. For example, after the external system interface changes, it becomes sending.
However, the original code has not been modified, which will cause the system to malfunction
Moreover, when a new application system wants to be notified of database operations, the code also needs to be modified, which affects the scalability of the system

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
  • Data synchronous method and device based on SQL
  • Data synchronous method and device based on SQL
  • Data synchronous method and device based on SQL

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0027] With reference to the flow process of the first embodiment of the method of the present invention shown in Fig. 1, this embodiment comprises the following steps:

[0028] Step 101: Establish data association synchronization rules.

[0029] The data association synchronization rule includes: a database information table and a set of operation information related to the database. Wherein, the database information table includes at least the database name and the database address; the operation information set includes at least the main database information and the trigger information list corresponding to the main database, and the trigger information list includes at least the operation information set label, the synchronization database name library, Synchronous operation type.

[0030] The information in the operation information set can be organized by adopting SQL structure, and a named SQL is determined for each operation information set.

[0031] For example, to ...

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

A method for synchronizing data based on SQL includes setting up data correlation synchronization rule, carrying out operation on data in master databank according to said rule and synchronizing operated data into synchronous databank correlated with said data in system according to said rule. The device used for realizing said method is also disclosed.

Description

technical field [0001] The invention relates to data processing technology, in particular to an SQL-based data synchronization method and device. Background technique [0002] In an enterprise, there are many kinds of data, which are usually stored in a database for unified management. At the same time, in order to effectively distinguish these data, put them in different tables of the database. There is a strong relationship between data and data. When a data is modified, the data associated with it must be guaranteed to be modified, that is, to maintain data consistency. How to ensure the consistency of data in different tables is very important for enterprises. In addition, there may be multiple application systems in an enterprise. After an application system performs data operations on the database, it needs to notify the external system of the data operation event. [0003] In general application systems, hard coding is usually used to implement the data that needs ...

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 HUAWEI TECH CO LTD