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.

Connection String

A formatted string containing all parameters needed to establish a connection to a database server.

The process of copying and maintaining database data across multiple servers for redundancy, failover, and read scaling.

The structure definition of a database including tables, columns, data types, relationships, indexes, and constraints.

A database object that automatically executes a specified function when certain events (INSERT, UPDATE, DELETE) occur on a table.

Query Optimization

The process of improving database query performance through indexing, query rewriting, and schema design techniques.

View All Databases Terms →