4 ms·
The “real” unique identifier is such a common problem. And the solution is almost always “model, make, and serial number.” Plus year of production if necessary
by pyuser583 1y ago
The “real” unique identifier is such a common problem. And the solution is almost always “model, make, and serial number.”
Plus year of production if necessary.
I’ve seen programmers attempt deduplicate humans by language spoken.
- oflebbe 1y agoI know about systems who had two types of serial numbers which ought to be the same, but weren‘t because they had been programmed at different eol stages, when daylight savings time kicked in. One of the system run in utc the other in local time. Date was part of the serial.
- sixdimensional 1y agoParallel production lines with overlapping sequences also cause this, especially in aerospace- it is widely known that Airbus does it, for example.
- specialist 1y agoVery interesting thread. Noob me would have guessed the "source of truth" would be whatever identifier(s) is recorded by the insurance company. Or maybe the service and maintenance agreements. Failing that, I would have guessed some kind of (natural) compound key derived from the transfer(s) of ownership (Airplane Purchase Agreement? Bill of Sale?) noting the unique major components like airframe, interior, and engines? And maybe wings? Sounds like a fun problem. Thanks for sharing.
- fho 1y agoHow does "model, make and serial number" translate to humans? (No racist intentions here, but you bring up both points and I thought that to be interesting)
- godelski 1y agoJohnson Smith The son of John who is a smith I'm only joking a little. Funny thing, surnames aren't actually that old for Europeans. Most of history there'd be maybe two people with the same name. They solved it back then very much the same way we solve it now. https://en.wikipedia.org/wiki/Category:Occupational_surnames https://en.wikipedia.org/wiki/Category:Occupational_surnames https://en.wikipedia.org/wiki/Patronymic https://en.wikipedia.org/wiki/Patronymic
- pjc50 1y agoEven worse in other languages. The three surnames Kim, Lee, and Park cover about 50% of Koreans.
- godelski 1y agoYou should see Vietnamese! It's decreasing, but it used to be ~40%! Now it's closer to 30[0]. And don't forget that there's Lee[1], Lee[2], Lee[3], Lee[4], and Lee[5]! Which are all different [0] https://en.wikipedia.org/wiki/Vietnamese_name https://en.wikipedia.org/wiki/Vietnamese_name [1] https://en.wikipedia.org/wiki/Lee_(English_surname) https://en.wikipedia.org/wiki/Lee_(English_surname) [2] https://en.wikipedia.org/wiki/L%C3%BD_(Vietnamese_surname) https://en.wikipedia.org/wiki/L%C3%BD_(Vietnamese_surname) [3] https://en.wikipedia.org/wiki/Lee_(Korean_surname) https://en.wikipedia.org/wiki/Lee_(Korean_surname) [4] https://en.wikipedia.org/wiki/Li_(surname_%E6%9D%8E) https://en.wikipedia.org/wiki/Li_(surname_%E6%9D%8E) [5] https://en.wikipedia.org/wiki/Li_(surname_%E5%88%A9) https://en.wikipedia.org/wiki/Li_(surname_%E5%88%A9)
- sandbach 1y agoBesides the two you mention, there are ten other Chinese surnames that could be anglicized as Lee, namely 力, 勵, 厲, 栗, 澧, 禮, 立, 酈, 離, and 黎.
- fho 1y agoTo be fair, that's probably still "good enough" these days. "Abel Davidson Carpenter of Helsinki born in the year 2020" is probably good enough an identifier. Obviously has some issues, but it's interesting to see that this "ancient" scheme would still hold up these days.
- bombcar 1y ago> And the solution is almost always “model, make, and serial number.” If you've ever spent time in old car forums, you learn that even this isn't enough because of production-line sloppiness. Serial number re-use is rare, but it happens. Usually because a product had something detected that resulted in remanufacturing, but sometimes other things slip.
- thaumasiotes 1y ago> I’ve seen programmers attempt deduplicate humans by language spoken. How is that supposed to help? If two people have the same name, it's overwhelmingly likely that they also speak the same language.