Business Intelligence Options

There are many business intelligence tools out there, but as the DBA, it should not be your job to select one—just to support it. However, that means that you'll need a basic understanding of its architecture, resource requirements, database connection model, query construction techniques, query tuning capabilities, and numerous other aspects that will influence your software architecture definition.

There are three basic business intelligence software questions to ask:

  • Will the business intelligence user interface be fat or thin? (Will there be a web server?)

  • Will the business intelligence application be two- or three-tier? (Will there be an application server?)

  • If there are web and/or application server components, ...

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.