Data Warehousing: Architecture and Implementation

Chapter 10. Hardware and Operating Systems

The term hardware and operating systems refers to the server platforms and operating systems that serve as the computing environment of the data warehouse. Warehousing environments are typically separate from the operational computing environments (i.e., a different machine is used) to avoid potential resource contentions between operational and decisional processing. Enterprises are correctly wary of computing solutions that may compromise the performance levels of mission-critical operational systems.

The major hardware vendors have all established data warehousing initiatives or partnership programs with other firms in a bid to provide comprehensive data warehousing solution frameworks to their customers. ...