Saturday, February 24, 2018

What Is the Elastic SQL Approach?

DZone Database Zone
What Is the Elastic SQL Approach?
What Is the Elastic SQL Approach?

Editor's Note: This is an excerpt of a larger white paper written by Craig Mullins that explores database scaling options. You can download the full white paper here.

Elastic SQL: An Alternative, Services-Based Approach

So far, we have examined the status quo, wherein various architectural alternatives of achieving improved elasticity and scalability using existing solutions are offered. But each of these methods has some significant drawbacks: shared-disk requires expensive hardware and software to achieve, shared-nothing requires partitioning the data that may not match the requirements of all applications, and NoSQL eliminates ACID and often, SQL. Clearly, an alternative approach is needed — one that does not try to work around the shortcomings of the existing solutions.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...