Also, in Codd we trust.

I Love That!

lame

In the late 1970's, "relational" was as hot an industry buzzword as "machine learning" is now.

@@Bebtelovimab looking forward to the noML hype of the 2060s

+Program differential equations for missles

Nice

BlackRock 👀?

I don't feel so bad anymore, the one I work with is approaching 1900 tables and it still keeps referential integrity, mostly.

Lol, ever seen just one table with 3 columns: name, value, type?. Barf city.

I recall working with such a DB dumping ground as a new hire at one of my previous jobs. Source data from a global company in the banking and payments space. It came with hundreds of mostly useless stored procedures and functions that were supposedly written around 2015, but contained zero proper joins in the code. My new colleagues were waiting for me to make snarky comments about it!

I came here for this comment 😂😂😂

His worst enemies were two guys called Fisher and Hook.

Made me smile, too. The video is well done.

I came here to groan at that 😅

@@cjsveningsson I love groanworthy bad puns.

I think you meant to say "FoxBase" or "FoxPro."

@@vulpo FoxPro was derived from dBase which became popular on IBM pc's in the early 80s

@@atheistbushman dBase was an awesome tool on the PC.

@@zzbeasley Agreed. I first met dBase on an Osborne luggable with 5 1/4" floppy drives and no hard disk! Later used dbase on PC and I liked Superbase under DR DOS/Gem. I think Superbase used dbase for data storage with Superbase giving a GUI front end.

Good

Humankind is generating vast amounts of data. Making sense of it all is beyond what a relational database can do well. The next step is "big data" non-relational databases. There are no keys, there is no structure to the data. The goal is to find the relations, not order them in that way. It is where we are headed. A relational database is great for what we use it for and will be used that way for a long time to come, but big data will look information a new way for a new purpose.

"Humankind is generating vast amounts of data. Making sense of it all is beyond what a relational database can do well"... did you ask ChatGPT to write this bunch of vague and disconnected catch phrases just to oppose the OP ? What would be the practical purpose of "making sense" of all data we are producing? Make a real life Matrix ?

​@@chpsilva Cook his ass

@@chpsilva A comment section is not the place to have a deep discussion about big data. I don't see that I opposed the OP, I presented what the next generation of databases are about and where the research is going. I have spent my professional life programming SQL relational databases, I do it for a living. If you are interested in the big data concepts I am talking about do a google search. Big data is useful and yes, despite your reservations, it is something that matters.

I find it remarkable that it is the only widely used non-imperative language.

Part of Data-oriented programming.

The problem is that most NoSQL databases (Mongo is fully ACID but records aren't usually normalizaed each document has all data so this doesn't mean much and so multi document transaction were only introduced in Mongo 4 mere 4 years ago) aren't fully ACID (Atomicity, Consistensy, Integrity and Durability). For things like banking transactions are a must: the money that gets out of one account must get in on another or the transaction must rollback. Unstructured or partially unstructured data are a case for NoSQL, many NoSQL databases are very simple and good in replication, but at a cost of using GUIDs as the primary key (as a surrogate key) this is not always desirable. When you get billions of records that need integrity and complex queries (Mongo performance with complex queries is abysmal) that must be done fast SQL is a must (good part of my life I passed tuning badly designed and maintained databases, and if I got a Dollar for each time I heard this can't be done faster or this can't be done in SQL I would have double what I earned).

​@@agranero6 I agree with you, but my point really was that we are ending the era when NoSQL was trendy and "you have to use it to be cool" like many other bad ideas mostly in webdev (microservices for all, complex SPAs for everything, rewriting everything in the latest language, etc). Nowadays everybody is rediscovering that SQL in its many forms is a solid language with solid ideas. Even SQLite is becoming popular! 😜 For me, I'm in both sides: For small projects I'm happy with tools like Cloud Firestore, but for more complex projects nothing that good ol' SQL.

@@agranero6 this, so much

Still can’t believe they named it “mongo” lmao

Maybe he will cover MUMPS.

For sure, a database is way more than an Excell spreadsheet. With column based storage, data compression, and parallel processing. We get things like Google, a keyword database of the entire internet. And Twitter a database that adds records at a rate of 100's of gigabytes a second, all instantly searchable.

Please post interesting fundamental question(s).

@@Martinit0 What is your background so I can gauge my wording?

Not the original poster but curious; a bachelor's degree in mathematics with no theoretical exposure to databases, and 6 months experience programming with SQL.

There are billions of ignorant people too.

I'd use the word 'care'.

At least now I know how SQL got its pronunciation ! Can't wait for the sequel ! 😊 ... and how Larry Ellison got his dirty mitts on things

_Lots_ of people know where and how SQL got started. They just had to graduate college before the rise of Java. Heck, I've still got a Relational Databases textbook in a box somewhere.

Yeah if only knowledge were stored somewhere other than UKposts... WAIT A MINUTE! 🤦‍♂

it's the moral of the story if your ideology revolves around the idea of making money.

​@@Bestmann3nlet me guess, you're a socialist and think " money bad! Me no like! >:("

@@Bestmann3n The moral still works if you just want awards.

Awesome find! Thanks! 😎✌️

Thanks. (You needed a time base corrector inline with the signal)

