O'Reilly logo

Oracle® DBA Guide to Data Warehousing and Star Schemas by Bert Scalzo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Rationale for Stars

Over the past decade, an interesting computer phenomenon has occurred: Hardware technology has grown much faster than software technology. We see this all the time in the PC market with hard drives, memory, CPUs, and video cards getting more powerful and cheaper year after year. But, the same is also true in the database server world as well. Mainstream UNIX servers and their disk storage systems have grown in similar leaps and bounds. When's the last time you managed a production Oracle database on a single-processor server? Even test and development database servers are predominately multi-processor given today's low hardware costs.

But alas, the poor Oracle database and optimizer have grown at a somewhat slower pace ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required