Advantages & Disadvantages Of View In DBMS

View Advantage & Disadvantage Explain, What Is The Need Of View, Why View Is Created Explain, Describe Advantages & Disadvantages Of View In DBMS

Reasons why views are created

Data security reason

To minimize data redundancy

Advantage of View

* Data independence

* Improved security

* Reduced complexity: Instead of forcing your users to learn the SQL JOIN syntax you might wish to provide a view that runs a commonly requested SQL statement. Convenience

* Customization: If you wish to display some computed values or column names formatted differently than the base table columns, you can do so by creating views.


Disadvantage of View

* Update restriction

* Structure restriction (new attribute in the base table)

* Performance : Even though views can be a great tool for securing and customizing data, they can be slow.

Tweet