Database Integrity Checks Using WAL and Multi-Stage Verification
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing electronic devices face challenges in ensuring data integrity and atomicity for database transactions, particularly in ensuring that all operations related to a transaction are reflected in the database or none are, while also preventing data corruption.
Innovation Solution
The electronic device includes a processor configured to perform an integrity check on data based on a specified integrity check level for an application, determining whether to execute operation commands based on the check results, using a write-ahead log (WAL) method to ensure data integrity by storing operation results in a separate file before updating the database, and employing integrity check modules for commit, checkpoint, and open operations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If integrity check operations are performed on database data, then data integrity and atomicity are improved, but processing time and operational complexity increase
Solution Approach 1:
The patent implements integrity check modules that perform verification operations in advance before database transactions are committed. The commit integrity check module verifies data before commit operations, the checkpoint integrity check module verifies data at checkpoint intervals, and the open integrity check module verifies data when the database is opened. This preliminary verification prevents corrupted data from being processed, thereby ensuring data integrity while avoiding the need for extensive post-processing verification.
Solution Approach 2:
The patent divides the integrity verification process into multiple independent modules: commit integrity check module, checkpoint integrity check module, and open integrity check module. Each module handles specific verification tasks at different stages of database operations. This segmentation allows the system to perform comprehensive integrity checks without creating a single bottleneck, as each module operates independently at its designated stage, thereby reducing overall processing time while maintaining thorough verification.
2Reliability
If multiple integrity check modules are implemented, then data protection capability is improved, but device complexity increases
Solution Approach 1:
The patent designs integrity check modules that serve multiple functions across different database operations. The same modular verification logic is reused in commit, checkpoint, and open operations, allowing a single module design to protect data across multiple stages. This multi-functionality reduces the need for separate specialized verification code for each operation type, thereby maintaining comprehensive protection while limiting the growth of system complexity through code reuse and standardized interfaces.
3Manufacturing precision
If integrity checks are performed at multiple stages (commit, checkpoint, open), then data accuracy is improved, but operational overhead increases
Solution Approach 1:
The patent performs integrity verification at multiple predetermined stages: when the database is opened, before commit operations, and at checkpoint intervals. By verifying data in advance at each stage, the system prevents corrupted data from propagating through subsequent operations. This multi-stage preliminary verification ensures high data accuracy by catching errors early, while the automated nature of each check reduces the perceived operational overhead.
Data Source
AI summary
According to an embodiment of the disclosure, an electronic device may include a memory and a processor operatively connected to the memory, wherein the memory may include instructions that cause, when executed, the processor to identify whether or not a specified operation command for data related to an application executed in the electronic device is received, if the specified operation command is received, identify an integrity check level specified for the application, perform an integrity check on the data, if the specified integrity check level of the application is greater than or equal to a reference level, in response to reception of the specified operation command, and determine whether or not to execute the specified operation command for the data according to a result of the integrity check. In addition to the embodiment of the disclosure, various other embodiments are possible.