Unlock instant, AI-driven research and patent intelligence for your innovation.
A recovery method for lost data based on sqlite database
What is Al technical title?
Al technical title is built by PatSnap Al team. It summarizes the technical point description of the patent document.
A technology of lost data and recovery method, which is applied to data error detection, electrical digital data processing, special data processing applications, etc. with redundancy in operation, which can solve the problems of insufficient data recovery and low operation efficiency, and achieve good results. Application prospect, improved efficiency, high integrity effect
Active Publication Date: 2018-05-04
XLY SALVATIONDATA TECHNOLOGY INC
View PDF5 Cites 0 Cited by
Summary
Abstract
Description
Claims
Application Information
AI Technical Summary
This helps you quickly interpret patents by identifying the three key elements:
Problems solved by technology
Method used
Benefits of technology
Problems solved by technology
[0007] Aiming at the deficiencies of the prior art, the present invention provides a method for recovering lost data based on the SQLite database, which can effectively solve the problems of insufficient data recovery and low operating efficiency in the prior art
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
Click on the blue label to locate the original text in one second.
Reading with bidirectional positioning of images and text.
Smart Image
Examples
Experimental program
Comparison scheme
Effect test
Embodiment 1
[0032] A recovery device for lost data based on an SQLite database, comprising the following modules:
[0033] Feature configuration module: used to configure the attribute features of the columns of some or all tables in the source database containing the data to be restored;
[0034] Feature matching module: used to match and verify the attribute features of the column with the data to be restored.
[0035] Further, the feature configuration module includes the following units:
[0036] Database loading unit: used to read the information of the database containing the data to be restored;
[0037] Characteristic definition unit: used to set the attribute characteristics of the columns of some or all tables in the source database, including column value type, column value length and column quantity;
[0038] Save unit: used to save the attribute characteristics of the column to a preset specific file type.
[0039] Further, the feature matching module includes the followin...
Embodiment 2
[0046] A kind of recovery method based on the lost data of SQLite database, comprises the steps:
[0047] S1 configures the attribute characteristics of the columns of some or all tables in the source database containing the data to be restored;
[0048] S2 matches and verifies the special attribute characteristics and the data to be restored.
[0049] Further, the detailed process of S1 is as follows:
[0050] S11 reads the source database containing the data to be restored;
[0051] S12, according to the source database obtained in S11, set the attributes of the columns of the table containing the data to be restored, including column value type, column value length and column quantity;
[0052]Among them, when defining multiple table structures, if the structure of the tables is completely consistent, you can use * as a wildcard to create a table set to indicate that the same type of table can use a feature information, for example, in the database that stores WeChat chat...
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
Login to View More
Abstract
The invention discloses a device and method for recovering lost data based on an SQLite database, belonging to the field of data recovery. The device for recovering the lost data based on the SQLite database comprises a characteristic configuration module and a characteristic matching module, wherein the characteristic configuration module is used for configuring attributive characteristics of columns of partial or all tables in a source database including data to be recovered; and the characteristic matching module is used for performing matched verification of the attributive characteristics of the columns and the data to be recovered. The device and the method disclosed by the invention have the beneficial effects that: all application data using the SQLite database is recovered according to characteristics of a customized source database under different application conditions, but not limited by a mobile terminal; therefore, an application platform is very wide; and the device and the method disclosed by the invention have good application prospects.
Description
technical field [0001] The invention belongs to the technical field of data recovery, and in particular relates to a method for recovering lost data based on an SQLite database. Background technique [0002] SQLite is a lightweight database. Its design goal is embedded, and it has been used in many embedded products. It occupies very low resources. In embedded devices, it may only need a few hundred KB. RAM is enough. It can support mainstream operating systems such as Windows / Linux / Unix / Mac OSX, and can be combined with many programming languages. SQLite is widely used in embedded devices, desktop applications, and Websites with a series of features such as less resource occupation, simple operation, zero management cost, good performance, and open source code. [0003] However, once a data loss occurs in a system based on the SQLite database, it will often bring a lot of inconvenience to the user. The existing methods for restoring the SQLite database are generally aimed...
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
Application Date:The date an application was filed.
Publication Date:The date a patent or application was officially published.
First Publication Date:The earliest publication date of a patent with the same application number.
Issue Date:Publication date of the patent grant document.
PCT Entry Date:The Entry date of PCT National Phase.
Estimated Expiry Date:The statutory expiry date of a patent right according to the Patent Law, and it is the longest term of protection that the patent right can achieve without the termination of the patent right due to other reasons(Term extension factor has been taken into account ).
Invalid Date:Actual expiry date is based on effective date or publication date of legal transaction data of invalid patent.
Login to View More 
Login to View More