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

A distributed database data distribution upload synchronization method

A data distribution and data uploading technology, which is applied in the direction of electrical digital data processing, special data processing applications, transmission systems, etc., can solve problems such as the inability to guarantee unique identification, low efficiency, and the risk of concurrent access

Active Publication Date: 2017-12-12
JIANGNAN INST OF COMPUTING TECH
View PDF6 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

But this method also has corresponding defects: ① Low efficiency, each time the ID value needs to be retrieved from the database by calling the stored procedure
②There are risks in concurrent access, and the unique identification cannot be guaranteed when multiple pieces of data are stored at the same time

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
  • A distributed database data distribution upload synchronization method
  • A distributed database data distribution upload synchronization method
  • A distributed database data distribution upload synchronization 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 distributed database data distribution upload 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 databas...

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 Patents(China)
IPC IPC(8): G06F17/30H04L29/08
CPCG06F16/275H04L67/1095
Inventor 何曼吴利张超容张慧邵玲
Owner JIANGNAN INST OF COMPUTING TECH