orientdb, the fastest document-based graph database @ confoo 2014 in montreal (ca)

129

Upload: alessandro-nadalin

Post on 08-May-2015

4.546 views

Category:

Technology


5 download

DESCRIPTION

OrientDB is a NoSQL graph database which also includes a document layer (like MongoDB): it gained a lot of attention, enough to push big companies like Sky and UltraDNS to use it in production: it's written in Java and it's amazingly fast, since it can store up to 150,000 records per second on common hardware; moreover, thanks to being a graphdb, it can manage relationship so fast that, compared to traditional DBs, can be 1000% faster than them.

TRANSCRIPT

Page 1: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 2: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 3: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 4: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 5: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 6: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 7: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 8: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 9: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 10: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 11: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 12: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 13: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 14: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 15: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 16: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 17: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 18: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 19: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 20: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 21: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 22: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 23: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 24: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 25: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 26: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 27: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

parent_id

Page 28: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 29: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 30: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 32: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 33: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 34: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 35: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 36: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 37: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 38: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 39: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 40: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 41: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 42: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 43: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 45: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

<a href=”http://en.wikipedia.org/wiki/Sergei_Stepashin”>Sergei Stepashin

</a>

Page 46: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

<a href=”http://en.wikipedia.org/wiki/Sergei_Stepashin”>Sergei Stepashin

</a>

Page 47: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

<a href=”http://en.wikipedia.org/wiki/Sergei_Stepashin”>Sergei Stepashin

</a>

Page 48: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 49: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 50: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 51: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 52: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 53: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 54: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 56: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 57: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 58: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 59: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 60: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 61: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 62: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 63: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 64: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 65: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 66: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 67: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 68: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

SELECT FROM Vehicle WHERE owner = 1:1

Page 69: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 70: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 71: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

MichelleObama

BarackObama

AngelaMerkel

Kim Jong-un

NicolasSarkozy

Page 72: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

MichelleObama

BarackObama

AngelaMerkel

Kim Jong-un

NicolasSarkozy

SELECT FROM fellas WHERE any() traverse(0,-1) (@rid = [Michelle @rid])

Page 73: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

MichelleObama

BarackObama

AngelaMerkel

Kim Jong-un

NicolasSarkozy

SELECT FROM fellas WHERE any() traverse(0,-1) (@rid = [Michelle @rid])

Page 74: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

MichelleObama

BarackObama

AngelaMerkel

Kim Jong-un

NicolasSarkozy

SELECT FROM fellas WHERE any() traverse(0,2) (@rid = [Michelle @rid])

Page 75: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

MichelleObama

BarackObama

AngelaMerkel

Kim Jong-un

NicolasSarkozy

SELECT FROM fellas WHERE any() traverse(0,2) (@rid = [Michelle @rid])

Page 76: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 77: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 78: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

SELECT FROM authors WHERE book.title = ...

Page 79: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

SELECT FROM authors WHERE book.title = ...

Page 80: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 81: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 82: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 83: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 84: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 85: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

SELECT FROM Cats

Page 86: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

SELECT FROM Cats

Page 87: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

SELECT FROM 1:0

Page 88: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

SELECT FROM 1:0

Page 89: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

SELECT FROM [1:0, 1:1]

Page 90: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

SELECT FROM [1:0, 1:1]

Page 91: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

SELECT FROM [1:0, 2:1]

Page 92: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

SELECT FROM [1:0, 2:1]

Page 93: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 94: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

./path/to/orientdb/bin/server.sh

Page 95: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 96: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 98: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 99: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 100: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 102: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 105: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 106: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

~ � httparty -u admin:admin 'http://127.0.0.1:2480/command/mydb/sql/SELECT%20FROM%20user'

{"result"=> [{"@type"=>"d", "@rid"=>"#9:0", "@version"=>0, "@class"=>"user", "email"=>"[email protected]", "password"=> "123456"}, {"@type"=>"d", "@rid"=>"#9:2", "@version"=>0, "@class"=>"user", "email"=>"[email protected]", "password"=> "123456"}]}

Page 107: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 108: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 110: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

use Doctrine\OrientDB\Binding;

$url = 'http://admin:[email protected]:2480/demo';$parameters = Binding\BindingParameters::create($url);$orient = new Binding\HttpBinding($parameters);$response = $orient->query("SELECT FROM User");

foreach ($response->getResult() as $user) { echo $user->name;}

Page 111: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

use Doctrine\OrientDB\Binding;

$url = 'http://admin:[email protected]:2480/demo';$parameters = Binding\BindingParameters::create($url);$orient = new Binding\HttpBinding($parameters);$response = $orient->query("SELECT FROM User");

foreach ($response->getResult() as $user) { echo $user->name;}

Page 112: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

use Doctrine\OrientDB\Binding;

$url = 'http://admin:[email protected]:2480/demo';$parameters = Binding\BindingParameters::create($url);$orient = new Binding\HttpBinding($parameters);$response = $orient->query("SELECT FROM User");

foreach ($response->getResult() as $user) { echo $user->name;}

Page 113: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

use Doctrine\OrientDB\Binding;

$url = 'http://admin:[email protected]:2480/demo';$parameters = Binding\BindingParameters::create($url);$orient = new Binding\HttpBinding($parameters);$response = $orient->query("SELECT FROM User");

foreach ($response->getResult() as $user) { echo $user->name;}

Page 114: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

use Doctrine\OrientDB\Binding;

$url = 'http://admin:[email protected]:2480/demo';$parameters = Binding\BindingParameters::create($url);$orient = new Binding\HttpBinding($parameters);$response = $orient->query("SELECT FROM User");

foreach ($response->getResult() as $user) { echo $user->name;}

Page 115: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 116: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

Alessandro Nadalin

Page 117: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

Alessandro Nadalin

@_odino_

Page 118: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

Alessandro Nadalin

@_odino_

Namshi | Rocket Internet

Page 119: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

Alessandro Nadalin

@_odino_

Namshi | Rocket Internet

VP Technology

Page 120: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

Alessandro Nadalin

@_odino_

Namshi | Rocket Internet

VP Technology

odino.org

Page 121: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

Thanks!Alessandro Nadalin

@_odino_

Namshi | Rocket Internet

VP Technology

odino.org

Page 122: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 123: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 124: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 125: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 126: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 127: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)
Page 128: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)

Thanks!Alessandro Nadalin

@_odino_

Namshi | Rocket Internet

VP Technology

odino.org

Page 129: OrientDB, the fastest document-based graph database @ Confoo 2014 in Montreal (CA)