Database Table Validation for Unauthenticated Data Integrity
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing systems lack effective methods to verify the authenticity of unauthenticated digital data received from untrusted sources, which can be manipulated or tampered with, posing risks in secure data management and transactions.
Innovation Solution
A system and method that securely transmits unauthenticated data for validation to a remote device, using cryptographic hash functions and data security techniques to ensure the data has not been modified by unauthorized users, and generates a database table to compare and validate the data against authenticated data, resolving discrepancies and executing transactions based on verified correction data.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If unauthenticated data is received from untrusted sources, then data processing can proceed, but data authenticity and integrity cannot be guaranteed
Solution Approach 1:
The system performs preliminary authentication by comparing received data against authenticated data stored in the database before processing. This advance verification ensures data authenticity is established prior to any processing operations, resolving the contradiction by making reliability checks a prerequisite rather than an afterthought.
Solution Approach 2:
The patent introduces an intermediary authentication mechanism that mediates between untrusted data sources and the processing system. The comparison against authenticated data in the database acts as an intermediary verification layer, allowing the system to accept data from untrusted sources while maintaining integrity guarantees through the intermediary check.
2Reliability
If data validation techniques are implemented, then data authenticity can be verified, but system complexity increases
Solution Approach 1:
The system performs self-verification by automatically comparing received data against authenticated data stored in its own database. This self-service approach eliminates the need for external authentication services or complex verification infrastructure, reducing system complexity while maintaining reliable authenticity verification.
Solution Approach 2:
The patent uses copying of authenticated data from the database for comparison purposes. Instead of implementing complex cryptographic verification or external authentication protocols, the system creates and compares copies of authenticated data, simplifying the verification process while ensuring data authenticity.
3Reliability
If authenticated data is stored in a database, then data integrity can be maintained, but data format compatibility issues arise when comparing with unauthenticated data
Solution Approach 1:
The system applies local quality comparison by examining specific fields or characteristics of the data rather than requiring complete format matching. This allows authenticated data in the database to maintain its integrity while comparing only relevant local properties with unauthenticated data, resolving format compatibility issues without compromising data integrity.
Data Source
AI summary
A computer system, method, and non-transitory computer-readable medium are provided. A request including unauthenticated data is created and securely transmitted to a remote device, metadata corresponding to the request is updated to indicate successful validation, a response file is validated, and a discrepancy is detected between the unauthenticated data and the authenticated data. Correction data is obtained, and a transaction based on the request and the correction data is executed. A second processor of the remote device verifies that an unauthorized user has not modified the authenticated data, generates a database table based on one or more fields of the authenticated data, extracts one or more predetermined data values from the authenticated data and the database table, and validates the unauthenticated data in the request based on comparing the one or more predetermined data values from the authenticated data and the database table to the unauthenticated data in the request.