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

Data synchronization method for source terminal table of database without major key

A data synchronization and database technology, applied in the database field, can solve the problems of data synchronization failure, unpredictable error, unknown data update or deletion, etc., to achieve the effect of speeding up

Inactive Publication Date: 2012-03-14
HANGZHOU HEZHONG DATA TECH CO LTD
View PDF3 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, if the source table of the database does not contain a primary key during database synchronization, data synchronization to the target database will cause various problems. For example, if there are more than 1 identical records in the table, because the column data are all the same , so the source table updates or deletes one of the data, and the target table will update or delete which piece of data is unknown. These problems will lead to data synchronization failure and unpredictable errors

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] The present invention is further described below in conjunction with specific embodiment, but protection scope of the present invention is not limited thereto:

[0017] A data synchronization method for a source table without a primary key in a database is implemented as follows: as listed in the table below, the source table without a primary key in a database has the following data:

[0018] Age

name

32

Zhangsan

21

Lisi

32

Zhangsan

[0019] Add an identification field Rowid in the source table of the database without a primary key and the target table of the database that needs to be synchronized; store unique identification characters in the identification field of each record in the source table, as listed in the following table;

[0020] Age

name

Rowid

32

Zhangsan

AAABc4AADAAAGLUAAA

21

Lisi

AAABc4AADAAAGLUAAB

32

Zhangsan

AAABc4AADAAAGLU...

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 the field of databases, in particular to a data synchronization method for a source terminal table of a database without a major key. By adopting a unique identification character of a database table to carry out the assistant synchronous data transmission, the method solves the problem of failed synchronization on the target terminal, caused by incapability of location on the target terminal table due to updating and deleting operations on the rows of the source terminals with the same content in the data synchronization process when the conventional source terminal table of the database has no major key, meanwhile, the data synchronization speed is accelerated. The invention is easy and feasible, suitable for the synchronization operation of all kinds of databases, and capable of solving the problems in the prior art.

Description

technical field [0001] The invention relates to the field of databases, in particular to a data synchronization method for a source table without a primary key in a database. Background technique [0002] Database synchronization is a technology that synchronizes a set of data from the data source to one or more target ends, so that the data at all target ends is consistent with the data at the source end. It can ensure that the data in databases distributed in different locations are automatically updated synchronously, thereby Ensure data consistency between the source database and the target database. However, if the source table of the database does not contain a primary key during database synchronization, data synchronization to the target database will cause various problems. For example, if there are more than 1 identical records in the table, because the column data are all the same , so if one of the data is updated or deleted in the source table, it is unknown wh...

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
Inventor 杨波周弘懿
Owner HANGZHOU HEZHONG DATA TECH CO LTD