Data Management

The Evolution of Data Management Technology

from Traditional File to Data Warehouse

Traditional file-based system is the first and the oldest database system that attempt to computerize the manual filing system. For example, in an organization, a manual file is set up to record all internal and external information include, employee, product, project and customer. File-based system consists of many file with name label and keep in different location. These manual filings works well but also have some problem include data redundancy, lack of data integration, data dependence and lack of data integrity or standardization. Data redundancy is duplicated data. Below is an example of file-based system.

To become more effective, a new system has been created, database and database management system (DBMS). A database is an integrated collection of logically related data elements. It strengthens the records that stored earlier in separate files into common collection of data elements that provides data for many applications. The database is a large storehouse of data which can be used and shared at the same time by many departments and users. Instead of occurring redundant file, all data items are integrated with lower percentage of duplication.

Data management system is use to process and organize large amount of data and it is also and important part of computer system which also serves as software interface between users and database. Data management also knows as software that enables users to define, create, maintain, and control access to the database. Below is an example of data management system.

There are four types of databases which is operational databases, distributed data, external databases and hypermedia databases. These databases will be the static data that stored in the data warehouse and the data of the data warehouse is used for data mining, analytical processing, analysis, research, and decision support.