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

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.

Bf71450537acca19e045ae6f7febdf9a?s=128

Gianni Ceresa

May 16, 2019
Tweet

Transcript

  1. None
  2. None
  3. None
  4. None
  5. None
  6. None
  7. None
  8. None
  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
  11. None
  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. • • • • • • •

  17. None
  18. None
  19. • • • • • • • • • •

    It can only get better in future releases …
  20. • • • •

  21. • • • • • • • •