Step-by-step database synchronization method with autoincrement identifications

A database and self-incrementing technology, applied in database distribution/replication, electronic digital data processing, structured data retrieval, etc., can solve problems such as table uniqueness constraints, self-incrementing identification consistency problems, multi-source data updates, etc.

Active Publication Date: 2015-04-29
JIANGNAN INST OF COMPUTING TECH
View PDF3 Cites 33 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0010] The technical problem to be solved by the present invention is to provide a step-by-step database synchronization technology with self-increment marks to solve the self-increment marks encountered in the asynchronous update process of the step-by-step database in view of the above-mentioned defects in the prior art Consistency issues, unique constraints on tables, and multi-source data update issues

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
  • Step-by-step database synchronization method with autoincrement identifications
  • Step-by-step database synchronization method with autoincrement identifications
  • Step-by-step database synchronization method with autoincrement identifications

Examples

Experimental program
Comparison scheme
Effect test

specific example 1

[0067] Taking a distributed database for project management as an example, the business data is centered on the project data table, and each business data table has a direct or multi-table cascaded relationship with the project data table. The business data of the central database and the site database The table structure is the same, and the process of distributing all business data of a project from the central database to the site database is as follows: image 3 As shown, the specific steps are as follows.

[0068] 1) Obtain the basic structure information of the central database. The basic structure information of the database includes information such as database type, table structure, column information of the table, primary key and foreign key of the table.

[0069] 2) According to the basic structural information of the central database, the business data table association relationship is established. The most important content in the association relationship of dat...

specific example 2

[0080] Taking a distributed database for project management as an example, the business data is centered on the project data table, and each business data table has a direct or multi-table cascaded relationship with the project data table. The business data of the central database and the site database The table structure is different. The process of uploading all business data of a project from the central database to the site database is as follows: Figure 4 As shown, the specific steps are as follows.

[0081] 1) Obtain the basic structure information of the site database. The basic structure information of the database includes information such as database type, table structure, column information of the table, primary key and foreign key of the table.

[0082] 2) According to the basic structural information of the site database, the business data table association relationship is established. The most important content in the association relationship of data tables is...

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

Disclosed is a step-by-step database synchronization method with autoincrement identifications. The method includes the steps: firstly, analyzing a business data table to be exported out of a first database so as to acquire a table structure and association, wherein the first database is one of a central database and a site database; secondly, acquiring a business correlated data set according to the table structure and association acquired in the first step; thirdly, analyzing a business data table to be imported into a second database so as to acquire a table structure and association, wherein the second database is the other one of the central database and the site database; fourthly, analyzing the business data table structure and association acquired in the first step, analyzing the business data table structure and association acquired in the third step, combining the business correlated data set acquired in the second step, determining an import sequence of business data, and controlling the business data to be sequentially imported according to the import sequence of the business data.

Description

technical field [0001] The invention relates to a step-by-step database synchronization method with an auto-increment mark. Background technique [0002] With the increasing scale and regionalization of information systems, the role of data bridges played by distributed databases in information systems is becoming more and more important, and the design of distributed databases is widely used in systems. However, due to the system's own characteristics and different requirements for the system, there are still many problems to be studied and solved in the process of designing a distributed database system. One of the most important issues is how to ensure the data synchronization of the distributed database to ensure the consistency and security of the entire system data. [0003] In distributed database systems, data replication technology is widely used for data replication and transmission, so as to achieve the purpose of data synchronization. Almost all large-scale dat...

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
CPCG06F16/27
Inventor 吴利何曼贾家涛韩爱芳
Owner JIANGNAN INST OF COMPUTING TECH
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