From SQL, to Graph Prototype, back to SQL for Production: a Data Science Lifecycle

Do you think a Graph Database could help you but don't know where to start and how that could turn into production? A possible data science lifecycle is what you get here: building a graph with data stored in your relational database, identify the interesting queries and analysis on the graph, convert them back to SQL to run in your database.

Oracle provides a full set of solutions thanks to its Property Graph engine able to use Oracle Database as backend for storage and options to “offload” queries from the graph directly to the relational database.

Transcript

9. Vertex edge Graph Database (also called node)
10. edge edge label edge properties edge ID directed edge vertex (node) vertex properties vertex ID a vertex can have a label
12. Scalable and Persistent Storage Graph Data Access Layer API Graph Analytics In-memory Analytic Engine Blueprints & SolrCloud / Lucene Property Graph Support on Apache HBase, Oracle NoSQL or Oracle DB 12.2+ REST Web Service Python, Perl, PHP, Ruby, Javascript, … Java APIs Java APIs/JDBC/SQL/PLSQL Cytoscape Plug-in R Integration (OAAgraph) Spark integration SQL*Plus, … PGX
13. • • BEGIN OPG_APIS.CREATE_PG('sa607', 4, 8, ''); END;
14. There is a new column “VL” added in PGX 3.1.1 only
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. • • • • • • •
19. • • • • • • • • • • It can only get better in future releases …
20. • • • •
21. • • • • • • • •