Scalable SQL.

The article discusses scalable SQL, focusing on the need to scale up relational database systems to internet size. Online social networks are cited as an example. Topics discussed include user load, data load, distributed processing and partitioning. The CAP (consistency, availability, partition tol...

Descripción completa

Detalles Bibliográficos
Publicado en:Communications of the ACM Vol. 54; no. 6; pp. 48 - 54
Autor principal: RYS, MICHAEL
Formato: Artículo
Publicado: Association for Computing Machinery Jun2011
Materias:
Acceso en línea:Ver este registro en EBSCOhost
Descripción
Sumario:The article discusses scalable SQL, focusing on the need to scale up relational database systems to internet size. Online social networks are cited as an example. Topics discussed include user load, data load, distributed processing and partitioning. The CAP (consistency, availability, partition tolerance) theory propounded by Eric Brewer is discussed, which argues that no distributed web service can guarantee all three of the CAP variables will be optimally met. The implications for scalable architecture and message delivery are analyzed in terms of global transaction models.