Oracle-L: RE: What is a 'data mart'?

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Tue, 29 Apr 2003 12:26:49 -0800
Message-ID: <F001.0058C33E.20030429122649@fatcity.com>

the stuff I work with, I have seen the data mart to be a collection of related
data from the warehouse that have multiple dimension. Information from the data mart
is used to generate molap cubes for reporting.

brian

-----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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Spears, Brian
INET: BSpears_at_Limitedbrands.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------