What is View in database ? Why do we need to create View ?
A view is virtual table which is created from one or many tables which depends on the written SQL query to create a view. A view is actually a composition of a table in the form of a predefined SQL query. Interesting fact about the view is that it is not represented by its own separate data , but by its definition in terms of other named table.
Reason to create View :
1) Data Security : View is created when data security is required because by creating view only some data will be visible to other user and other important data will be hidden.
2) Data Redundancy : View is created when data redundancy is to be kept to the minimum while maintaining data security .
3) Easy Access : By creating View we summarize data from various table . So it becomes easy for a user to access the data as he does not need to bothered about applying all those joins operation to fetch data from many table as data is already present in View.
A view is virtual table which is created from one or many tables which depends on the written SQL query to create a view. A view is actually a composition of a table in the form of a predefined SQL query. Interesting fact about the view is that it is not represented by its own separate data , but by its definition in terms of other named table.
Reason to create View :
1) Data Security : View is created when data security is required because by creating view only some data will be visible to other user and other important data will be hidden.
2) Data Redundancy : View is created when data redundancy is to be kept to the minimum while maintaining data security .
3) Easy Access : By creating View we summarize data from various table . So it becomes easy for a user to access the data as he does not need to bothered about applying all those joins operation to fetch data from many table as data is already present in View.
No comments:
Post a Comment