Databases Overview - Speaker Deck

Slide 1

Slide 1 text

Databases overview Mårten Gustafson, 2010-11-12 Hitta.se

Slide 2

Slide 2 text

Mårten Gustafson Hitta.se Java PHP HTML Oracle MySQL PostgreSQL OpenLDAP Microsoft ActiveDirectory Riak CouchDB Linux Windows OS X

Slide 3

Slide 3 text

Databases

Slide 4

Slide 4 text

* Data * Baser

Slide 5

Slide 5 text

fact / information / values %BUB * Data * Baser

Slide 6

Slide 6 text

* Data * Baser

Slide 7

Slide 7 text

fundamentals / basics CBTFT * Data * Baser

Slide 8

Slide 8 text

foundation for information %BUBCBTFT * Data * Baser

Slide 9

Slide 9 text

Information Mårten [email protected]

Slide 10

Slide 10 text

Data models • Relational • Hierarchial • Graph • Document • Key-Value

Slide 11

Slide 11 text

Relational databases Id Name 1 Mårten Person E-mail 1 [email protected]

Slide 12

Slide 12 text

Relational databases • “Most of it” (it’s the standard) • Present in “all” businesss • eg. Financial systems • eg. Your schools website

Slide 13

Slide 13 text

Hierarchical databases Mårten e-mail = [email protected] phone = 0705-10 51 98 User

Slide 14

Slide 14 text

Hierarchical databases • Account / logging in (Windows accounts)

Slide 15

Slide 15 text

Graph databases Mårten [email protected] 0705-10 51 98 e-mail phone

Slide 16

Slide 16 text

Graph databases • Facebook (friends, friends of friends, etc) • Twitter (followers)

Slide 17

Slide 17 text

Document databases name: Mårten email: [email protected] phone: 0705-10 51 98

Slide 18

Slide 18 text

Document databases • Hitta.se - PoI • train stations, weather, trafﬁc cameras

Slide 19

Slide 19 text

Key/Value Mårten => [email protected], 0705-10 51 98

Slide 20

Slide 20 text

Key/Value • Hitta.se, proﬁle pictures

Slide 21

Slide 21 text

“traditionals” Namn Typ Microsoft SQL Relational Oracle Relational PostgreSQL Relational MySQL Relational Microsoft Active Directory Hierarchial OpenLDAP Hierarchical Apache Directory Server Hierarchical IBM Tivoli Directory Server Hierarchical Novell eDirectory Hierarchical

Slide 22

Slide 22 text

“non-traditional” Namn Typ CouchDB Document MongoDB Document RavenDB Document Neo4J Graph InﬁniteGraph Graph Amazon Dynamo Key/Value Dynomite Key/Value Riak Key/Value Redis Key/Value Scalaris Key/Value Tokyo Cabinet Key/Value Voldemort Key/Value Google BigTable Column family HBase Column family Cassandra Column family

Slide 23

Slide 23 text

Try it Windows OS X / Linux Graph Neo4J Neo4J Key/Value ? Riak Document CouchDB CouchDB Relational PostgreSQL PostgreSQL

Slide 24

Slide 24 text

In the corporate world • Now - now: relational databases • Now - indirect: hierarchical • Future? • My guess: document, key/value