What are some of the benefits of using Views in a Database Management

1.	What are some of the benefits of using Views in a Database Management System?
Answer» The following are some of the advantages of employing views in a database management system: A view can REPRESENT a subset of a table's data. As a result, a view can limit the extent to which the underlying tables are visible to the outside world: for example, a user may be ABLE to QUERY the view but not the entire base database. Views are aggregated tables in which the database engine aggregates data (sum, average, and so on) and shows the resulting results alongside the data. Using views, we may merge and simplify several tables into a single virtual table. Views take up very little storage SPACE; the database just stores the view's specification, not a copy of all the data it displays. The COMPLEXITY of data can be obscured by views. Views can provide additional protection depending on the SQL engine being used.

What are some of the benefits of using Views in a Database Management System?

Answer»

The following are some of the advantages of employing views in a database management system:

A view can REPRESENT a subset of a table's data. As a result, a view can limit the extent to which the underlying tables are visible to the outside world: for example, a user may be ABLE to QUERY the view but not the entire base database.
Views are aggregated tables in which the database engine aggregates data (sum, average, and so on) and shows the resulting results alongside the data.
Using views, we may merge and simplify several tables into a single virtual table.
Views take up very little storage SPACE; the database just stores the view's specification, not a copy of all the data it displays.
The COMPLEXITY of data can be obscured by views.
Views can provide additional protection depending on the SQL engine being used.