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

1. View Slide

2. View Slide

3. View Slide

4. View Slide

5. View Slide

6. View Slide

7. View Slide

8. View Slide

9. Vertex
   edge
   Graph Database
   (also called node)
   

   View Slide

10. edge
    edge label
    edge properties
    edge ID
    directed edge
    vertex (node)
    vertex
    properties
    vertex ID
    a vertex can
    have a label
    

    View Slide

11. View Slide

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
    

    View Slide

13. •
    •
    BEGIN
    OPG_APIS.CREATE_PG('sa607', 4, 8, '');
    END;
    

    View Slide

14. There is a new column “VL”
    added in PGX 3.1.1 only
    

    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. •
    •
    •
    •
    •
    •
    •
    

    View Slide

17. View Slide

18. View Slide

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

    View Slide

20. •
    •
    •
    •
    

    View Slide

21. •
    •
    •
    •
    •
    •
    •
    •
    

    View Slide