Databases Reference
In-Depth Information
warehousing environment, shown in Figure 1-1, are described in the following
sections. This figure indicates how the data flows throughout the environment.
Table 1-1
Comparison of Online Transaction Processing and Data Warehousing Systems
AREA OF
OLTP
DATA WAREHOUSING
COMPARISON
System
purpose
Support operational
processes
Support strategic analysis,
performance, and exception
reporting
Data usage
Capture and maintain the
data
Exploit the data
Data validation
Data verification occurs upon
entry
Data verification occurs after
the fact
Update
frequency
Data is updated when
business transactions occur
(e.g., client uses debit card,
web order is placed)
Data is updated by periodic,
scheduled processes
Historical data
requirement
Current data
Multiple years of history
Data
integration
and balancing
Data is balanced within the
scope of this one system
Data must be integrated and
balanced from multiple
systems
Source
System
Data
Source
System
Data
Data Organized
to Support the
Business
Source
System
Data
Source
System
Data
Figure 1-1
Basic data warehousing environment
