Tweet
Tweet

Slide 1

Slide 1 text

No content

Slide 2

Slide 2 text

No content

Slide 3

Slide 3 text

No content

Slide 4

Slide 4 text

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

Slide 5

Slide 5 text

• • • • • •

Slide 6

Slide 6 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 7

Slide 7 text

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

Slide 8

Slide 8 text

(what) (who) If interested in how to practically get the metadata from OAC/OBIEE have a look at

Slide 9

Slide 9 text

No content

Slide 10

Slide 10 text

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

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

•

Slide 13

Slide 13 text

• • • • • • • •

Slide 14

Slide 14 text

• •

Slide 15

Slide 15 text

No content

Slide 16

Slide 16 text

• • • • • • • •

Slide 17

Slide 17 text

• • • • • •

Slide 18

Slide 18 text

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

Slide 19

Slide 19 text

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

Slide 20

Slide 20 text

No content

Slide 21

Slide 21 text

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

Slide 22

Slide 22 text

No content

Slide 23

Slide 23 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 24

Slide 24 text

No content

Slide 25

Slide 25 text

No content

Slide 26

Slide 26 text

No content

Slide 27

Slide 27 text

No content

Slide 28

Slide 28 text

• • • • • •

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

No content

Slide 33

Slide 33 text

No content

Slide 34

Slide 34 text

• • • • • • • • • • •

Slide 35

Slide 35 text

• • • •

Slide 36

Slide 36 text

• • • • •