Therefore there is possibility of information getting duplicated, this redundancy is storing same data multiple times leads to higher costs and wastage of space. This may result in data inconsistency in the application, this is because update is done to some of the files only and not all the files. Moreover in database approach multiple views can be created. View is a tailored representation of information contained in one or more tables. View is also called as "Virtual table" because view does not contain physically stored records and will not occupy any space.
A multi-user database whose users have variety of applications must provide facilities for defining multiple views. In traditional file system, if any changes are made to the structure of the files if will affect all the programs, so changes to the structure of a file Fax List may require changing of all programs that access the file. But in case of database approach the structure of the database is stored separately in the system catalog from the access of the application programs. This property is known as program-data independence.
Database can be used to provide persistent storage for program objects and data structures that resulted in object oriented database approach. Traditional systems suffered from impedance mismatch problem and difficulty in accessing the data, which is avoided in object oriented database system. Database can be used to represent complex relationships among data's as well as to retrieve and update related data easily and efficiently. It is possible to define and enforce integrity constraints for the data's stored in the database. The database also provides facilities for recovering hardware and software failures. The backup and recovery subsystem is responsible for recovery.