Viewing 15 posts - 151 through 165 (of 432 total)
Ryan C. Price (11/4/2010)
I don't understand why any discussion about surrogate vs natural keys always degenerates into an idealogical 'flame-war'.
Part of the problem is a widespread lack of understanding about...
November 5, 2010 at 3:15 pm
Robert Frasca (11/4/2010)
What's seems to be confusing a number of you is that you keep referring to entities as "tables". A data entity is NOT a table.
However, in...
November 4, 2010 at 9:24 am
ta.bu.shi.da.yu (11/4/2010)
Still trying to see what desirable qualities that natural keys have. Could you point out some examples?
A natural key enforces a data integrity rule that stops some meaningful data...
November 4, 2010 at 8:48 am
Michael Wang (11/4/2010)
David Portas (11/4/2010)
Michael Wang (11/4/2010)
November 4, 2010 at 8:27 am
Michael Wang (11/4/2010)
November 4, 2010 at 8:10 am
ta.bu.shi.da.yu (11/4/2010)
ebaya (11/4/2010)
If your key changes, you update it.Yeah, along with all the data in all the tables that rely on it. Nice one.
Sure, so if you have a key...
November 4, 2010 at 7:26 am
Robert Mahon-475361 (11/4/2010)
November 4, 2010 at 6:49 am
Robert Mahon-475361 (11/4/2010)
When WOULD a Primary Key's actual data (natural or surrogate) ever actually be changed? For a natural key I could see you'd have to, but a surrogate?
I...
November 4, 2010 at 6:08 am
Robert Mahon-475361 (11/4/2010)
SSN's keep being mentioned, but they can change/be missed/be duplicates. Most other 'natural' keys end up falling to the same traps. ...
November 4, 2010 at 3:43 am
autoexcrement (11/3/2010)
Robert Mahon-475361 (10/24/2010)
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6136&whichpage=2
and quazibubble's posts. Yes he's argumentative, but...
November 3, 2010 at 6:13 pm
wagner crivelini (10/26/2010)
When you say the article mix up keys and indexes, this is kind of intentional, as most DBMSs use primary keys as clustered indexes as a default. So,...
October 27, 2010 at 12:27 am
ebaya (10/26/2010)
Robert Frasca (10/26/2010)
Tables are the product of normalization.
True-- when starting from a clean slate. In practice, the word "normalization" has come to mean aligning an existing schema with...
October 26, 2010 at 3:29 pm
wagner crivelini (10/25/2010)
As I said on this forum, I'm also a fan of surrogate keys.
Actually, my goal in this first article is to show the concepts and methods I'm using...
October 26, 2010 at 2:45 pm
Michael Valentine Jones (10/15/2010)
David Portas (10/15/2010)
Michael Valentine Jones (10/14/2010)
Always use Surrogate keys for the primary key. Add unique constraints on all natural keys (alternate keys).
A primary key means exactly the...
October 15, 2010 at 6:19 pm
Michael Valentine Jones (10/14/2010)
Always use Surrogate keys for the primary key. Add unique constraints on all natural keys (alternate keys).
A primary key means exactly the same thing as an alternate...
October 15, 2010 at 2:01 am
Viewing 15 posts - 151 through 165 (of 432 total)