ISEDJ

Information Systems Education Journal

Volume 17

V17 N4 Pages 24-41

August 2019


Storing and Querying Blockchain using SQL Databases


Kwok-Bun Yue
University of Houston - Clear Lake
Houston, TX 77058, USA

Karthika Chandrasekar
University of Houston - Clear Lake
Houston, TX 77058, USA

Hema Gullapalli
University of Houston - Clear Lake
Houston, TX 77058, USA


Abstract: Bitcoin is the first major decentralized cryptocurrency with wide acceptance. A core technological innovation of Bitcoin is blockchain, a secure and pseudonymous general ledger that stores every Bitcoin transaction. Blockchain has received enormous attention from both the commercial and academic worlds, and it is generally recognized as the enabling technology of the Internet of Value (IoV), in which securely stored valuable entities are intended to be transferred as easily as information. Current blockchains are designed as special kinds of Online Transaction Processing (OLTP) systems, but not Online Analytical Processing (OLAP) systems. Data analytics by querying the blockchain directly can be ineffective. To incorporate the increasingly important blockchain technology into Information Systems curriculum, one approach is to store the blockchain in a SQL database, thus allowing fast data access and an easier understanding of the underlying concepts. This paper describes our experiment of using three different methods for accessing Bitcoin data from SQL databases. It elaborates an assignment of querying a Bitcoin’s SQL database in an undergraduate database course. The paper discusses our experience on using SQL databases for blockchain analysis, elaborates the characteristics of Bitcoin blockchain that make it an interesting database case, examines the relative merits of the three different methods, and provides suggestions on how they may be used in IS courses. Overall, we find that using SQL to query blockchains can be an effective educational technique for introducing it to IS curriculum.

Keywords: Bitcoin, Blockchain, Data analytics, Database, query, SQL

Download this article: ISEDJ - V17 N4 Page 24.pdf


Recommended Citation: Yue, K., Chandrasekar, K., Gullapalli, H. (2019). Storing and Querying Blockchain using SQL Databases Information Systems Education Journal, 17(4) pp 24-41. http://isedj.org/2019-17/ ISSN: 1545-679X. (A preliminary version appears in The Proceedings of EDSIGCON 2018)