Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems

The advent of affordable, shared-nothing computing systems portends a new class of parallel DataBase Management Systems (DBMS) for On-Line Transaction Processing (OLTP) applications that scale without sacrificing ACID guarantees. The performance of these DBMSs is predicated on the existence of an optimal database design that is tailored for the unique characteristics of OLTP workloads. Deriving such designs for modern DBMSs is difficult, especially for enterprise-class OLTP systems, since they impose extra challenges: the use of stored procedures, the need for load balancing in the presence of time-varying skew, complex schemas, and deployments with larger number of partitions.

Provided by: Association for Computing Machinery Topic: Data Management Date Added: May 2012 Format: PDF

Find By Topic