Data recovery method based on large database

Abstract

The invention discloses a data recovery method based on a large database. The data recovery method comprises the following steps that S1, a database backup or a database design document is found out; S2, a data table needing data recovery is found; S3, the logical structure relation of records is determined; S4, structures of fields are determined; S5, all record heads are analyzed; S6, the fields are separated; S7, data is extracted. The data recovery method has the advantages that the records and fields in the data table are parsed by adopting a database structure, structural division data of heads of all the records and the fields is found and then is extracted, the data recovery efficiency is high, fragment-level databases with damaged data and discontinuous data can be also normally extracted and recovered, the data recovery success rate is high, and loss caused by database damage is effectively reduced.

Description

technical field [0001] The invention relates to the technical field of information security, in particular to a data recovery method based on a large database. Background technique [0002] Database (Database) is a warehouse that organizes, stores and manages data according to the data structure. It was produced more than 60 years ago. With the development of information technology and the market, especially after the 1990s, data management It is no longer just storing and managing data, but has transformed into various data management methods that users need. There are many types of databases, from the simplest tables storing various data to large database systems capable of storing massive amounts of data, which have been widely used in various aspects; A collection of related structured data that is reasonably stored on the Internet. A database contains various components, including tables, views, stored procedures, records, fields, indexes, etc.; [0003] However, dat...

AI Technical Summary

Problems solved by technology

[0003] However, database failures sometimes occur, resulting in inaccessible data. Among them, the common reasons for database corruption are as follows: Transaction log problems

For example, the transaction log file is lost; the transaction log file is deleted by mistake during the operation; The database is shut down abnormally while being read and written; the table of the database is damaged or the index is damaged, or other objects of the database are damaged or lost; the data file is deleted or its name is changed; the hard disk is damaged, causing data and Log file read and write errors, etc.; some of these errors can be handled by the database itself through disaster recovery mechanisms to ensure normal data access, but for database table damage, database deletion, or data file deletion, the database itself cannot be repaired at this time. A special method is needed to solve these problems. Most of the solutions are to restore the lost database files, and then restore the records. However, if the files are stored in fragments, there are some methods to restore the database on the market. In this case, it is necessary to use the method of recording characteristics to complete data recovery, so as to preserve the integrity of key data to the greatest extent.