Data base backup recovery method and device

A recovery method and database technology, applied in the database field, can solve the problem of time-consuming operation and achieve the effect of forward compatibility

Inactive Publication Date: 2010-12-08
ZTE CORP
View PDF3 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0012] The above steps are a very cumbersome process, especially the three steps (4), (5), and (6). In the case of many tables, it is very time-consuming to operate

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
  • Data base backup recovery method and device
  • Data base backup recovery method and device
  • Data base backup recovery method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] Hereinafter, the present invention will be described in detail with reference to the drawings and examples. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other.

[0023] A database usually includes multiple data tables, each data table is composed of multiple columns, and each column has a data structure. Embodiments of the present invention are implemented based on this database.

[0024] figure 2 A flow chart showing a database backup recovery method according to an embodiment of the present invention, including:

[0025] Step S10, backing up the old version database, wherein the table structure of the old version database is saved, such as the table structure information, table data and current version number required for backup in the old version, and saved in the form of a file;

[0026] Step S20, clearing the records of all tables of the new version ...

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 data base backup recovery method and device. The method comprises the following steps of: backing up an older-version data base, wherein storing a table structure of the older-version data base; emptying the records of all tables of a new-version data base, and acquiring a table structure of the new-version data base; comparing the table structure of the older-version data base with the table structure of the new-version data base to determine whether the table structure is changed or not; and recovering the backups of the older-version data base to the new-version data base according to a change type and a corresponding preset strategy. The invention realizes the forward compatibility of data base backups recovery.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and device for backing up and restoring a database. Background technique [0002] In the prior art, the database structure design (including table structure and data content) often changes with the change of functional modules, and the differences between versions may be relatively large. Due to the incompatibility of table structure and data content between the new version and the old version, when the existing database is backed up and restored, it is impossible to restore the backed up old version database to the new version database whose database structure design has changed. [0003] figure 1 Shown is a flow chart of a database backup and recovery method in the prior art, and the usual processing flow is as follows: [0004] (1) Start the old version database; [0005] (2) start the new version database; [0006] (3) Empty the records of all tables in the new version d...

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): G06F17/30
CPCG06F17/30569G06F11/1469G06F2201/80G06F11/1448G06F16/258G06F17/00
Inventor 龙涛
Owner ZTE CORP
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