Loading [a11y]/accessibility-menu.js
aChain: A SQL-Empowered Analytical Blockchain as a Database | IEEE Journals & Magazine | IEEE Xplore

aChain: A SQL-Empowered Analytical Blockchain as a Database


Abstract:

In various multi-party cooperations data stored on blockchains (i.e., on-chain data) should be decentralized consistent, verifiable, traceable, and immutable. Online anal...Show More

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.
Published in: IEEE Transactions on Computers ( Volume: 72, Issue: 11, November 2023)
Page(s): 3099 - 3112
Date of Publication: 16 June 2023

ISSN Information:

Funding Agency:


Contact IEEE to Subscribe

References

References is not available for this document.