Blockchain Ledger for Tamper-Resistant Database Record Storage
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database connection interfaces lack a tamper-resistant solution for storing data manipulation records, which are essential for search and verification purposes across different types of databases.
Innovation Solution
A data manipulation record storage method using a blockchain type ledger, where manipulation instructions and results are packaged into data records, hashed, and stored in blocks with increasing block heights based on sequence times, ensuring transparent and irreversible storage.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If traditional database storage is used for manipulation records, then storage simplicity is maintained, but tamper-resistance and verification capability are lost
Solution Approach 1:
The storage structure is segmented into blocks, where each block contains multiple manipulation records and a hash value. This segmentation enables tamper-resistance while maintaining manageable complexity through modular organization of data.
Solution Approach 2:
Hash values serve as intermediaries between manipulation records and verification mechanisms. Each block's hash value acts as a digital fingerprint that verifies integrity without requiring complex cryptographic protocols, simplifying the overall system while ensuring reliability.
2Reliability
If all manipulation records are stored in detail, then complete verification capability is achieved, but storage space consumption increases
Solution Approach 1:
The essential verification information (hash values) is extracted from the complete manipulation records and stored separately in block structures. This allows verification capability to be maintained while reducing storage space by not duplicating all record details in the verification structure.
Solution Approach 2:
Instead of storing complete manipulation records for verification, compact hash value copies are created. These hash copies provide sufficient verification capability while occupying minimal storage space compared to the original detailed records.
3Reliability
If block generation requires processing all accumulated data records, then data integrity is ensured, but processing time increases
Solution Approach 1:
Data records are pre-organized and buffered before block generation. This preliminary organization reduces the processing burden during block creation, ensuring data integrity through systematic handling while minimizing the time penalty of block generation.
Data Source
AI summary
Computer-implemented methods, computer-implemented systems, and non-transitory, computer-readable media for data manipulation record storage. One computer-implemented method includes: sending, by a server, one or more manipulation instructions to a database, wherein the one or more manipulation instructions are in a structured query language (SQL) format; receiving, by the server from the database, an execution result of the one or more manipulation instructions; generating, by the server, one or more data records comprising the one or more manipulation instructions and the execution result; and determining, by the server, that a predetermined condition of generating a data block is satisfied; and generating, by the server, the data block that includes at least a portion of the data records.