Blockchain Data Processing via Relational Database Mediator
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Blockchain systems face inefficiencies in querying specific conditions and complex logic due to their inability to connect with application layers, resulting in low query efficiency and limited support for data processing.
Innovation Solution
A blockchain data processing method and apparatus that analyze Key-Value data to determine data types, map them to target tables in a relational database using a data type information table, and write data accordingly, enabling efficient storage and query operations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If blockchain systems use simple Key-Value storage structure, then storage simplicity is maintained, but query efficiency for specific conditions and complex logic deteriorates
Solution Approach 1:
The patent introduces a relational database as an intermediary layer between the blockchain Key-Value storage and the application layer. The relational database receives data from the blockchain, stores it in structured tables with defined schemas, and handles complex queries. This mediator enables efficient querying of specific conditions and complex logic while the blockchain maintains its simple Key-Value storage structure for immutability and decentralization.
2Reliability
If blockchain systems maintain isolated data structure, then data integrity is preserved, but connection with application layers deteriorates
Solution Approach 1:
The relational database serves as a mediator that preserves blockchain data integrity while enabling application layer connections. It maintains the original Key-Value data from blockchain through structured storage and provides standardized interfaces for applications to query and interact with the data, thus bridging the isolation between blockchain and application layers without compromising data integrity.
Solution Approach 2:
The relational database provides multi-functional capabilities: it stores blockchain data, performs complex queries, supports multiple application layer connections, and maintains data integrity. This universal component enables the blockchain system to serve diverse application needs while preserving the core blockchain data structure and integrity guarantees.
Data Source
AI summary
Provided are a blockchain data processing method and apparatus, a device, and a readable storage medium. By storing a data type information table in a relational database in advance, the data type information table is used for storing storage information of all the data types, and the storage information includes a table corresponding to the data type, a mapping relationship between the service field of the Value of the data type and a table field in the corresponding table, and a data format of the Value of the data type. A data type of the Value is determined when the Key-Value data needs to be stored; and a target table corresponding to the data type of the Value is determined and the Key-Value data is written into the target table according to the data type information table.