CODEWITHSUNDEEP
databaserdbms
keyur
keyur

Reputation: 249

The difference between a 'view' and 'base' relation

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

Upvotes: 5

Views: 15914

Answers (3)

hussanain
hussanain

Reputation: 41

A base relation is just a table that actually physically exists and is stored in the database.

This is in contrast to a view, which is derived from base relations but does not actually physically exist in the database - it only exists as a structural definition, pulling its data from a number of base relations.

Upvotes: 4

Mike Siame
Mike Siame

Reputation: 1

A base relation is a table with some values while a view is essentially some subset of the database that allows each user to have his or her own view of the database

Upvotes: 0

Eric Petroelje
Eric Petroelje

Reputation: 60559

A base relation (table) actually contains data. A view is a query over one (or more) base relations but does not actually contain any data itself.

Upvotes: 15

Related Questions