Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Design question DW

Design question DW

From: <>
Date: Fri, 19 Oct 2001 07:02:34 -0700
Message-ID: <>

Hello List,

     I have a design question for a datawarehouse application. I have done OLTP design, but no DW design before. The issue is that this warehouse is being fed from an existing system that allows multi-values. What I mean by multi-values is a column that has comma delimited values in it. So for example, if there is a car table with a column that says tire_size, if the car can handle tire sizes of p200, p240, and p250 then for a select on the one row with that car in it, under the tire column you would have p200,p240,p250.
I would never even think about letting this thru in an OLTP system, and if I didn't have access to the list I wouldn't allow it in a data warehouse either. But, since I have the advantage of your expertise, I thought I might as well use it. There are about 40 of these columns in 5 tables in the proposed design by the developer. The developer is trying to say that they won't use these columns in the where clauses on most of them and that they are just detailed data for display. I have been around long enough to know how fast that changes, and all of a sudden the database is a dog and everyone is blaming the DBA.

     So my question is, am I just an OLTP DBA in new territory, or the same principles apply, and multi-values are still one of the biggest relational design disasters regardless of OLTP or DW.

Any help is appreciated,

You too can have your own email address from Eurosport.


Please see the official ORACLE-L FAQ:


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: (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 Fri Oct 19 2001 - 09:02:34 CDT

Original text of this message