Oracle^® Business Intelligence Data Warehouse Administration Console Guide > Overview of Oracle Business Analytics Warehouse >

Oracle Business Analytics Warehouse Architecture

High-level analytical queries, like those commonly used in Oracle Business Analytics Warehouse, scan and analyze large volumes of data using complex formulas. This process can take a long time when querying a transactional database, which impacts overall system performance.

For this reason, the Oracle Business Analytics Warehouse was constructed using dimensional modeling techniques to allow for fast access to information required for decision making. The Oracle Business Analytics Warehouse derives its data from operational applications, and uses Informatica's data integration technology to extract, transform, and load data from transactional databases into the Oracle Business Analytics Warehouse.

Figure 2 illustrates how the Oracle Business Analytics Warehouse interacts with the other components of Oracle BI Applications.

Figure 2. Oracle Business Intelligence Applications Architecture