Upgrade to Pro — share decks privately, control downloads, hide ads and more …

From SQL, to Graph Prototype, back to SQL for P...

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.

Gianni Ceresa

May 16, 2019
Tweet

More Decks by Gianni Ceresa

Other Decks in Technology

Transcript

  1. edge edge label edge properties edge ID directed edge vertex

    (node) vertex properties vertex ID a vertex can have a label
  2. 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
  3. 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
  4. • • • • • • • • • •

    It can only get better in future releases …