Partiqle: an elastic SQL engine over key-value stores

Authors:
Junichi Tatemura;Oliver Po;Wang-Pin Hsiung;Hakan Hacigümüş
Affiliations:
NEC Laboratories America, Cupertino, CA, USA;NEC Laboratories America, Cupertino, CA, USA;NEC Laboratories America, Cupertino, CA, USA;NEC Laboratories America, Cupertino, CA, USA
Venue:
SIGMOD '12 Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data
Year:
2012

Citing 8
Cited 0

Query optimization in the presence of limited access patterns

SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Concurrency control in a system for distributed databases (SDD-1)

ACM Transactions on Database Systems (TODS)
Bigtable: a distributed storage system for structured data

OSDI '06 Proceedings of the 7th symposium on Operating systems design and implementation
Building a database on S3

Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Supporting table partitioning by reference in oracle

Proceedings of the 2008 ACM SIGMOD international conference on Management of data
The case for PIQL: a performance insightful query language

Proceedings of the 1st ACM symposium on Cloud computing
CloudDB: One Size Fits All Revived

SERVICES '10 Proceedings of the 2010 6th World Congress on Services
Microsharding: a declarative approach to support elastic OLTP workloads

ACM SIGOPS Operating Systems Review

Quantified Score

Hi-index	0.00

Visualization

Abstract

The demo features Partiqle, a SQL engine over key-value stores as a relational alternative for the recent procedural approaches to support OLTP workloads elastically. Based on our microsharding framework [12], it employs a declarative specification, called transaction classes, of constraints applied on the transactions in a workload. We demonstrate use of a transaction class in design and analysis of OLTP workloads. We then demonstrate live-scaling of our fully functioning system on a server cluster.