What is the Materialized View Pattern?

A pattern that pre-populates and stores views over data in one or more data stores to optimize querying.

In databases or distributed systems, querying data that requires complex joins across millions of rows is slow. A Materialized View computes the result of the query in advance and stores it as a physical table, updating it periodically or asynchronously via events.