Storing and Querying Bitcoin Blockchain Using SQL Databases

Autor/inn/en	Yue, Kwok-Bun; Chandrasekar, Karthika; Gullapalli, Hema
Titel	Storing and Querying Bitcoin Blockchain Using SQL Databases
Quelle	In: Information Systems Education Journal, 17 (2019) 4, S.24-41 (18 Seiten) PDF als Volltext kostenfreie Datei Verfügbarkeit
Sprache	englisch
Dokumenttyp	gedruckt; online; Zeitschriftenaufsatz
ISSN	1545-679X
Schlagwörter	Monetary Systems; Information Storage; Databases; Technological Advancement; Programming Languages; Undergraduate Students; Introductory Courses; Computer Science Education; Information Systems + Suchen Sie Ihr Suchwort? Monetary system; Währungssystem; Informationsspeicherung; Datenbank; Technological development; Technologische Entwicklung; Einführungskurs; Computer science lessons; Informatikunterricht
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 blockchain data in a SQL database, thus allowing fast data access and a simpler understanding of the underlying concepts. This paper describes our experiment of using three different methods for storing and querying 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. (As Provided).
Anmerkungen	Information Systems and Computing Academic Professionals. Box 488, Wrightsville Beach, NC 28480. e-mail: publisher@isedj.org; Web site: http://isedj.org
Erfasst von	ERIC (Education Resources Information Center), Washington, DC
Update	2020/1/01