Updates
Latest Tweet
What's New?
Check out for latest innovation, a computer based training video collection
Like this Page
Oracle 10g Data Warehousing Review by F. Riaz
A great resource for novices and intermediate designers to learn the nuts & bolts of data warehousing
Why Data warehousing ?
While data warehouses have been around for a while, the recent financial crises has compelled the financial institutions to do a better job of accountability (i.e. storing, measuring, and reporting of their business).
Why Oracle ?
Largest market share of database technology in the corporate world
Why this book ?
In the absence of this text, if a novice were to build a data warehouse from scratch, they will have to learn data modeling, database design, database administration, ETL, and BI. These subjects are a universe in themselves and will warrant considerable effort in terms of time and resources
What I liked about this book (in the order of importance)?
·"doing-by-learning" approach to data warehousing
·the book flows smoothly from conception, design, implementation, administration, and maintenance phases
·where applicable, all the design alternatives are discussed, and best practises are recommended
·a good balance of implementation details either via the OEM (i.e. GUI) or programming (mostly PL/SQL)
·minimal coverage of Oracle Warehouse Builder (Oracle's ETL tool) and Discoverer (Oracle's BI tool). Yes, minimal coverage makes the user aware of the existence of these tools. Anything beyond this is a waste of time, considering neither OWB nor Oracle Discoverer has gained any substantial foot hold in the ETL or BI markets
·excellent use of graphics and screen shoots on a high quality paper
Conclusions
A great spring board for anybody who wants to experience an "end-to-end" data warehouse implementation
What next ?
IBM Cognos (for aspiring BI developers)
Informatica or DataStage (for aspiring ETL developers)
Ralph Kimball's Data Warehouse Toolkit (for data modelers / architects)