Jeff Moden wrote:
Gail Shaw wrote:
she then concludes that these results should all but put the nail in the coffin on integers vs naturals keys. This is NOT a valid conclusion to draw.
And it's not a conclusion I drew. The only conclusion drawn was that joins on integers are faster than joins on strings. The blog post states at the end:
"While this may not the final nail in the coffin for natural keys, it is worth keeping in mind when choosing between natural and artificial keys for a system, especially one likely to process large numbers of rows, such as a decision support/datawarehouse system. Test carefully with expected data volumes and expected loads if you’re considering natural keys and decide based on the result of those tests."
C'mon Gail. You shouldn't have talked about natural keys at all. It's your paragraph's topic sentence. You have to at least admit it was a reasonable inference to assume you thought this had some bearing on the statement. It does not. As for data warehouse (OLAP) systems, they should always use surrogate keys as a matter of design. The only exception I make in this regard is for flush-and-fill ETL systems. Incremental ETLs should avoid this. The only support I give to natural keys is in OLTP designs.
Why the hell not? It IS STRONGLY related and she did NOT say to avoid the use of natural keys but to take them into consideration. Based on your original misread of her conclusion, your suggestion seems to be a bit on the side of sour grapes.
Not at all. I'm using language. The hypothesis simply deals with which join is faster. The conclusion should have stayed in that area. Had it not been referenced in the topic sentence, it might have been a different matter. Not sure the response required a "strong" word to make your point.
I just think that Gail and Jeff want us to overlook the text indicating that they MAY have purchased a coffin that they're hammering nails into.
The threadizens predictable attack on perfectly reasonably offered counterpoints just makes this entire thread junk for me personally, I just feel that the "big hitters" here are somehow pathologically terrified at being incorrect in even the slightest degree, and this for me is turning SSC into the LAST place to go when discussing anything that gets the least bit complex and subjective. At least I got a giggle on Jeff's traumatic reaction, maybe I'll send him a "get well" card, maybe I'll send him a fake oscar statue, I dunno, whadya think? I have included a poll, feel free to select 3, my therapist did!
1: Send Jeff a "get well" card
2: Send Jeff a fake oscar.
3: Delete my account and get a hobby I would actually enjoy.