Method and device for recovering deleted data in SQLite

A data and data table technology, applied in the database field, can solve the problems of redundant analysis of WAL files and incomplete recovery records, etc., and achieve the effect of improving accuracy and comprehensiveness, strong applicability, and ensuring non-destructiveness

Active Publication Date: 2015-02-25
XIAMEN MEIYA PICO INFORMATION
View PDF5 Cites 24 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] The invention provides a method and device for recovering deleted data in SQLite, which has strong versatility and can solve the problems of redundant analysis of WAL files and incomplete recovery records when using existing general data recovery products for data recovery. , improve the accuracy and comprehensiveness of data recovery

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
  • Method and device for recovering deleted data in SQLite
  • Method and device for recovering deleted data in SQLite
  • Method and device for recovering deleted data in SQLite

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0058] The technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some of the embodiments of the present application, not all of them. All other embodiments obtained by persons of ordinary skill in the art based on the embodiments of the present invention belong to the protection scope of the present application.

[0059] The "first", "second", etc. in the following descriptions are only for the purpose of describing the steps in the embodiment of the present invention more clearly and do not play a limiting role (for example, they are not limited to the first, second, etc. in the sense of ordering ).

[0060] see figure 1 , is a schematic flowchart of an embodiment of the method for restoring deleted data in SQLite according to the present invention.

[0061] The method for recovering...

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 provides a method and device for recovering deleted data in the SQLite. The method includes the steps that a B+tree type main tree and a WAL file which correspond to a data sheet are read from the SQLite; the WAL file is divided into a plurality of page sets according to imperative statements; a first unread page set is read and marked as read and is marked as a first page set; if the first page set is not empty, a second page set related to the main tree is extracted from the first page set; if the second page set is not empty, the second page set and related pages form a B+tree type second subtree; if the second subtree is not empty, a first subtree, corresponding to the second subtree, in the main tree is obtained, and whether the second subtree is in a data deleting type or not is judged; if the second subtree is in the data deleting type, first original data deficient in the first subtree are found according to the second subtree, and data recovering can be carried out on the deleted data corresponding to the first original data in a preset mode conveniently. By means of the method, the data recovery accuracy rate and the data recovery comprehensiveness can be improved.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and device for recovering deleted data in SQLite. Background technique [0002] At present, in forensics and other fields, it is often encountered that deleted data needs to be recovered, and products for recovering deleted data have also appeared in the market. [0003] SQLite is a lightweight database, a relational database management system that complies with ACID. Its design goal is embedded, and it has been used in many embedded products. It occupies very low resources. For standard devices, only a few hundred K of memory may be enough. Moreover, it can support mainstream operating systems such as Windows / Linux / Unix, and can be combined with many programming languages, such as Tcl, C#, PHP, Java, etc. In addition, it also has a fairly fast processing speed. The first Alpha version of SQLite was born in May 2000, and it has been 14 years since then, and the new version of ...

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
CPCG06F16/21
Inventor 陈明辉方均滩吴世雄
Owner XIAMEN MEIYA PICO INFORMATION
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