
386
14.2
Tuning Hardware Resources for Data Warehousing
acceptable performance constraints. Decision support implies many types
of forecasting, prediction, planning assistance, and
what if
analysis–type
functionality. These types of reporting can be accomplished using various
bells and whistles, such as OLAP utilities, data mining, advanced SQL
functionality, and many available third party tools and reporting engines.
14.2 Tuning Hardware Resources for
Data Warehousing
Hardware resource tuning for a data warehouse is in reality a lot easier than
tuning the same for an OLTP database. The problem with an OLTP data-
base is that it needs to be intensely ...