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

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
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…