Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!u72g2000cwu.googlegroups.com!not-for-mail
From: "dawn" <dawnwolthuis@gmail.com>
Newsgroups: comp.databases.theory
Subject: Re: MV Keys (was: Key attributes with list values)
Date: 26 Feb 2006 06:21:52 -0800
Organization: http://groups.google.com
Lines: 33
Message-ID: <1140963712.820976.72300@u72g2000cwu.googlegroups.com>
References: <1140522359.762187.213930@o13g2000cwo.googlegroups.com>
   <1140804359.681816.282310@t39g2000cwt.googlegroups.com>
   <1140804994.799874.324810@t39g2000cwt.googlegroups.com>
   <1140806669.181174.102510@e56g2000cwe.googlegroups.com>
   <1140812436.783278.188800@i39g2000cwa.googlegroups.com>
   <uHWLf.278635$PC2.8409285@phobos.telenet-ops.be>
   <1140883592.060038.188390@z34g2000cwc.googlegroups.com>
   <1140886408.778878.179090@i39g2000cwa.googlegroups.com>
   <1140915349.609443.285650@e56g2000cwe.googlegroups.com>
   <1140916287.800990.284570@t39g2000cwt.googlegroups.com>
   <Xz9Mf.37664$F_3.21295@newssvr29.news.prodigy.net>
   <1140928045.223226.301140@i40g2000cwc.googlegroups.com>
   <440185c0$0$11076$e4fe514c@news.xs4all.nl>
NNTP-Posting-Host: 207.199.203.250
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1140963717 22486 127.0.0.1 (26 Feb 2006 14:21:57 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 26 Feb 2006 14:21:57 +0000 (UTC)
In-Reply-To: <440185c0$0$11076$e4fe514c@news.xs4all.nl>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: u72g2000cwu.googlegroups.com; posting-host=207.199.203.250;
   posting-account=fLxfag0AAADzmFPc_IBdM-stGY4WCEYa
Xref: dp-news.maxwell.syr.edu comp.databases.theory:36909


mAsterdam wrote:
> dawn wrote:
> > ... What does it mean that a list is a key?  If
> > I change one value in the list, does that make it a new key?  I would
> > think so.
>
> If I change the order of the items in the list,
> does that make it a new key? I would think so. (See below)

Yes, I too often mix sets & lists when I think in terms of the MV data
model, which has only list attributes in which conceptual sets & lists
are both implemented.

>
> > It might model a proposition something like
> >
> > The team with people whose ID's are 112233 and 123456 has a best run of
> > 38 seconds in the potato sack race.
>
> The team with people whose ID's are 123456 and 112233 has a best run of
> 38 seconds in the potato sack race.
>
> Would be the same proposition, right?
>
> So, in this example we have a set-key, not a list-key.

Yes, unless we add to the proposition so that it matters who's on top
-- perhaps that person is the lead person, the one we want to contact,
the one whose left leg is in the sack, the parent...

Cheers!  --dawn