Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: MV Keys

Re: MV Keys

From: Marshall Spight <marshall.spight_at_gmail.com>
Date: 2 Mar 2006 09:51:43 -0800
Message-ID: <1141321903.073152.307390@i40g2000cwc.googlegroups.com>


David Cressey wrote:
> "Marshall Spight" <marshall.spight_at_gmail.com> wrote in
>
>
> > An n-ary tuple is an n-ary relation whose cardinality is constrained to
> > be exactly 1. Lots of people hate this idea, but it seems to work
> > very well.
>
> Hmmm.....
>
> The Pick folks say that a simple datum is a multivalue list with only one
> list element.
>
> I'm not sure I buy either one.

Ha! In any event, this idea is not for sale. :-)

Of all the ideas that Dawn has mentioned over the years, the one I find most intriguing is the idea that MV can handle cardinality changes easily. This is annoyingly hard in SQL. (Not prohibitively hard, but still hard.)

Again, though, this is design and not theory.

Marshall Received on Thu Mar 02 2006 - 11:51:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US