research-article

Ethereum query language

Authors:

Santiago Bragagnolo,

Henrique Rocha,

Marcus Denker,

Stéphane DucasseAuthors Info & Claims

WETSEB '18: Proceedings of the 1st International Workshop on Emerging Trends in Software Engineering for Blockchain

Pages 1 - 8

https://doi.org/10.1145/3194113.3194114

Published: 27 May 2018 Publication History

Get Access

Abstract

Blockchains store a massive amount of heterogeneous data which will only grow in time. When searching for data on the Ethereum platform, one is required to either access the records (blocks) directly by using a unique identifier, or sequentially search several records to find the desired information. Therefore, we propose the Ethereum Query Language (EQL), a query language that allows users to retrieve information from the blockchain by writing SQL-like queries. The queries provide a rich syntax to specify data elements to search information scattered through several records. We claim that EQL makes it easier to search, acquire, format, and present information from the blockchain.

References

[1]

Massimo Bartoletti, Stefano Lande, Livio Pompianu, and Andrea Bracciali. 2017. A General Framework for Blockchain Analytics. In 1st Workshop on Scalable and Resilient Infrastructures for Distributed Ledgers (SERIAL '17). ACM, New York, NY, USA, Article 7, 6 pages.

Digital Library

Google Scholar

[2]

Karthikeyan Bhargavan, Antoine Delignat-Lavaud, Cédric Fournet, Anitha Gollamudi, Georges Gonthier, Nadim Kobeissi, Natalia Kulatova, Aseem Rastogi, Thomas Sibut-Pinote, Nikhil Swamy, and Santiago Zanella-Béguelin. 2016. Formal Verification of Smart Contracts: Short Paper. In 2016 ACM Workshop on Programming Languages and Analysis for Security (PLAS '16). ACM, New York, NY, USA, 91--96.

Digital Library

Google Scholar

[3]

BitCoin.org. 2018. Bitcoin Developer Reference. Bitcoin Core APIs. (2018). https://bitcoin.org/en/developer-reference#opcodes Bitcoin Project 2009--2018.

Google Scholar

[4]

Ramez Elmasri and Shamkant Navathe. 2010. Fundamentals of Database Systems (6th ed.). Addison-Wesley Publishing Company, USA.

Digital Library

Google Scholar

[5]

Ethereum Foundation. 2014. Ethereum's white paper. (2014). https://en.wikibooks.org/wiki/LaTeX/Bibliography_Management

Google Scholar

[6]

Ethereum Foundation. 2018.JSONRPC. (2018). https://github.com/ethereum/wiki/wiki/JSON-RPC

Google Scholar

[7]

Ethereum Foundation. 2018. Solidity Documentation Release 0.4.20. (2018). https://media.readthedocs.org/pdf/solidity/develop/solidity.pdf

Google Scholar

[8]

Ari Juels, Ahmed Kosba, and Elaine Shi. 2016. The Ring of Gyges: Investigating the Future of Criminal Smart Contracts. In Proceedings of the 2016 ACM SIGSAC Conference on Computerand Communications Security (CCS '16). ACM, New York, NY, USA, 283--295.

Digital Library

Google Scholar

[9]

H. Kalodner, S. Goldfeder, A. Chator, M. Möser, and A. Narayanan. 2017. BlockSci: Design and applications of a blockchain analysis platform. ArXiv e-prints (Sept. 2017). arXiv:cs.CR/1709.02489

Google Scholar

[10]

Loi Luu, Duc-Hiep Chu, Hrishi Olickel, Prateek Saxena, and Aquinas Hobor. 2016. Making Smart Contracts Smarter. In CCS'2016 (ACM Conference on Computer and Communications Security).

Digital Library

Google Scholar

[11]

Satoshi Nakamoto. 2009. BitCoin: A peer-to-peer electronic cash system. (2009). bitcoin.org

Google Scholar

[12]

Russell O'Connor. 2017. Simplicity: A New Language for Blockchains. In Proceedings of the 2017 Workshop on Programming Languages and Analysis for Security (PLAS '17). ACM, New York, NY, USA, 107--120.

Digital Library

Google Scholar

[13]

Simone Porru, Andrea Pinna, Michele Marchesi, and Roberto Tonelli. 2017. Blockchain-oriented Software Engineering: Challenges and New Directions. In Proceedings of the 39th International Conference on Software Engineering Companion (ICSE-C '17). IEEE Press, Piscataway, NJ, USA, 169--171.

Digital Library

Google Scholar

[14]

Abraham Silberschatz, Henry Korth, and S. Sudarshan. 2011. Database Systems Concepts (6 ed.). McGraw-Hill, Inc., New York, NY, USA.

Google Scholar

Cited By

View all

Ismael Imran I(2024)Enhancement of NoSQL Database Performance Using Parallel ProcessingJournal of Information Systems Engineering and Management10.55267/iadt.07.146709:2(26126)Online publication date: 2024
https://doi.org/10.55267/iadt.07.14670
Fernández‐Bravo Peñuela FArjona Aroca JMuñoz‐Escoí FYatsyk Gavrylyak YIllán García IBernabéu‐Aubán J(2024)DELTA: A Modular, Transparent, and Efficient Synchronization of DLTs and DatabasesInternational Journal of Network Management10.1002/nem.229334:5Online publication date: 5-Aug-2024
https://doi.org/10.1002/nem.2293
Stach C(2023)Data Is the New Oil–Sort of: A View on Why This Comparison Is Misleading and Its Implications for Modern Data AdministrationFuture Internet10.3390/fi1502007115:2(71)Online publication date: 12-Feb-2023
https://doi.org/10.3390/fi15020071
Show More Cited By

Index Terms

Ethereum query language
1. Information systems

Recommendations

An open systems SEE query language
SEE '95: Proceedings of the 1995 Software Engineering Environment Conferences

CASE tools inevitably require query and report generation facilities on data held in the SEE repository. The speed and ease of a powerful query language significantly improves productivity in the development of such tools. In the case of relational ...
Language integrated query: unified querying across data sources and programming languages
OOPSLA '06: Companion to the 21st ACM SIGPLAN symposium on Object-oriented programming systems, languages, and applications

.NET Language Integrated Query (LINQ) is based on the philosophy that querying should be native to your object-oriented programming language. LINQ allows you to write queries in a uniform way in your programming language itself, taking full advantage of ...
Predicting Ethereum prices with machine learning based on Blockchain information
Highlights:
- Generic Blockchain information of Ethereum is relevant in Ethereum price.
- ...
Abstract
With the growing interest in cryptocurrency and its fundamental algorithm, studies of cryptocurrency price predictions have been actively conducted in various academic disciplines. Since cryptocurrency is generated and consumed by ...

Comments

Information & Contributors

Information

Published In

WETSEB '18: Proceedings of the 1st International Workshop on Emerging Trends in Software Engineering for Blockchain

May 2018

70 pages

ISBN:9781450357265

DOI:10.1145/3194113

Program Chairs:
Roberto Tonelli
University of Cagliari, Cagliari, Italy
,
Giuseppe Destefanis
University of Hertfordshire, Hatfield, United Kingdom
,
Steve Counsell
Brunel University London, United Kingdom
,
Michele Marchesi
University of Cagliari, Cagliari, Italy

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than the author(s) must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected].

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 27 May 2018

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

ICSE '18

Sponsor:

SIGSOFT
IEEE-CS

ICSE '18: 40th International Conference on Software Engineering

May 27, 2018

Gothenburg, Sweden

Upcoming Conference

ICSE 2025

2025 IEEE/ACM 46th International Conference on Software Engineering

April 26 - May 3, 2025

Ottawa , ON , Canada

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

32
Total Citations
View Citations
565
Total Downloads

Downloads (Last 12 months)38
Downloads (Last 6 weeks)2

Reflects downloads up to 21 Sep 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Ismael Imran I(2024)Enhancement of NoSQL Database Performance Using Parallel ProcessingJournal of Information Systems Engineering and Management10.55267/iadt.07.146709:2(26126)Online publication date: 2024
https://doi.org/10.55267/iadt.07.14670
Fernández‐Bravo Peñuela FArjona Aroca JMuñoz‐Escoí FYatsyk Gavrylyak YIllán García IBernabéu‐Aubán J(2024)DELTA: A Modular, Transparent, and Efficient Synchronization of DLTs and DatabasesInternational Journal of Network Management10.1002/nem.229334:5Online publication date: 5-Aug-2024
https://doi.org/10.1002/nem.2293
Stach C(2023)Data Is the New Oil–Sort of: A View on Why This Comparison Is Misleading and Its Implications for Modern Data AdministrationFuture Internet10.3390/fi1502007115:2(71)Online publication date: 12-Feb-2023
https://doi.org/10.3390/fi15020071
Rafaj TMastilak LKostal KKotuliak I(2023)DeFi Gaming Platform Using the Layer 2 Benefits2023 33rd Conference of Open Innovations Association (FRUCT)10.23919/FRUCT58615.2023.10143054(236-242)Online publication date: 24-May-2023
https://doi.org/10.23919/FRUCT58615.2023.10143054
Peñuela FAroca JMuñoz-Escoí FGravrylyak YGarcía IBernabéu-Aubán J(2023)DELTA: DLT-Database Synchronization2023 IEEE International Conference on Blockchain and Cryptocurrency (ICBC)10.1109/ICBC56567.2023.10174930(1-9)Online publication date: 1-May-2023
https://doi.org/10.1109/ICBC56567.2023.10174930
Zhang QHe YLai RHou ZZhao G(2023)A survey on the efficiency, reliability, and security of data query in blockchain systemsFuture Generation Computer Systems10.1016/j.future.2023.03.044145:C(303-320)Online publication date: 1-Aug-2023
https://dl.acm.org/doi/10.1016/j.future.2023.03.044
Li YHuang HMa L(2023)An Efficient Data Retrieval Method for BlockchainTools for Design, Implementation and Verification of Emerging Information Technologies10.1007/978-3-031-33458-0_9(121-137)Online publication date: 17-Jun-2023
https://doi.org/10.1007/978-3-031-33458-0_9
Brahmia ZGrandi FBouaziz R(2023)Temporal Blockchains for Intelligent Transportation and Autonomous Vehicles ManagementArtificial Intelligence and Smart Environment10.1007/978-3-031-26254-8_108(747-756)Online publication date: 8-Mar-2023
https://doi.org/10.1007/978-3-031-26254-8_108
Brahmia ZGrandi FBouaziz R(2022)Temporal Blockchains for Intelligent Transportation Management and Autonomous Vehicle Support in the Internet of VehiclesModelling and Simulation of Fast-Moving Ad-Hoc Networks (FANETs and VANETs)10.4018/978-1-6684-3610-3.ch009(155-189)Online publication date: 30-Sep-2022
https://doi.org/10.4018/978-1-6684-3610-3.ch009
Stach CGritti CPrzytarski DMitschang B(2022)Assessment and treatment of privacy issues in blockchain systemsACM SIGAPP Applied Computing Review10.1145/3570733.357073422:3(5-24)Online publication date: 3-Nov-2022
https://dl.acm.org/doi/10.1145/3570733.3570734
Show More Cited By

View Options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

An open systems SEE query language

Language integrated query: unified querying across data sources and programming languages

Predicting Ethereum prices with machine learning based on Blockchain information

Comments

Published In

Sponsors

Publisher

Publication History

Permissions

Check for updates

Author Tags

Qualifiers

Conference

Upcoming Conference

Other Metrics

Article Metrics

Other Metrics

Cited By

Login options

Full Access

PDF

eReader

Abstract

References

Cited By

Index Terms

Recommendations

An open systems SEE query language

Language integrated query: unified querying across data sources and programming languages

Predicting Ethereum prices with machine learning based on Blockchain information

Comments

Information

Published In

Sponsors

Publisher

Publication History

Permissions

Check for updates

Author Tags

Qualifiers

Conference

Upcoming Conference

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

Get Access

Login options

Full Access

View options

PDF

eReader

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations