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

Database recovery method and device

A recovery method and database technology, applied in the database field, can solve the problems of inability to achieve online recovery and time-consuming, and achieve the effects of forward compatibility, less time-consuming, and online recovery.

Inactive Publication Date: 2015-02-25
RUN TECH CO LTD BEIJING
View PDF4 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The present invention is completed in order to solve the above-mentioned deficiencies in the prior art. The purpose of the present invention is to propose a database restoration method and device, which can solve the time-consuming problem that the prior art cannot realize online restoration

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 recovery method and device
  • Database recovery method and device
  • Database recovery method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0039] figure 2 It is a flow chart of the database recovery method provided in the first embodiment. Such as figure 2 As shown, the method includes the following steps:

[0040] Step 210, acquire old version database information, the old version database information includes first data table structure information, data content and version number.

[0041] In this step, the database of the old version can be backed up, and the information of the database of the old version can be saved in the form of files. Wherein, the old version database information represents information such as the structure information and data type of the old version database, the old version database information may include the first data table structure information, data content and version number, and the first data table structure information may be the first database Name, first data table name, first column name, first column length, and first column data type, or a combination of at least two...

Embodiment 2

[0051] image 3 It is a flow chart of the database recovery method provided in the second embodiment. Such as image 3 As shown, the method includes the following steps:

[0052] Step 301, backing up the database of the old version, obtaining the information of the database of the old version, and obtaining the backup file.

[0053] In this step, the backup operation is performed in the old version database, and the first data table structure information, data content and current version number of all data tables in the old version database that need to be backed up are exported as files and put into a separate folder , this folder is a backup file, and the first data table structure information can contain multiple data table structure information, and the first data table structure information can be the first database name, the first data table name, the first column name, Either or a combination of at least two of the length of the first column and the data type of the ...

Embodiment 3

[0077] Figure 4 A structural diagram of the database restoration device provided by Embodiment 3 of the present invention is given. Such as Figure 4 As shown, the device includes:

[0078] The old version database information obtaining module 401 is used to obtain the old version database information, the old version database information includes the first data table structure information, data content and version number.

[0079] In this embodiment, the first data table structure information can be any one or a combination of at least two of the first database name, the first data table name, the first column name, the first column length, and the first column data type .

[0080] The new version database information obtaining module 402 is configured to obtain the new version database information, and the new version database information includes the second data table structure information.

[0081] In this embodiment, the second data table structure information can be...

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 database recovery method and device. The method includes the steps that database information of an old version is obtained; database information of a new version is obtained; whether a data table structure of a database of the old version and a data table structure of a database of the old version are consistent is judged according to first data table structure information and second data table structure information, if the answer is positive, the database of the old version is directly restored in the database of the new version, and if the answer is negative, the next step is executed; according to the first data table structure information and the second data table structure information, a change type of the database of the new version relative to the database of the old version is obtained; according to a preset strategy corresponding to the change type, the database of the old version is directly restored in the database of the new version. By means of the database recovery method and device, forward compatibility of database recovery can be achieved.

Description

technical field [0001] The invention relates to the field of databases, in particular to a database recovery method and device. Background technique [0002] In the prior art, the structural design of the database (including the structure of the data table and the data content) often changes with the change of the functional modules, and the differences between the various versions of the database may be relatively large. After installing or updating a new version of the database, it is necessary to restore the backup of the old version of the database to the new version of the database. [0003] The process flow of the database recovery method in the prior art is as follows: figure 1 shown, including the following steps: [0004] 110. Start the old version database. 120. Start the new version database. 130. Empty the records of all the tables in the database of the new version. 140. Manually determine whether each data table in the old version database and the new vers...

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): G06F17/30
CPCG06F16/219
Inventor 杨威
Owner RUN TECH CO LTD BEIJING
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