|
Answer» Some benefits of using views in a Database Management System are as FOLLOWS: - Views can represent a subset of the data in a table. As a result, a view can limit the extent to which the underlying tables are exposed to the outside world: a user MAY be allowed to query the view but not the whole of the BASE database.
- Views can be used as aggregated tables, in which the database engine aggregates data (sum, average, and so on) and displays the generated results alongside the data.
- Views allow us to combine and simplify numerous tables into a single virtual table.
- Views take up extremely minimal storage space; the database simply MAINTAINS the specification of a view, not a copy of all the data it displays.
- Views can obscure data complexity.
- Views can give additional SECURITY depending on the SQL engine utilized.
|
