News for hackers. Stuff that matters.

A comment on SQL Keys in Depth. Parent comment

Re:SQL Keys in Depth by tzahola on Tuesday January 02, 2018 @05:15AM (#16051020)
>I think the point was that for a 40 people club odd are very very poor that two people would have the same name.

Wrong. For example I have exactly the same name as my father and we're members of the same squash club.

[ Parent | on HN ]
Re:SQL Keys in Depth by twic on Tuesday January 02, 2018 @03:34PM (#16055354)
I don't have exactly the same name as my father, and we are not members of the same squash club. So, in the sample so far, there's only a 50% chance of that happening. I suspect that if we enlarged the sample, it would fall much further.

A single counterexample does not falsify the theory that the odds are very very poor!

[ Parent | on HN ]
Re:SQL Keys in Depth by Dylan16807 on Wednesday January 03, 2018 @04:56AM (#16059759)
We're interested in the odds of collision of people in the same club. Any data about people not sharing a club is irrelevant.

> I suspect that if we enlarged the sample, it would fall much further.

Try to back that up, maybe.

[ Parent | on HN ]