Re: What predicates the following relation represents

From: robert <gnuoytr_at_rcn.com>
Date: 7 May 2004 05:04:01 -0700
Message-ID: <da3c2186.0405070404.21f459ac_at_posting.google.com>


"x" <x-false_at_yahoo.com> wrote in message news:<409a64a2_at_post.usenet.com>...
> **** Post for FREE via your newsreader at post.usenet.com ****
>
>
> "robert" <gnuoytr_at_rcn.com> wrote in message
> news:da3c2186.0405060759.5f17fbf9_at_posting.google.com...
> > pbrazier_at_cosmos-uk.co.uk (Paul) wrote in message
> news:<51d64140.0404070044.487ccbc6_at_posting.google.com>...
> > > "Paul Vernon" <paul.vernon_at_ukk.ibmm.comm> wrote in message
> news:<c4u8li$106q$1_at_gazette.almaden.ibm.com>...
> >
> > <snip>
> > > OK I think you understand what I'm saying but I think some others in
> > > the thread maybe don't. I'm in agreement with Date that saying
> > > something twice doesn't make it any truer. What I'm also saying is
> > > that saying something twice doesn't make it wrong.
> > <snip>
> >
> > of course it makes it wrong; unless, of course, you're treating each
> > table like a VSAM/COBOL flat file. as soon as you join to this table
> > (and if you're phobic about joins, find another line of work), you
> > get wrong results. unless you write explicit code to deal with
> > duplicates, etc.
>
> Could you give a counterexample ?

if you mean to the VSAM approach, just define a PK. duplicates will be prevented.
>
> > unfortunately, the MV/XML/java twinks are pounding the drum these days.
> > Dr. Codd gave us Data Independence with the RM. the twinks are
> > sending us back to the days of COBOL/VSAM, where the only way to
> > comprehend the data is through the application code. that is STUPID.
>
> And we refused to this day to take full advantage of "data independence" :-)
>
> > sorry for the yell, but there is clearly a regression in thought the
> > last few years. do a search on FOLDOC with 'network database'.
> > read the answer. it says it all.
>
> It isn't CLEARLY a regression. It's more like a lack of progress.

in my experience it is regression. in the period 1988->1995 (before java), even the mainstream VAR software community embraced the relational model, in the (imperfect) form of sql databases. we've gone back to diapers since.
>
>
>
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.usenet.com
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Received on Fri May 07 2004 - 14:04:01 CEST

Original text of this message