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

A database backup and recovery method and system based on massive data

A technology of massive data and database, applied in the redundant operation of data error detection, electrical digital data processing, special data processing applications, etc., can solve problems such as low efficiency, achieve integrity and security, solve Backup and restore inefficiencies

Active Publication Date: 2016-04-20
QTONE EDUCATION GROUP (GUANGDONG) CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Designed to solve the inefficiency of existing technology backup and recovery solutions when dealing with massive data

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 database backup and recovery method and system based on massive data
  • A database backup and recovery method and system based on massive data
  • A database backup and recovery method and system based on massive data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The present invention provides a database backup and recovery method and system based on massive data. In order to make the purpose, technical solution and effect of the present invention clearer and clearer, the present invention will be further described in detail below. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0035] For the convenience of description, we divide this solution into two parts: database backup and database recovery.

[0036] see figure 1 , which is a flow chart of the database backup method in the massive data-based database backup and recovery method of the present invention. As shown in the figure, the database backup and recovery method based on massive data includes the following steps when performing database backup:

[0037] S1. Create each table partition and partition index on a separate table space, and set the table partition tha...

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 database backup and a recovery method and a system based on mass data. Data in database are exported by a transition table space or table export mode, and then files are filed on a storage medium, so that the problems that a large amount of data backup and recovery efficiency are low and prone to error are fundamentally solved. The database backup and recovery method and the system based on the mass data are successfully applied to actual production environment, by practice proving, processing efficiency is improved by 80% than a traditional backup and traditional recovery method, and meanwhile, integrity and security of the data are well ensured.

Description

technical field [0001] The invention relates to the technical field of database backup and recovery, in particular to a method and system for database backup and recovery based on massive data. Background technique [0002] For Oracle database, traditional database backup and recovery schemes include data export and data hot backup. [0003] 1. Backup data through data export [0004] like figure 1 As shown, it uses the built-in EXP / EXPDP tool to export data to realize data backup, which is suitable for situations where the amount of data is small, the update frequency is low, and the data security requirements are not high. In the recovery method, directly import the object (partition) to be recovered into the database from the exported data. [0005] 2. Database hot backup [0006] This method is more common, such as figure 2 As shown, it requires the database to run in an archive mode, which can be realized through the Rman tool, and incremental backup of data can a...

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/30G06F11/14
Inventor 陈炽昌胡磊高祖辉李如勇卢俊生
Owner QTONE EDUCATION GROUP (GUANGDONG) CO LTD