... but alas, it was a full join. Thus, the glasses from those two tables duplicated and then duplicated again. And again. Soon, the glasses were filling the entire bar, from floor to ceiling. A union guy came and cleaned up, then declared "No more joins! If you want stuff from different tables, only unions are allowed to do that from now on."
Another great SQL history video: I have a 35 year career in SQL, and again, I was unaware of much of this history detail. And you managed to discuss Codd without going into his Rules, for which you are to be congratulated! I worked briefly at the Microsoft campus shortly after SQL Server 2000 was released, as as a customer, we were struggling to get an enterprise system ported from the earlier Sybase-based database engine code that still resided in SQL Server 6.5 into 2000, and performance was proving a big problem: the optimiser had been significantly re-written since Microsoft had forked the database engine following their split from Sybase. While I was there, I was told a story of what happened when Microsoft and Sybase parted ways. There was an agreement that upon termination of their cooperation agreement, all source code would be shared between them at that point. As you can imagine, Microsoft had done a lot of development separately. So when Microsoft sent Sybase all their final source code,, they stripped out all of the white space and mangled all the identifier names. I've never looked upon Microsoft in the same way since.
@@CaptainDangeax What exactly does the OS have to do with databases? I went from Linux to SunOS then Solaris, a stint with both Irix and AIX and on to MSSQL, ASP and .NET when it still didn't fully know what it wanted to be, stayed as a dev and systems designer with .NET and MSSQL with all the various subtrends of sorts until .NET 4.5 mostly. You can basically do anything you want faster, easier and with less resources on MS platforms compared to Linux. Linux is fine if you either opensource and do it all as a hobby more or less, or have an army of developers and testers along with a huge company doing something else too, like hardware. If you need enterprise level software developed quickly with constant iteration and customer responsiveness with a team of 2-3 people or just 1 - Linux isn't an option for a number of reasons but more than anything else speed and availability of outside resources to be hired in fast for specific tasks. But - each to their own I suppose. I'm not biased based on any other factor than what I am able to get off the ground into a full enterprise class product on my own reasonably quickly. Many times I've had that a new thing comes up, I sit down with a customer to understand their need and from that to a fully usable solution including a CRM, end user facing website, logistics partner integration, etc it's a matter of two weeks, maybe three - then it all goes live. Obviously after going live things come up but you deal with them as they come in, and 2-3 weeks after going live all issues are worked out. It then runs in production for years until there is a new something that needs to be built into it.
I remember an interview with Ted Codd in an 80's computer magazine where he made the interviewer sign an agreement that included the stipulation to refrain from calling him a "guru". Now I can't think of Codd or even SQL without that word "guru" popping into my head. Streisand effect.
The last 25 years of my work life before retirement were spent in SQL. Really liked working with it, especially the ability for ad hoc queries when unexpected information is needed. Periodically management would need some very specific information, and SQL was a great tool for that task.
I have to say the amount of effort you put into the script and production is excellent. Having worked at Logica and used databases i really enjoyed this. These subjects are fascinating because although they are considered obscure they are literally world changing. Thank you.
16:00 Date's book is what my university used for the undergrad database class in the late 80's early 90's. I still have my copy. We used DB/2 on DOS-based PCs, and Date's book. This combination started to show the idiosyncratic differences between the different SQL dialects. Over her career, my wife has used Sybase, Ingress, SQL Server, Oracle, Informix, and DB/2.
Seventh edition dedicated to the 25-th anniversary of the first edition is right on my table now :) That's why I've moved to DBA after 20 years in IT - it is a most stable and conservative branch of the CS.
RIP Jim Gray. I had the pleasure of hearing him speak multiple times in my career at Microsoft before he was lost at sea. His disappearance sent shockwaves through the company. He was such a bright light in a company full of brilliant people.
we could have so much more great software if only we had those rabbits. makes you wonder whether sticking a CS-degree on everyone with a pulse was such great idea.
I remember reading long ago that Sybase would not sell to Microsoft, so Microsoft instead hired all of their top talent. An act that kicked off the popularity of non-poaching clauses between companies and non-competes in employment contracts. We're seeing that come full circle as more and more rulings and legislation (especially in CA) are dismantling these practices.
Sybase used be in Emeryville before they moved to Dublin. I used to work at Oracle & Ed Oates office above my office & unfortunately I get his mail & he will get mine so I knew pretty well. He really didn’t need to work but wanted to do something.
Incredibly well done history. I am developing a query system (not relational, but somewhat related) and I find this extremely informative and useful. Thank you!
This is like a trip down memory lane, im to young to have known any of these products from their initial stages but I have literally had the "pleasure" (millage may vary) to work with every one of the databases mentioned in this video. It's really interesting to hear how all these sometimes nightmarish products are related. Love the video's they are a must watch pretty much regardless of the topic being covered they are always very well researched and informative, truly a joy to watch. Though some like this one make me fee very old 🙂 (I am not all that old just yet, just had the "good fortune" of working for a large enterprise that had swallowed up a little over 200 of its smaller competitors within less than a decade. That is how I got to first consolidate all the different companies systems into a few central data centers to then start and consolidating the different business applications covering the same processes into a single system either existing or newly build. Being part of that work results in you working with pretty much every DB under the sun as the logistics industry which was where this organization made its money is not known for their progressive IT procurement policies.
I was one of the 500+ first porting engr and employees of Sybase in Emeryville, CA before going public. We definitely competed against Oracle. Worked right beside Bob Epstein. Greatest time of my 40yrs of software engineering!
Hey your videos are really great, and I'm not even into SW stuff, I am an accountant that had to learn SQL when working in cost. But your videos are rich in history and I love history in all its forms.
Takes me back to my old days in Austin, Tx working at a software development company. At that time the company had made some pretty neat, small and fast software/browser-based emulators for the VAX, SYS 360, Unix/Linux and IBM 5250 Mini - all of them really including Amdahl and others from Europe. That was a lot of fun and I got to play with some of those mainframes and mini databases. They were remarkably fast and stable. It is amazing to me that SQL is still used to this day. A testament to its well thought out design. Who knows what the next innovation generation will bring? Perhaps something akin to using Quantum or other alternative systems with the only way I can put it, already connected so in a weird way "instant global connectivity and access to the data." Always enjoy your nostalgic content!
as a DBA in SQL Server, that video is amazing, I also had the pleasure of briefly work with the IBM verson of Informix, in the Avaya CMS database, kinda different dialect of SQL, but pretty easy to use
@@vulpo Besides the CAP, noSQLs are popular mostly because the declarative approach of SQL is not very clear for coders stuck with imperative languages... Queries they write are terrible.
@@kondybas Yes, this is why Object-Relational Mapping tools like Hibernate (for Java) became popular [yuck!]. However some might prefer a simpler, lighter, and more transparent approach such as with Apache DbUtils that allows the programmer to have complete control and understanding of their data and SQL queries.
It would have been worth going into much closer detail about Oracle's early days. Just like IBM, the VC community believed software existed as a give-away used to sell hardware, and nearly everyone turned Ellision down when he tried to raise VC funding. When he finally succeeded, he got the brainless oaf Don Valentine on his Board, and Valentine was famously addicted to his notion "you can never fire a startup CEO too fast" - which led Sequoia to destroy dozens of potentially world-beating companies early in their lifecycle. Somehow Ellison managed to avoid Valentine's destructive impulses long enough to reach the IPO. Then, at the $1 billion revenue mark, Oracle nearly detonated because of Ellision's very poor financial management. Plus, Ellision played some very dubious games with the stock, resulting in his co-founders becoming nowhere near as incredibly rich as he himself did. It's an interesting tale and shows that there's a lot more to success than technology and timing.
@@fensoxx While Oracle was reasonably effective at its job as a database, its efficiency and stability didn't quite live up to the hype in sales presentations-it worked amazingly on the projector slide deck (the presentation materials), but customers using the tech in the real world didn't get the performance they were hoping for.
Really like this story. Feels like I have been part. I started as DBA on mainframe network database - then was sysadmin on Unix with first version informix growing with two phase commit and SQL. I remember Stonebraker came to Informix . Anyway great memories - today we came so far with technology and this knowledge is as important as ever ❤
This was your best video EVER. I was in the industry in the early 90s when things had shaken out and I only saw the remnants. Thank you. Will there be a Part 2? 😬
I really appreciate your efforts! A bit off-topic, but I wanted to ask: My OKX wallet holds some USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). What's the best way to send them to Binance?
At 11:59, the picture, bottom left hand corner. The Data General Corporation Nova 3 with an either Phoenix(5MB removable/5MB fixed) or Gemini(10MB removable/10MB fixed) disk drive system. DGC's hardware system I supported as a Field Engineer. Also the Eclipse and then the MV-Series. DGC went on to commercialize RAID, with the Clariion. Good Times.
Asianometry coul you make a video about a company or economic sector of mexico? There is not as good of economic evolution analisis as yours out there.
Hey bro, Awesome videos, I look forward to seeing them but I'm not sure what Google (RUclips) is playing at but I just had to resubscribe to your channel.
I wish to see more stories about database programs because I use Microsoft Access 2021. It is somewhat simpler to use than previous versions. Your computer histories impress me very much.
It's amazing how IBM shoots one more time themselves on the foot. Another was Sybase selling the code to Microsoft, just to see Microsoft eat their lunch. My guess is they were thinking windows is never going to dominate the Enterprise, back then you had to restart Windows NT one time per day, not exactly stable. But they launch to the sky riding the WinTel model.
Didn't Asianometry already do SQL a few weeks ago? For those SELECT few who read this, I say: AS FROM WHERE Asianometry got the idea to do another video on SQL, I'm not HAVING it. AND BETWEEN you and me, Asiometry, you can DELETE this post. But I LIKE and subscribe to your channel.
You’ve missed a huge part of the history. That of Information Engineering, as promulgated and taught by Clive Finkelstein and James Martin. They developed a methodology for designing relational databases by modeling business data using the relational model. This was a prerequisite to implementing with Oracle or similar dbms. I know. I was there
I made my career doing SQL mostly, is a fascinating story. I wonder if Doctor Codd imagined how impactful was the whitepaper he wrote all those years ago.
interesting how dedicated Oracle were (at the start anyway) to being compatible with Big Blue. That seems like a canny choice for an underdog. Double edged sword though if you accidentally become the industry leader.
I have used every kind of databases in my career of computing. Every. The relational DB is by far the easiest to write software for, but also slowest of them all. Back in the day when the computers and their drives were veeeery slow, other types of databases were necessary. Today we can work with relational databases.
I never used SQL because the "relational" databases I was using was keyed with the realtime stamps and those were (practically) never in sync. Timestamps as double-precision real numbers, you have to interpolate something to match them, usually I interpolated the vessel position as we knew it travelled more or less in a straight line.
With the right hardware, RDBMSs out pace other systems in high concurrency ACID compliant transaction processing, such as core banking, share trading, gaming (horses), lotteries etc... They are also great for CRMs.
I read CJ Date's books when I learned SQL at UCLA. I used Microsoft SQL later at Massachusetts General Hospital to build a research registry for the neonatal ICU.
@@snuscaboose1942 No. HTML for the user interface, Cold Fusion 1.5 for the interface generator, and Microsoft SQL for the database itself. I could have used Javascript to make the menu mask prettier, but artistry is not one of my strengths.
Jim Gray didn't invent the Transaction. IBM's IMS database and transaction-server (formerly IMS DB/DC), had this feature from 1969, and other database products may have had it even earlier. IMS just had different terminology than later RDBMSs. IMS had "Unit-of-Work" instead of a transaction (a transaction was the software you wrote to process an actual business transaction in real time), "Sync-point" instead of Commit, "Backout" instead of rollback, and "Program Isolation" instead of transactionality. Using the 1969 IMS server, the DC server, you could define your Transaction to be re-tryable so that, if there was a deadlock, it would "pseudo-abend" (terminate and roll-back) one of the threads, complete the other, then rerun the killed thread. IMS rocked! (Except you had to be on the spectrum, or something, in order to use it.) Jim Gray just devised the "Two Phase Commit" to include other external resources in the UoW/Transaction. ie. "Is everyone ready to commit?", then "OK, actually commit now.".
20:59 Alex. Brown & Sons! Have to say I do miss the niche bankers like them, H&Q, even Adams, Harkness & Hill. At the time the financial side was more relational too (for better or worse). Seems less so now.
I remembre building an early version of Oracle on a Taiwanese AT-class compatible PC, back in the 80... It tooked some 20 floppy disks, at least ! But the product was running, complete. All on a 640KBytes RAM (I had to check !) machine. Waouh !
please do a course on Coursera or Patreon on anything you find interesting, especially on the actual history of technology, I would pay for it. alternatively, write a book.
A SQL query walks into a bar, he sees two tables and joins them
Then he has a row with the owner.
The owner only authorizes select clients
That was pretty good 😂 I haven't heard that one
@@feraudyhWhen the bouncers list is updated he seats the selected guests at the joined tables where their ID matched their nametags 😂
... but alas, it was a full join. Thus, the glasses from those two tables duplicated and then duplicated again. And again.
Soon, the glasses were filling the entire bar, from floor to ceiling.
A union guy came and cleaned up, then declared "No more joins! If you want stuff from different tables, only unions are allowed to do that from now on."
As a daily user of sql databases, i really enjoy hearing the history
Aren't we all daily users of SQL databases? Hahaha
@@glass00jdofiwbskdg there're wild tribes in Amazonia who ain't.
Another great SQL history video: I have a 35 year career in SQL, and again, I was unaware of much of this history detail. And you managed to discuss Codd without going into his Rules, for which you are to be congratulated!
I worked briefly at the Microsoft campus shortly after SQL Server 2000 was released, as as a customer, we were struggling to get an enterprise system ported from the earlier Sybase-based database engine code that still resided in SQL Server 6.5 into 2000, and performance was proving a big problem: the optimiser had been significantly re-written since Microsoft had forked the database engine following their split from Sybase.
While I was there, I was told a story of what happened when Microsoft and Sybase parted ways. There was an agreement that upon termination of their cooperation agreement, all source code would be shared between them at that point. As you can imagine, Microsoft had done a lot of development separately. So when Microsoft sent Sybase all their final source code,, they stripped out all of the white space and mangled all the identifier names. I've never looked upon Microsoft in the same way since.
That sounds like what will Bill do.
I pity you for working on MS databases. It was always painful to me, and I'm a happy Linux engineer now
@@CaptainDangeax What exactly does the OS have to do with databases? I went from Linux to SunOS then Solaris, a stint with both Irix and AIX and on to MSSQL, ASP and .NET when it still didn't fully know what it wanted to be, stayed as a dev and systems designer with .NET and MSSQL with all the various subtrends of sorts until .NET 4.5 mostly.
You can basically do anything you want faster, easier and with less resources on MS platforms compared to Linux. Linux is fine if you either opensource and do it all as a hobby more or less, or have an army of developers and testers along with a huge company doing something else too, like hardware. If you need enterprise level software developed quickly with constant iteration and customer responsiveness with a team of 2-3 people or just 1 - Linux isn't an option for a number of reasons but more than anything else speed and availability of outside resources to be hired in fast for specific tasks.
But - each to their own I suppose. I'm not biased based on any other factor than what I am able to get off the ground into a full enterprise class product on my own reasonably quickly. Many times I've had that a new thing comes up, I sit down with a customer to understand their need and from that to a fully usable solution including a CRM, end user facing website, logistics partner integration, etc it's a matter of two weeks, maybe three - then it all goes live. Obviously after going live things come up but you deal with them as they come in, and 2-3 weeks after going live all issues are worked out. It then runs in production for years until there is a new something that needs to be built into it.
6:30 lmao at the Boeing picture :)
Maybe they found the Bolts in the Database? 🤔
I just paused the video to come comment the same thing! 🤣
@@MotokoKaiousei they're actually probably in there, how it got out of sync with the real world is a different question though :P
Isn't that their new logo??
That had me rolling 🤣🤣
I remember an interview with Ted Codd in an 80's computer magazine where he made the interviewer sign an agreement that included the stipulation to refrain from calling him a "guru". Now I can't think of Codd or even SQL without that word "guru" popping into my head. Streisand effect.
Wierd from Codd. Do u know why he put that condition to avoid calling him Guru?
@@thiruvetti I don't remember. But it was just one of several stipulations. Wierd enough for the interviewer to comment about it.
@@thomasgilson6206 Ok. Tx
My father was COO of ASK/Ingress in the very early 90's. while I joined Oracle in 1993... exciting years.
Ingres was better
The last 25 years of my work life before retirement were spent in SQL. Really liked working with it, especially the ability for ad hoc queries when unexpected information is needed. Periodically management would need some very specific information, and SQL was a great tool for that task.
Ellison, Gates -- you've outdone yourself in the pictures you chose for them. Nice job!
3 months ago???
@@TheHilariousGoldenChariot Patreon?
When he says early access he really means early.@@TheHilariousGoldenChariot
Ellison looks so yass. Looking forward to Oracle 24.0.yass
I have to say the amount of effort you put into the script and production is excellent. Having worked at Logica and used databases i really enjoyed this. These subjects are fascinating because although they are considered obscure they are literally world changing. Thank you.
16:00 Date's book is what my university used for the undergrad database class in the late 80's early 90's. I still have my copy. We used DB/2 on DOS-based PCs, and Date's book. This combination started to show the idiosyncratic differences between the different SQL dialects. Over her career, my wife has used Sybase, Ingress, SQL Server, Oracle, Informix, and DB/2.
Seventh edition dedicated to the 25-th anniversary of the first edition is right on my table now :)
That's why I've moved to DBA after 20 years in IT - it is a most stable and conservative branch of the CS.
"The company now known as Oracle has a chaotic history."
Understatement, subtle like a brick.
RIP Jim Gray. I had the pleasure of hearing him speak multiple times in my career at Microsoft before he was lost at sea. His disappearance sent shockwaves through the company. He was such a bright light in a company full of brilliant people.
"Porting like drunk rabbits". A phrase I must use more often.
we could have so much more great software if only we had those rabbits. makes you wonder whether sticking a CS-degree on everyone with a pulse was such great idea.
Would have tried replicating instead of porting, but porting is so IT related.
I remember reading long ago that Sybase would not sell to Microsoft, so Microsoft instead hired all of their top talent. An act that kicked off the popularity of non-poaching clauses between companies and non-competes in employment contracts. We're seeing that come full circle as more and more rulings and legislation (especially in CA) are dismantling these practices.
A teaser finish (a bloody teaser!) about the history of databases.... and I am hooked.
Sybase used be in Emeryville before they moved to Dublin.
I used to work at Oracle & Ed Oates office above my office & unfortunately I get his mail & he will get mine so I knew pretty well. He really didn’t need to work but wanted to do something.
This was so informative Asianometry. Fills in a lot of context behind things I've wondered about for a while. Thanks!
Incredibly well done history. I am developing a query system (not relational, but somewhat related) and I find this extremely informative and useful. Thank you!
If you do it right, you might become the next Larry Ellison!
6:36 It’s slides like these that keep me coming back
wrangling and cleaning a 60GB database, the "VACUUM;" command made me laugh
Really enjoying this multi-part look into the history of SQL and databases in general 👍
This is like a trip down memory lane, im to young to have known any of these products from their initial stages but I have literally had the "pleasure" (millage may vary) to work with every one of the databases mentioned in this video. It's really interesting to hear how all these sometimes nightmarish products are related.
Love the video's they are a must watch pretty much regardless of the topic being covered they are always very well researched and informative, truly a joy to watch. Though some like this one make me fee very old 🙂 (I am not all that old just yet, just had the "good fortune" of working for a large enterprise that had swallowed up a little over 200 of its smaller competitors within less than a decade. That is how I got to first consolidate all the different companies systems into a few central data centers to then start and consolidating the different business applications covering the same processes into a single system either existing or newly build. Being part of that work results in you working with pretty much every DB under the sun as the logistics industry which was where this organization made its money is not known for their progressive IT procurement policies.
Jon, you are fantastic. Thankyou for being the 'no nonsense historian' of our sector.
I've watched a few of your videos. I have zero programming ability, but the history is fascinating. Looking forward to the future
I was one of the 500+ first porting engr and employees of Sybase in Emeryville, CA before going public. We definitely competed against Oracle. Worked right beside Bob Epstein. Greatest time of my 40yrs of software engineering!
Hey your videos are really great, and I'm not even into SW stuff, I am an accountant that had to learn SQL when working in cost. But your videos are rich in history and I love history in all its forms.
Can you send this movie, with the ACID part highlighted, to British Post Office and Fujitsu?
Only if it comes with a side of mushrooms.
@@DrewNorthup are you trying to say they're not delusional enough?
@@wolcek It might open their minds…
@@DrewNorthup assuming there is anything to open.
Takes me back to my old days in Austin, Tx working at a software development company. At that time the company had made some pretty neat, small and fast software/browser-based emulators for the VAX, SYS 360, Unix/Linux and IBM 5250 Mini - all of them really including Amdahl and others from Europe. That was a lot of fun and I got to play with some of those mainframes and mini databases. They were remarkably fast and stable. It is amazing to me that SQL is still used to this day. A testament to its well thought out design. Who knows what the next innovation generation will bring? Perhaps something akin to using Quantum or other alternative systems with the only way I can put it, already connected so in a weird way "instant global connectivity and access to the data." Always enjoy your nostalgic content!
Oracle was early implementers of Row level locking and that was one of the major trumpcard besides being available on all major systems
as a DBA in SQL Server, that video is amazing, I also had the pleasure of briefly work with the IBM verson of Informix, in the Avaya CMS database, kinda different dialect of SQL, but pretty easy to use
Keep making these great videos! I'm loving the format and the well-researched content!
Can we do a history of the current major open source SQL software? (mysql, mariadb, postgresql, etc)
i think that would fit for a part 3 or part 4 video on sql databases.
@@Armadurapersonal I agree, those RDBMS started around the end of the nineties, so there still a lot to cover in next videos.
And finally an episode on the challenges to relational databases by the No-SQL upstarts and where we are today.
@@vulpo Besides the CAP, noSQLs are popular mostly because the declarative approach of SQL is not very clear for coders stuck with imperative languages... Queries they write are terrible.
@@kondybas Yes, this is why Object-Relational Mapping tools like Hibernate (for Java) became popular [yuck!]. However some might prefer a simpler, lighter, and more transparent approach such as with Apache DbUtils that allows the programmer to have complete control and understanding of their data and SQL queries.
I have so much work to do but you keep seducing me with well researched videos on topics I should not be binge watching!
I resemble that.
It would have been worth going into much closer detail about Oracle's early days. Just like IBM, the VC community believed software existed as a give-away used to sell hardware, and nearly everyone turned Ellision down when he tried to raise VC funding. When he finally succeeded, he got the brainless oaf Don Valentine on his Board, and Valentine was famously addicted to his notion "you can never fire a startup CEO too fast" - which led Sequoia to destroy dozens of potentially world-beating companies early in their lifecycle. Somehow Ellison managed to avoid Valentine's destructive impulses long enough to reach the IPO. Then, at the $1 billion revenue mark, Oracle nearly detonated because of Ellision's very poor financial management. Plus, Ellision played some very dubious games with the stock, resulting in his co-founders becoming nowhere near as incredibly rich as he himself did. It's an interesting tale and shows that there's a lot more to success than technology and timing.
Loved the slide projector joke. I laughed heartily 👍
Break it down for us plebes please 🤤
@@fensoxx While Oracle was reasonably effective at its job as a database, its efficiency and stability didn't quite live up to the hype in sales presentations-it worked amazingly on the projector slide deck (the presentation materials), but customers using the tech in the real world didn't get the performance they were hoping for.
I worked on a product that used Sybase for the backend in the mid 2000's and quite enjoyed it. It was straightforward to setup and get running.
Really like this story.
Feels like I have been part. I started as DBA on mainframe network database - then was sysadmin on Unix with first version informix growing with two phase commit and SQL. I remember Stonebraker came to Informix .
Anyway great memories - today we came so far with technology and this knowledge is as important as ever ❤
".... and boeing [shows missing door plug] "... aw hell that was savage
This was your best video EVER. I was in the industry in the early 90s when things had shaken out and I only saw the remnants. Thank you.
Will there be a Part 2? 😬
Love it - Oracle database ran best on PowerPoint and slide projectors 🤣
In other words, it never ran as well as Oracle promised it would in the sales presentations. Yeah... that sounds about right.
Yep, runs best in a sales pitch.
Eventually, the database became rock solid. Version 5 was a good release.
The time I used Oracle, 9i to 11g, it was rock solid
Oracle was, and still has more bugs than Starship Troopers. It was an absolute nightmare.
Love the video, always love you channel, you're just brilliant!
Only thing - it's not "seequel" - albeit it's original name - it's "SQL"...
17:00 - Wait - you lived in Dublin?!
21:40 - "...like drunk rabbits, ..." - huh? 🙂
The SEQUEL paper at 2:11 was published 50 years ago this week.
A nice relational coincidence.
Fun fact - only 2 people maintain the tz timezone database that virtually every operating system queries to configure geos
As a DBA, across DBASE, Oracle, IBM AS/400, I loved this video. Will probably watch it many times....
Brooks was the 360 project manager, not the designer of it, as far as I remember.
Slide Projector! What a knee slapper! You have a great sense of humor.
No foils?
WE LOVE YOU ASIANOMETRY!!!!!YOURE THE BEST
I really appreciate your efforts! A bit off-topic, but I wanted to ask: My OKX wallet holds some USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). What's the best way to send them to Binance?
At 11:59, the picture, bottom left hand corner. The Data General Corporation Nova 3 with an either Phoenix(5MB removable/5MB fixed) or Gemini(10MB removable/10MB fixed) disk drive system. DGC's hardware system I supported as a Field Engineer. Also the Eclipse and then the MV-Series. DGC went on to commercialize RAID, with the Clariion. Good Times.
My database class about data normalization was one of the hardest classes.
That course has paid off handsomely for me. Third normal form is a mindset.
Asianometry coul you make a video about a company or economic sector of mexico? There is not as good of economic evolution analisis as yours out there.
Cool! I'm watching at the moment. I hope I can do something useful one day like these guys. Thanks for sharing this story.
How does Borland dBase fit into this ? Im not that up with the technicals ...for that matter Access ?
Will you be doing a video on Digital or DEC?
Your videos are superb. I thoroughly enjoy this channel. Excellent. Thank you.
Hey bro,
Awesome videos, I look forward to seeing them but I'm not sure what Google (RUclips) is playing at but I just had to resubscribe to your channel.
I wish to see more stories about database programs because I use Microsoft Access 2021. It is somewhat simpler to use than previous versions. Your computer histories impress me very much.
Yes! This is exactly the video I was waiting for and you did not disappoint!
How a database maintains 'coherency' (data integrity) would be its own interesting topic. I imagine some form of 'lock' protocol is involved.
It's amazing how IBM shoots one more time themselves on the foot. Another was Sybase selling the code to Microsoft, just to see Microsoft eat their lunch. My guess is they were thinking windows is never going to dominate the Enterprise, back then you had to restart Windows NT one time per day, not exactly stable. But they launch to the sky riding the WinTel model.
Didn't Asianometry already do SQL a few weeks ago? For those SELECT few who read this, I say: AS FROM WHERE Asianometry got the idea to do another video on SQL, I'm not HAVING it. AND BETWEEN you and me, Asiometry, you can DELETE this post. But I LIKE and subscribe to your channel.
I never thought I would have to type by hand into the URL bar to access YT videos. LOL
Yes we women do love databases!!!
The history of scientific & mathematical advances yields an understanding of today and how we got here.
Thank you for your educational efforts.
the many blunders of IBM and Xerox are legendary
3:24 that pronunciation of Stonebraker got me rollin for days ngl
You’ve missed a huge part of the history. That of Information Engineering, as promulgated and taught by Clive Finkelstein and James Martin. They developed a methodology for designing relational databases by modeling business data using the relational model. This was a prerequisite to implementing with Oracle or similar dbms. I know. I was there
I made my career doing SQL mostly, is a fascinating story. I wonder if Doctor Codd imagined how impactful was the whitepaper he wrote all those years ago.
was that lighthouse a reference to SHIELDs lighthouse at season 6?
interesting how dedicated Oracle were (at the start anyway) to being compatible with Big Blue. That seems like a canny choice for an underdog. Double edged sword though if you accidentally become the industry leader.
I have used every kind of databases in my career of computing. Every. The relational DB is by far the easiest to write software for, but also slowest of them all. Back in the day when the computers and their drives were veeeery slow, other types of databases were necessary. Today we can work with relational databases.
I never used SQL because the "relational" databases I was using was keyed with the realtime stamps and those were (practically) never in sync. Timestamps as double-precision real numbers, you have to interpolate something to match them, usually I interpolated the vessel position as we knew it travelled more or less in a straight line.
Also cloud computing has led to the rise of more non relational databases as well
@@OldieBuggerGeoInformation is also a problem for relational databases. GoogleMaps was one of the first apps to go to noSQL .
@@stang9806how? AWS offers RDS. All my contacts with noSQL were on premises.
With the right hardware, RDBMSs out pace other systems in high concurrency ACID compliant transaction processing, such as core banking, share trading, gaming (horses), lotteries etc... They are also great for CRMs.
I read CJ Date's books when I learned SQL at UCLA. I used Microsoft SQL later at Massachusetts General Hospital to build a research registry for the neonatal ICU.
You didn't use MUMPS (Massachusetts General Hospital Utility Multi-Programming System) or it's diabolical derivative, M?
@@snuscaboose1942 No. HTML for the user interface, Cold Fusion 1.5 for the interface generator, and Microsoft SQL for the database itself. I could have used Javascript to make the menu mask prettier, but artistry is not one of my strengths.
The timing couldn't have been perfect
I just started my Database course at uni on the same day of upload 😅
HONEY! STOP EVERYTHING YOU'RE DOING! ASIANOMETRY JUST DROPPED A VIDEO! GRAB YHE THE POPCORN!
Jim Gray didn't invent the Transaction. IBM's IMS database and transaction-server (formerly IMS DB/DC), had this feature from 1969, and other database products may have had it even earlier. IMS just had different terminology than later RDBMSs. IMS had "Unit-of-Work" instead of a transaction (a transaction was the software you wrote to process an actual business transaction in real time), "Sync-point" instead of Commit, "Backout" instead of rollback, and "Program Isolation" instead of transactionality. Using the 1969 IMS server, the DC server, you could define your Transaction to be re-tryable so that, if there was a deadlock, it would "pseudo-abend" (terminate and roll-back) one of the threads, complete the other, then rerun the killed thread. IMS rocked! (Except you had to be on the spectrum, or something, in order to use it.)
Jim Gray just devised the "Two Phase Commit" to include other external resources in the UoW/Transaction. ie. "Is everyone ready to commit?", then "OK, actually commit now.".
Worked with IBM RBase for many years... Excellent only found one bug !!
C.J. Date's book is how we learned databases in uni! I owe a big chunk of my career to what I learned from that book.
yea president bush sr is just "some guy" lol
That projector joke is pretty good.
Interesting... I've been working with relational databases since '86 - Informix, then Oracle, ...
I'm glad you're continuing with the history of SQL.
Best jokes ever - so far.. you had me laugh out loudly at least three times. What an achievement for a monday morning
20:59 Alex. Brown & Sons! Have to say I do miss the niche bankers like them, H&Q, even Adams, Harkness & Hill. At the time the financial side was more relational too (for better or worse). Seems less so now.
Of course you used the picture of the plane with the blown-out door plug for Boeing.
This is so arcane one day you might start doing history of containers and load balancers. Good job!
As an American production there was no space to discuss Logica's Rapport relational database of the late 1970's.
I subscribed a minute into the video. never done that before. love the channel name too lol.
I remembre building an early version of Oracle on a Taiwanese AT-class compatible PC, back in the 80... It tooked some 20 floppy disks, at least ! But the product was running, complete. All on a 640KBytes RAM (I had to check !) machine. Waouh !
The mean girls quote was a nice tough haha
That Boeing picture was gangster
Excellent piece of content !
Nice Video. Thanks!
0:47 Thought this was a barbershop quartet video but no, it’s about SQL.
Really a great continuation of the previous video, and hoping for a good ending for this miniseries.
please do a course on Coursera or Patreon on anything you find interesting, especially on the actual history of technology, I would pay for it. alternatively, write a book.
@6:30: great picture to represent Boeing..... 😄
So important a channel explains history of technology
7:40 why do they always put the gate in the muddiest corner of the field.....?
They don't. It only becomes muddy after frequent use.
@@poetryflynn3712 whoooosh
It's an old joke.....
@@robturner3065 Jokes are useless constructions that only exist in the heads of the user.
Informix’s Informer, is that what Snow was singing about
7:54 Wow! Danny DeVito was into computer software? Oh my goodness!