| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: What is a 'data mart'?
<rant>
I went to a DataWarehousing conference and after 5 days of classes, I was able to finally figure out what a DW is.
The level of agreement among the various camps is that a DW is a non-transactional database.
Some camps say that a DW Must be a star schema. Others say that it cannot be. Some say that a DW can only be used to feed DataMarts, another says that it is the database that is queried. One says that the DW cannot be operationally populated or queried the other encourages it.
There is even less agreement as to what a DataMart is. It boiled down to a DataMart being data that can be queried. Could be a DW itself. A database optimized for query. A single star schema. A set of related tables.
In summary. A DataWarehouse is a database. And a DataMart is data. </rant>
My personal opinion is that a DW is more of an large-scale solution. It is designed to store, manage and analyze data from the enterprise, department or even a region. A DataMart is smaller in scale -- sales for the region, purchasing for the enterprise, etc.
In either case, the DW/DM is periodically populated from operational data and is organized to allow for efficient querying.
Kevin
-----Original Message-----
Sent: Tuesday, April 29, 2003 2:53 PM
To: Multiple recipients of list ORACLE-L
Ive read some documentation and its not 100% clear on what this means. I think people use the terminology differently. I take it to mean that you can have one main warehouse environment where you have a repository of your data, then you can publish parts of that data warehouse to individual data marts which are simply subsets of the data warehouse.
Are data marts OLAPs? or is the terminology used with transaction processing as well?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <rgaffuri_at_cox.net
INET: rgaffuri_at_cox.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Apr 29 2003 - 14:51:43 CDT
 |
 |