Database Error Correction via Layer Checks for Transaction Accuracy
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional systems for managing electronic payment transactions lack secure and accurate data transmission and storage, leading to data gaps and inefficiencies due to errors in database management and communication applications, which hinder real-time recording and reporting.
Innovation Solution
A database error correction system that detects errors in a transaction database by performing layer checks based on rules associated with fund values, determines the cause of errors, and modifies database operators to correct them, ensuring accurate and efficient data processing.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If conventional database management systems are used for transaction processing, then basic data storage and retrieval functions are provided, but data accuracy and completeness deteriorate due to data gaps and errors
Solution Approach 1:
The system performs preliminary layer checks on account balances before transactions are finalized. By validating that source and destination account balances are non-negative and that the source balance is sufficient before executing the transaction, the system prevents data gaps and errors from occurring in the first place, ensuring data accuracy and completeness
Solution Approach 2:
The system implements feedback mechanisms through layer checks that continuously monitor account balance states. When a transaction is executed, the system checks whether the resulting layer states are valid (non-negative balances). This feedback loop detects and prevents erroneous transactions, maintaining data accuracy and preventing information loss
2Reliability
If manual testing and correction of database errors is performed, then error identification and correction can be achieved, but time consumption increases significantly
Solution Approach 1:
The system performs self-validation through automated layer checks that automatically detect and report errors in transaction data. The system checks account balance layers and identifies erroneous transactions without requiring manual intervention. This self-service approach maintains high error correction accuracy while dramatically reducing the time needed for testing and correction
Solution Approach 2:
The system replaces manual mechanical checking processes with automated computational layer checks. Instead of manually reviewing transactions, the system uses computer-based validation of account balance layers to automatically detect errors, substituting human labor with automated mechanical processes that are faster and more consistent
3Reliability
If layer checks are performed on all transactions, then data accuracy is improved, but processing complexity increases
Solution Approach 1:
The system segments the transaction validation process into distinct layer checks for different account balance layers. Instead of a single complex validation routine, the system performs separate checks on source account layers and destination account layers, making the complexity manageable and the accuracy high through systematic validation of each layer
Data Source
AI summary
This disclosure describes methods, non-transitory computer readable storage media, and systems that utilize layer checks to detect and correct errors in a transaction database that includes transactions associated with multi-layered payment accounts. For example, the disclosed system detects errors in a transaction database caused by erroneous database operators. Specifically, the disclosed system determines states of layers that represent different fund values associated with one or more payment accounts based on transactions in a transaction database. The disclosed system detects errors in the transactions of the transaction database by performing layer checks on the layers according to rules associated with the layers and their respective states. The disclosed system utilizes information about the detected errors and transactions in the transaction database to modify database operators associated with the transaction database.