Chapter 3. Hardware Architecture

With the software architecture properly defined, the next biggest challenge for the data warehouse DBA is to select an appropriate hardware platform for implementation.

In theory, data warehouse hardware selection should be simple. Data warehouses are huge, so common sense would dictate ordering large, scalable systems. Once you start throwing around the “T” word (for terabytes) when referring to your data warehouse, then lots of CPUs and lots of disks should not be a hard sell. If you need further convincing, then reexamine your data warehouse's mission statement and sponsor. A data warehouse enabling both executives and senior management to form strategic business decisions is worth a lot to any business. Hence, ...

Get Oracle® DBA Guide to Data Warehousing and Star Schemas now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.