Smart-Views: Decentralized OLAP View Management using Blockchains

Collaborators

Petros Demetrakopoulos, Kostas Messanakis, Yannis Kotidis.

About

In this work we explore the use of a blockchain as an immutable ledger for storing historical facts in a decentralized data warehouse. We also exploit the ledger for storing definitions of aggregate data cube computations over these facts, in the form of smart contracts. These smart contracts define smart views that encapsulate frequently requested aggregations. We propose a modular architecture in which computations defined by the smart contacts are passed to suitable data processing engines. On each node, a smart view cache is also utilized, in the form of an in-memory database, so that frequently requested aggregates can be delivered with small latency. We explore techniques that model and take into consideration existing interdependencies between the smart views to expedite their computation and maintenance. We also propose efficient algorithms for managing the content of the smart views.

Architecture

 

Diagram

Description automatically generated

Publications

[1] Smart-Views: Decentralized OLAP View Management using Blockchains: K. Messanakis, P. Demetrakopoulos, Y. Kotidis. In Proceedings of the 23rd International Conference on Big Data Analytics and Knowledge Discovery (DaWaK 2021), September 27-30, Linz, Austria, 2021.

Code

https://github.com/petrosDemetrakopoulos/SmartViews