Repository logo
Log in(current)
Repository logoMIT Open ScholarshipDSpace@MIT
  1. Home
  2. MIT Open Access Articles
  3. MIT Open Access Articles
  4. GRAPHiQL: A graph intuitive query language for relational databases

GRAPHiQL: A graph intuitive query language for relational databases

Thumbnail Image
Download
Name

Madden_GRAPHiQL.pdf

Size

343.35 KB

Format

Adobe PDF

Checksum (MD5)

ee6981c9c671423425491b5e877da539

Author(s)
Jindal, Alekh
•
Madden, Samuel R.
Date Issued
October 2014
Journal
Proceedings of the 2014 IEEE International Conference on Big Data (Big Data)
Publisher
Institute of Electrical and Electronics Engineers (IEEE)
Citation
Jindal, Alekh, and Samuel Madden. “GRAPHiQL: A Graph Intuitive Query Language for Relational Databases.” 2014 IEEE International Conference on Big Data (Big Data) (October 2014).
Version
Author's final manuscript
Abstract
Graph analytics is becoming increasingly popular, driving many important business applications from social network analysis to machine learning. Since most graph data is collected in a relational database, it seems natural to attempt to perform graph analytics within the relational environment. However, SQL, the query language for relational databases, makes it difficult to express graph analytics operations. This is because SQL requires programmers to think in terms of tables and joins, rather than the more natural representation of graphs as collections of nodes and edges. As a result, even relatively simple graph operations can require very complex SQL queries. In this paper, we present GRAPHiQL, an intuitive query language for graph analytics, which allows developers to reason in terms of nodes and edges. GRAPHiQL provides key graph constructs such as looping, recursion, and neighborhood operations. At runtime, GRAPHiQL compiles graph programs into efficient SQL queries that can run on any relational database. We demonstrate the applicability of GRAPHiQL on several applications and compare the performance of GRAPHiQL queries with those of Apache Giraph (a popular `vertex centric' graph programming language).
MIT Department
Massachusetts Institute of Technology. Computer Science and Artificial Intelligence Laboratory
Massachusetts Institute of Technology. Department of Electrical Engineering and Computer Science
Terms of Use
Creative Commons Attribution-Noncommercial-Share Alike
http://creativecommons.org/licenses/by-nc-sa/4.0/
Persistent DSpace Link
http://hdl.handle.net/1721.1/100910
DOI of Published Version
https://doi.org/10.1109/BigData.2014.7004261
Repository logo
PrivacyPermissionsAccessibilityContact us
Repository logo
Notify us about copyright concerns.