Automatic data recovery method based on relational database

An automatic repair and database technology, applied in the computer field, can solve problems such as incomplete recovery, database table recovery, backup, and slow recovery.

Inactive Publication Date: 2017-12-26
南京绿领空间健康产业有限公司
View PDF2 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Conventional database backup and recovery technologies usually have the following problems: 1. When the amount of data is large, the backu

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
  • Automatic data recovery method based on relational database
  • Automatic data recovery method based on relational database
  • Automatic data recovery method based on relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0018] A method for automatically repairing data based on a relational database, the method steps are as follows:

[0019] S1: First, replace the existing data file with the data file dumped by the full backup;

[0020] S2: Then start the database;

[0021] S3: Apply the DML statement extracted from the incremental backup to recover the database to the desired point in time; either complete recovery of the database or incomplete recovery of the database based on a certain backup point in time is possible. The undo statement of the database change is recorded in the incremental backup. When a data misoperation occurs, the misoperation table can be quickly restored to the state before the misoperation.

Embodiment 2

[0023] The following uses the linux shell as a template to further describe this embodiment:

[0024]

[0025]

[0026]

[0027]

[0028]

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 an automatic data recovery method based on a relational database. The method comprises the steps of full-amount backup and increment backup, wherein in the full-amount backup step, all data of the database is subjected to memory transfer every time, and the backups of all the data are generated; in the increment backup step, only the data which is updated after full backup on the last time is subjected to memory transfer, and the backups of the data are generated. By means of the method, the database can be completely recovered, moreover, incomplete recovery based on some backup time point can be conducted on the database, and meanwhile, the backup time is greatly shortened.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to an automatic data repair method based on a relational database. Background technique [0002] With the development of society and the advancement of technology, the daily work of enterprises is increasingly dependent on data processing, and the continuity of business systems depends on the stable operation of data centers. However, disasters lie in ambush around the operating environment like dust, and the data center may be operating in an environment full of risks and threats. Once data is lost, it is likely to have a serious impact on the daily work of the enterprise. If the core data is lost, some core functions will be paralyzed, causing immeasurable losses. Therefore, in order to ensure the continuity of business, it is necessary to ensure the high reliability and availability of the data center, and it is necessary to have effective database backup and recovery technolo...

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
IPC IPC(8): G06F11/14
CPCG06F11/1451G06F11/1469
Inventor 张文军黄萌英浩周宇
Owner 南京绿领空间健康产业有限公司
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