It’s entirely possible that the database is pre SQL.
Comment on How does this pic show that Elon Musk doesnt know SQL?
GaMEChld@lemmy.world 5 weeks ago
Because of course the government uses SQL. It’s as stupid as saying the government doesn’t use electricity or something equally stupid. The government is myriad agencies running myriad programs on myriad hardware with myriad people. My damned computers at home are using at least 2-3 SQL databases for some of the programs I run.
SQL is damn near everywhere where data sets are found.
ryathal@sh.itjust.works 5 weeks ago
GaMEChld@lemmy.world 5 weeks ago
He didn’t say the SSN database isn’t SQL. He said the GOVERNMENT doesn’t use SQL.
tempest@lemmy.ca 5 weeks ago
Aha Airforce one likely uses SQL
GaMEChld@lemmy.world 5 weeks ago
AF1 probably needs a database just for it’s in in-flight menu.
DahGangalang@infosec.pub 5 weeks ago
Yeah, obviously ol’ boy is tripping if he thinks SQL isn’t used in the government.
Big thing I’m prying at is whether there would be a legitimate purpose to have duplicated SSNs in the database (thus showing the First Bro doesn’t understand how SQL works).
GaMEChld@lemmy.world 5 weeks ago
Oh, well another user pointed out that SSN’s are not unique, I think they are recycled after death or something. In any case, I do know that when the SSN system was first created it was created by people who said this is NOT MEANT to be treated as unique identifiers for our populace, and if it were it would be more comprehensive than an unsecure string of numbers that anyone can get their hands on. But lo and behold, we never created a proper solution and we ended up using SSN’s for identity purposes. Poop.
JustZ@lemmy.world 5 weeks ago
I’m pretty sure there is a federal statute that says ONLY the SSA may collect or use SSNs, as to federal agencies. I argued it once when a federal agency court tried to tell me that it couldn’t process part of my client’s case without it. I didn’t care but my client was crotchety and would only even give me the last four.
aesthelete@lemmy.world 5 weeks ago
SSNs being duplicated would be entirely expected depending upon the table’s purpose. There are many forms of normalization in database tables.
DahGangalang@infosec.pub 5 weeks ago
I don’t think I get what this means. As you describe it, that reference id sounds comparable to a pointer, and so there should be a quick look up when you need to de-reference it, but that hardly seems like a “dependency knot”?
I feel like this is showing my own ignorance on the back end if databasing. Can you point me to references that explain this better?
aesthelete@lemmy.world 5 weeks ago
I’m talking about a SQL join. It’s essentially combining two tables into one set of query results and there are a number of different ways to do it.
www.w3schools.com/sql/sql_join.asp
Some joins are fast and some can be slow. It depends on a variety of different factors. But making every query require multiple joins to produce anything of use is usually pretty disastrous in real-life scenarios. That’s why one of the basics of schema design is that you usually normalize to what’s called third normal form for transactional tables, but reporting schemas are often even less normalized because that allows you to quickly put together reporting queries that don’t immediately run the database into the ground.
DB normalization and normal forms are practically a known science, but practitioners (and sometimes DBAs) often have no clue that this stuff is relatively settled and sometimes even use a completely wrong normal form for what their doing.
In most software (setting aside well-written open source) the schema was put together by someone who didn’t even understand what normal form they were targeting or why they would target it. So the schema for one application will often be at varying forms of normalization, and schemas across different applications almost necessarily will have different normal forms within them even if they’re properly designed.