Database repairing method and electronic device

Patent metadata

Field	Value
Publication number	US-12561295-B2
Application number	US-202118245476-A
Country	US
Kind code	B2
Filing date	Aug 20, 2021
Priority date	Sep 16, 2020
Publication date	Feb 24, 2026
Grant date	Feb 24, 2026

Abstract

Database repairing methods and electronic devices are disclosed. In an implementation, a method includes, in response to determining that a first database file is corrupted, obtaining data of at least one field in the first database file, wherein the at least one field is predefined by an application, and generating a first data table in a second database file based on the data of the at least one field, wherein the second database file is obtained through repairing.

First claim

What is claimed is:

1 . A database repairing method, comprising:
in response to determining that a first database file and a second data table in a backup file of the first database file are corrupted, backing up the first database file to obtain a backup file of the first database file; obtaining data of at least one field in the first database file from a master table, wherein the master table stores a structured query language (SQL) statement for generating a first data table which is a repaired version of the second data table, and wherein the at least one field is predefined by an application; in response to determining that a second data table in the backup file that stores the data of the at least one field is not corrupted, obtaining the data of the at least one field from the second data table; in response to determining that the second data table in the backup file is corrupted, obtaining the data of the at least one field from a master table associated with the first database file, the master table storing statements and data used to generate the first database file, and reconstructing a key data table by re-executing the statements for the key data table; creating, in response to the first database file being corrupted, a second database file having a same file name and a same structure as the first database file; and generating the first data table to obtain a in the second database file based on the data of the at least one field, wherein the second database file comprises the first data table and is a repaired version of the first database file and replaces the first data file, and wherein the first database file and the second database file are stored in a database.

2 . The method according to claim 1 , wherein the SQL statement comprises one or more of an update statement, an insertion statement, a deletion statement, or a query statement.

3 . The method according to claim 1 , wherein the method further comprises:
deleting the first database file.

4 . The method according to claim 1 , wherein the database is a structured query language lite (SQLite) database.

5 . The method according to claim 1 , wherein a computer program for implementing the method is provided by the application.

6 . The method according to claim 1 , wherein a computer program for implementing the method is provided by an electronic device on which the application is installed.

7 . An electronic device comprising:
at least one processor; and a memory coupled to the at least one processor and storing programming instructions for execution by the at least one processor to cause the electronic device to perform operations comprising: in response to determining that a first database file and a second data table in a backup file of the first database file are corrupted, backing up the first database file to obtain a backup file of the first database file; obtaining data of at least one field in the first database file from a master table, wherein the master table stores a structured query language (SQL) statement for generating a first data table which is a repaired version of the second data table, and wherein the at least one field is predefined by an application; in response to determining that a second data table in the backup file that stores the data of the at least one field is not corrupted, obtaining the data of the at least one field from the second data table; in response to determining that the second data table in the backup file is corrupted, obtaining the data of the at least one field from a master table associated with the first database file, the master table storing statements and data used to generate the first database file, and reconstructing a key data table by re-executing the statements for the key data table; creating, in response to the first database file being corrupted, a second database file having a same file name and a same structure as the first database file; and generating the first data table to obtain a in the second database file based on the data of the at least one field, wherein the second database file comprises the first data table and is a repaired version of the first database file and replaces the first data file, and wherein the first database file and the second database file are stored in a database.

8 . The electronic device according to claim 7 , wherein the SQL statement comprises one or more of an update statement, an insertion statement, a deletion statement, or a query statement.

9 . The electronic device according to claim 7 , wherein the method further comprises:
deleting the first database file.

10 . The electronic device according to claim 7 , wherein the database is a structured query language lite (SQLite) database.

11 . The electronic device according to claim 7 , wherein a computer program for implementing the method is provided by the application.

12 . The electronic device according to claim 7 , wherein a computer program for implementing the method is provided by an electronic device on which the application is installed.

Assignees

• Huawei Tech Co Ltd

Inventors

• Xiao Mingpeng
• Wang Kai

Classifications

• G06F2201/80

  Database-specific techniques · CPC title

• G06F11/1448

  Management of the data involved in backup or backup restore · CPC title

• G06F11/1469

  Backup restoration techniques · CPC title

• G06F16/215 Primary

  Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors · CPC title