Traditional file based system defined as basically a file based system, in which we manually or through computer handle the database such as updating, insertion ,deletion adding new files to database. For the traditional file approach, there are collection of applications that each define and manage their own files. Example, each business application was designed to use one or more specialized data files containing only specific types of data. There are the diagram of traditional file processing.
However, there will facing some problems with traditional file processing which are data redundancy, lack of data integration, data dependence and lack of data integrity or standardization.
To solve the problem encountered with the traditional file processing, the database management approach was conceived as the foundation of modern methods for managing organizational data. The management database approach consolidates data records, formerly held in separate files, into databases that can be accessed by many different application programs. Below is n example of database management approach.
For the data warehouse, it stores the data that have been extracted from the various operational, external and other databases of an organization. It is a central source of the data that have been cleaned, transformed, and cataloged so the managers and other business professionals can use them for data mining, analytical processing, analysis, market research and decision support. Data warehouse can be divided into data marts which hold the subsets of data that focus on specific aspects of a company, such as department or a business process. There are the diagram of data marts and data warehouses.
Example of Applications and Data Marts.
Example of Data Warehouses.
