In Oracle : Oracle Warehouse Builder (OWB) components & architecture

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Data Warehouse & BI

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Data Warehouse

-> Oracle Warehouse Builder (OWB) components & architecture

 

Oracle Warehouse Builder (OWB) components & architecture

 

 

The most used component of Oracle Warehouse Builder is the Design Center.

 

To access this component you must click to Start button -> All Programs -> Oracle 11g Installation Name -> Warehouse Builder -> Design Center.

 

Oracle Warehouse Builder (OWB) components & architecture

 

You can install the OWB as stand alone software as well. In this picture you can see this at Start button -> All Programs -> Oracle - OracleDataWarehouse_112 .

 

The Design Center is the main client graphical interface for designing the data warehouse.

 

 

 

Using the Design Center, you will define the logical design of the implementation. All the date about this logical implementation is stored into an Oracle database, into the OWB repository. The Oracle Warehouse Builder repository is another component of the OWB architecture. Am workspace is created in order to store this information, so we can speak about a Repository Workspace. The Repository Workspace is situated on the server side.  Here we have the metadata of the implementation.

 

 

This Repository is stored in the OWBSYS shema. This schema is created automatically with the Oracle 11g installation (initially there are no objects in there). For storing the metadata in Oracle 10g we neeed to run scripts to create this user/ schema. In Oracle11g, no SYSDBA privileges are needed for installing the repository.

 

 

One Repository may have more workspaces. Generally, one workspace is created for one project. For development, testing, production we will have one workspace for each (into the same repository). 

 

Use the Repository Assistant to configure the repository, create a workspace and create the objects in the repository.

Oracle Warehouse Builder (OWB) components & architecture

Start button -> All Programs -> Oracle 11g Installation (Name) -> Warehouse Builder -> Administration -> Repository Assistant

 

The physical implementation is done using the Control Center Manager on the client side. On the server side, a Control Center Service is created.

 

 

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Data Warehouse

-> Oracle Warehouse Builder (OWB) components & architecture

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2013  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.