View is a virtual table made of one or tables of the database using complex/simple join logic. The view has some useful purposes. Some are as under:
1. Simplification of database:
A schema may have hundreds of tables. Applications can be simplified if they can access predefined views which embed complex join logic.
2. Easy Maintenance:
Views can contain complex column expressions that are transparent in the views. Changes to these expressions need only be made in the view.
3. Change management:
Views can reduce maintenance to the application as they can hide schema changes that affect the view's query.
4. Security purpose:
Views can embed selection logic and present a subset of a table's content. You can create additional schema that contains just views of the main schema, limiting what may be accessed. Different user groups enter through one of these other schema, each group having a different view of the overall database.
1. Simplification of database:
A schema may have hundreds of tables. Applications can be simplified if they can access predefined views which embed complex join logic.
2. Easy Maintenance:
Views can contain complex column expressions that are transparent in the views. Changes to these expressions need only be made in the view.
3. Change management:
Views can reduce maintenance to the application as they can hide schema changes that affect the view's query.
4. Security purpose:
Views can embed selection logic and present a subset of a table's content. You can create additional schema that contains just views of the main schema, limiting what may be accessed. Different user groups enter through one of these other schema, each group having a different view of the overall database.
