EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

Design and Implementation of Enabling SQL–Query Processing for Ethereum-Based Blockchain Systems

Jongbeen Han, Yunhyeong Seo, Sangjin Lee, Sunggon Kim, Yongseok Son

Electronics · 18.10.2023 · 12 (20) · 4317

DOI: 10.3390/electronics12204317 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Electronics, online erschienen am 18.10.2023. Verfasst von Jongbeen Han und 4 weiteren Autor:innen. Die Arbeit wurde bisher 12-mal zitiert (Crossref) und nennt 33 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0). Gefördert von: National Research Foundation of Korea (NRF).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

A blockchain is designed to establish consistent and reliable agreements in an untrusted and decentralized environment. In addition, the blockchain enables transaction processing and the creation of smart contracts. It empowers end users to execute contracts without any intermediate entities. However, there are some issues when it comes to retrieving information, such as the state and history of smart contracts and regular transactions in the blockchain. For example, in a smart contract, user-defined data structures can be used to recall the state of the smart contract for a range query, which can decrease the general performance. In addition, an external database can be required to retrieve regular transactions for range queries, which increases management costs. To achieve this, we propose a new scheme that enables SQL query operations to retrieve a smart contract and regular transaction information within the blockchain system. To achieve this, we combine an embedded relational database with an Ethereum-based blockchain system to provide the SQL query. It enables range queries on smart contracts without requiring user-defined data structures and decreases management costs for regular transactions without any external database. We implement the proposed blockchain system on quorum, which is an Ethereum-based blockchain system. Also, we evaluate the proposed system using a synthetic benchmark. The performance of retrieving smart contract data is improved by up to approximately 22×, with low memory usage compared with the existing system. Moreover, the proposed system demonstrates a similar search performance to the existing system, even when considering external databases in regular transactions.

Förderung

  • National Research Foundation of Korea (NRF)

Zitieren

APA

Han, J., Seo, Y., Lee, S., Kim, S., & Son, Y. (2023). Design and Implementation of Enabling SQL–Query Processing for Ethereum-Based Blockchain Systems. Electronics, 12(20), 4317. https://doi.org/10.3390/electronics12204317

Vancouver

Han J, Seo Y, Lee S, Kim S, Son Y. Design and Implementation of Enabling SQL–Query Processing for Ethereum-Based Blockchain Systems. Electronics. 2023;12(20):4317. doi:10.3390/electronics12204317

BibTeX
@article{Han2023,
  author = {Han, Jongbeen and Seo, Yunhyeong and Lee, Sangjin and Kim, Sunggon and Son, Yongseok},
  title = {Design and Implementation of Enabling SQL–Query Processing for Ethereum-Based Blockchain Systems},
  journal = {Electronics},
  year = {2023},
  volume = {12},
  number = {20},
  pages = {4317},
  doi = {10.3390/electronics12204317}
}
Kostenlos starten →