Viewing 15 posts - 31 through 45 (of 57 total)
Hugo Kornelis (10/26/2010)
I'd say that you are both correct. The normalization process deals with one table at a time. But you have to do this for all tables to get...
October 26, 2010 at 8:30 am
denis.hosdil (10/26/2010)
OK. I think 1nf through 3nf deals with decomposing a single table.
No it doesn't. The rules are typically illustrated by decomposition of a single table, simply...
October 26, 2010 at 8:19 am
Hugo Kornelis (10/26/2010)
October 26, 2010 at 8:02 am
ta.bu.shi.da.yu (10/26/2010)
October 26, 2010 at 7:44 am
ta.bu.shi.da.yu (10/26/2010)
I suspect it may be you who is not really understanding that a relational database is so called because...
October 26, 2010 at 7:38 am
ta.bu.shi.da.yu (10/25/2010)
October 25, 2010 at 3:30 pm
ta.bu.shi.da.yu (10/25/2010)
What does that even mean?!?
It means performance responds to increasing workload in an O(n) (linear) or better manner. Some people loosely use buzzwords like "scalable" to simply mean...
October 25, 2010 at 3:01 pm
Robert Frasca (10/25/2010)
October 25, 2010 at 2:53 pm
ta.bu.shi.da.yu (10/25/2010)
October 25, 2010 at 2:46 pm
cdesmarais 49673 (10/25/2010)
I'm familiar with that article. It's a not a junction table, and it's not based on sequential random inserts.
I'm not sure what you mean by an...
October 25, 2010 at 2:36 pm
Robert Mahon-475361 (10/25/2010)
A) Does the person have an SSN? .... Just use a PK and you'll not worry about that.
Robert, you've misunderstood my post. I wasn't advocating an...
October 25, 2010 at 2:31 pm
ta.bu.shi.da.yu (10/25/2010)
Uh... no, he's right. You normalize an individual table, no normal forms work on multiple tables simultaneously.
I'm sorry, but this isn't the case at all. Several...
October 25, 2010 at 2:28 pm
cdesmarais 49673 (10/25/2010)
But if you assume truly random inserts, updates, and deletes (a pair of GUIDs for example), my benchmarks came up consistently in favor of the heap.
You might want...
October 25, 2010 at 2:17 pm
Huh? What extra int column are you talking about? We're talking about a junction table with two FKs, period. The question is whether you have a...
October 25, 2010 at 2:08 pm
denis.hosdil (10/25/2010)
I agree in terms of inserts, updates, deletes - the heap would be fastest.
This isn't correct. In general, a clustered index outperforms a heap -- even for...
October 25, 2010 at 2:02 pm
Viewing 15 posts - 31 through 45 (of 57 total)