Re: What's the difference between Oracle Database and Datawarehouse

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Tue, 6 Mar 2007 09:32:35 +1100
Message-ID: <MPG.2057458fe1163e889898ee@news.readfreenews.net>

kaka.hui_at_gmail.com says...
> My understanding is, a data warehouse handles higher volumn of data.
> Is that correct? If so, what are the other difrerence? In the DBA's
> point of view, do they administer differently?

Larger data warehouses may use star-schema dimensional modeling rather standard RDBMS normalized models. If star-schemas are in use then there are certain parameters that the DBA would need to set.

Data warehouses are optimised for fast reads (at the expense of writes) and are more likely to be much more heavily indexed than a OLTP database.

From an Oracle + Data Warehouse perspective Bert Scalzo's "Oracle DBA: Guide to Data Warehousing and Star Schemas" is an excellent read.

Geoff M Received on Mon Mar 05 2007 - 16:32:35 CST