Yeah. And the fix for that has nothing to do with "de-duping" as a database operation either.
The main components would probably be:
- Decide on a new scheme (with more digits)
- Create a mapping from the old scheme to the new scheme. (that's where existing duplicates would get removed)
- Let people use both during some transition period, after which the old one isn't valid any more.
- Decide when you're going to stop issuing old SSNs and only issue new ones to people born after some date.
There's a lot of complication in each of those steps but none of them are particularly dependant on "de-duped" databases.
Maybe. I think it's more likely that she truly believed that her milquetoast approach was actually the safer option. I'm not even sure Harris was exceptionally cowardly.
Many other people would likely have folded and taken that "safe" option.
The problem is that we needed someone who went well beyond just "not cowardice". We needed an actual hero. We needed a candidate who was willing to boldly face down big money interests, even when it seemed unwise and hopeless. Harris definitely wasn't that hero.