CORRUPTED RECORD RECOVERY METHOD IN SQLITE DATABASE FILE

摘要

The present invention relates to a method for recovering a damaged record in a SQLite database file which, more preferably, includes: a step of a DB file determination unit for receiving data from the outside and determining whether the input data are the SQLite database file; a step of a damage determination unit for determining whether the input data have been damaged if the input data are the SQLite database; a step of a scan unit for scanning bytes of the input data and detecting a starting point and the size of pages in the database file if the input data have been damaged; a step of a schema information acquisition unit for acquiring schema information, used for a normal record, based on the starting point and the size of the searched page; and a step for a record recovery unit for recovering the damaged record based on schema information. According to the method for recovering a damaged record in a SQLite database file of the present invention, the damaged record is recovered by using schema information obtained by moving along a B-tree, which is a file structure of the SQLite database. Therefore, the method can be widely used for the SQLite database in all cases with a less miss-detection rate without dependency on a certain application program or a file system.