Cover Image
QR Code

10 Rules for Scalable Performance in 'Simple Operation' Datastores.

The article presents a set of guidelines on scalable SQL and NoSQL datastores which involve relational database management systems (RDBMSs) using multiple servers. It is argued that applications must be designed for scalability in a web 2.0 context, and topics such as operations that span partitions...

Full description

Published in:Communications of the ACM Vol. 54; no. 6; pp. 72 - 81
Main Authors: STONEBRAKER, MICHAEL, CATTELL, RICK
Format: Article
Published: Association for Computing Machinery Jun2011
Subjects:
Relational databases
Parallel processing
SQL
Database management
Software architecture
Web 2.0
Online Access:View this record in EBSCOhost
Summary:The article presents a set of guidelines on scalable SQL and NoSQL datastores which involve relational database management systems (RDBMSs) using multiple servers. It is argued that applications must be designed for scalability in a web 2.0 context, and topics such as operations that span partitions, parallelism, and requirements for consistency guarantees are discussed. Rules are promulgated regarding issues such as high-level languages, automatic recovery, the hazards of multi-node operations, and the advantages of open source software.