Home > Oracle data warehousing tutorial
Learning Guide:
EMAIL THIS

Oracle data warehousing tutorial

25 Nov 2009 | SearchOracle.com

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   

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.




    Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



    RELATED CONTENT
    Oracle data warehousing
    Oracle business intelligence guide
    BI strategies of Oracle and the megavendors
    Exadata: A first look at Oracle's entry into the appliance market
    Oracle New Year's resolutions, part 2: GRC tips and customer resolutions revealed
    Oracle's Top 8 stories of 2008
    IOUG chief discusses OpenWorld, DBA pay and security
    Oracle enters the appliance market with Exadata
    Tip: Exposing logical attributes with virtual columns
    Oracle users prepare for MDM
    Data modeling tools no substitute for hard work

    Oracle business intelligence and analytics
    Oracle business intelligence guide
    BI strategies of Oracle and the megavendors
    Ventana's Mark Smith on Hyperion and Oracle BI
    Has Oracle's BI strategy become smarter with Hyperion?
    Oracle's Primavera PPM software plans to be showcased at OpenWorld
    Oracle snaps up GoldenGate Software
    Will Sun help Oracle eclipse IBM?
    Customizing reports in Oracle CRM On Demand
    Oracle New Year's resolutions, part 2: GRC tips and customer resolutions revealed
    Oracle's business intelligence unit scores a win at the polls, signs Gallup
    Oracle business intelligence and analytics Research

    Oracle data quality
    Oracle's Fusion Applications: Way behind or right on track?
    Oracle users prepare for MDM
    Data quality getting worse
    Data integration challenges and solutions revealed
    Migrating data to legacy system as functional consultant
    New Oracle BI tool adds color to compliance efforts
    Getting BI with a little help from your friends
    Legal auditing firm retains customers with Oracle BI
    Oracle9i Warehouse Builder, integrated data quality
    Oracle9i Warehouse Builder: Data cleansing for ERP and CRM data

    RELATED GLOSSARY TERMS
    Terms from Whatis.com − the technology online dictionary
    multidimensional database  (SearchOracle.com)
    operational data store  (SearchOracle.com)
    repository  (SearchOracle.com)

    RELATED RESOURCES
    2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
    Search Bitpipe.com for the latest white papers and business webcasts
    Whatis.com, the online computer dictionary




  • Oracle Tutorials and Expert Advice
    HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Site Map




    All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
      TechTarget - The IT Media ROI Experts