Everything About ___
Live briefing

Everything about View (SQL)

Database stored query result set

In a database, a view is the result set of a stored query that presents a limited perspective of the database to a user. This pre-established query command is kept in the data dictionary. Unlike ordinary base tables in a relational database, a view does not form part of the physical schema: as a result set, it is a virtual table computed or collated dynamically from data in the database when access to that view is requested. Changes applied to the data in a relevant underlying table are reflected in the data shown in subsequent invocations of the view. Wikipedia →

🧭 Start here: a 6-step reading path

  1. Read the overview: View (SQL)A 5-minute orientation
  2. Skim a recent paper: A View-Oriented Skeleton Generation Method for Improving Multi-Table Text-to-SQL Translation AccuracyInfluential work since 2022
  3. Pick up a classic book: Database system conceptsThe most-reprinted book on the subject
  4. Read the landmark paper: SQL Injection Attack: Quick ViewCited 44 times
  5. Go sideways: Materialized viewA closely related topic
  6. Go sideways: Data definition languageA closely related topic

📖 Definitions

No dictionary entry for this exact phrase.

🗂️ The subject at a glance

  1. Read-only vs. updatable views
  2. Materialized views
  3. Equivalence

🏆 Landmark papers (most cited)

🆕 Influential since 2022

📚 Books worth reading

Ranked by number of editions on Open Library, a rough measure of how lasting a book is.

🔗 Related topics