aChain: A SQL-Empowered Analytical Blockchain as a Database

Yuchao Wang, Yanguo Peng, Ximeng Liu, Zuobin Ying, Jiangtao Cui, Dongyao Niu, Xiaofang Xia

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.