Chapter 6: Oracle Warehousing Tools

6.1 Which tool?

So far we have built and managed our database using the SQL*Plus interface, but there are a number of tools available to the user, DBA, and designer to facilitate easy warehouse creation and access. Now we will review some of the tools available from Oracle, which includes:

  • Warehouse Builder

  • Discoverer

  • Reports (described in Chapter 8)

  • OLAP and data mining (described in Chapter 9)

Oracle Warehouse Builder is a tool that helps the DBA design and manage the data warehouse, whereas Oracle Discoverer is an end-user tool for querying your data warehouse.



Oracle9iR2 Data Warehousing
Oracle9iR2 Data Warehousing
ISBN: 1555582877
EAN: 2147483647
Year: 2005
Pages: 91

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net