- Paperback: 368 pages
- Publisher: Packt Publishing Limited (December 15, 2010)
- Language: English
- ISBN-10: 1847195741
- ISBN-13: 978-1847195746
- Product Dimensions: 7.5 x 0.8 x 9.2 inches
- Shipping Weight: 794 g
- Average Customer Review: Be the first to review this item
Oracle Warehouse Builder 11g: Getting Started Paperback – 15 December 2010
|New from||Used from|
Amazon Global Store US
About the Author
Bob Griesemer has over 27 years of software and database engineering/DBA experience in both government and industry, solving database problems, designing and loading data warehouses, developing code, leading teams of developers, and satisfying customers. He has been working in various roles involving database development and administration with the Oracle Database with every release since Version 6 of the database from 1993 to the present. He has also been performing various tasks, including data warehouse design and implementation, administration, backup and recovery, development of Perl code for web-based database access, writing Java code utilizing JDBC, migrating legacy databases to Oracle, and developing Developer/2000 Oracle Forms applications. He is currently an Oracle Database Administrator Certified Associate, and is employed by the Northrop Grumman Corporation, where he is currently a Senior Database Analyst on a large data warehouse project.
No customer reviews
|5 star (0%)||0%|
|4 star (0%)||0%|
|3 star (0%)||0%|
|2 star (0%)||0%|
|1 star (0%)||0%|
Review this product
Most helpful customer reviews on Amazon.com
The book was written by Bob Griesemer. Although he's not a recognized name in the industry, he has been working with various database solutions for more than 25 years. His experience with various industries and even in some government institutions have provided the needed knowledge in getting this book done. He is currently the Senior Database Engineer in Northrop Grumman Corporation. His profile also indicates that he has worked with Oracle since its 6th version which means he has monitored almost every major change of Oracle since its inception.
The book is intended for those who want to learn more about data warehousing from scratch. The introduction on the necessity of data warehousing is very interesting since it provides a closer look on how database administrators should understand data manipulation in servers. The book slowly moves to complicated subjects as it tries to help readers fully understand each step.
Even though the book is intended on those starting in data warehousing, the book can be a good refresher for experts. The later chapter can be a good reference in case special functions in data warehousing should be used.
It aims to introduce data warehousing in general and Oracle Warehouse Builder in particular, to absolute beginners in the field.
In chapter 1 the author guides us through the installation process for OWB 11G. A typical installation of Warehouse Builder in a client/server environment is explained. More complex architectures with the Control Center service on a different server are not explained.
In chapter 2 we are introduced to the data model of the source system for the data warehouse. We are shown how to import or create the metadata for our source system. What I found useful here is that the author explains how we can use a non-Oracle RDBMS (in this case SQL Server) as a source system via heterogenous services. This can be a pain to set up so it is helpful to have a step by step walkthrough for this.
Chapter 3 gives an introduction to the basics of data warehouse design. It then explains how we can implement such a design as a target structure in Oracle Warehouse Builder.
In chapter 5 the author gives an overview on the basics of ETL processes and introduces us to some of the more important OWB operators that will allow us to implement ETL process in Warehouse Builder. I found that more space should have been given to explain the operators in detail. Some more detailed examples for each would have been useful also.
Chapters 6 and 7 then show us how we can bring the source metadata from chapter 2, the target metadata from chapter 3, and the operators from the previous chapter together in a Warehouse Builder mapping to extract, transform, and load data from source to target. What is completely missing here though is an introduction to process flows. Process flows are fundamental to glue ETL mappings in Warehouse Builder together and should have been part of an introduction to the subject.
Chapter 8 gives an overview on the deployment and execution of objects via the OWB Control Center. It also includes a good troubleshooting section with regards to deployment. As expected from a beginner's book, more advanced topics such as deployment via OMB+ and TCL scripts is not explained. What is also missing is an explanation on how to schedule objects once they have been deployed.
In chapter 9 the author introduces us to various OWB features. The book gives a good overview on version management via snapshots and export/import of metadata.
The book does pretty much what it says on the tin and gives a good introduction to novices in the area of data warehousing and Oracle Warehouse Builder. So if you have never used Oracle Warehouse Builder this book is for you. If you have used OWB before you will not learn anything new here. Also this book can only be a starting point for your OWB career. A lot more OWB features than are outlined in this book need to be learned to become a master in the area (if you think about it the OWB user manual in PDF format has about 1000 pages and in some areas only scratches at the surface). Also the timing of the publication of the book is a bit unfortunate as only recently OWB 11GR2 was released with a lot of important new features and a redesigned User Interface. Hopefully there will be a 2nd edition soon that addresses this shortcoming.