The following blog is only for history purpose and is not anymore maintained. The whole style is a mess. Sorry.

Oracle Warehouse Builder 11g: Getting Started (Paperback) by Robert Griesemer


[[http://www.packtpub.com/getting-started-with-oracle-warehouse-builder-11g?utm_source=gerardnico.com&utm_medium=bookrev&utm_content=blog&utm_campaign=mdb_001193|{{ :book:oracle_warehouse_builder_getting_started_11g.jpg|}}]]

[[http://www.packtpub.com/getting-started-with-oracle-warehouse-builder-11g?utm_source=gerardnico.com&utm_medium=bookrev&utm_content=blog&utm_campaign=mdb_001193|Oracle Warehouse Builder 11g: Getting Started by Robert Griesemer]] – ISBN 1847195741

Packt Publishing offer me the chance to review this book and I want to thank them as the author Robert Griesemer because writing a book is never an easy task.

The book is a step by step tutorial offering to construct a complete datawarehouse environment from the capture of the data, through their integration to the construction of a cube.

===== Review =====

Robert Griesemer has written a book for the beginners. With Oracle Warehouse Builders, you have three kinds of beginner :
* the complete beginners in datawarehousing design
* the beginner in datawarehousing database techniques
* the beginner with the tool
The book have clearly a great focus on the only use of the tool. Although you have a description of some datawarehouse concept (ROLAP, MOLAP), you will not find wide answer on technical and design questions such as :
* What is an OLTP system and what is the difference with a DSS/OLAP system ?
* What is a BI Application and where Oracle Warehouse Builder fit in ?
* Why do we use a bitmap index in a cube rather than a btree index ?
* Why do we have to build a cube when we can simply report against table in a dimensional model ?
By the way, the author send the reader for more datawarehouse design concepts to this book : [[book:the_datawarehouse_toolkit]].

The book compete with the [[http://www.oracle.com/technology/obe/11gr1_owb/index.htm|Oracle By Example Series (OBE)]] and one of its strength is that :
* You will play with three different data capture connections (ODBC with SQL Server, direct against an Oracle schema, and import of a flat file) where [[http://www.oracle.com/technology/obe/11gr1_owb/index.htm|OBE]] use only the last one.
* The author take his time and give tips.
I have done only the first two chapters to see if I could follow them easily and it’s the case.

For the others chapters, as the book is really rich in information, I only searched to see if I could find answer to the questions that I had as beginner. Then my review can be inaccurate.

If you search a book which explain well how to use Oracle Warehouse Builder, you can find it on the [[http://www.packtpub.com/getting-started-with-oracle-warehouse-builder-11g?utm_source=gerardnico.com&utm_medium=bookrev&utm_content=blog&utm_campaign=mdb_001193|website of the publisher]]. Beside, the [[http://www.packtpub.com/getting-started-with-oracle-warehouse-builder-11g?utm_source=gerardnico.com&utm_medium=bookrev&utm_content=blog&utm_campaign=mdb_001193|book]] is available in electronic format and it’s good for the environment.

You can also get your own opinion by reading this extracts :
* [[http://www.packtpub.com/files/5746-getting-started-with-oracle-warehouse-builder-sample-chapter-designing-the-target-structure.pdf|Sample Chapter 3 - Designing the target structure]]
* [[http://www.packtpub.com/article/time-dimension-oracle-warehouse-builder-11g|Time dimension]]

===== Environment Installation =====

The installation of the environment is completely explained and delivered in this [[http://www.packtpub.com/files/code/5746_Code.zip|archive]]. You can find below extra article which explain in more details and images the installation instructions.

==== SQL Server ====
See [[book:owb_getting_started_11g_sql_server_database_creation]]
==== Oracle Database ====
In the [[http://www.packtpub.com/files/code/5746_Code.zip|ACME_POS archive]] from the Packt web site, you can find the file create_acme_ws_orders.sql.

The original instructions can be found in the file readme.

Copy it in a directory (for instance C:TEMP5746_Code) and perform the actions below in a command dos :

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:Documents and SettingsAdministrator>cd C:TEMP5746_Code

C:TEMP5746_Code>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Oct 19 05:45:16 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> start create_acme_ws_orders.sql


Tags: , , ,

Comments are closed.