Warehouse Builder
From Oracle FAQ
Oracle Warehouse Builder (OWB) is a GUI tool and server infrastructure used for creating and managing Oracle data warehouses and data marts. It support the ETL (extract, transform and load) process, relational and dimensional modelling, data quality functions, data auditing and the full life cycle management of data and metadata.
Contents |
[edit] History and licensing
Warehouse Builder was first releases in January 2000.
OWB is licensed as part of the Oracle Developer Suite. You obviously also need to license the database side as well. Depending on how you utilize the software, you may also need to license additional products and options like the Enterprise ETL Option, Data Quality Option, Partitioning, OLAP, and Gateways.
[edit] Architecture
The OWB GUI is written in Java. Current version is OWB 10g and 11g. Versions are provided for
OWB consists of two main components:
- the design environment, which is concerned with working with meta data (abstract representations of warehouse objects, together with business rules),
- and the runtime environment, which takes this meta data and turns it into physical database objects and process flows.
[edit] Also see
- Oracle Data Integrator
