RE: No Nulls? (was: Warehouse design: snowflake vs star schemas)

From: Robson, Peter <pgro_at_bgs.ac.uk>
Date: Tue, 15 Oct 2002 01:53:54 -0800
Message-ID: <F001.004E8E87.20021015015354@fatcity.com>

If you go back to that site, and take the 'Content' page ( http://www.dbdebunk.com/content.htm ) you will find two articles by Fabian Pascal on nulls. Chris Date has also written frequently on the subject of nulls. Use Google to search on <"chris date" nulls> and you will find more. (The reference to the site www.pgro.uk7.net is actually www.dbdebunk.com, just an irritating feature of the forwarding domain registration - sigh, they are the same site.)

Chris's statement that nulls are a disaster could not be more true - take note!

peter
edinburgh

> -----Original Message-----
> From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com]
> Sent: 14 October 2002 18:34
> To: Multiple recipients of list ORACLE-L
> Subject: No Nulls? (was: Warehouse design: snowflake vs star schemas)
>
>
> On the link below is this quote from C.J.Date:
>
> "I don't want you to think that my SQL solution to your
> problem means I
> advocate the use of nulls. Nulls are a disaster."
>
> Of course, he doesn't expound upon it (probably not a need except for
> dummies like me). Anyone care to comment? (On the quote, not on my
> dumminess...)
>
>
> Rich
>
>
> Rich Jesse System/Database Administrator
> Rich.Jesse_at_qtiworld.com Quad/Tech International,
> Sussex, WI USA
>
> > -----Original Message-----
> > From: Robson, Peter [mailto:pgro_at_bgs.ac.uk]
> > Sent: Monday, October 14, 2002 4:59 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Warehouse design: snowflake vs star schemas
> >
> >
> > Just for the record (and perhaps to confirm that there are
> > always two sides
> > to a story). Readers may like to see the article Chris Date
> > wrote to Ralph
> > Kemball on the subject of business rules and integrity constraints:
> >
> > http://www.dbdebunk.com/kimball1.htm
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
> 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).
>

---

This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please

scan all attachments.                            http://www.bgs.ac.uk
*********************************************************************

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robson, Peter
  INET: pgro_at_bgs.ac.uk

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 Oct 15 2002 - 04:53:54 CDT