PIQL: Success-Tolerant Query Processing in the Cloud

Details PIQL: Success-Tolerant Query Processing in the Cloud PIQL: Success-Tolerant Query Processing in the Cloud

2011-11-30

arxiv.org/abs/1111.7166v1

Proceedings of the VLDB Endowment (PVLDB), Vol. 5, No. 3, pp. 181-192 (2011)

Computer Science

Databases

VLDB2012

Scientific paper

Newly-released web applications often succumb to a "Success Disaster," where overloaded database machines and resulting high response times destroy a previously good user experience. Unfortunately, the data independence provided by a traditional relational database system, while useful for agile development, only exacerbates the problem by hiding potentially expensive queries under simple declarative expressions. As a result, developers of these applications are increasingly abandoning relational databases in favor of imperative code written against distributed key/value stores, losing the many benefits of data independence in the process. Instead, we propose PIQL, a declarative language that also provides scale independence by calculating an upper bound on the number of key/value store operations that will be performed for any query. Coupled with a service level objective (SLO) compliance prediction model and PIQL's scalable database architecture, these bounds make it easy for developers to write success-tolerant applications that support an arbitrarily large number of users while still providing acceptable performance. In this paper, we present the PIQL query processing system and evaluate its scale independence on hundreds of machines using two benchmarks, TPC-W and SCADr.

Affiliated with

Also associated with

No associations

Rating

PIQL: Success-Tolerant Query Processing in the Cloud does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.

If you have personal experience with PIQL: Success-Tolerant Query Processing in the Cloud, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and PIQL: Success-Tolerant Query Processing in the Cloud will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFWR-SCP-O-8570