What is a view in database system and how it is related to data independence?
View is a table that does not really exist in its own right, it derived from one or more underlying base table. In other word view is a virtual table. There is no stored file that direct represents view.
- Views can represent a subset of the data contained in a table.
- View perform alogical operations.
- View can join multiple table in a single vertual table.
- Importent feature is, to hide complexity of data.
Now disscuss how view relate data independence, restructuring of base tables is not reflected in views. Thus the view can insulate users from the effects of restructuring and growth in the database. Hence accounts for logical data independence.