北京大学学报自然科学版 ›› 2023, Vol. 59 ›› Issue (2): 261-270.DOI: 10.13209/j.0479-8023.2022.120

上一篇    下一篇

区块链与数据库混合架构下的空间查询优化方法

桂智明1, 孙忠祥1, 黄舟2,†   

  1. 1. 北京工业大学信息学部, 北京 100124 2. 北京大学遥感与地理信息系统研究所, 北京 100871
  • 收稿日期:2022-08-04 修回日期:2022-10-06 出版日期:2023-03-20 发布日期:2023-03-20
  • 通讯作者: 黄舟, E-mail: huangzhou(at)pku.edu.cn
  • 基金资助:
    国家自然科学基金(41771425)资助

Spatial Query Optimization Methods by Integrating Blockchain and Database

GUI Zhiming1, SUN Zhongxiang1, HUANG Zhou2,†   

  1. 1. Faculty of Information, Beijing University of Technology, Beijing 100124 2. Institute of Remote Sensing and Geographical Information System, Peking University, Beijing 100871
  • Received:2022-08-04 Revised:2022-10-06 Online:2023-03-20 Published:2023-03-20
  • Contact: HUANG Zhou, E-mail: huangzhou(at)pku.edu.cn

PDF

摘要：

空间数据与区块链相结合, 能够为空间数据管理提供去中心化、安全、可信的技术支撑, 但存在查询速率低下、查询方式种类单一以及脱离区块链体系等问题。针对此问题, 结合空间数据库的高性能、函数种类丰富等特点, 提出一种区块链与空间数据库混合架构下的空间查询优化方法。该方法把Hyperledger Fabric与空间数据库进行集成, 并区别于传统的链下查询方式, 提出一种区块链集成空间数据库的方法, 在智能合约中嵌入高效的空间操作函数, 并且分布式部署数据库, 从而保留区块链原有的分布式查询特点。在防篡改方面, 采取哈希加盐的安全存储机制和双重验证机制来加强安全性。实验结果表明, 该方法在性能和安全性方面都有优良的表现。

关键词: 区块链, 超级账本, 空间数据库, 数据安全存储, 空间查询

Abstract:

The combination of spatial data and blockchain can provide decentralized, secure and trustworthy technical support for spatial data management, but there are currently problems such as low query rate, single type of query, and detachment from blockchain system. According to this problem, combined with the characteristics of high performance and rich function types of spatial database, a spatial query optimization method by integrating blockchain and database is proposed. The method integrates Hyperledger Fabric with spatial database, and differs from the traditional off-chain query method by proposing a blockchain-integrated spatial database method, embedding efficient spatial operation functions in smart contracts, and deploying the database in a distributed manner, so as to retain the original distributed query characteristics of the blockchain. In terms of tamper-proof, a hash-and-salt secure storage mechanism and double verification mechanism are used to strengthen the security. The experimental results show that the method has excellent performance and security.

Key words: blockchain, hyperledger fabric, spatial database, secure data storage, spatial query

版权所有 © 《北京大学学报（自然科学版）》编辑部
技术支持：北京玛格泰克科技发展有限公司