Databases: A History of Places to Put Your Stuff

A presentation at Chicago Open Source Data Infrastructure Meetup - June 2024 in June 2024 in Chicago, IL, USA by Matt Stratton

Slide 1

Slide 2

“ Ideal for high throughput and scalability with low latency - Marketing copy for any given database, ever

Slide 3

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 4

The 1950s

Slide 5

Bigass Boxes of Punch Cards

Slide 6

1951 Univac I First magnetic tape

Slide 7

1956 IBM 305 RAMAC First disc storage

Slide 8

1961 The first DBMS Integrated Data store Charles Bachman

Slide 9

Slide 10

The 1970s

Slide 11

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

Slide 12

ORACLE AND IBM ENTER THE CAGE

Slide 13

TIME FOR POSTGRES

Slide 14

The 80s

Slide 15

Slide 16

Slide 17

The 90s

Slide 18

Slide 19

Slide 20

The 2000s and beyond

Slide 21

Slide 22

https://bit.ly/its-webscale

Slide 23

Slide 24

#nosql

Slide 25

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

Slide 26

ACID vs CAP theorem

Slide 27

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

Slide 28

Slide 29

What have we learned?

Slide 30

Let’s Talk! Twitter - @mattstratton Mastodon - @mattstratton@hachyderm.io Bluesky - @matty.wtf GitHub - mattstratton Slides - speaking.mattstratton.com LinkedIn - linkedin.com/in/mattstratton

Slide 31

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 32

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)

Slide 33

Pssst…try Aiven!