Step-by-step database data distribution uploading and synchronizing method

A data distribution and data uploading technology, which is applied in digital data processing, special data processing applications, transmission systems, etc., can solve problems such as self-incremental identification consistency, multi-source data update, table uniqueness constraints, etc.

Active Publication Date: 2015-05-06
JIANGNAN INST OF COMPUTING TECH
View PDF6 Cites 27 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 data distribution uploading and synchronizing method
  • Step-by-step database data distribution uploading and synchronizing method
  • Step-by-step database data distribution uploading and synchronizing method

Examples

Experimental program
Comparison scheme
Effect test

specific example 1

[0070] 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.

[0071] 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.

[0072] 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

[0083] 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.

[0084] 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.

[0085] 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

The invention provides a step-by-step database data distribution uploading and synchronizing method. A step-by-step database system consists of a center database and a plurality of station databases. The step-by-step database data synchronizing method comprises the following steps: data distribution processing and data uploading processing, wherein in the step of the data distribution processing, business data are exported from the center database and imported into the station databases; and in the step of the data uploading processing, the business data are exported from the station databases and imported into the center database.

Description

technical field [0001] The invention relates to a step-by-step database data distribution uploading synchronization method. 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/30H04L29/08
CPCG06F16/275H04L67/1095
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