No SQL - BarCamp Nürnberg 2010

Jonathan Weiss, 20.02.2010Peritor GmbH

N✮SQLData-Storage jenseits von SQL

Saturday, February 20, 2010

Wer?

Ruby-Entwickler

Open-Source-Contributor (http://github.com/jweiss)

@jweiss

2


http://github.com/mattmatt

http://github.com/mattmatt

N✮SQL-Datenbanken?

3

Built for the Web

Skalierbar

Performant

Flexibles Datenschema


4

DynamoCouchDBDynomite

Tokyo Tyrant

MongoDB

Riak

Amazon SimpleDB

Redis Memcached

BigTableAmazon S3

Cassandra

Lotus Notes

Excel ;)Neo4j

Project Voldemort HBase


Der Status-Quo

Relationale Datenstrukturen

SQL

Transaktionssicherheit

Locking

5


Das Problem

6


Das Problem

7


Die Lösung

8

”Simplicity is prerequisite for reliability“— Edsger W. Dijkstra


Die Lösung

key => “value”

9


Dokumente

10


Dokumente

10


Dokumente

10


Dokumente

10


Integrität

11


Eventual Consistency

12


Append-Only

13


Append-Only

14

Update


Append-Only

15

Update


Skalierbarkeit

16


Tools

17


Tools

18


Tokyo Tyrant

MongoDB

Riak

Amazon SimpleDB

Redis Memcached

BigTableAmazon S3

Cassandra

Lotus Notes

Excel ;)Neo4j



Tools

19


Tokyo Tyrant

MongoDB

Riak

Amazon SimpleDB

Redis Memcached

BigTableAmazon S3

Cassandra

Lotus Notes

Excel ;)Neo4j



Redis

Simpler Key-Value-Store

Speichert Strings, Listen und Sets

Semi-Persistent

20


Redis

21


Redis

set foo 4

1000

+OK

22


Redis

set foo 4

1000

+OK

22

Request

Response


Amazon SimpleDB

Database as a Service

Hoch-Skaliert

Always On

HTTP-API

23


Amazon SimpleDB

24


Amazon SimpleDB

25


Amazon SimpleDB

26

MembershipsItem #1

Name: Paul, Address: 234 Performance Rd.

Item #2Name: John, Address: 567 Couch St.

Item #3Name: Frank, Address: 321 Cloud Ave.

Item #4Name: Tom, Address: 123 Scale St.


Amazon SimpleDB

26

MembershipsItem #1





Domain


Amazon SimpleDB

27

MembershipsItem #1






Amazon SimpleDB

27

MembershipsItem #1





Item


Amazon SimpleDB

28

Memberships




Item #1Name: Paul, Address: 234 Performance Rd.


Amazon SimpleDB

28

Memberships





Attribute


Amazon SimpleDB

28

Memberships





Attribute Value


Amazon SimpleDB

Wie komme ich an die Daten?

29


Amazon SimpleDB

GetAttributes: ItemName=1

30


Amazon SimpleDB

select * from memberships where Name = ‘Paul’

31


Amazon SimpleDB

32

Simplizität durch Restriktionen


Skalierung mit Eventual Consistency

33

Amazon SimpleDB


34

CouchDBrelax


CouchDB

Dokument-orientiert

35


36

”CouchDB is built of the Web“— Jacob Kaplan-Moss


CouchDB

37

{ "_id": "BCCD12CBB", "_rev": "1-AB764C", "type": "person", "name": "Darth Vader", "age": 63, "headware": ["Helmet", "Sombrero"], "dark_side": true}


CouchDB

38



CouchDB

39



CouchDB - CRUD

Erstellen/Aktualisieren:

PUT /starwars/BCCD12CBB

Lesen:

GET /starwars/BCCD12CBB

Löschen:

DELETE /starwars/BCCD12CBB

40


CouchDB

Wie komme ich an meine Daten?

41


CouchDB

42

Views!


CouchDB

43

function(doc) { if (doc.headware) { for (var hat in doc.headware) { emit(hat, 1); } }}


CouchDB

44

function(keys, values, rereduce) { return sum(values);}


CouchDB

45


CouchDB

46


CouchDB

47


CouchDB

48


CouchDB

POST /_replication

49


Und?

Daten sind wieder König

50


Aber!

Kein goldener Hammer

51


52


53


Peritor

54

Cloud-Management und -Deployment made easy

http://scalarium.com




© Peritor GmbH - Alle Rechte Vorbehalten

Peritor GmbHBlücherstr. 22, Hof III Aufgang 610961 Berlin

Tel.: +49 (0)30 69 20 09 84 0Fax: +49 (0)30 69 20 09 84 9

Internet: www.peritor.comE-Mail: [email protected]


mailto:[email protected]

mailto:[email protected]

Documents

No SQL - BarCamp Nürnberg 2010