Wednesday, December 26, 2012

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 metadataof 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 sideOn the server side, a Control Center Service is created.