Design and Implementation of Enabling SQL–Query Processing for Ethereum-Based Blockchain Systems
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).
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}
}
EUVIMED