Re: Newbie question about db normalization theory: redundant keys OK?
Date: Sun, 16 Dec 2007 14:14:27 -0000
Message-ID: <nIidnZ42CIler_jaRVnygwA_at_giganews.com>
"Brian Selzer" <brian_at_selzer-software.com> wrote in message
news:U2W8j.80311$Um6.5491_at_newssvr12.news.prodigy.net...
>
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas_at_acm.org> wrote in message
> news:HZednQ8PPZsCBP7anZ2dnUVZ8qClnZ2d_at_giganews.com...
>> The only way to tell whether the current state of the database equals
>> some previous state is to query again and compare that to a result
>> previously retrieved. That comparison is usually based on a key value. It
>> makes no difference what type of value is used for the key. The
>> comparison is exactly the same whether it is an "artificial" key or
>> otherwise. (I'm not too concerned about defining what an "artificial" key
>> is because I don't think it matters).
>>
>
> I disagree. Unless the identifier is a rigid designator or a rigid
> definite description, then any comparison based upon that identifier is
> suspect. It may be the case that the key values are identical, but the
> individuals in each state that are identified by that key value are
> different individuals. For example, "the first person in line" can be
> different people at different times.
>
Isn't that purely a question of what propositions we want to represent?
Assume that the tuple:
represents the proposition:
P: "Teacher named Celko teaches class 'Database 101' in room 222 during period 6"
B: ('Selzer', 'Database 101', 222, 6)
C: ('Celko', 'Zen Buddhism', 223, 6)
representing propositions of the same kind as P.
>> BTW I seriously doubt whether it would be possible or desirable to
>> implement anything like a ROWVERSION in a true RDBMS. The consequences of
>> SQL Server's implementation are serious because it attempts to identify
>> row data based on something other than keys. I have never been a fan of
>> the ROWVERSION feature.
>>
>
> In what way does it attempt to identify row data based on something other
> than keys?
-- David PortasReceived on Sun Dec 16 2007 - 15:14:27 CET