Blockchain-oriented data management middleware

doi:10.3969/j.issn.1000-5641.2021.05.006

Abstract

Abstract:

As a decentralized distributed ledger, blockchain technology is widely used to share data between untrusted parties. Compared with traditional databases that have been refined over many years, blockchains cannot support rich queries, are limited to single query interfaces, and suffer from slow response. Simple organizational structures and discrete storage limits are the main barriers that limit the expression of transaction data. In order to make up for the shortcomings of existing blockchain technology and achieve efficient application development, users can build abstract models, encapsulate easy-to-use interfaces, and improve the efficiency of queries. We also propose a general data management middleware for blockchain, which has the following characteristics: ① Support for custom construction of data models and the flexibility to add new abstractions to transaction data; ② Provide multiple data access interfaces to support rich queries and use optimization methods such as synchronous caching mechanisms to improve query efficiency; ③ Design advance hash calculation and asynchronous batch processing strategies to optimize transaction latency and throughput. We integrated the proposed data management middleware with the open source blockchain CITA and verified its ease of use and efficiency through experiments.

Key words: blockchain, data management, transaction data, abstract model

CLC Number:

TP302

Sijia DENG, Xing TONG, Haibo TANG, Zhao ZHANG, Cheqing JIN. Blockchain-oriented data management middleware[J]. Journal of East China Normal University(Natural Science), 2021, 2021(5): 60-73.

Figures/Tables 15

Fig.1

Fig.2

Fig.3

Fig.4

Table 1

Fig.5

Table 2

Fig.6

Table 3

Fig.7

Fig.8

Fig.9

Fig.10

Fig.11

Fig.12

References 21

1	MCCONAGHY T, MARQUES R, MÜLLER A, et al. Bigchaindb: A scalable blockchain database [R]. White Paper, BigChainDB, 2016.
2	ZHU Y, ZHANG Z, JIN C, et al. SEBDB: Semantics empowered blockchain database [C]//35th IEEE International Conference on Data Engineering. 2019: 1820-1831.
3	ELHINDI M, BINNIG C, ARASU A, et al. Blockchaindb - A shared database on blockchains. Proceedings of the VLDB Endowment, 2019, 12 (11): 1597- 1609. doi: 10.14778/3342263.3342636
4	LI Y, ZHENG K, YAN Y, et al. Etherql: A query layer for blockchain system [C]//Database Systems for Advanced Applications 22nd International Conference. 2017: 556-567.
5	LUU L, CHU D, OLICKEL H, et al. Making smart contracts smarter [C]//Proceedings of the 2016 ACM SIGSAC Conference on Computer and Communi cations Security. 2016: 254-269.
6	NATHAN S, GOVINDARAJAN C, SARAF A, et al. Blockchain meets database: Design and implementation of a blockchain relational database. Proceedings of the VLDB Endowment, 2019, 12 (11): 1539- 1552. doi: 10.14778/3342263.3342632
7	PENG Y, DU M, LI F, et al. Falcondb: Blockchain-based collaborative database [C]//Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data. 2020: 637-652.
8	邵奇峰, 金澈清, 张召, 等. 区块链技术: 架构及进展. 计算机学报, 2018, 41 (5): 3- 22.
9	邵奇峰, 张召, 朱燕超, 等. 企业级区块链技术综述. 软件学报, 2019, 30 (9): 2571- 2592.
10	钱卫宁, 邵奇峰, 朱燕超, 等. 区块链与可信数据管理: 问题与方法. 软件学报, 2018, 29 (1): 150- 159.
11	蔡磊, 朱燕超, 郭庆兴, 等. 面向区块链的高效物化视图维护和可信查询. 软件学报, 2020, 31 (3): 680- 694.
12	SHARMA A, SCHUHKNECHT F M, AGRAWAL D, et al. Blurring the lines between blockchains and database systems: The case of hyperledger fabric [C]//SIGMOD Conference. 2019: 105-122.
13	RUAN P, CHEN G, DINH T T A, et al. Finegrained, secure and efficient data provenance on blockchain systems. Proceedings of the VLDB Endowment, 2019, 12 (11): 975- 988.
14	WANG J, WANG H. Monoxide: Scale out blockchains with asynchronous consensus zones [C]//USENIX Symposium on Networked Systems Design and Implementation. 2019: 95-112.
15	DANG H, DINH T T A, LOGHIN D, et al. Towards scaling blockchain systems via sharding [C]//SIGMOD Conference. 2019: 123-140.
16	WANG H, XU C, ZHANG C, et al. Vchain: A blockchain system ensuring query integrity [C]//Proceedings of the 2020 International Conference on Management of Data. 2020: 2693-2696.
17	AMIRI M J, AGRAWAL D, ABBADI A E. CAPER: A cross-application permissioned blockchain. Proceedings of the VLDB Endowment, 2019, 12 (11): 1385- 1398. doi: 10.14778/3342263.3342275
18	XU Z, HAN S, CHEN L. Cub, aconsensusunit-based storage scheme for blockchain system [C]//34th IEEE International Conference on Data Engineering. 2018: 173-184.
19	ZHANG C, XU C, XU J, et al. Gem²-tree: A gas-efficient structure for authenticated range queries in blockchain [C]//35th IEEE International Conference on Data Engineering. 2019: 842-853.
20	WANG S, DINH T T A, LIN Q, et al. Forkbase: An efficient storage engine for blockchain and forkable applications. Proceedings of the VLDB Endowment, 2018, 11 (10): 1137- 1150. doi: 10.14778/3231751.3231762
21	AL-BASSAM M, SONNINO A, BANO S, et al. Chainspace: A sharded smart contracts platform [C]//25th Annual Network and Distributed System Security Symposium: abs/1708.03778. 2018.

