4 ms·
The absolute disgusting nature of standardization of data sets in the world, and this insane notion that we should maintain legacy data as the status-quo of doi
by 9ec4c12949a4f3 16y ago
The absolute disgusting nature of standardization of data sets in the world, and this insane notion that we should maintain legacy data as the status-quo of doing things.
Just look at the airline industry. IATA, ICAO, ISO, all competing and separate, all with insane and bat-shit psychotic rules and conventions (eg, IATA lets multiple airlines have the same "two letter designator" [by the way, it's sometimes three, but you never know for sure] if they operate on different parts of the globe and 'rarely if ever will confuse an operator'). When the hell did computers need human-understandable designation short-hand codes for things? What the hell was wrong with 1 - American Airlines, 2 - Air Canada, 3 - Delta, 4 - SAS, 5 - That small one that flys between A and B once a year you've never heard of. Why the HELL do we have a system that has "AA" and "AA*" ? This is basically the worst thing you can do for normalization of global data. Travel GDSs are even worse, they don't actually follow along with these standards because they cannot, so while you take your "AA" flight number 123456 (oh, by the way, we recycle flight numbers instead of archive forever historical tickets) from airport zzz to xxx (by the way, depending on the standard they came from, your airport might not even exist), which are actually city codes for airports, so when you're flying to a city with multiple airports you have two cities in the GDS just to deal with this.
We can't even agree on how to measure distance, it's like we're stuck in the stone ages. What the hell is wrong with measuring in kelvin degrees? Why do we have MORE THAN FIVE separate standards for systems of measurme for what most people think is one (the metric system)?
Fact: We do not live in 1950 or any time before then, computers don't give a flying rats ass if the letters make sense to you as a short-hand abbreviation, you should just number them. That's what databases are for, to relate data. Major airports alone have several names people call them anyway, some airlines go by a few names (for example, SAS airlines is actually "Scandinavian Airlines").
Fact: We do not need to encode data about the data into the primary key of our data. For example, we do not need to generate employee numbers like "Q100-5-TR-9" where Q is the building they work in, 100 is their pay grade, TR is their last name's first two letters, 9 is that number we introduced for separating all duplicates of Q100-5-TR. This is just stupid, stop this insanity NOW.
People working on global standards, you should be ashamed. Do you have ANY idea how much time is wasted because we do not have UUIDs for so many things, even something as simple as an airport? There's only 50,000~ of them, and we have duplicates? Did we run out of beads on the abacus??
- bambax 16y ago"Identifiers should not carry meaning": for some reason people just hate this rule and try everything to circumvent it. It drives me crazy too.
- aaronblohowiak 16y agoMedical information standards are similarly convoluted, but getting better.
- 9ec4c12949a4f3 16y agoI've seen medical stuff and there's a good reason I won't work in that industry... What REALLY bothers me is things like credit cards. http://www.merriampark.com/anatomycc.htm http://www.merriampark.com/anatomycc.htm There's encoded data on something that's supposed to be a UUID thing: Industry, Issuer (card company), Lender (banking institution), Account number, and Checksum This is a good way to prevent fraud? Or have they just given me the keys to generate "valid" credit cards? http://www.darkcoding.net/credit-card-numbers/ http://www.darkcoding.net/credit-card-numbers/ Slap a name from the phonebook on there and see what you can purchase. Now we have PCI compliance trying to tell people to somehow lock this crap down? So they invent the CV2 codes, a 1 in 1000 hit-or-miss, I don't think my odds are too bad when I can generate any creditcard. Dates will also only fall into a specific range of time anyway. Yeah, we keep putting up bandages to creditcard security processing, but why do we need to? Honestly, the world of standards sucks.