On Friday 07 December 2001 20:35, Robert Chin wrote: > >> My short take on this is that a datawarehouse is a OLTP database...... > > What ??? I think you should keep that "short take" to yourself for the > benefit of those who are seeking to learn/understand about DWH. > It's not uncommon to find OLTP databases with de-normalized data, and they > are certainly NOT DWH.
Robert, tday6 was not far off the mark. First off, the logical design for an OLTP database should not have denormalizations in it. Secondly, a Data Warehouse will very much resemble an OLTP database with the addition of time series data. The structure of a Data Warehouses are designed to extract data to create data marts. Users shouldn't even be allowed near the Data Warehouse, that's what data marts are for. Mr. Inmon himself subscribes to the gist of this description of DW systems. Try not to to be so critical until you are somewhat more enlightened, and even then you could use a little tact. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
