Electrical Engineering
      and Computer Sciences

Electrical Engineering and Computer Sciences

COLLEGE OF ENGINEERING

UC Berkeley

PIQL: A Performance Insightful Query Language For Interactive Applications

Michael Armbrust, Nick Lanham, Stephen Tu, Armando Fox, Michael Franklin and David A. Patterson

EECS Department
University of California, Berkeley
Technical Report No. UCB/EECS-2010-8
January 25, 2010

http://www.eecs.berkeley.edu/Pubs/TechRpts/2010/EECS-2010-8.pdf

Large-scale, user-facing applications are increasingly moving from relational databases to distributed key-value stores for high request rate, low latency workloads. Often this move is motivated not only by key/value stores’ ability to scale simply by adding more hardware, but also by the easy to understand predictable performance they provide for all operations. For complex queries this approach often requires onerous explicit index management and imperative data lookup by the developer. We propose PIQL, a Performance Insightful Query Language that allows developers to express many of the queries found on these websites, while still providing strict performance guarantees.


BibTeX citation:

@techreport{Armbrust:EECS-2010-8,
    Author = {Armbrust, Michael and Lanham, Nick and Tu, Stephen and Fox, Armando and Franklin, Michael and Patterson, David A.},
    Title = {PIQL: A Performance Insightful Query Language For Interactive Applications},
    Institution = {EECS Department, University of California, Berkeley},
    Year = {2010},
    Month = {Jan},
    URL = {http://www.eecs.berkeley.edu/Pubs/TechRpts/2010/EECS-2010-8.html},
    Number = {UCB/EECS-2010-8},
    Abstract = {Large-scale, user-facing applications are increasingly moving from relational databases to distributed key-value stores for high request rate, low latency workloads. Often this move is motivated not only by key/value stores’ ability to scale simply by adding more hardware, but also by the easy to understand predictable performance they provide for all operations. For complex queries this approach often requires onerous explicit index management and imperative data lookup by the developer. We propose PIQL, a Performance Insightful Query Language that allows developers to express many of the queries found on these websites, while still providing strict performance guarantees.}
}

EndNote citation:

%0 Report
%A Armbrust, Michael
%A Lanham, Nick
%A Tu, Stephen
%A Fox, Armando
%A Franklin, Michael
%A Patterson, David A.
%T PIQL: A Performance Insightful Query Language For Interactive Applications
%I EECS Department, University of California, Berkeley
%D 2010
%8 January 25
%@ UCB/EECS-2010-8
%U http://www.eecs.berkeley.edu/Pubs/TechRpts/2010/EECS-2010-8.html
%F Armbrust:EECS-2010-8