[DATABASE] File base vs database

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.
Advertisements
This entry was posted in Database and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s