choosing primary key
-
jith - iii wrote:
Some where I read that SSN(social security number) can not be considered as primary key in complex applications. I also heard that if a person died after 50 years there is a possibility for the SSN being reassigned. Is it right?
SSNs are not reused. See http://www.ssa.gov/history/hfaq.html Q20: Are Social Security numbers reused after a person dies? A: No. We do not reassign a Social Security number (SSN) after the number holder's death. Even though we have issued over 415 million SSNs so far, and we assign about 5 and one-half million new numbers a year, the current numbering system will provide us with enough new numbers for several generations into the future with no changes in the numbering system. There have been instances of accidental duplication though, and some instances of numbers getting invalidated due to their use in advertising.
Regards, Nish
Nish’s thoughts on MFC, C++/CLI and .NET (my blog)
My latest book : C++/CLI in Action / Amazon.com linkNishant Sivakumar wrote:
the current numbering system will provide us with enough new numbers for several generations into the future with no changes in the numbering system.
About 2 generations or so. The last I heard they were expected to run out about the same time as the Y2039bug hits give or take demographic projection errors.
-- You have to explain to them [VB coders] what you mean by "typed". their first response is likely to be something like, "Of course my code is typed. Do you think i magically project it onto the screen with the power of my mind?" --- John Simmons / outlaw programmer
-
Democratic and Republican politicians on Thursday both promised to enact new federal laws by the end of the year that would restrict some commercial uses of Social Security numbers, which are often implicated in identity fraud cases.
It's actually illegal to use the SSN for any purpose other than Social Security, according to the legislation that created it, and that was one of the things that made it possible to get the law passed. Americans have long opposed any universal numbering system, even more so in the past than now. The fact that the IRS, most other government agencies, banks, and almost all employers have flagrantly violated this federal law for decades seems to have escaped the notice of the Supreme Court.
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
-
Democratic and Republican politicians on Thursday both promised to enact new federal laws by the end of the year that would restrict some commercial uses of Social Security numbers, which are often implicated in identity fraud cases.
:confused: What has this got to do with what Jith posted? You seem to prove that you are nothing more than a bot.
-
It's actually illegal to use the SSN for any purpose other than Social Security, according to the legislation that created it, and that was one of the things that made it possible to get the law passed. Americans have long opposed any universal numbering system, even more so in the past than now. The fact that the IRS, most other government agencies, banks, and almost all employers have flagrantly violated this federal law for decades seems to have escaped the notice of the Supreme Court.
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
As well as most of the public, who hand it over like nothing (myself included, though I think I'd be a little more reluctant now). I hear stuff like this all the time, yet I don't know anyone who actually challenges that. Too bad :(
¡El diablo está en mis pantalones! ¡Mire, mire! Real Mentats use only 100% pure, unfooled around with Sapho Juice(tm)! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! VCF Blog
-
Nishant Sivakumar wrote:
the current numbering system will provide us with enough new numbers for several generations into the future with no changes in the numbering system.
About 2 generations or so. The last I heard they were expected to run out about the same time as the Y2039bug hits give or take demographic projection errors.
-- You have to explain to them [VB coders] what you mean by "typed". their first response is likely to be something like, "Of course my code is typed. Do you think i magically project it onto the screen with the power of my mind?" --- John Simmons / outlaw programmer
dan neely wrote:
About 2 generations or so.
By that time, the government will probably have switched to GUID, and it will be tattooed in 10 different places on everyone's body. :)
-
Some where I read that SSN(social security number) can not be considered as primary key in complex applications. I also heard that if a person died now,after say 50 years there is a possibility for the SSN being reassigned. Is it right?
A primary key should never represent any real value like a SSN. Marc
People are just notoriously impossible. --DavidCrow
There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer
People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith -
:confused: What has this got to do with what Jith posted? You seem to prove that you are nothing more than a bot.
-
A primary key should never represent any real value like a SSN. Marc
People are just notoriously impossible. --DavidCrow
There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer
People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith -
Yeah thats what I am trying to tell, why does he need to copy paste the information about social security number. It is the bots which do stuff like this and give irrelevant information. BTW he seems to have already changed his post:doh:, he has a different text now.
-
jith - iii wrote:
Some where I read that SSN(social security number) can not be considered as primary key in complex applications. I also heard that if a person died after 50 years there is a possibility for the SSN being reassigned. Is it right?
SSNs are not reused. See http://www.ssa.gov/history/hfaq.html Q20: Are Social Security numbers reused after a person dies? A: No. We do not reassign a Social Security number (SSN) after the number holder's death. Even though we have issued over 415 million SSNs so far, and we assign about 5 and one-half million new numbers a year, the current numbering system will provide us with enough new numbers for several generations into the future with no changes in the numbering system. There have been instances of accidental duplication though, and some instances of numbers getting invalidated due to their use in advertising.
Regards, Nish
Nish’s thoughts on MFC, C++/CLI and .NET (my blog)
My latest book : C++/CLI in Action / Amazon.com linkOk.But I have read somewhere(could not get that article though I'm searching it for an hour) that in some cases like a missing identity or something like that the SSN may be reused. Like we may see more than one person with the same SSN in a 100 year period,if other guy had expired or missing long before.
-
Some where I read that SSN(social security number) can not be considered as primary key in complex applications. I also heard that if a person died now,after say 50 years there is a possibility for the SSN being reassigned. Is it right?
-
A primary key should never represent any real value like a SSN. Marc
People are just notoriously impossible. --DavidCrow
There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer
People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith -
Vikram A Punathambekar wrote:
So you fall into the "PKs should only be GUIDs" camp?
Absolutely. :) Marc
People are just notoriously impossible. --DavidCrow
There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer
People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith -
jith - iii wrote:
Ok..but can it be used as a unique key.
Ah, for indexing? That I don't know. Marc
People are just notoriously impossible. --DavidCrow
There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer
People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith -
I've been doing db related business apps for...well forever and I've come to learn that it's a wise person who uses Guid's as primary keys. Besides all the uniqueness reasons and ease of combining databases etc it's a huge performance benefit because you can generate them at the client and do single trips to the db server for just about any operation.
"110%" - it's the new 70%
-
Ok.But I have read somewhere(could not get that article though I'm searching it for an hour) that in some cases like a missing identity or something like that the SSN may be reused. Like we may see more than one person with the same SSN in a 100 year period,if other guy had expired or missing long before.
jith - iii wrote:
Ok.But I have read somewhere(could not get that article though I'm searching it for an hour) that in some cases like a missing identity or something like that the SSN may be reused. Like we may see more than one person with the same SSN in a 100 year period,if other guy had expired or missing long before.
That article was incorrect then. The site I linked to is the official govt website.
Regards, Nish
Nish’s thoughts on MFC, C++/CLI and .NET (my blog)
My latest book : C++/CLI in Action / Amazon.com link -
Vikram A Punathambekar wrote:
"PKs should only be GUIDs"
Yes.
Regards, Satips.
-
Some where I read that SSN(social security number) can not be considered as primary key in complex applications. I also heard that if a person died now,after say 50 years there is a possibility for the SSN being reassigned. Is it right?
-
jith - iii wrote:
Ok..but can it be used as a unique key.
Ah, for indexing? That I don't know. Marc
People are just notoriously impossible. --DavidCrow
There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer
People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith -
Some where I read that SSN(social security number) can not be considered as primary key in complex applications. I also heard that if a person died now,after say 50 years there is a possibility for the SSN being reassigned. Is it right?
Aside from the duplication issue, it would probably be a poor choice of primary key for a couple of other reasons. First, A person could decline to give you their SSN because of privacy or fraud concerns. If this were the case, you would have to generate a key value that does not duplicate any of the possible SSNs. The process for doing so would almost certainly be more complex than just generating a unique key up front. Second, by using SSN as a primary key, you introduce privacy requirements into your schema and processing. You would have to make sure that some output does not accidently expose the SSN to unauthorized recipients either explicitly or accidently, e.g. as part of some network communication. I would think that using SSN as a primary key would be more trouble than it is worth.