Oracle Instance Options—Querying
The first key architectural issue the DBA must decide is how many Oracle instances will form the data warehouse for the purpose of supporting business intelligence queries? In essence, the DBA must decide how he or she will partition the data across instances. In fact, the answer to this one question alone will do more to define the available software and hardware architectural options open to the DBA than anything else.
For example, putting the entire data warehouse all in one instance will probably require a mainframe-like platform, whereas separating subject areas across instances will permit the DBA to use lots of smaller servers. Of course, it's really how the business users need access to the data that drives ...
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.
