Index   Search   Add FAQ   Ask Question  

Oracle Data Warehousing FAQ

$Date: 06-Feb-2000 $
$Revision: 1.03a $
$Author: Frank Naudé $

Topics

  • What is a Data Warehouse?
  • What is the difference between a data warehouse and a data mart?
  • Where can I get more info about Data Warehousing?
    •
    Back to Oracle FAQ Index

    What is a Data Warehouse?

     A Data Warehouse is the "corporate memory". Academics will say it is a subject oriented, point-in-time, inquiry only collection of operational data.

    Typical relational databases are designed for on-line transactional processing (OLTP) and do not meet the requirements for effective on-line analytical processing (OLAP). As a result, data warehouses are designed differently than traditional relational databases.

  • Back to top of file

    • What is the difference between a data warehouse and a data mart?

     This is a heavily debated issue. There are in-herent similarities between the basic constructs used to design a data warehouse and a data mart. In general a data Data Warehouse is used on an enterprise level, while Data Marts is used on a business division/department level.

  • Back to top of file

    • Where can I get more info about Warehousing?

  • Back to top of file

    • General: Home | Index | Preamble | Glossary | OraCorp | Papers | Fun | News | Events | Y2000 | Books | Links | Forums
    Products: SQL | Plus | Loader | PL/SQL | PreComp | OPO | OMO | OO4OLE | DBA | PQO | PSO | OCO | Net | ODBC | WebServer | Des2k | Dev2k
    Systems: MVS | Unix | Windows | WindowsNT | NetWare | VMS