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

Transcript

1. View Slide

2. View Slide

3. Vertex
   edge
   Graph Database
   (also called node)
   

   View Slide

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

   View Slide

5. •
   •
   •
   •
   •
   •
   •
   •
   Didn’t test it, a .bat file is included in the
   ZIP to start the PGX server
   

   View Slide

6. •
   •
   

   View Slide

7. DEMO
   

   View Slide

8. View Slide

9. •
   •
   •
   •
   •
   •
   Simplified version
   

   View Slide

10. Product Order
    Customer
    Country
    Confirm
    LivesIn
    Reference
    

    View Slide

11. Product Order
    Customer
    Confirm
    Reference
    Country= “”
    

    View Slide

12. Order
    Customer
    Confirm
    Country= “” Product= “”
    

    View Slide

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

    View Slide

14. Product Customer
    Country
    LivesIn
    Buys
    Quantity= “”
    Amount= “”
    OrderDate= “”
    Let’s implement this one
    

    View Slide

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
    

    View Slide

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
    

    View Slide

17. DEMO
    

    View Slide

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…
    

    View Slide

19. View Slide