Storing and Querying Bitcoin Blockchain Using SQL Databases

Item request has been placed! ×
Item request cannot be made. ×
  Processing Request
  • Source:
    Information Systems Education Journal, v17 n4 p24-41 Aug 2019. 18 pp.
  • Language:
    English
  • Publication Type:
    Journal Articles; Reports - Evaluative
  • Additional Information
    • Author(s):
    • Availability:
      Full Text from ERIC Available online: https://eric.ed.gov/contentdelivery/servlet/ERICServlet?accno=EJ1219543
      Information Systems and Computing Academic Professionals. Box 488, Wrightsville Beach, NC 28480. e-mail: publisher@isedj.org; Web site: http://isedj.org
    • Peer Reviewed:
      Y
    • ISSN:
      1545-679X
    • Subject Terms:
    • 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.
    • Abstract:
      As Provided
    • Number of References:
      -1
    • Physical Description:
      18
    • Education Level:
      Higher Education; Postsecondary Education
    • Journal Code:
      SEP2019
    • Publication Date:
      2019
    • Accession Number:
      EJ1219543
  • Citations
    • ABNT:
      YUE, K.-B.; CHANDRASEKAR, K.; GULLAPALLI, H. Storing and Querying Bitcoin Blockchain Using SQL Databases. Information Systems Education Journal, [s. l.], v. 17, n. 4, p. 24–41, 2019. Disponível em: . Acesso em: 18 nov. 2019.
    • AMA:
      Yue K-B, Chandrasekar K, Gullapalli H. Storing and Querying Bitcoin Blockchain Using SQL Databases. Information Systems Education Journal. 2019;17(4):24-41. http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=eric&AN=EJ1219543&custid=s8280428. Accessed November 18, 2019.
    • APA:
      Yue, K.-B., Chandrasekar, K., & Gullapalli, H. (2019). Storing and Querying Bitcoin Blockchain Using SQL Databases. Information Systems Education Journal, 17(4), 24–41. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=eric&AN=EJ1219543&custid=s8280428
    • Chicago/Turabian: Author-Date:
      Yue, Kwok-Bun, Karthika Chandrasekar, and Hema Gullapalli. 2019. “Storing and Querying Bitcoin Blockchain Using SQL Databases.” Information Systems Education Journal 17 (4): 24–41. http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=eric&AN=EJ1219543&custid=s8280428.
    • Harvard:
      Yue, K.-B., Chandrasekar, K. and Gullapalli, H. (2019) ‘Storing and Querying Bitcoin Blockchain Using SQL Databases’, Information Systems Education Journal, 17(4), pp. 24–41. Available at: http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=eric&AN=EJ1219543&custid=s8280428 (Accessed: 18 November 2019).
    • Harvard: Australian:
      Yue, K-B, Chandrasekar, K & Gullapalli, H 2019, ‘Storing and Querying Bitcoin Blockchain Using SQL Databases’, Information Systems Education Journal, vol. 17, no. 4, pp. 24–41, viewed 18 November 2019, .
    • MLA:
      Yue, Kwok-Bun, et al. “Storing and Querying Bitcoin Blockchain Using SQL Databases.” Information Systems Education Journal, vol. 17, no. 4, Aug. 2019, pp. 24–41. EBSCOhost, search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=eric&AN=EJ1219543&custid=s8280428.
    • Chicago/Turabian: Humanities:
      Yue, Kwok-Bun, Karthika Chandrasekar, and Hema Gullapalli. “Storing and Querying Bitcoin Blockchain Using SQL Databases.” Information Systems Education Journal 17, no. 4 (August 1, 2019): 24–41. http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=eric&AN=EJ1219543&custid=s8280428.
    • Vancouver/ICMJE:
      Yue K-B, Chandrasekar K, Gullapalli H. Storing and Querying Bitcoin Blockchain Using SQL Databases. Information Systems Education Journal [Internet]. 2019 Aug 1 [cited 2019 Nov 18];17(4):24–41. Available from: http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=eric&AN=EJ1219543&custid=s8280428