Using a Hybrid Approach to Data Management in Relational Database and Blockchain: a Case Study on The E-health Domain

Marinho, S. S. Carlos; Filho, José Silveira; Moreira, Leonardo O.; Machado, Javam C.

doi:10.1109/icsa-c50368.2020.00030

Cited by 6 publications

(3 citation statements)

References 12 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The original work [Marinho et al 2020] introduces MOON, while this work introduces Inter-MOON, an extension of MOON focused on improving interoperability between relational and blockchain-based DBs through middleware using a subset of SQL syntax. While both works share a similar core architecture, some key differences exist.…”

Section: Related Workmentioning

confidence: 99%

“…The approach to data Management on relatiOnal database and blOckchaiN (MOON) [Marinho et al 2020] is a tool meant to act as a singular entry-point for database queries by applications using both blockchain-based and relational databases. Queries are written in SQL syntax, analyzed and mapped by MOON's middleware, and then executed using either the relational or blockchain-based environments.…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Improving Interoperability between Relational and Blockchain-based Database Systems: A Middleware approach

Sá,

Moreira,

Machado

2023

Anais Do XXXVIII Simpósio Brasileiro De Banco De Dados (SBBD 2023)

View full text Add to dashboard Cite

Multi-model, federated and polystore architectures allow for querying data from different sources through a unified interface, providing interoperability for databases. However, support for blockchain-based databases remains scarce. MOON is a middleware designed to enable cross-model querying of data in relational and blockchain databases through standard SQL syntax. This paper aims to promote the interoperability of blockchain-based and relational database systems through a new approach, called Inter-MOON. Through experimentation, Inter-MOON was found to offer near-total support for SQL DML query syntax, be up to 10x faster than MOON, and show comparable performance to similar tools.

show abstract

Section: Related Workmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

Improving Interoperability between Relational and Blockchain-based Database Systems: A Middleware approach

Sá,

Moreira,

Machado

2023

Anais Do XXXVIII Simpósio Brasileiro De Banco De Dados (SBBD 2023)

View full text Add to dashboard Cite

show abstract

“…For example, Carlos S. S. Marinho. et al [39] proposed a hybrid approach called MOON to manage data in relational database and blockchain, which receives SQL queries. Zhu.…”

Section: Related Workmentioning

confidence: 99%

TDRB: An Efficient Tamper-Proof Detection Middleware for Relational Database Based on Blockchain Technology

2021

View full text Add to dashboard Cite

The relational database has become one of the mainstream tools for data storage and management. However, there are two main types of threats to relational databases: external attacks and internal tampering threats. In this paper, we focus on the internal tampering threats and propose a tamper-proof detection middleware named TDRB to provide efficient tamper-proof detection for relational databases. Within the TDRB middleware framework, raw data is still stored and queried from the relational database, while the hash digest of the critical data in the relational database is synchronously migrated to the blockchain for tamper detection. Based on this method, we leverage blockchain's immutability to detect data tamper and maintain the advanced features of relational databases to better support ease of data persistence, complex queries, and large storage capacity. We also propose a performance improvement mechanism that involves connecting the blockchain and relational database to improve throughput and mitigate performance impact. A series of experiments indicate that the TDRB middleware can accurately detect the tampering information during arbitrary tampering with the relational database and the cache database. Compare with the baseline, with the increase of cache hit rate, the TDRB middleware query speed increased by 93.1%, update speed increased by 16.3%, delete speed increased by 16.1%, and join operation average speed increased by 95.2%. Given its generality, the TDRB middleware can be flexibly and conveniently integrated into third-party platforms.

show abstract

A Preliminary Review on Complementary Applications of Databases and Blockchain Technology

Kramberger

Welzer

Kamišalić

2021

Blockchain and Applications

View full text Add to dashboard Cite

Using a Hybrid Approach to Data Management in Relational Database and Blockchain: a Case Study on The E-health Domain

Cited by 6 publications

References 12 publications

Improving Interoperability between Relational and Blockchain-based Database Systems: A Middleware approach

Improving Interoperability between Relational and Blockchain-based Database Systems: A Middleware approach

TDRB: An Efficient Tamper-Proof Detection Middleware for Relational Database Based on Blockchain Technology

A Preliminary Review on Complementary Applications of Databases and Blockchain Technology

Contact Info

Product

Resources

About