Method for clearing data in SQLite database

A database and data technology, applied in the field of information security, can solve problems such as loss, deletion, and harm, and achieve the effect of preventing malicious theft and protecting security.

Active Publication Date: 2015-01-21
MWH TECH LLC
View PDF6 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] When using an application with an SQLite database, the deletion of data does not actually delete the data, and the data still exists but is marked as deleted; and some data recovery software currently on the market can easily find out These deleted data are thus used by some criminals to steal private data, causing serious losses and harm to individuals, enterprises, and state agencies; so there is an urgent need for a method that can completely clear the private data in the SQLite database

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 for clearing data in SQLite database
  • Method for clearing data in SQLite database
  • Method for clearing data in SQLite database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] In order to describe the specific implementation manner of the present invention in detail, illustrate below in conjunction with accompanying drawing:

[0055] Such as figure 1 As shown, a method for clearing data in an SQLite database comprises the following steps:

[0056] S1: Connect to the device equipped with the SQLite database, and establish a connection channel with the device;

[0057] S2: Scan all SQLite files in the device memory space to obtain the storage path;

[0058] S3: Analyze the scanned SQLite files one by one and clear abnormal data.

[0059] Such as figure 2 As shown, the S2 includes the following steps:

[0060] S201: Scan device storage space one by one to obtain paths;

[0061] S202: Determine whether the obtained path corresponds to a folder or a file, if it is a folder, open the file in the scanned folder, and if it is a file, execute S203;

[0062] S203: Parse and determine whether the file is an SQLite database file. In this step, to...

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 method for clearing data in an SQLite database. The method comprises the following steps that S1, a device comprising the SQLite database is connected to establish a connection channel with the device; S2, all SQLite files in a memory space of the device are scanned to obtain a storage path; S3, the scanned SQLite files are analyzed one by one, and abnormal data clearing is carried out. The method has the advantages that scanning is complete, all the SQLite files in the memory space can be found out, and all areas in the SQLite are scanned and marked; clearing is complete, abnormal data of master tables, data tables, index tables and free pages in the SQLite files are scanned and cleared, malicious steal of privacy data is prevented, and safety of privacy data is protected.

Description

technical field [0001] The invention relates to the technical field of information security, in particular to a method for clearing data in an SQLite database. Background technique [0002] SQLite is a light-weight database that occupies less resources, supports mainstream operating systems, can be combined with multiple languages, and is widely used because of its fast processing speed. The data in the SQLite database involves the confidential data and privacy of state agencies, the military, enterprises, institutions, and individuals. [0003] When using an application with an SQLite database, the deletion of data does not actually delete the data, and the data still exists but is marked as deleted; and some data recovery software currently on the market can easily find out These deleted data are thus used by some criminals to steal private data, causing serious losses and harm to individuals, enterprises, and state agencies; so there is an urgent need for a method that c...

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/215G06F16/2246G06F16/2282
Inventor 梁效宁黄旭
Owner MWH TECH LLC
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