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.

Transcript

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
6. • • • • • • • • • • From now, and for the rest of the session, we focus on the Oracle solution
7. • • • •
8. • • • • • • • • • •
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. •
19. • • • • • • • •
20. • • • • •
21. • • • • • • • • • • • • • •
22. • • • • Doesn’t support loading a graph from DB !!! • Will support loading from DB
24. GraalVM will make this part useless thanks to its polyglot feature • Python will have direct access to Java objects and methods
27. 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;
32. • • • • • •
38. • • • • • • • • • • • • … and 45 minutes aren’t enough to talk about Graphs!
39. • • • • •