This post illustrates the need for database approach to manage data.
Problems with file base approach
- Data is stored in file defined by application, hence there is a possibility of potential useful data needed by another application but not aware by the application that requires it.
- Because the data is stored in file defined by application, the structure is hard to maintain, to unify the structure you need to change on every application.
- Because common data is not aware among applications, duplicated (redundant) data may be present in every applications.
Motivation to use database
- Data is stored in a single location which can be accessed by any applications that need it, in other words the same data can be accessed by any applications.
- Duplicated data can be normalised within database.
- Data stored in database can be unified by data dictionary which defines the structure, data type and domain of data.
- The draw back of database is its complexity in building it, expertise in database product is required.