graphing the second screen - glen ford @ graphconnect london 2013
DESCRIPTION
Glen will show how a graph database is helping zeebox improve both performance and the end-user experienceTRANSCRIPT
![Page 1: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/1.jpg)
zeebox Graphing the Second Screen
![Page 2: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/2.jpg)
zeebox is Your TV Sidekick
![Page 3: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/3.jpg)
In the beginning…
We came up with rela?onal model from which we can build an EPG.
![Page 4: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/4.jpg)
So, what is the problem?
An EPG looks like a good fit for a rela?on database?
An EPG, maybe. But we have poten6ally 1.5 million EPGs…
![Page 5: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/5.jpg)
we also have a lot available data sources…
zeebox analyses live TV to understand the context
of what’s on air…
+ lots lots more…
![Page 6: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/6.jpg)
With some smart implementa?on it all worked well, but suffers from limita?ons, including how oKen we can update those EPG’s.
And we are/want to be much, much more than just an EPG.
![Page 7: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/7.jpg)
One problem to solve…
What channel? What ?me? Can Ian even see it?
![Page 8: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/8.jpg)
Now it can be done
but it’s ugly
and it’s slow.
![Page 9: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/9.jpg)
![Page 10: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/10.jpg)
hSp://www.fanpop.com/clubs/lt-‐commander-‐data/images/31158615/?tle/data-‐photo
We have all the data. Is there a smarter way to structure it?
![Page 11: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/11.jpg)
Need to handle: Structured and Semi-‐Structured Densely Connected High Read Rates Rela?vely Low Write Rates
![Page 12: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/12.jpg)
Dr Who.S1 EP1
![Page 13: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/13.jpg)
Dr Who.S1 EP1
Broadcast
AIRED_ON
![Page 14: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/14.jpg)
Dr Who.S1 EP1
Channel
Broadcast
AIRED_BYTime
AIRED_AT
AIRED_ON
![Page 15: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/15.jpg)
Dr Who.S1 EP1
Channel
Broadcast
AVAILABLE_ONAIRED_BYTime
AIRED_AT
AIRED_ON
Provider
![Page 16: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/16.jpg)
Dr Who.S1 EP1
Channel
Broadcast
AVAILABLE_ON
AIRED_BY
Time
AIRED_AT
AIRED_ON
Provider
BroadcastTime
Channel
Provider
AIRED_ON
AIRED_AT
AIRED_BY
AVAILABLE_ON
![Page 17: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/17.jpg)
MATCH
Dr Who.S1 EP1
Broadcast
AIRED_ONBroadcast
Time
Channel
Provider
AIRED_ON
AIRED_AT
AIRED_BY
AVAILABLE_ON
(b:Broadcast)<-‐[:AIRED_ON]-‐(ep:Episode)
-‐[:AIRED_ON]-‐>(d:Broadcast)
-‐[:AIRED_BY]-‐>(c:Channel)
-‐[:AVAILABLE_ON]-‐>(p:Provider),
(d:Broadcast)-‐[:AIRED_AT]-‐>(t:Time)
WHERE b.broadcast_id = {JIMs BROADCAST}
RETURN d,c,t;
AND p.provider_id = {IANs PROVIDER}
![Page 18: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/18.jpg)
But what are the numbers?
So some early benchmarks based on 7 days worth of broadcast data. Running on a 2011 MBP, 2.3GHz, 8GB with SSD Neo 1.9, MySQL 5.1 MySQL 80 seconds Cypher 1st Attempt 6 seconds Cypher after tuning 190 milliseconds Traversal* 42 milliseconds
![Page 19: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/19.jpg)
So that’s cool you can make your system faster, nice.
But that’s not actually the really good bit.
![Page 20: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/20.jpg)
Deeper ques?ons of the data…
Dr Who.
Tom Baker
BlackAdder
APPEARED_IN
APPEARED_IN
Little Britain
NARRATED
![Page 21: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/21.jpg)
Dr Who.
Tom Baker
BlackAdder
APPEARED_IN
APPEARED_IN
Little Britain
NARRATED
Broadcast
Time
Channel
AIRED_AT
AIRED_BY
AIRED_ON
![Page 22: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/22.jpg)
Flexibility of the data…
Dr Who.S1 EP1
Dr Who.S1
Dr Who.
Image.
Image.
![Page 23: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/23.jpg)
Represent the data as it is, no “wedging”
Star Trek
FRANCHISE
Star TrekVI
MOVIE
Broadcast
Star TrekS1 EP1
EPISODE
Broadcast
Star TrekCon. Live
LIVE EVENT
Broadcast
![Page 24: Graphing the Second Screen - Glen Ford @ GraphConnect London 2013](https://reader034.vdocuments.us/reader034/viewer/2022051514/54b6b79e4a79595f598b45b6/html5/thumbnails/24.jpg)
Glen
zeebox
ChiefArchitect
WORKS_FOR
HOLDS_ROLE
HAS_ROLE
@glen_ford
USES_TWITTER
[email protected]_EMAIL
Thank you.