Anonymous
Asked in
Cars &Transportation
ยท
2 weeks ago
Why do we use database views?
A database view is a subset of a database and is based on a query that runs on one or more database tables. Database views are saved in the database as named queries and can be used to save frequently used, complex queries.
Why do we use views instead of tables?
Views can provide many advantages over tables: Views can represent a subset of the data contained in a table. Views can limit the degree of exposure of the underlying tables to the outer world: a given user may have permission to query the view, while denied access to the rest of the base table.
Why are views needed?
Views can be used for a few reasons. Some of the main reasons are as follows: To simplify database structure to the individuals using it. As a security mechanism to DBAs for allowing users to access data without granting them permissions to directly access the underlying base tables.
Related Questions
Relevance
-
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago
Write us your question, the answer will be received in 24 hours