Method for recovering database file in electronic device
According to an embodiment, an electronic device includes a memory including a database file and at least one processor connected to the memory. The at least one processor may identify damage to the database file while a first application running on the electronic device accesses the database file. The at least one processor may control a second application running on the electronic device to wait without accessing the database file until recovery of the damaged database file is completed. The at least one processor may record recovery state information indicating that the database file is recovered if the recovery of the damaged database file is completed. The at least one processor may control the second application to access the recovered database file based on the recovery state information.
1. An electronic device comprising:
at least one processor including processing circuitry; and
memory including one or more storage mediums storing instructions that, when executed by the at least one processor individually or collectively, cause the electronic device to:
receive a request from a first application running on the electronic device to open a database file, wherein the database file is stored in the memory,
identify that the database file is damaged as a damaged database file responsive to the first application running on the electronic device requesting to open the database file,
set a file lock on the damaged database file to indicate that the database file is being recovered,
identify a second application running on the electronic device that wants to access the damaged database file while recovering the database file,
based on the file lock, identify that the database file is being recovered and control the second application to wait without accessing the damaged database file until recovery of the damaged database file is completed,
record recovery state information indicating that the damaged database file is recovered as a recovered database file based on identifying that the recovery of the damaged database file is completed,
release the file lock for the database file based on the recovery of the damaged database file succeeding and after completion of recording the recovery state information, and
control the second application to access the recovered database file based on the recovery state information, wherein the recovered database file is accessible by the first application.
2. The electronic device of claim 1 , wherein the instructions, when executed by the processing circuitry individually or collectively, cause the electronic device to recover the damaged database file using the first application accessing on the database file.
3. The electronic device of claim 1 , wherein the file lock is an exclusive lock uniquely set for the database file.
4. The electronic device of claim 1 ,
wherein based on the recovery state information being set to a first value, the first value indicates that the damaged database file is recovered, and
based on the recovery state information being set to a second value, the second value indicates that the damaged database file is not recovered.
5. The electronic device of claim 1 , wherein the recovery state information is implemented as a user defined attribute included in metadata for the database file.
6. The electronic device of claim 5 , wherein the user defined attribute is set as an extended attribute of an index node of a file system.
7. The electronic device of claim 1 , wherein the recovery state information is implemented as a table included in the recovered database file.
8. The electronic device of claim 1 ,
wherein the database file is constituted of a plurality of pages, and
wherein the recovery state information is included in a first page in the database file.
9. The electronic device of claim 1 ,
wherein the at least one processor includes a database library, and
wherein the database library is set to include a first logic for identifying a recovery operation for the damaged database file and a second logic for identifying a recovery state for the damaged database file.
10. A method for operating an electronic device, the method comprising:
receiving a request from a first application running on the electronic device to open a database file, wherein the database file is stored in memory of the electronic device;
identifying, by at least one processor of the electronic device executing a plurality of instructions stored in a memory of the electronic device, that the database file is damaged as a damaged database file responsive to a first application running on the electronic device requesting to open the database file;
setting a file lock on the damaged database file to indicate that the database file is being recovered;
identifying a second application running on the electronic device that wants to access the damaged database file while recovering the database file;
based on the lock, identifying that the database file is being recovered and controlling, by the at least one processor of the electronic device, the second application to wait without accessing the damaged database file until recovery of the damaged database file is completed;
recording, by the at least one processor of the electronic device, recovery state information indicating that the damaged database file is recovered as a recovered database file based on identifying that the recovery of the damaged database file is completed;
releasing the file lock for the database file based on the recovery of the damaged database file succeeding and after completion of recording the recovery state information; and
controlling, by the at least one processor of the electronic device, the second application to access the recovered database file based on the recovery state information, wherein the recovered database file is accessible by the first application.
11. The method of claim 10 , further comprising:
recovering, by the at least one processor, the damaged database file using the first application accessing on the database file.
12. The method of claim 10 , wherein the file lock is an exclusive lock uniquely set for the database file.
13. The method of claim 10 ,
wherein based on the recovery state information being set to a first value, the first value indicates that the damaged database file is recovered, and
based on the recovery state information being set to a second value, the second value indicates that the damaged database file is not recovered.
14. The method of claim 10 , wherein the recovery state information is implemented as a user defined attribute included in metadata for the database file.
15. The method of claim 14 , wherein the user defined attribute is set as an extended attribute of an index node of a file system.
16. The method of claim 10 , wherein the recovery state information is implemented as a table included in the recovered database file.
17. The method of claim 10 ,
wherein the database file is constituted of a plurality of pages, and
wherein the recovery state information is included in a first page in the database file.
18. A computer program product comprising a non-transitory storage medium storing instructions that, when executed by at least one processor of an electronic device individually or collectively, cause the electronic device to perform a plurality of operations, the plurality of operations comprising:
receiving a request from a first application running on the electronic device to open a database file, wherein the database file is stored in memory of the electronic device;
identifying that the database file stored in a memory of the electronic device is damaged as a damaged database file responsive to a first application running on the electronic device requesting to open the database file;
setting a file lock on the damaged database file to indicate that the database file is being recovered;
identifying a second application running on the electronic device that wants to access the damaged database file while recovering the database file;
based on the lock, identifying that the database file is being recovered and controlling the second application to wait without accessing the damaged database file until recovery of the damaged database file is completed;
recording recovery state information in the electronic device indicating that the damaged database file is recovered as a recovered database file based on identifying that the recovery of the damaged database file is completed;
releasing the file lock for the database file based on the recovery of the damaged database file succeeding and after completion of recording the recovery state information; and
controlling the second application to access the recovered database file based on the recovery state information, wherein the recovered database file is accessible by the first application.