Technical Discussion :: DBMS
Home > Technical Interview Q&A > DBMS > Discussion
12 / 143
What is a view? How it is related to data independence?
Answer:
A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is instead derived from one or more underlying base table. In other words, there is no stored file that directly represents the view instead a definition of the view is stored in data dictionary.
Growth and restructuring of base tables are 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.
Asked In ::
Ankita Gautam
23 Feb, 2019 5:07 AM
A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is instead derived from one or more underlying base table. In other words, there is no stored file that directly represents the view instead a definition of the view is stored in data dictionary.
Growth and restructuring of base tables are 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.
Growth and restructuring of base tables are 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.