aChain: A SQL-Empowered Analytical Blockchain as a Database

Yuchao Wang

doi:10.1109/TC.2023.3287036

aChain: A SQL-Empowered Analytical Blockchain as a Database

2023-11-01

0

PRE

AI

DOI：10.1109/TC.2023.3287036

Original

Original request for help

Save

Abstract

En 中文

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.

Keywords:

Blockchain

relational storage of on-chain data

relational APIs

OLAP service

aChain: A SQL-Empowered Analytical Blockchain as a Database

Abstract

Journal

Organization