aChain: A SQL-Empowered Analytical Blockchain as a Database
Authors: 
Yuchao Wang, Yanguo Peng, Ximeng Liu, Zuobin Ying, Jiangtao Cui, Dongyao Niu, Xiaofang XiaAuthors Info & Claims
Pages 3099 - 3112
Abstract
In various multi-party cooperations data stored on blockchains (i.e., on-chain data) should be decentralized consistent, verifiable, traceable, and immutable. Online analytical processing (OLAP) services are critical requirements in these applications. However, OLAP performances of existing blockchain systems are much worse than those of relational databases due to the lack of SQL support. In this paper, we propose a novel SQL-empowered analytical blockchain framework, aChain. It fully provides SQL-based OLAP services, while keeping the secure characteristics. Specifically, aChain relationally reorganizes on-chain data to support full SQL executions. Then, a relational versioning scheme is designed to ensure the atomicity and consistency of transactions. Furthermore, SQL-based APIs are designed based on an execute-order-validate architecture. Finally, we demonstrate that the performance of aChain and MySQL (in both cluster and non-cluster models) is at the same level on a typical OLAP benchmark, TPC-H.
References
[1]
J. Huang, L. Kong, G. Chen, M. Wu, X. Liu, and P. Zeng, “Towards secure industrial IoT: Blockchain system with credit-based consensus mechanism,” IEEE Trans. Ind. Informat., vol. 15, no. 6, pp. 3680–3689, Jun. 2019.
[2]
V. Hassija, G. Bansal, V. Chamola, N. Kumar, and M. Guizani, “Secure lending: Blockchain and prospect theory-based decentralized credit scoring model,” IEEE Trans. Netw. Sci. Eng., vol. 7, no. 4, pp. 2566–2575, Fourth Quarter 2020.
[3]
C. Yang and Z. Sun, “Data management system based on blockchain technology for agricultural supply chain,” in Proc. IEEE 20th Int. Conf. Data Mining Workshops, Sorrento, Italy, 2020, pp. 907–911.
[4]
G. Le, Q. Gu, Q. Jiang, and W. Lin, “TrustedChain: A blockchain-based data sharing scheme for supply chain,” in Proc. IEEE 20th Int. Conf. Data Mining Workshops, Sorrento, Italy, 2020, pp. 895–901.
[5]
S. Nakamoto et al., “Bitcoin: A peer-to-peer electronic cash system,” 2008. [Online]. Available: http://bitcoin.org/bitcoin.pdf
[6]
G. Wood et al., “Ethereum: A secure decentralised generalised transaction ledger,” Ethereum Project Yellow Paper, vol. 151, no. 2014, pp. 1–32, 2014.
[7]
Y. Yan et al., “Confidentiality support over financial grade consortium blockchain,” in Proc. Int. Conf. Manage. Data, Portland, OR, USA, 2020, pp. 2227–2240.
[8]
A. Norta, B. Leiding, and A. Lane, “Lowering financial inclusion barriers with a blockchain-based capital transfer system,” in Proc. IEEE Conf. Comput. Commun. Workshops, Paris, France, 2019, pp. 319–324.
[9]
T. McConaghy et al., “BigchainDB: A scalable blockchain database,” White Paper, BigChainDB, 2016. [Online]. Available: https://gamma.bigchaindb.com/whitepaper/bigchaindb-whitepaper.pdf
[10]
Wolk SWARMDB: Decentralized database services for web3, Work Inc., 2017. [Online]. Available: https://openset.com/whitepaper/WolkTokenGenerationEvent-20170717.pdf
[11]
Y. Peng, M. Du, F. Li, R. Cheng, and D. Song, “FalconDB: Blockchain-based collaborative database,” in Proc. Int. Conf. Manage. Data, Portland, OR, USA, 2020, pp. 637–652.
[12]
Y. Li, K. Zheng, Y. Yan, Q. Liu, and X. Zhou, “EtherQL: A query layer for blockchain system,” in Proc. 22nd Int. Conf. Database Syst. Adv. Appl., Suzhou, China, 2017, pp. 556–567.
[13]
M. Muzammal, Q. Qu, and B. Nasrulin, “Renovating blockchain with distributed databases: An open source system,” Future Gener. Comput. Syst., vol. 90, pp. 105–117, 2019.
[14]
Y. Zhu, Z. Zhang, C. Jin, A. Zhou, and Y. Yan, “SEBDB: Semantics empowered blockchain database,” in Proc. IEEE 35th Int. Conf. Data Eng., Macao, China, 2019, pp. 1820–1831.
[15]
C. Xu, C. Zhang, and J. Xu, “vChain: Enabling verifiable Boolean range queries over blockchain databases,” in Proc. Int. Conf. Manage. Data, Amsterdam, The Netherlands, 2019, pp. 141–158.
[16]
M. El-Hindi, C. Binnig, A. Arasu, D. Kossmann, and R. Ramamurthy, “BlockchainDB - A shared database on blockchains,” in Proc. VLDB Endowment, vol. 12, no. 11, pp. 1597–1609, 2019.
[17]
S. Cohen, A. Rosenthal, and A. Zohar, “Reasoning about the future in blockchain databases,” in Proc. IEEE 36th Int. Conf. Data Eng., Dallas, TX, USA, 2020, pp. 1930–1933.
[18]
V. Ermolaev, I. Klangberg, Y. Madhwal, S. Vapper, S. Wels, and Y. Yanovich, “Incorruptible auditing: Blockchain-powered graph database management,” in Proc. IEEE Int. Conf. Blockchain Cryptocurrency, Toronto, ON, Canada, 2020, pp. 1–3.
[19]
E. Androulaki et al., “Hyperledger fabric: A distributed operating system for permissioned blockchains,” in Proc. 13th EuroSys Conf., 2018, pp. 30:1–30:15.
[20]
P. Ruan, D. Loghin, Q. Ta, M. Zhang, G. Chen, and B. C. Ooi, “A transactional perspective on execute-order-validate blockchains,” in Proc. Int. Conf. Manage. Data, Portland, OR, USA, 2020, pp. 543–557.
[21]
A. Sharma, F. M. Schuhknecht, D. Agrawal, and J. Dittrich, “Blurring the lines between blockchains and database systems: The case of hyperledger fabric,” in Proc. Int. Conf. Manage. Data, Amsterdam, The Netherlands, 2019, pp. 105–122.
[22]
S. Nathan, C. Govindarajan, A. Saraf, M. Sethi, and P. Jayachandran, “Blockchain meets database: Design and implementation of a blockchain relational database,” in Proc. VLDB Endowment, vol. 12, no. 11, pp. 1539–1552, 2019.
[23]
E. Brewer, “CAP twelve years later: How the ‘rules’ have changed,” Computer, vol. 45, no. 2, pp. 23–29, 2012.
[24]
A. Miller, Y. Xia, K. Croman, E. Shi, and D. Song, “The honey badger of BFT protocols,” in Proc. ACM SIGSAC Conf. Comput. Commun. Secur., E. R. Weippl, S. Katzenbeisser, C. Kruegel, A. C. Myers, and S. Halevi, Eds., Vienna, Austria, 2016, pp. 31–42. [Online]. Available: https://doi.org/10.1145/2976749.2978399
[25]
S. Bergman, M. Asplund, and S. Nadjm-Tehrani, “Permissioned blockchains and distributed databases: A performance study,” Concurrency Computation Pract. Experience., vol. 32, no. 12, 2020, Art. no.
[26]
T. T. A. Dinh, J. Wang, G. Chen, R. Liu, B. C. Ooi, and K. Tan, “BLOCKBENCH: A framework for analyzing private blockchains,” in Proc. ACM Int. Conf. Manage. Data, Chicago, IL, USA, 2017, pp. 1085–1100.
Index Terms
- aChain: A SQL-Empowered Analytical Blockchain as a Database
Index terms have been assigned to the content through auto-classification.
Comments
Please enable JavaScript to view thecomments powered by Disqus.Information & Contributors
Information
Published In
0018-9340 © 2023 IEEE. Personal use is permitted, but republication/redistribution requires IEEE permission. See https://www.ieee.org/publications/rights/index.html for more information.
Publisher
IEEE Computer Society
United States
Publication History
Published: 01 November 2023
Qualifiers
- Research-article
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- 0Total Citations
- 0Total Downloads
- Downloads (Last 12 months)0
- Downloads (Last 6 weeks)0
Reflects downloads up to 26 Jan 2025