Graph Database: from scratch in 45 minutes

Graph Database: from scratch in 45 minutes

You often hear theoretical talks about Graph Databases, either with just theory or with some potential use cases. But how to do it for real? How to practically get started with Graph Databases?
This session is going to show you "live" how you can practically get started with Oracle Graph Databases, by going from a sample dataset to creating and loading a graph, to doing analysis on it to get insights into it.
All you need to get started with graph databases by yourself with confidence right after the session.

Notebooks available at: https://gianniceresa.com/wp-content/uploads/2019/05/Graph-Database-from-scratch-in-45-minutes-by-Gianni-Ceresa-Notebooks.pdf

Bf71450537acca19e045ae6f7febdf9a?s=128

Gianni Ceresa

March 22, 2019
Tweet

Transcript

  1. None
  2. None
  3. Vertex edge Graph Database (also called node)

  4. vertex (node) vertex properties vertex ID edge edge label edge

    properties edge ID directed edge
  5. • • • • • • • • Didn’t test

    it, a .bat file is included in the ZIP to start the PGX server
  6. • •

  7. DEMO

  8. None
  9. • • • • • • Simplified version

  10. Product Order Customer Country Confirm LivesIn Reference

  11. Product Order Customer Confirm Reference Country= “<country>”

  12. Order Customer Confirm Country= “<country>” Product= “<product>”

  13. Product Customer Country LivesIn Buys Quantity= “” Amount= “” OrderDate=

    “”
  14. Product Customer Country LivesIn Buys Quantity= “” Amount= “” OrderDate=

    “” Let’s implement this one
  15. Name Null? Type ----- -------- ----------------------- VID NOT NULL NUMBER

    VL NVARCHAR2(3100) K NVARCHAR2(3100) T INTEGER V NVARCHAR2(15000) VN NUMBER VT TIMESTAMP WITH TIMEZONE 47 name: Matthew McConaughey [T=1] age: 47 [T=2] birth-date:1969-11-04 12:00:00.0 [T=5] Name Null? Type ------- -------- ------------------------ EID NOT NULL NUMBER SVID NOT NULL NUMBER DVID NOT NULL NUMBER EL NVARCHAR2(3100) K NVARCHAR2(3100) T INTEGER V NVARCHAR2(15000) VN NUMBER VT TIMESTAMP WITH TIME ZONE 46 47 admires weight:1.0 [T=4] 1102 Column “VL” added in PGX 3.1.1 only
  16. • • • • ID Data type Column 1 String

    V 2 Integer VN 3 Float VN 4 Double VN 5 Date VT 6 Boolean V 7 Long VN 8 Short VN 9 Byte VN 10 Char V 101 Serializable V
  17. DEMO

  18. If you feel like having more questions than before this

    presentation, it’s a good thing! It means you have to try graphs for real…
  19. None