Query Support for Data Processing and Analysis on Ethereum Blockchain

Blockchain technology has gained immense popularity because many researchers believe that it could solve numerous problems and could be applied in various fields of study. Unfortunately, behind its potentials, blockchain also possessed many challenges and limitations. The highlighted problem is the usability aspect of blockchain technology examined from developer and user perspective. This paper tried to address this problem by proposing query functionalities, with the help of query layer system, to facilitate the developer and the user to access blockchain data easily. There are three main query functionalities that will be discussed in this paper: (1) finding blockchain data based on multiple search parameters (retrieval query), (2) providing simple statistical analysis from a collection of blockchain data (aggregate query) and (3) sorting blockchain data according to its blockchain component (ranking query). For the implementation stage, Ethereum is used as platform to provide blockchain network, MongoDB is used as cloud storage service and REST API is used as web services. For the testing stage, throughput and time response are used to evaluate the performance of the developed query functionalities in the query layer system. The results are: (1) the throughput of query layer system is lower than Ethereum service for blockchain data retrieval and (2) the time response of query layer system is affected by the number of thread and the amount of data stored in cloud storage.