FabricSQL:区块链数据的关系查询

FabricSQL:Relational query of blockchain data

为解决区块链在查询方面存在的访问方法支持有限、查询功能单一、查询效率低等不足,提出一种区块链数据的关系查询解决方案FabricSQL,将Hyperledger Fabric与MySQL结合,把实时存储的区块链有效交易数据同步存储到SQL数据库中。为防止数据库中的数据被篡改,提出一种交易数据存储验证机制,在SQL数据存储时使用Salt加密方法,在数据顺序追加时引入区块链前哈希的思想防止作恶,在用户访问时,进行数据的一致性校验,返回需求数据和校验结果,保证数据的安全性。在设计的实验模型和基于Fabric的区块链系统上进行多项查询性能的对比实验,实验结果表明,FabricSQL同时拥有区块链和关系型数据库的良好特性。

To solve the problems of blockchain in terms of query,including limited access method support,single query function and low query efficiency,FabricSQL was proposed as a relational query solution of blockchain data.Hyperledger Fabric was combined with MySQL to conduct real-time storage through blockchain,and the effective transaction data were synchronously stored in SQL database.To prevent the data in the database from being tampered with,a transaction data storage verification mechanism was proposed.When SQL data were stored,the Salt encryption method and prehash were introduced to restrict the evil.When the user queried,the consistency of the data was verified,and the data and the result of verification were returned,to ensure the security of the data.A comparison of multiple query performances on experimental models and fabric-based blockchain systems shows that FabricSQL has good features of both blockchain and relational database.