The most common use case

Typical system consists of the following 3 tiers: presentation, business logic and storage tier. Dealing with data represents its own set of non-trivial challenges which we have discussed above - storage layer encapsulates all of these challenges. It is expected that you understand the reasons behind the tiering approach at this point.

A relational data store is a goto solution for the vast majority of use cases and can comfortably support data volumes of up to several terabytes. Relational data stores offer strong ACID guarantees, support for Structured Query Language (SQL) and great performance for certain types of workloads. This architecture addresses correctness, performance and data access challenges.