Menu
What is the difference between a 'view' and 'base' relation in database systems?
707
Explanation: A relation that is not a part of the schema but is a virtual relation is called as view. Views improve writability as viewing the entire logical model is not feasible.
A view is a database object that allows generating a logical subset of data from one or more tables. A table is a database object or an entity that stores the data of a database.
A view is just a way of abbreviating a subquery. An index is used to optimize matching column data.
A table is structured with columns and rows, while a view is a virtual table extracted from a database. The table is an independent data object while views are usually depending on the table.
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.
109
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.
33
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
