Great Operating System Debate
No discussion on software architecture would be complete without the mandatory argument over operating systems. System administrators and Oracle DBAs love to debate over which OS is ultimately better: UNIX or Windows NT/2000/XP. In fact, Democrats and Republicans often agree on more issues than UNIX and Windows bigots. Likewise, the Microsoft SQL Server versus Oracle debate is equally as heated. Be that as it may, there exists a relatively simple guideline for such selections: Let the size of the data warehouse be the deciding factor (see Table 2-1).
| GB | INTEL | RISC | ||||
|---|---|---|---|---|---|---|
| NT/2000/XP | Linux | NT | UNIX/Linux | |||
| SQL Server | Oracle | Oracle | SQL Server | Oracle | Oracle | |
| 10's | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| 100's | ✗ | ✓ | ✓ | ✗ | ✓ | ✓ |
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.
