Database cluster difference comparison and data synchronization method and system and medium

A data synchronization and database technology, applied in the direction of database management system, database indexing, database updating, etc., can solve the problem of fast and comprehensive flow of information, inconsistency of database data, reduce the cooperation efficiency of cascade database information system and the utilization rate of information, etc. problems, to achieve the effect of solving foreign key conflicts and ensuring convenience

Active Publication Date: 2021-03-30
EAST CHINA INST OF COMPUTING TECH
View PDF8 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If an effective data reporting system is not built, it will be difficult for information to flow quickly and comprehensively among the dedicated databases, and then become an information island, which greatly reduces the cooperation efficiency and information utilization rate between cascaded database information systems, and cannot provide information for information warfare. Provide effective, reliable and timely information support
[0004]The difference in database clusters refers to the fact that users of different nodes of the database modify the data table records in different ways, resulting in inconsistent data in the databases of some nodes

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
  • Database cluster difference comparison and data synchronization method and system and medium
  • Database cluster difference comparison and data synchronization method and system and medium
  • Database cluster difference comparison and data synchronization method and system and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0054] Such as figure 1 The database cluster architecture shown includes the following steps:

[0055] Step 1.1: Database cluster architecture design, including the following:

[0056] The database cluster is designed in a tree structure, and the cluster database in the tree structure has a design of authority, that is, the higher the depth, the higher the node level. It can be seen from the figure that any node has at most one upper-level node, but multiple lower-level nodes are allowed. Obviously, there is data interaction between connected nodes, while unconnected nodes are logically independent of each other, that is, there is no direct interaction.

[0057] Step 1.2: Node database and adjacent node backup database design, including the following:

[0058] Any node not only has its own data, but at the same time, after completing step 3.4, the node generates the records of the adjacent node database as a backup.

[0059] The main problem to be solved in step 1.2 is as ...

specific Embodiment

[0128] Step 5: Database maintenance includes business data maintenance, dictionary data maintenance, data backup and restoration, and log management. Specific examples are as follows:

[0129] Step 5.1: Business data maintenance, including providing the function of collaborative maintenance of business data according to the assigned data authority, and supporting data maintenance operations such as adding, deleting, editing, and querying various business data according to the assigned authority.

[0130] Step 5.2: dictionary data maintenance, including the following steps:

[0131] (1) Tree-shaped dictionary data maintenance: tree-shaped dictionary data maintenance provides editing and processing functions for tree-shaped dictionary data such as troop sequence lists and equipment sequence lists, supports displaying data in table form, and supports the function of querying information on nodes and their direct subordinate nodes .

[0132] (2) Special dictionary data maintenan...

Embodiment 2

[0151] The invention provides a data standard upgrade method for naval combat data application database, based on the original client / server (C / S) application software, without changing the design structure of the original data table , upgraded to browser / server (B / S), multi-user and multi-node web application software to solve the maintenance and management of dedicated databases under various business needs and cross-regional cascading databases under the conditions of military dedicated networks Data reporting issues, including the following steps:

[0152] 1) Adopt multi-layer system B / S structure. Follow the SOA system, adopt standardized software design of components, and couple and integrate each sub-project;

[0153] 2) Provide data maintenance function, support business data maintenance, dictionary data maintenance;

[0154] 3) Support dynamic generation of business data maintenance pages, support graphical and drag-and-drop mode for node level editing, support node...

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 database cluster difference comparison and data synchronization method and system and a medium. The method comprises the steps that 1, constructing a database cluster, a nodedatabase and an adjacent node backup library; 2, grouping tables in the database, enabling each group of tables to have a foreign key connection relationship, enabling fields of the tables in the groups to depend on each other, selecting the groups which need to be compared and synchronized, and generating corresponding data tables; 3, establishing an initial backup point for the submitted data table, storing the initial backup point in a backup library and a database to serve as an initial comparison benchmark for comparison, and obtaining a data increment; 4, synchronously reporting the database, and when the reported data is sent to the sender node, comparing the management website and verifying the synchronous data, and then selecting agreement or rejection; and 5, maintaining the database, including business data maintenance, dictionary data maintenance, data backup and restoration and log management.

Description

technical field [0001] The invention relates to the technical field of databases and the Internet, in particular to a method, system and medium for database cluster difference comparison and data synchronization. Background technique [0002] A database is "a warehouse that organizes, stores and manages data according to its data structure". It is a long-term storage in the computer, organized, shareable, and unified management of a large amount of data collection, users can add, query, update, delete and other operations on the data in the file. Nowadays, with the surge in the number of people surfing the Internet, in order to adapt to the rapid growth of concurrent visits to the server requested by users in the era of big data, some large websites have begun to use database clusters to improve the reliability of the database and the concurrent processing capabilities of the database. Database cluster, as the name implies, is to use at least two or more database servers to...

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): G06F16/22G06F16/27G06F16/23G06F16/21G06F16/25G06F11/14
CPCG06F16/2282G06F16/27G06F16/2358G06F16/219G06F16/252G06F11/1448
Inventor 王智铎赵慧高士连陈春波
Owner EAST CHINA 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