Databases: A History of Places to Put Your Stuff

A presentation at Toronto Open Source Data Infrastructure Meetup in May 2023 in Toronto, ON, Canada by Matt Stratton

Slide 1

Slide 1

Databases: A History of Places to Put Your Stuff

Slide 2

Slide 2

Slide 3

Slide 3

“ It’s like one person 8 years ago wrote the slappingest piece of database marketing copy known to man and everyone else remixed it like they’re trying to get away with plagiarizing a high school book report. - Kat, complaining on Twitter

Slide 4

Slide 4

Damn that’s a lot of databases in-memory, active, cloud, data warehouse, deductive, descriptive, document-oriented, embedded, federated, heterogeneous, graph, array, hypertext, knowledge base, mobile, operational, parallel, probabilistic, real-time, spatial, temporal, terminology-oriented, unstructured

Slide 5

Slide 5

The 1950s

Slide 6

Slide 6

Bigass Boxes of Punch Cards

Slide 7

Slide 7

1951 Univac I First magnetic tape

Slide 8

Slide 8

1956 IBM 305 RAMAC First disc storage

Slide 9

Slide 9

1961 The first DBMS Integrated Data store Charles Bachman

Slide 10

Slide 10

Slide 11

Slide 11

The 1970s

Slide 12

Slide 12

How relational databases work Edgar Codd, the top gun of tables

Slide 13

Slide 13

ORACLE AND IBM ENTER THE CAGE

Slide 14

Slide 14

TIME FOR POSTGRES

Slide 15

Slide 15

The 80s

Slide 16

Slide 16

Slide 17

Slide 17

Slide 18

Slide 18

The 90s

Slide 19

Slide 19

KAT RESIST THE URGE TO JUST PUT A BIG PHOTO OF GRADY BOOCH HERE, HE KNOWS YOU USE HIM IN HIS TALKS AND IT’S PROBABLY GETTING CREEPY

Slide 20

Slide 20

Slide 21

Slide 21

The 2000s and beyond

Slide 22

Slide 22

Slide 23

Slide 23

https://bit.ly/its-webscale

Slide 24

Slide 24

Slide 25

Slide 25

#nosql

Slide 26

Slide 26

key-value graph column NoSQL isn’t just document model document

Slide 27

Slide 27

ACID vs CAP theorem

Slide 28

Slide 28

The World Wide Webs is technically just a large, distributed hypertext database

Slide 29

Slide 29

Slide 30

Slide 30

What have we learned?

Slide 31

Slide 31

KAT Twitter - @dixie3flatline Bluesky - @kat.lol GitHub - katcosgrove LinkedIn - linkedin.com/in/katcosgrove MATTY Twitter - @mattstratton Mastodon - @mattstratton@hachyderm.io Bluesky - @matty.wtf GitHub - mattstratton Slides - speaking.mattstratton.com LinkedIn - linkedin.com/in/mattstratton

Slide 32

Slide 32

REFERENCES ● ● ● ● ● A Timeline of Database History & Database Management Wikipedia entry for databases and history IBM Information Management System MongoDB is Web Scale video Charles Bachman

Slide 33

Slide 33

ATTRIBUTIONS This presentation is licensed under the Creative Commons Attribution-ShareAlike https://creativecommons.org/licenses/by-sa/3.0/deed.en Photo of Edgar Codd - Photo copyright IBM Relational database diagram from Photo of Michael Stonebreaker - Photo by David Monniaux Photo of an IBM punched card - Photo by Peter Birkinshaw, CC By 2.0 Photo of an IBM 305 RAMAC - Photo by Norsk Teknisk Museum dBase Logo Drawing of Route 53 Database t-shirt logo - Copyright Corey Quinn (probably)