All geek questions in one place

The difference between the relationship "view" and "base"

What is the difference between the 'view' and 'base' relationship in database systems?

+4
source share
3 answers

The base relation (table) actually contains data. A view is a request for one (or more) basic relationships, but actually contains no data.

+14
source

A basic relation is simply a table that actually exists and is stored in a database.

, , - , .

+2

A basic relationship is a table with some values, while a view is essentially a subset of the database that allows each user to have their own view of the database.

0
source

Source: https://habr.com/ru/post/1715994/

More articles:


All Articles