Database denormalization - Deepstash

Bite-sized knowledge

to upgrade

your career

Ideas from books, articles & podcasts.

Database denormalization

Database denormalization

Joins in relational databases get very slow as the system grows bigger. You should denormalize your data to avoid joins and speed up your queries.

Normalized databases are designed to minimize redundancy, while denormalized databases are designed to optimize read time.

STASHED IN:

13

MORE IDEAS FROM THE SAME ARTICLE

Caching systems are usually in-memory key-value databases that provide very fast access to data. They sit between your application and the database.

Systems can be scaled:

  • Bandwidth - Maximum amount of data that can be transferred in a unit of time. Usually expressed in bits per second.
  • Throughput - Amount of data that is actually transferred in a unit of time.
  • Latency - How long it takes data ...

Sharding means splitting your data across multiple nodes. This can be done in different ways:

Slow operations should be done asynchronously to avoid making users wait for long periods of time until their requests are processed.

3 Reactions

Comment

MORE LIKE THIS

created 7 ideas

Chapter 3 How to influence people and friends

1

Comment

292 reads

It's time to

READ

LIKE

A PRO!

Jump-start your

reading habits

, gather your

knowledge

,

remember what you read

and stay ahead of the crowd!

Takes just 5 minutes a day.


TRY THE DEEPSTASH APP

+2M Installs

4.7 App Score