The Evolution of Data Management Technology:from Traditional File to Data Warehouse

Traditional File

Traditional file uses transaction processing,a transaction is the record of an event,it require a master file(permanent information)and many transaction file(contains information relevant to the most recent transactions.traditional used in business data processing,each business application designed to use one/more specialized data files containing only specific type of data records.e.g:below diagram





traditional file processing-a company y checking account processing account processing application was designed to access and update a data file containing only specific types of data record.

------------------------------processing traditional file image ------------------------

-----------------------------------batch processing system---------------------------

Limitation of Traditional File Processing

-Data redundancy-duplicated data(i.e. data integrity and confusion)

-Separated and Isolated Data

-Application program dependency

-Incompatible files

-Difficult to represent users' perspectives of data

-Lack of data sharing and availability

Advantage of Traditional File Processing

-no need external storage

-no need high technical person to handle the database

-processing speed is high compare to DBMS(database management system)

.

.

.

Data Warehouse

A data warehouse is a central repository for all or significant parts of the data that an enterprise's various business systems collect

Typically, a data warehouse is housed on an enterprise mainframe server. Data from various online transaction processing (OLTP) applications and other sources is selectively extracted and organized on the data warehouse database for use by analytical applications and user queries. Data warehousing emphasizes the capture of data from diverse sources for useful analysis and access, but does not generally start from the point-of-view of the end user or knowledge worker who may need access to specialized, sometimes local databases. The latter idea is known as the data mart.
Stored static that has been extracted form other database in an organization,data warehouse may divided into data marts.

----------------------------example data warehouse in ASU --------------------------

-------------------------processing data warehouse system(1) ---------------------

-------------------------processing data warehouse system(2)----------------------

--------------------------processing data warehouse and data mart---------------

Advantage of data warehouse

-users will be able to access a large amount of information.

-the information can be used to solve a large number of problem.

-its can increase the profit of a company

Disadvantage of data warehouse

-before data can be stored,it must be cleaned,loaded,or extracted.

-this process take a long period of time.

-also be issues with compatibility.