@@MePeterNicholls I used one, a Key West Big Voodoo. It doesn't handle dropouts in the vertical blanking very well. The tapes were very degraded unfortunately.

@@256byteram ah 👍🏼 find one these days is hard enough too tbh

@@MePeterNicholls The biggest problem were dropouts. A digital timebase corrector used with a domestic video recorder is not going to help with that. Sure they can on studio machines like Umatic, Betacam, MII etc., but domestic machines lack the required RF output signal. However it might be that the particular player could have usefully had the DOC (dropout compensator) sensitivity adjusted, I recently showed that with a Beta machine on UKposts.

Do professors tell you that physical structure of the RDBMS is as important as logical structure? As a contractor DBA I make much more money from physical structure issues than from logical ones.

@@kondybasAgreed to a point. Usually, the logical design isn’t that bad. My big problem is middleware… stuck threads, garbage collection, multi-threaded architecture and lack of commits.

for our management information systems program in university we barely do the SQL behind these academic concepts and it's really dumb, I am currently building a .NET interface for a access database just so I can practically learn this stuff.

its only called Asianometry because there's a focus on Chinese, Taiwanese, Japanese, Indian technology sector! the channel is not actually about asian culture lol

It’s oddly addictive for reasons I can’t figure out. I usually set the videos to my ‘watch later’ list for when I’m driving my daily commute.

​@@Old_Jack_Ketchi agree. It is probably because the topics in the video's are not ancient history and still have relevance to this day. But even if you started studying or working in ICT you might have never heard of many contextual details in these vids but when you hear or see them you can often instantly relate them to personal experiences (at least i can) and that's entertaining. Greetings from ASML-city!

@@thinkingcitizen I get that. I meant in terms of the initial draw for me, what made me pick this content, based solely on the name of the channel - It speaks to how genuinely interesting the selection of topics are. 😉

Agreed, this channel is a gold mine of technology history

Information exists outside of youtube, ya know. Pretending youtube is some super-special, locked down knowledge store that will never go away and is vital to maintaining a record of history... come on now. 😏

​@@mercster Asianometry helps spread this information to a wider audience without them actively searching for it. Almost every person watching this video had it recommended to them via the UKposts home page or through another recommendation method on the site. There are other sources for this information, but this video is a good way of pushing out that knowledge to a large number of people who would have not previously considered or cared about the topics discussed on the channel. Best regards.

@@broadestsmiler I'm not taking anything at all away from Asionometry, whose videos I very much enjoy. What I'm getting at is, when you lavishly heap praise in an overly-enthusiastic, hyperbolic manner that doesn't really accurately reflect reality, you diminish the genuine value.

​@@mercsterNot everybody has the time to delve into historical documents. I see this channel as a low-treshhold gateway into the early history of the computer industry. Not overly theoretical yet very informative.

underrated

S-Q-L (originally SEQUEL) had to change its name to S-Q-L due to an existing language called SEQUEL and subsequent trademark dispute. I try my best to use S-Q-L on Monday, Wednesday, Friday, SEQUEL other days, and "Squirrel" when I have had too much to drink.

squirrel 😂 - I can laugh about that joke without an IQ of 10000. - I didn’t have to come up with it, I only needed to understand. Edit: on the other hand: it seems a bit unfair, as squirrels (allegedly) sometimes forget where they stored all of their seeds for the winter, thus enabling unintended growth of trees… (- „trees“ ?😂) Edit 2: maybe the 10000 wasn’t in the decimal system, but binary 😂

Wonder what DB model squirrels use to find their hidden hazelnuts again 😉

One Rich A**hole Called Larry Ellison

One Rich As.... Called Larry Ellison

Jon missed another opportunity to cement his brand by mispronouncing industry terms.

Thank you for the clarification regarding Ingres. For personal reasons, I've been doing research on this subject off and on for years. But do you see what happens? A slight error, and history is re-writren: "Ingress (or Ingress Prime) is an augmented reality (AR) mobile game developed and published by Niantic for Android and iOS devices." Or "Jean-Auguste-Dominique Ingres 29 August 1780 - 14 January 1867) was a French Neoclassical painter. "

I can RELATE to that. WHERE did you learn such corny jokes?

When you get your coat just remember to don't DROP it on the TABLE.

It definitely made a _statement_ no one was _prepared_ for.

@@raylopez99 🤣🤣

I'd rather SELECT someone else to make jokes...

May he rest in peace

Maybe WinFS with the relational model applied to file systems.

Basic: "We let dumb folks program."

I miss Visual Basic 😭

It may be "elitist", but... While conquering C, decades ago, I couldn't get past the literal meaning of the name of my first language: BASIC The name stands for "Beginner's All-purpose Symbolic Instruction Code". Can't remain only a "Beginner" forever. Can't imagine life without a pointer... Pointless existence... 🙂

​@@kyriosity-at-github Yep, there's a reason no killer apps were ever written in BASIC.

@@rustycherkas8229 I know personally of at least three (maybe four but hazy memory) companies selling applications built using VB in active development to this day which started life as one-man bands. People may scoff at that language and look down on their work because of it, and those one-man band folk will be crying into their champagne tonight in their private south of france villas.