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

Recommended Oracle Architecture

With all these various architectural design options, it should be evident that the software architecture is the single most important determinant of success. As stated earlier, the end-users' business intelligence software selection and/or general user interface preferences will often decide the need for application and/or Web servers. So, the data warehousing DBA can concentrate on the database server architecture. In short, the data warehousing DBA must decide on two basic issues: number and method. When considering the issue of number, the DBA must know how many servers, instances, and databases the data warehouse will have. And, when contemplating the issue of method, the DBA must know how the data will be ...

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