Glossary term
What is Materialized view? Meaning for developers
A stored, precomputed query result. Example: A daily sales summary table.
Learn it properly · System DesignLesson 23: Normalization vs DenormalizationStore each fact once and writes stay correct; copy facts on purpose and reads get fast. Normal forms explained simply, the anomalies they prevent, the denormalisation toolkit, and how to keep copies in sync.