OLTP + OLAP ftw! QCon San Francisco November 8, 2016 ABOUT ME - - PowerPoint PPT Presentation

▶
oltp olap ftw
SMART_READER_LITE
LIVE PREVIEW

OLTP + OLAP ftw! QCon San Francisco November 8, 2016 ABOUT ME - - PowerPoint PPT Presentation

Jan 28, 2024 379 likes •1.06k views

OLTP + OLAP ftw! QCon San Francisco November 8, 2016 ABOUT ME Developed web apps for 5 years including e-commerce, business workflow, more. Worked at Google for 8 years on Google Apps, Cloud Platform Technologies: Python, Java,

slide-1
SLIDE 1

OLTP + OLAP ftw!

November 8, 2016

QCon San Francisco

slide-2
SLIDE 2

ABOUT ME

  • Developed web apps for 5 years

including e-commerce, business workflow, more.

  • Worked at Google for 8 years on

Google Apps, Cloud Platform

  • Technologies: Python, Java,

BigQuery, Oracle, MySQL, OAuth ryan@neo4j.com @ryguyrg

slide-3
SLIDE 3
  • Quick intro to Graph DBs

  • How Analytics works with Neo4j - then, now, and soon!

  • Our patriotic duty to combine the two

Talking about Today

slide-4
SLIDE 4

What is a Graph?

slide-5
SLIDE 5
slide-6
SLIDE 6
slide-7
SLIDE 7

A Graph Is Connected Data

slide-8
SLIDE 8 ROAD TRAFFIC LIGHTS

A Graph Is Connected Data

slide-9
SLIDE 9 HAS AVAILABLE

A Graph Is Connected Data

HOTEL ROOMS AVAILABLE
slide-10
SLIDE 10

What does a Graph look like?

slide-11
SLIDE 11

Whiteboard Model is the Physical Model

slide-12
SLIDE 12

Ann Dan Loves

Graphing Love

slide-13
SLIDE 13

Property Graph Model

CREATE (:Person { name:“Ann”} ) - [:LOVES]-> (:Person { name:“Dan”} )

LOVES

LABEL PROPERTY NODE NODE LABEL PROPERTY

slide-14
SLIDE 14

CAR DRIVE

name: “Dan” born: May 29, 1970 twitter: “@dan” name: “Ann” born: Dec 5, since: 
 Jan 10, brand: “Volvo” model: “V70”

LOVES LOVES LIVES WITH OWN

PERSON PERSON

Property Graph Model: Extended

slide-15
SLIDE 15

GRAPHS FOR OLTP

slide-16
SLIDE 16

Intuitivness Speed Agility

slide-17
SLIDE 17

What about Neo4j?

CREATE MODEL

+

LOAD DATA QUERY DATA

slide-18
SLIDE 18

CYPHER!!!!

(Graphs)-[:ARE]->(Everywhere)

slide-19
SLIDE 19

How do you Query?

slide-20
SLIDE 20
slide-21
SLIDE 21

How do you use Neo4j?

slide-22
SLIDE 22

Official Language Drivers

slide-23
SLIDE 23

Community Language Drivers

slide-24
SLIDE 24

Extending Neo4j

slide-25
SLIDE 25
slide-26
SLIDE 26
slide-27
SLIDE 27

GRAPHS FOR

ANALYTICS

slide-28
SLIDE 28

(1) DATA IN GRAPH (4) QUERY GRAPH (2) ANALYZE RELATIONSHIPS (3) RESULTS IN GRAPH

slide-29
SLIDE 29

Spark’s API for graph processing

GraphX

slide-30
SLIDE 30

MAZERUNNER FLOW

slide-31
SLIDE 31

NEO4J SPARK CONNECTOR

slide-32
SLIDE 32

CYPHER over BOLT

Neo4j Spark Connector

slide-33
SLIDE 33

APOC Library

slide-34
SLIDE 34

CYPHER over BOLT

APOC Library

slide-35
SLIDE 35
slide-36
SLIDE 36

GRAPHS FOR

RECOMMENDATIONS

slide-37
SLIDE 37 Related products People who bought X also bought Y

Recommendations (In Real-Time)

The main product
slide-38
SLIDE 38 L O O K S _ A T KITCHEN AID SERIES
slide-39
SLIDE 39 L O O K S _ A T Complaints reviews Tweets Emails KITCHEN AID SERIES
slide-40
SLIDE 40 L O O K S _ A T Returns Complaints reviews Tweets Emails KITCHEN AID SERIES
slide-41
SLIDE 41 L O O K S _ A T Returns Inventory Complaints reviews Tweets Emails KITCHEN AID SERIES
slide-42
SLIDE 42 L O O K S _ A T Returns Home delivery Inventory Express goods Complaints reviews Tweets Emails Location/ KITCHEN AID SERIES Promotions Bundling
slide-43
SLIDE 43 L O O K S _ A T Returns Purchase History Price-range Home delivery Inventory Express goods Complaints reviews Tweets Emails Category Promotions Bundling Location/ KITCHEN AID SERIES
slide-44
SLIDE 44 L O O K S _ A T Returns Purchase History Price-range Home delivery Inventory Express goods Complaints reviews Tweets Emails Category Promotions Bundling Location KITCHEN AID SERIES
slide-45
SLIDE 45
slide-46
SLIDE 46

Simple Recommendations

slide-47
SLIDE 47

Content Filtering: Article Recommendations

slide-48
SLIDE 48

Content Filtering: Article Recommendations

slide-49
SLIDE 49

Content Filtering: Product Recommendations

slide-50
SLIDE 50

Content Filtering: Product Recommendations

slide-51
SLIDE 51

Our Patriotic Duty

slide-52
SLIDE 52

Legislative Graph

slide-53
SLIDE 53

Determining Influence

slide-54
SLIDE 54

Determining Influence

slide-55
SLIDE 55
slide-56
SLIDE 56

Executing PageRank

slide-57
SLIDE 57

Most Influential Senators

slide-58
SLIDE 58

Most Influential Representatives

slide-59
SLIDE 59

Recommend to Me:





Member of Congress who can get me a Tesla everyone ^

slide-60
SLIDE 60

Subject Matter Experts

slide-61
SLIDE 61

Combining Analytics + Subgraph Traversal

slide-62
SLIDE 62

Other Graph Algorithms

  • Community Detection

  • Centrality (Betweenness, Closeness)

  • aStar (djikstra with h(0))
slide-63
SLIDE 63

Betweenness Centrality

slide-64
SLIDE 64

Community Detection

slide-65
SLIDE 65

graphdatabases.com

slide-66
SLIDE 66

THANK YOU!

Ryan Boyd @ryguyrg ryan@neo4j.com