SQL语句	功能	数据处理
CREATE/ALTER	数据建模	创建/更新Schema
INSERT	数据上链	检查数据属性
SELECT	数据查询	解析交易字段

方法	功能描述
Read(k)→v	根据交易哈希/块高读取区块链中的交易
Write(v)→tx-hash	将交易发往区块链, 返回交易哈希
Check(tx-hash)→tx-state	根据交易哈希查询区块链交易状态

序号	SQL语句
C	CREATE TABLE INVOICE (invoiceno varchar(255), clientname varchar(255), amount varchar(255), date date);
I	INSERT INTO INVOICE VALUES (‘IN00001’, ‘Alice’, ‘10000’, ‘2021-01-01’);
Q	SELECT * FROM INVOICE WHERE invoiceno = ‘IN00001’;

[1]	Shaojie QIAO, Yuhe JIANG, Chenxu LIU, Cheqing JIN, Nan HAN, Shuaiwei HE. Algorithm for security management and privacy protection of education big data based on smart contracts [J]. Journal of East China Normal University(Natural Science), 2024, 2024(5): 128-140.
[2]	Danqi LIU, Peng CAI. Separate management strategies for Part metadata under the storage-computing separation architecture [J]. Journal of East China Normal University(Natural Science), 2023, 2023(5): 40-50.
[3]	Xinjun ZHENG, Guoliang TIAN, Feihu HUANG. A multimode data management method based on Data Fabric [J]. Journal of East China Normal University(Natural Science), 2023, 2023(5): 164-181.
[4]	Chaoran HUANG, Xing TONG, Zhao ZHANG, Cheqing JIN, Yingjie YANG, Gang QIN. Research on contract architecture and data privacy for education-oriented blockchain applications [J]. Journal of East China Normal University(Natural Science), 2022, 2022(5): 61-72.
[5]	Yingjie YANG, Gang QIN, Shugang CHEN, Furong YIN, Zhao ZHANG, Cheqing JIN. Development and application of blockchain-based inspection certificates in the steel supply chain [J]. Journal of East China Normal University(Natural Science), 2022, 2022(5): 36-47.
[6]	Yuchen HONG, Yiming YU, Ye WANG, Qiwen DONG. Data application system for multi-source data-aided materialresearch and development [J]. Journal of East China Normal University(Natural Science), 2022, 2022(5): 14-25.
[7]	Furong YIN, Chengyu ZHU, Bin ZHAO, Zhao ZHANG. Erasure code partition storage based on the CITA blockchain [J]. Journal of East China Normal University(Natural Science), 2021, 2021(5): 48-59.
[8]	XIAO Dalong, ZHANG Jingwei, YANG Qing, ZHOU Ya. A method for community contribution incentives based on ethereum [J]. Journal of East China Normal University(Natural Science), 2020, 2020(6): 82-89.
[9]	HUANG Libo, WANG Wei, XU Yanjun, CHEN Xugang. A certificate management system for the completion of online education based on blockchain technology [J]. Journal of East China Normal University(Natural Science), 2020, 2020(6): 72-81.
[10]	LIU Feng, YANG Jie, LI Zhibin, QI Jiayin. Research on an endogenous data interaction protocol for the dual-middle platform and dual-chain architecture [J]. Journal of East China Normal University(Natural Science), 2020, 2020(5): 44-55.
[11]	GAO Yichen, ZHAO Bin, ZHANG Zhao. Research and implementation of a smart automatic contract generation method for Ethereum [J]. Journal of East China Normal University(Natural Science), 2020, 2020(5): 21-32.
[12]	TANG Hai-bo, LIN Yu-ming, LI You. A K-Means based clustering algorithm with balanced constraints [J]. Journal of East China Normal University(Natural Sc, 2018, 2018(5): 164-171.
[13]	QI Xue-cheng, ZHU Yan-chao, SHAO Qi-feng, ZHANG Zhao, JIN Che-qing. A warehouse receipt management system based on blockchain technology [J]. Journal of East China Normal University(Natural Sc, 2018, 2018(5): 144-153.
[14]	TIAN Fu-liang, TIAN Xiu-xia, CHEN Xi. Blockchain-based smart meter authentication scheme [J]. Journal of East China Normal University(Natural Sc, 2018, 2018(5): 135-143,171.
[15]	ZHANG Wen-Jie, PENG Zhi-Yong, PENG Yu-Wei. Application of inmemory data management technology in genealogy information system [J]. Journal of East China Normal University(Natural Sc, 2014, 2014(5): 311-319.