Day 31/100

Day 31/100

Akshay Habbu's photo
Akshay Habbu
·

1 min read

Designing Data-Intensive Applications [Book Highlights]

[Part I : Chapter III] Storage and Retrieval

Aggregation: Data Cubes and Materialized Views

image.png

  • The advantage of a materialized data cube is that certain queries become very fast because they have effectively been precomputed.

Summery

  • On a high level, we saw that storage engines fall into two broad categories: those optimized for transaction processing (OLTP), and those optimized for analytics (OLAP).
  • OLTP systems are typically user-facing, which means that they may see a huge volume of requests
  • In order to handle the load, applications usually only touch a small number of records in each query.
  • OLAP - They handle a much lower volume of queries than OLTP systems, but each query is typically very demanding, requiring many millions of records to be scanned in a short time.
Databasesdatabooksstorage