Blockchain Data Processing via Relational Mapping
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Blockchain networks face challenges in data storage reliability and transaction processing capabilities, such as data analysis and computation, due to the non-relational nature of stored service data.
Innovation Solution
A blockchain-based data processing method and device that determines identifiers for blocks and service data, establishes mapping relationships between them, and stores these in a relational database, converting non-relational data to relational data for improved storage reliability and enhanced transaction processing capabilities.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of manufacture
If service data is stored in non-relational key-value form in blockchain blocks, then data storage simplicity is maintained, but data analysis and computation capabilities are limited
Solution Approach 1:
The patent introduces an intermediary layer (relational database system) between the blockchain storage and the data analysis/computation operations. The blockchain maintains its simple key-value storage, while a relational database receives data from blockchain, converts it to relational format with proper schemas, and provides enhanced query and analysis capabilities. This mediator resolves the contradiction by preserving blockchain storage simplicity while enabling advanced data processing.
2Device complexity
If service data is stored directly in blockchain blocks without relational mapping, then storage structure is simple, but data storage reliability for complex queries is insufficient
Solution Approach 1:
The patent segments the data storage system into two distinct parts: blockchain blocks for immutable transaction storage and a relational database for structured data organization. Each component performs its specialized function - blockchain maintains cryptographic integrity while the relational database provides reliable structured storage with foreign key relationships, constraints, and ACID properties. This segmentation resolves the contradiction by allowing each layer to optimize for its specific purpose.
3Productivity
If mapping relationships between block identifiers and service data identifiers are established and stored in relational database, then transaction processing capabilities are enhanced, but system complexity increases
Solution Approach 1:
The patent creates a copy of the essential data relationships in relational format without modifying the original blockchain structure. The relational database contains copied and transformed representations of block-service data mappings, enabling efficient querying and analysis. This copying approach resolves the contradiction by providing enhanced transaction processing capabilities through the relational model while keeping the blockchain system itself unchanged and relatively simple.
Data Source
AI summary
Example methods, non-transitory computer-readable medium, and systems for blockchain-based data processing are provided herein. In one example method, a blockchain network is identified, where the blockchain network includes a plurality of blocks. For each particular block of the plurality of blocks, a series of operations can be performed. An identifier of the particular block and an identifier of service data stored in the particular block are determined. A first mapping relationship is established between the determined identifier of the particular block and the determined identifier of the service data stored in the particular block. That first mapping relationship for the particular block is then stored in a relational database. In some instances, determining the identifier of the block includes obtaining digest information of the block, computing a value based on the digest information of the block, and associating the computed value as the identifier of the particular block.