EtherQL: A Query Layer for Blockchain System

  • Yang Li
  • Kai ZhengEmail author
  • Ying Yan
  • Qi Liu
  • Xiaofang Zhou
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 10178)


Blockchain - the innovation behind Bitcoin - enables people to exchange digital money with complete trust, and seems to be completely transforming the way we think about trust. While blockchain is designed for secured, immutable funds transfer in trustless and decentralized environment, the underlying storage of blockchain is very simple with only limited supports for data access. Moreover, blockchain data are highly compressed before flushing to hard disk, making it harder to have an insight of these valuable data set. In this work, we develop EtherQL, an efficient query layer for Ethereum – the most representative open-source blockchain system. EtherQL provides highly efficient query primitives for analyzing blockchain data, including range queries and top-k queries, which can be integrated with other applications with much flexibility. Moreover, EtherQL is designed to provide different levels of abstraction, which are suitable for data analysts, researchers and application developers.


Range Query Block Data Query Interface Hash Code Analytical Query 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.



This work is partially supported by NSFC 61502324, 61532018.


  1. 1.
  2. 2.
  3. 3.
  4. 4.
  5. 5.
  6. 6.
  7. 7.
    Bahga, A., Madisetti, V.K.: Blockchain platform for industrial Internet of Things. J. Softw. Eng. Appl. 9(10), 533 (2016)CrossRefGoogle Scholar
  8. 8.
    Buechler, M., Eerabathini, M., Hockenbrocht, C., Wan, D.: Decentralized reputation system for transaction networks. Technical report, University of Pennsylvania (2015)Google Scholar
  9. 9.
  10. 10.
    Buterin, V., et al.: Ethereum white paper (2013)Google Scholar
  11. 11.
    Castro, M., Liskov, B.: Practical byzantine fault tolerance. In: Symposium on Operating Systems Design and Implementation, pp. 173–186 (1999)Google Scholar
  12. 12.
    Coinbase: Toshi project.
  13. 13.
  14. 14.
    Fleder, M., Kester, M.S., Pillai, S.: Bitcoin transaction graph analysis. arXiv preprint arXiv:1502.01657 (2015)
  15. 15.
    Ethereum Foundation: EthereumJ project.
  16. 16.
    R Foundation: Ripple project.
  17. 17.
    Krishnapriya, G., Prabakaran, M.: An multi-variant relational model for money laundering identification using time series data set. Int. J. Eng. Sci 3, 43–47 (2014)Google Scholar
  18. 18.
    Nakamoto, S.: Bitcoin: a peer-to-peer electronic cash system. Consulted (2009)Google Scholar
  19. 19.
    Ron, D., Shamir, A.: Quantitative analysis of the full bitcoin transaction graph. In: Sadeghi, A.-R. (ed.) FC 2013. LNCS, vol. 7859, pp. 6–24. Springer, Heidelberg (2013). doi: 10.1007/978-3-642-39884-1_2 CrossRefGoogle Scholar
  20. 20.
    Sanjay Ghemawat, J.D.: Leveldb github page.
  21. 21.
  22. 22.
  23. 23.
    Wikipedia: Remote procedure call.
  24. 24.
    Wilkinson, S., Boshevski, T., Brandoff, J., Buterin, V.: Storj: a peer-to-peer cloud storage network (2014)Google Scholar
  25. 25.
    Wood, G.: Ethereum: a secure decentralised generalised transaction ledger. Ethereum Project Yellow Paper (2014)Google Scholar
  26. 26.
    Yue, X., Wang, H., Jin, D., Li, M., Jiang, W.: Healthcare data gateways: found healthcare intelligence on blockchain with novel privacy risk control. J. Med. Syst. 40(10), 218 (2016)Google Scholar

Copyright information

© Springer International Publishing AG 2017

Authors and Affiliations

  • Yang Li
    • 1
  • Kai Zheng
    • 1
    Email author
  • Ying Yan
    • 2
  • Qi Liu
    • 2
  • Xiaofang Zhou
    • 1
    • 3
  1. 1.School of Computer Science and TechnologySoochow UniversitySuzhouChina
  2. 2.Microsoft ResearchBeijingChina
  3. 3.The University of QueenslandBrisbaneAustralia

Personalised recommendations