Database
145 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
ORM
Mapping object-oriented code to database tables
Key-Value Store
NoSQL database storing data as key-value pairs
B-Tree Index
Self-balancing tree index for efficient sorted data operations
NoSQL
Non-relational databases with flexible data models and scaling
Normalization
Organizing tables to reduce redundancy and improve integrity
Concurrency Control
Managing simultaneous data access while maintaining consistency