Database
276 views
Materialized View
Quick Definition
Physical stored copy of query results refreshed periodically
Full Definition
A physical stored copy of query results refreshed periodically.
Examples
query performance, data warehousing, precomputed aggregations
Related Terms
view
caching
data-warehouse
More Database Terms
Query Optimization
Improving query performance through various techniques
Sharding
Horizontal data partitioning across multiple instances
Denormalization
Intentionally adding redundancy to improve reads
Write Ahead Log
Persistence mechanism writing changes to log before database
Graph Database
Database optimized for entity relationship queries
Document Database
NoSQL database storing data as flexible JSON-like documents