Databases Intermediate

What is View?

A virtual table defined by a SQL query that provides a simplified or restricted view of data from one or more tables.

Views act as saved queries that can be referenced like tables. They simplify complex queries, restrict data access (showing only certain columns), and provide a stable interface even when underlying tables change.

Regular views execute the query each time they are accessed. Materialized views (PostgreSQL) store the result physically and must be refreshed, offering faster reads for complex aggregations at the cost of data freshness.

Learn More About This Topic

SQL for Absolute Beginners

Related reading

Redis Fundamentals

Related reading

MongoDB Fundamentals: Building Scalable NoSQL Applications with Document Databases

Related reading

Related Terms

Write-Ahead Log (WAL)

A technique where changes are first written to a log before being applied to the database, ensuring crash recovery and data integrity.

An advanced open-source relational database known for its reliability, feature richness, and standards compliance.

A data structure that improves the speed of data retrieval operations on database tables at the cost of additional storage.

A middleware server that sits between applications and databases, providing connection pooling, load balancing, and query routing.

A database object that enables row-by-row processing of query results, useful for operations that cannot be done in bulk.

A pattern where records are marked as deleted with a flag or timestamp rather than being physically removed from the database.

View All Databases Terms →