Tweet
Tweet

Slide 1

Slide 1 text

No content

Slide 2

Slide 2 text

No content

Slide 3

Slide 3 text

vertex (node) vertex properties vertex ID edge edge label edge properties edge ID directed edge

Slide 4

Slide 4 text

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

Slide 5

Slide 5 text

No content

Slide 6

Slide 6 text

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

Slide 7

Slide 7 text

• • • •

Slide 8

Slide 8 text

• • • • • • • • • •

Slide 9

Slide 9 text

No content

Slide 10

Slide 10 text

• • • • • • • •

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

mapped to reference reference page contains contains Catalog ACL member of member of

Slide 13

Slide 13 text

• • • • • • •

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

•

Slide 16

Slide 16 text

No content

Slide 17

Slide 17 text

No content

Slide 18

Slide 18 text

No content

Slide 19

Slide 19 text

• • • • • • • •

Slide 20

Slide 20 text

• • • • •

Slide 21

Slide 21 text

• • • • • • • • • • • • • •

Slide 22

Slide 22 text

• • • • Doesn’t support loading a graph from DB !!! • Will support loading from DB

Slide 23

Slide 23 text

No content

Slide 24

Slide 24 text

GraalVM will make this part useless thanks to its polyglot feature • Python will have direct access to Java objects and methods

Slide 25

Slide 25 text

No content

Slide 26

Slide 26 text

No content

Slide 27

Slide 27 text

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;

Slide 28

Slide 28 text

No content

Slide 29

Slide 29 text

No content

Slide 30

Slide 30 text

No content

Slide 31

Slide 31 text

No content

Slide 32

Slide 32 text

• • • • • •

Slide 33

Slide 33 text

No content

Slide 34

Slide 34 text

No content

Slide 35

Slide 35 text

No content

Slide 36

Slide 36 text

No content

Slide 37

Slide 37 text

No content

Slide 38

Slide 38 text

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

Slide 39

Slide 39 text

• • • • •