Monday, August 14, 2017

2 Approaches to Scalable Database Design

DZone Database Zone
2 Approaches to Scalable Database Design

Any form of application used for data analysis is stringently dependent on its ability to retrieve queries fast. However, when working with larger or more complex datasets, as well as an increasing amount of concurrent users, the performance depends largely on the underlying analytical database — whether this is built into the application as part of a single-stack tool or implemented via a separate data warehouse layer.

What Makes a Scalable Database?

Database scalability is a concept in database design that emphasizes the capability of a database to handle growth in the amount of data and users. In the modern applications sphere, two types of workloads have emerged: analytical and transactional workloads. Planning for workload growth must take into account operating system, database design, and hardware design decisions.

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...