Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Distributed database backup method, device and system

A technology for backing up systems and databases, applied in the computer field, can solve the problems of scattered backup result files, unfavorable full database backup recovery, long processing time, etc., and achieves the effect of facilitating backup recovery and reducing backup time.

Pending Publication Date: 2020-09-11
BANK OF CHINA
View PDF3 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

like figure 1 as shown, figure 1 It is a schematic flow chart of the distributed database backup method in the prior art provided in the embodiment of the present invention. Due to the batch application of nodes, the backup operations of each database node need to be executed sequentially in a serial manner, resulting in a long processing time; the backup result file Scattered in each database node is not conducive to the backup and recovery of the whole database

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
  • Distributed database backup method, device and system
  • Distributed database backup method, device and system
  • Distributed database backup method, device and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, the embodiments of the present invention will be further described in detail below in conjunction with the accompanying drawings. Here, the exemplary embodiments and descriptions of the present invention are used to explain the present invention, but not to limit the present invention.

[0028] Embodiments of the present invention relate to the following nouns, which are explained as follows:

[0029] Oracle data pump backup technology: Oracle database supports data pump backup and recovery methods, combined with the import and export commands of EXPDP and IMPDP, exporting a single database node backup file by EXPDP, and supporting rich configuration backups, including by user, by table name, According to table space, query conditions, and full database backup, the backup results are stored in the form of DMP (Data Management Platform, data management...

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 discloses a distributed database backup method, device and system, and the system comprises a main node unit which is used for generating a plurality of node database backup commands according to a preset database sub-database sub-table; wherein each node database backup command is used for indicating a data sub-table needing to be backed up of the corresponding node database; and each sub-node backup module is used for backing up the data sub-tables needing to be backed up of the corresponding node database according to the corresponding node database backup command, generatinga backup file and copying the backup file to the shared storage server. According to the invention, the node database can perform backup operation at the same time; the situation that the backup tasksneed to be processed by batch application nodes in series is avoided, the backup duration of the distributed database can be shortened, compared with the prior art, the batch application nodes do notneed to be set to execute the backup tasks in series, database backup files can be stored in a centralized mode through shared storage, and backup recovery of the whole database is facilitated.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a distributed database backup method, device and system. Background technique [0002] This section is intended to provide a background or context to embodiments of the invention that are recited in the claims. The descriptions herein are not admitted to be prior art by inclusion in this section. [0003] With the explosive growth of data volume in enterprise-level applications, the single-node centralized database of the traditional online transaction processing system can no longer meet the performance requirements of online transaction processing and high concurrent user access under large data volumes. Therefore, the existing technology Gradually develop and utilize data sharding technology (a method that divides a table with a large amount of data into multiple parts and puts them in different databases to alleviate the performance problem of a single database. Ve...

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): G06F11/14G06F16/27
CPCG06F11/1448G06F16/27G06F16/278G06F2201/80
Inventor 李清泉周宝琛陈明芬
Owner BANK OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com