Database view Advantages of database view
A database can pull information from multiple areas and put it all in one large database where the information can then be viewed and analyzed in many different ways without any danger of changing the original information. Microsoft Access is an example of a database program.
Database views are virtual tables and if they are defined, they could be referenced any time is needed. In database view are stored data from one or more database tables.
A great advantage of storing data in database view is the one that a view occupies a little space and this fact is crucial when working with a very large amount of data.
Another advantage of a database view is that it's not a copy but a stored query. If one user wants to modify data, this is possible only for data exposed, protecting the data from underlying tables.