Okuzeka
Software Engineering vocabulary · Databases and Persistence

View

Meaning in software engineering, with examples

/vjuː/nounCommon term

In software engineering, view means: A saved SELECT query that you can use like a table. It usually stores no data of its own and shows the current result of the query each time.

In Turkish: görünüm, view

How it is used

Used to hide complex joins, give reporting teams a simple interface or limit which columns a user can see. A materialized view is different: it stores the result physically and must be refreshed. You create, drop and query views.

Example sentences

  1. The finance team queries a view that joins orders, payments and refunds.

  2. We refresh the materialized view every hour because the base query is expensive.

Common collocations

  • create a view
  • materialized view
  • refresh a view
  • query a view
  • tableA structure in a relational database that stores data about one kind of thing in rows and columns, for example all customers or all orders.
  • SELECT statementThe SQL statement that reads data from one or more tables and returns the matching rows without changing anything in the database.
  • privilegeA permission that allows a database user or role to do a specific action, such as reading a table, inserting rows or creating new objects.
  • stored procedureA named block of SQL code saved inside the database that can take parameters and be run again and again with a single call.

This word in other fields

The same English word can have a different meaning in another field:

More terms: Databases and Persistence

Practise with graded reading

Reading at the right level is the fastest way to make new words stick. Pick free English books by level: