Skip to main content
SpringerLink
Log in

EtherQL: A Query Layer for Blockchain System

  • Conference paper
  • First Online:
Book cover Database Systems for Advanced Applications (DASFAA 2017)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 10178))

Included in the following conference series:

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    https://github.com/LeonSpark/EtherQL.

References

  1. Blockchain.info. https://blockchain.info/

  2. Etherchain. https://etherchain.org/

  3. Ethereum main wiki. https://github.com/ethereum/go-ethereum/wiki

  4. MongoDB. https://www.mongodb.com/

  5. Proof of Stake. https://en.bitcoin.it/wiki/Proof_of_Stake

  6. Proof of Work. https://en.bitcoin.it/wiki/Proof_of_work

  7. Bahga, A., Madisetti, V.K.: Blockchain platform for industrial Internet of Things. J. Softw. Eng. Appl. 9(10), 533 (2016)

    Article  Google Scholar 

  8. Buechler, M., Eerabathini, M., Hockenbrocht, C., Wan, D.: Decentralized reputation system for transaction networks. Technical report, University of Pennsylvania (2015)

    Google Scholar 

  9. Buterin, V.: Merkling in ethereum. https://blog.ethereum.org/2015/11/15/merkling-in-ethereum/

  10. Buterin, V., et al.: Ethereum white paper (2013)

    Google Scholar 

  11. Castro, M., Liskov, B.: Practical byzantine fault tolerance. In: Symposium on Operating Systems Design and Implementation, pp. 173–186 (1999)

    Google Scholar 

  12. Coinbase: Toshi project. https://github.com/coinbase/toshi

  13. EtherScan: EtherScan.io. https://etherscan.io/

  14. Fleder, M., Kester, M.S., Pillai, S.: Bitcoin transaction graph analysis. arXiv preprint arXiv:1502.01657 (2015)

  15. Ethereum Foundation: EthereumJ project. https://github.com/ethereum/ethereumj

  16. R Foundation: Ripple project. https://ripple.com/

  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. Nakamoto, S.: Bitcoin: a peer-to-peer electronic cash system. Consulted (2009)

    Google Scholar 

  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

    Chapter  Google Scholar 

  20. Sanjay Ghemawat, J.D.: Leveldb github page. https://github.com/google/leveldb

  21. Wikipedia: Chain of responsibility. https://en.wikipedia.org/wiki/Chain-of-responsibility_pattern

  22. Wikipedia: Merkle tree. https://en.wikipedia.org/wiki/Merkle_tree

  23. Wikipedia: Remote procedure call. https://en.wikipedia.org/wiki/Remote_procedure_call

  24. Wilkinson, S., Boshevski, T., Brandoff, J., Buterin, V.: Storj: a peer-to-peer cloud storage network (2014)

    Google Scholar 

  25. Wood, G.: Ethereum: a secure decentralised generalised transaction ledger. Ethereum Project Yellow Paper (2014)

    Google Scholar 

  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 

Download references

Acknowledgment

This work is partially supported by NSFC 61502324, 61532018.

Author information

Authors and Affiliations

  1. School of Computer Science and Technology, Soochow University, Suzhou, China

    Yang Li, Kai Zheng & Xiaofang Zhou

  2. Microsoft Research, Beijing, China

    Ying Yan & Qi Liu

  3. The University of Queensland, Brisbane, Australia

    Xiaofang Zhou

Authors
  1. Yang Li
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Kai Zheng
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Ying Yan
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Qi Liu
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Xiaofang Zhou
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Kai Zheng .

Editor information

Editors and Affiliations

  1. Arizona State University, Tempe - Phoenix, Arizona, USA

    Selçuk Candan

  2. of Science and Technology, Hong Kong University of Science and Technology, Hong Kong, China

    Lei Chen

  3. Aalborg University , Aalborg, Denmark

    Torben Bach Pedersen

  4. University of New South Wales , Sydney, New South Wales, Australia

    Lijun Chang

  5. The University of Queensland , Brisbane, Queensland, Australia

    Wen Hua

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Springer International Publishing AG

About this paper

Cite this paper

Li, Y., Zheng, K., Yan, Y., Liu, Q., Zhou, X. (2017). EtherQL: A Query Layer for Blockchain System. In: Candan, S., Chen, L., Pedersen, T., Chang, L., Hua, W. (eds) Database Systems for Advanced Applications. DASFAA 2017. Lecture Notes in Computer Science(), vol 10178. Springer, Cham. https://doi.org/10.1007/978-3-319-55699-4_34

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-55699-4_34

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-55698-7

  • Online ISBN: 978-3-319-55699-4

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation