Graph Databases: The Next Frontier

Graph Databases: The Next Frontier

Graph Databases and Graph Analysis are the new boundaries of the Business Analytics world. After the classical DWH and big data, graphs provides new perspectives and insights, but are still kind of mysterious and with a steep learning curve. Newness make it difficult to find simple approaches on where to start and how to add graphs to your analytics toolbox. This session will take you over this step: introducing graphs databases and to enable them. Not another theoretical talk but more down to earth supported by a sample dataset all over the process. Practical hints on how to get started with graphs.

Bf71450537acca19e045ae6f7febdf9a?s=128

Gianni Ceresa

June 07, 2018
Tweet

Transcript

  1. None
  2. None
  3. vertex (node) vertex properties vertex ID edge edge label edge

    properties edge ID directed edge
  4. CUSTOMER Gianni PRODUCT New laptop ORDER 07/06/2018 Gianni [customer] New

    laptop [product] [order] quantity: 1 date: 07/06/2018 Imagine N-M relationships, dynamic list of attributes etc. ORDER_LINE Quantity 1
  5. None
  6. • • • • • • • • • •

    From now, and for the rest of the session, we focus on the Oracle solution
  7. • • • •

  8. • • • • • • • • • •

  9. None
  10. • • • • • • • •

  11. Common Enterprise Information Model Connecting Data with Self Service Analytic

    Applications Presentation Layer Physical Layer Semantic Object Layer Map Phyisical Data Connections Schemas Business Model Dimensions & Hierarchies Measures & Calculations Time Series & Aggregation Simplified Business View Subject Areas Security and Roles Preferences
  12. mapped to reference reference page contains contains Catalog ACL member

    of member of
  13. • • • • • • •

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

  15. None
  16. None
  17. None
  18. • • • • • • • •

  19. • • • • •

  20. • • • • • • • • • •

    • • • •
  21. • • • • Doesn’t support loading a graph from

    DB !!! • Will support loading from DB
  22. None
  23. GraalVM will make this part useless thanks to its polyglot

    feature • Python will have direct access to Java objects and methods
  24. None
  25. None
  26. WITH properties AS ( SELECT DISTINCT k, t, 'Vertex' AS

    kind FROM sa607vt$ UNION ALL SELECT DISTINCT k, t, 'Edge' AS kind FROM sa607ge$ ) ,cfg AS ( SELECT '.add' || kind || 'Property("' || k || '",PropertyTypeClass.' || CASE WHEN t = 1 THEN 'STRING' WHEN t = 5 THEN 'DATE' END || ')' AS prop FROM properties ) SELECT LISTAGG(prop,'') WITHIN GROUP(ORDER BY prop) FROM cfg;
  27. None
  28. None
  29. None
  30. None
  31. • • • • • •

  32. None
  33. None
  34. None
  35. None
  36. None
  37. • • • • • • • • • •

    • • … and 45 minutes aren’t enough to talk about Graphs!
  38. • • • • •