The Easiest Way of Turning your Relational Database into a Blockchain - and the Cost of Doing So

F. Schuhknecht, Simon Jörz
{"title":"The Easiest Way of Turning your Relational Database into a Blockchain - and the Cost of Doing So","authors":"F. Schuhknecht, Simon Jörz","doi":"10.48550/arXiv.2210.04484","DOIUrl":null,"url":null,"abstract":"Blockchain systems essentially consist of two levels: The network level has the responsibility of distributing an ordered stream of transactions to all nodes of the network in exactly the same way, even in the presence of a certain amount of malicious parties (byzantine fault tolerance). On the node level, each node then receives this ordered stream of transactions and executes it within some sort of transaction processing system, typically to alter some kind of state. This clear separation into two levels as well as drastically different application requirements have led to the materialization of the network level in form of so-called blockchain frameworks. While providing all the\"blockchain features\", these frameworks leave the node level backend flexible or even left to be implemented depending on the specific needs of the application. In the following paper, we present how to integrate a highly versatile transaction processing system, namely a relational DBMS, into such a blockchain framework. As framework, we use the popular Tendermint Core, now part of the Ignite/Cosmos eco-system, which can run both public and permissioned networks and combine it with relational DBMSs as the backend. This results in a\"relational blockchain\", which is able to run deterministic SQL on a fully replicated relational database. Apart from presenting the integration and its pitfalls, we will carefully evaluate the performance implications of such combinations, in particular, the throughput and latency overhead caused by the blockchain layer on top of the DBMS. As a result, we give recommendations on how to run such a systems combination efficiently in practice.","PeriodicalId":421643,"journal":{"name":"Datenbanksysteme für Business, Technologie und Web","volume":"12 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2022-10-10","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Datenbanksysteme für Business, Technologie und Web","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.48550/arXiv.2210.04484","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0

Abstract

Blockchain systems essentially consist of two levels: The network level has the responsibility of distributing an ordered stream of transactions to all nodes of the network in exactly the same way, even in the presence of a certain amount of malicious parties (byzantine fault tolerance). On the node level, each node then receives this ordered stream of transactions and executes it within some sort of transaction processing system, typically to alter some kind of state. This clear separation into two levels as well as drastically different application requirements have led to the materialization of the network level in form of so-called blockchain frameworks. While providing all the"blockchain features", these frameworks leave the node level backend flexible or even left to be implemented depending on the specific needs of the application. In the following paper, we present how to integrate a highly versatile transaction processing system, namely a relational DBMS, into such a blockchain framework. As framework, we use the popular Tendermint Core, now part of the Ignite/Cosmos eco-system, which can run both public and permissioned networks and combine it with relational DBMSs as the backend. This results in a"relational blockchain", which is able to run deterministic SQL on a fully replicated relational database. Apart from presenting the integration and its pitfalls, we will carefully evaluate the performance implications of such combinations, in particular, the throughput and latency overhead caused by the blockchain layer on top of the DBMS. As a result, we give recommendations on how to run such a systems combination efficiently in practice.
查看原文
分享 分享
微信好友 朋友圈 QQ好友 复制链接
本刊更多论文
将关系数据库转换为bbb的最简单方法-以及这样做的成本
区块链系统本质上由两层组成:网络层负责以完全相同的方式将有序的交易流分发到网络的所有节点,即使存在一定数量的恶意方(拜占庭容错)。在节点级别上,每个节点接收这个有序的事务流,并在某种事务处理系统中执行它,通常是为了改变某种状态。这种明确划分为两个级别以及截然不同的应用需求导致了网络级别以所谓的区块链框架的形式实现。在提供所有“区块链特性”的同时,这些框架使节点级后端保持灵活,甚至可以根据应用程序的特定需求来实现。在下面的文章中,我们将介绍如何将一个高度通用的事务处理系统(即关系DBMS)集成到这样的区块链框架中。作为框架,我们使用了流行的Tendermint Core,它现在是Ignite/Cosmos生态系统的一部分,它可以运行公共和许可网络,并将其与关系dbms结合起来作为后端。这就产生了一个“关系区块链”,它能够在一个完全复制的关系数据库上运行确定性SQL。除了介绍集成及其缺陷之外,我们还将仔细评估这种组合的性能影响,特别是由DBMS之上的区块链层引起的吞吐量和延迟开销。最后,就如何在实践中有效地运行这一系统组合提出了建议。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
求助全文
约1分钟内获得全文 去求助
来源期刊
自引率
0.00%
发文量
0
期刊最新文献
SportsTables: A new Corpus for Semantic Type Detection Accelerating Large Table Scan using Processing-In-Memory Technology The InsightsNet Climate Change Corpus (ICCC) On the State of German (Abstractive) Text Summarization The Easiest Way of Turning your Relational Database into a Blockchain - and the Cost of Doing So
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
现在去查看 取消
×
提示
确定
0
微信
客服QQ
Book学术公众号 扫码关注我们
反馈
×
意见反馈
请填写您的意见或建议
请填写您的手机或邮箱
已复制链接
已复制链接
快去分享给好友吧!
我知道了
×
扫码分享
扫码分享
Book学术官方微信
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术
文献互助 智能选刊 最新文献 互助须知 联系我们:info@booksci.cn
Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。
Copyright © 2023 Book学术 All rights reserved.
ghs 京公网安备 11010802042870号 京ICP备2023020795号-1