What are the advantages of views ?

Questions by doodi

Showing Answers 1 - 4 of 4 Answers

rajeev kumar

  • Apr 19th, 2013

if you have created view and if you want to update something in view it will also be update in table

  Was this answer useful?  Yes


  • May 6th, 2013

Define frequently used joins, projections, and selections as views so that users need not specify all the conditions and qualifications each time an operation is performed on that data.

Display different data for different users, even when they are using the same data at the same time. This advantage is particularly important when users of many different interests and skill levels share the same database.

  Was this answer useful?  Yes


  • Jun 12th, 2013

1. Hiding Unwanted(users do not have right to see those columns e.g login, password column in table) columns from the user.

2. Reduce the complexity of tables from using joins etc. in your query.

  Was this answer useful?  Yes


  • Mar 19th, 2015

1. We can restrict the users access to the stored data by using Views. User can be given permission to access database through views that contain the specific data the user is authorized to see.

2. A view is logical representation of data from several different tables. So that multi table queries by using Joins are converted into Single queries against View.

3. Views can give a user a "personalized" view of the database structure.

4. A view can present a consistent, unchanged image of the structure of the database, even if the underlying source tables are split, restructured, or renamed.

5. If data is accessed and entered through a view, the DBMS can automatically check the underlying source tables to ensure that it meets the specified integrity constraints.

6. If update something in view it will also be update in underlying source tables.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions