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.
Sign-in/Register to access full text options 
Free) 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
