Oracle business intelligence and data warehousing tutorial
The
goal of Oracle business intelligence (BI) technologies is to turn data into knowledge in order to
improve business performance. Easier said than done! Whether you're looking for in-depth Oracle BI
and data warehousing (DW) advice and analysis, or just need to learn business intelligence or data
warehousing basics, you've come to the right place. This Oracle business intelligence and data
warehousing tutorial compiles all the news, columns and expert advice from SearchOracle.com's
archives, from broad overviews of Oracle BI and DW to tips for those who are already working with
Oracle's business intelligence and data warehousing tools.
Read the other sections of this guide on Oracle business intelligence and data warehousing:
Oracle data warehousing tutorial
Oracle
business intelligence guide
Oracle
ETL tools tutorial
In this Oracle data warehousing tutorial, learn data warehousing basics and data warehousing concepts. Get tips on using data warehousing tools, find out the most useful Oracle data warehousing features and learn about the most common data warehousing problems and how to solve them.
- New vendor has different approach to data warehousing: BIReady calls its approach "model-driven data warehousing," which allows companies to design, generate and populate a data warehouse or mart directly from a business model.>
- Do
people really understand data warehousing?: A data warehousing initiative shouldn't result in
multiple data silos, but too often that's just what happens. The problem, says guest columnist Rick
Sherman, is that data warehousing is misunderstood.
- Peering
into Bill Inmon's data warehousing crystal ball: "Data warehousing is just beginning as an
industry," according to W. H. Inmon, the father of the data warehouse. So what lies ahead?
- Data
warehouse woes? Blame your CEO: If you're disappointed with your data warehouse performance,
find out whether your CEO is doing a good job integrating disparate business units.
- Top 10
new data warehousing features in Oracle Database 10g: Plus Consultancy's Mark Rittman shares
what he believes are the 10 most exciting new data warehousing features in 10g.
- Deciding
what hardware to purchase for a data warehouse: Data warehousing expert Ian Abramson addresses
the question, "Are there formulas for deciding what hardware to purchase for a data
warehouse?"
- Data
warehousing possible on a disaster recovery hot site?: Our expert Brian Peasland responds to a
user's question: "We have been granted approval to put together a disaster recovery hot site. Our
CIO would like to do some data warehousing on the hot site. Is this possible when using DataGuard
in a standby DR replication scenario?"
- Resources
for Oracle DBA learning about DW principles: This expert response provides guidance for Oracle
DBAs looking to learn more about data warehousing.
- Using
export/import to clone a data warehouse: This detailed expert response addresses the pros and
cons of using an export/import process for DW cloning.
- MetaBase
scripting for the Oracle data warehouse DBA: This tip describes the merits of Oracle's
dbms_scheduler package and the Oracle Warehouse Builder MetaBase Plus (OMB) scripting
language.
- More
data warehousing advice: Browse the archives of Ian Abramson's expert advice on DW
implementation and ETL.
This was first published in August 2010