View
A virtual table based on a stored SQL query that presents data from one or more tables in a specific format.
In Depth
A database view is a virtual table defined by a SQL query. Unlike physical tables, views do not store data themselves—they dynamically execute their underlying query each time they are accessed. Views simplify complex queries by encapsulating joins, filters, and aggregations into a simple table-like interface. They also enhance security by exposing only specific columns or filtered rows to certain users. Materialized views are a special type that cache the query results and must be periodically refreshed, offering better read performance at the cost of freshness. Views are commonly used for reporting, access control, and API abstraction layers.
How AI for Database Helps
AI for Database treats views as first-class data sources, querying them alongside regular tables for comprehensive results.
Related Terms
SQL
Structured Query Language—the standard programming language for managing and querying relational databases.
Query Optimization
The process of improving a SQL query's execution speed and resource usage without changing the results.
Schema
The structural blueprint of a database that defines tables, columns, data types, relationships, and constraints.
Ready to try AI for Database?
Query your database in plain English. No SQL required. Start free today.