Materialized View

Quick Definition

Physical stored copy of query results refreshed periodically

A physical stored copy of query results refreshed periodically.

query performance, data warehousing, precomputed aggregations

view caching data-warehouse

Intentionally adding redundancy to improve reads

Organized collection of structured data for storage and retrieval

Non-relational databases with flexible data models and scaling

Communication channel between application and database server

Creating data structures to speed up data retrieval

Database object for traversing result sets row by row