graph studio how to analyze data warehouse as a graph...graph studio graph modeler emp dpt emp_dpt...
TRANSCRIPT
!"#$%&'()*+*!"#$% ,%-./0*-123"%*&)4*-55&/&-)046*7//*%&'()4*%040%8026**9
&'()*')+,-./01)2-*-)3-415'671)2-*-)-7)-)84-95
:'4;<)=>5?<@) A-/-,*)=5-4?-=4B)C-,-D14)E4'@6>*)21F1.'9?1,* =4B)2<41>*'4)E4'@6>*)C-,-D1?1,*84-95)G1>5,'.'D<17 84-95)G1>5,'.'D<17
H>*';14%)!"#$
Copyright © 2018, Oracle and/or its affiliates. All rights reserved. |
Safe Harbor StatementThe following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, timing, and pricing of any features or functionality described for Oracle’s products may change and remains at the sole discretion of Oracle Corporation.
2
Copyright © 2018, Oracle and/or its affiliates. All rights reserved. |
Outline
• Graph Cloud Service• Use Cases• Demo• Discussion
!"#$%&'()*+*,-./0*1%2345*2678"%*&)9*2::&4&2)59;*<44*%&'()9*%595%=57;**>
?%2#(*!4"@7*A5%=&35
! B165C34&3DE*75#4"$F56)G*6"*&69)2442)&"60*H5%"*3"6:&'@%2)&"6" <@)"F2)57*:2&4@%5*75)53)&"6*267*%53"=5%$
! <@)"F2)57*'%2#(*F"7545%" I29&4$*3"6=5%)*$"@%*%542)&"624*72)2*&6)"*#%"#5%)$*'%2#(9
! J%5CK@&4)*<4'"%&)(F90*L4"M9*267*ANOC4&D5*'%2#(*P@5%$*426'@2'5" Q2=20*?%""=$*
" R59)*<JS9
! R&3(*T95%*S6)5%:235" O"M*3"75*8*H5%"*3"75*:52)@%59
" U")5K""D*9@##"%)*267*#"M5%:@4*72)2*=&9@24&H2)&"6*:52)@%59
!"##$%&'(')*+%),'-.%/#0"+%1*,23/*
Copyright © 2018, Oracle and/or its affiliates. All rights reserved. |
Graph StudioGraph Modeler
EMP
DPT
EMP_DPT
Graph Modeler
E1
E3
D1D2
E2Tabular Data
Property Graph
• CSV Files• External Database Tables • Data Pump Files
Automatically create Graph Model(Foreign key constraint heuristics)
Modify Graph Model
!"#$%&'()*+*,-./0*1%2345*2678"%*&)9*2::&4&2)59;*<44*%&'()9*%595%=57;**>
?"@5*A95*!2959*:"%*B%2#(*<624$)&39
! !"@@C6&)$*75)53)&"6*267*&6:4C5635%*2624$9&9
" !(C%6*%&9D*2624$9&98)2%'5)57*@2%D5)&6'0*EF*GC%6"=5%*2624$9&9
! H%"7C3)*%53"@@5672)&"6
" !"442I"%2)&=5*:&4)5%&6'0*34C9)5%&6'
! <6"@24$*75)53)&"6
" ?"3&24*J5)K"%D*<624$9&9*L9#2@*75)53)&"6M0*:%2C7*75)53)&"6
! H2)(*2624$9&9*267*%523(2I&4&)$
" 1C)2'5*2624$9&9*&6*C)&4&)&59*65)K"%D90*=C465%2I&4&)$*2624$9&9*&6*NH*65)K"%D90*OH262@2*H2#5%9P
" Q26C:23)C%&6'0*R&44*":*Q2)5%&2490*N@#23)*<624$9&9
! H2))5%6*@2)3(&6'
" G2S*:%2C7*75)53)&"60*72)2*5S)%23)&"6
Copyright © 2018, Oracle and/or its affiliates. All rights reserved. |
Demo
!"#$%&'()*+*,-./0*1%2345*2678"%*&)9*2::&4&2)59;*<44*%&'()9*%595%=57;**>
?5@"! A959*)(5*B2459*C&9)"%$*B2@#45*93(5@2*D(&3(*&9*E957*&6*?2)2*F2%5("E95*)E)"%&249" !E9)"@5%90*G%"@")&"690*B24590*!(266549" H53(6&324*#%"7E3)9
! I"7549*)(5*72)20*29*'%2#(
! A95*)(5*J%2#(*B)E7&"*6")5K""L*)"*" ?&93"=5%*G2))5%69" M&67*)(5*@"9)*&@#"%)26)*#%"7E3)9" G%"7E3)*N53"@@5672)&"6
!"#$%&'()*+*,-./0*1%2345*2678"%*&)9*2::&4&2)59;*<44*%&'()9*%595%=57;**> !?
"#$%&$'($)*(+,$#-($%(../($)*(01*2(.)2(3456(!"#$%&'"(%)"(&%*&%%&"+,-.)/012345*&"*)6.*5'7789:@599&"69
!"#$%&'($ &'#)$ *+,"#'+-
&.$/0"1234,#5367
.ABC*#D*E ,AF-*#D 8",9'-$3*$":-'-;3<'#93=3"-03>$??$)'-3+-34:",)$3@';3!"#"3A+).#'+-/3BC=4DEFDG
G"93"65 H59)*E F--C
BA--*#D*I BABC*#D @.')03A$:H$:)$// @';3!"#"3"-03I:"?93J'K L$M3N??/3<'#93A?:'-;3!"#"3"-03O+:$3P"H"3B!QJFDRSG
G"93"65 H59)*E ,--.
CABC*#D*I JAF-*#D* I$+T&";;'-;23I$+TQ-:',9($-#23I$+TU$-,'-;23"-03&:",V'-;3W+:3*+,"#'+-TQ-"M)$03N??/3B&=XDESFG
G"93"65 H59)*E F--F
&9.:/0"1234,#536F
..A--*2D*I ..ABC*2D Y/'-;3*+,"#'+-3'-3O)+.03N??)',"#'+-/3<'#93C1#9+-23X+0$5Z/23"-038+:$3B&=XDE[SG
G"93"65 H59)*I F--.
,A--*#D*I ,ABC*#D N-")1K'-;3@)+,V,9"'- "-03@'#,+'-3&:"-/",#'+-3!"#"3"/3I:"?9/3B!QJD[7FG
G"93"65 H59)*I ,-./
!"#$%&'()*+*,-./0*1%2345*2678"%*&)9*2::&4&2)59;*<44*%&'()9*%595%=57;**> !".-.-
#$%&'%()%*+),-%$.)%&)//0)%*+)12+3)/*3)4"!5)!"#$%&'"(%)"(&%*&%%&"+,-.)/012345*&"*)6.*5'7789:
?55)*)(5*@A#5%)9!"#$%&'($ &'#)$ *+,"#'+-
&.$/0"1234,#5367
..B--*2C*D ..BE-*2C *+,"#'+-89"/$03&:",;'-<3"-03=$+/>"#'")3?-")1#',/3@+:3!"#"A"/$3"-039'<3!"#"3B)"#@+:(/3CD&EFGHHI ?"93"65 F59)*G H(5*IJK*G L"J6'5*M
.,B--*#C*G .,BE-*#C =:">J3?-")1/'/3"-03!"#"A"/$3&$,J-+)+<'$/3CD&EFGKKI ?"93"65 F59)*G H(5*IJK*G L"J6'5*M
NB--*#C*G NBE-*#C* =:">J3?-")1/'/3"-03D",J'-$ *$":-'-< CD&EFGKFI ?"93"65 F59)*G H(5*IJK*G L"J6'5*M
L$0-$/0"1234,#536K
..B--*2C*G ..BE-*2C =:">J3M.$:'$/3"-03?-")1/'/3CD&EFGKFI ?"93"65 F59)*G H(5*IJK*G L"J6'5*<
.,B--*#C*G .,BE-*#C *+,"#'+-89"/$03&:",;'-<3"-03=$+/>"#'")3?-")1#',/3@+:3!"#"A"/$3"-039'<3!"#"3B)"#@+:(/3CD&EFGHHI ?"93"65 F59)*G H(5*IJK*G L"J6'5*M
!"#$%&'()*+*,-./0*1%2345*2678"%*&)9*2::&4&2)59;*<44*%&'()9*%595%=57;**>
?#2)&24*267*@%2#(*2)*11A*267*!"75*165*,-./*!"#$%&'"(%)"(&%*&%!"#$%&'()*+,-./!"/'0&/.122345
+*&#,-".# -"&)# /01*&"02
! B"672$**CDEF*2G*H FDEF*#G
! IJ5972$**.-DK-*2G*H FDEF*#G
! A5765972$**.-DK-*2GH EDEF*
#G
1%2345*?#2)&24*267*@%2#(*
L2)2M2950*<624$)&390*267*!4"J7*
?5%=&359
B"93"65*?"J)(*NO(&M&) P244*
QRI(5*NO3(26'5ST
! 1%2345*L5G"'%"J679D
!4"J7*U42):"%G*V*<##4&32)&"6*
L5=54"#G56)*2%52
! W&"9X*Y*<ULZA[K
"#$%&
Copyright © 2018, Oracle and/or its affiliates. All rights reserved. |
Intelligent Business Applications
Cloud Platform
Oracle Spatial and Graph demopod
(behind the Keynote Arena)Kiosk #: APD-WU3
Application Development
Moscone South Exhibit Hall / Demogrounds (“The Exchange”)
!"#$%&'()*+*,-./0*1%2345*2678"%*&)9*2::&4&2)59;*<44*%&'()9*%595%=57;**>
!"#$%&'()'*$+$,-'&"$%.,$/0#-$123345)(6!"#$%"#$#&'(%$)*#+,--.)'*/#,0#+.1*,-"%1#$)2#3$%*)"%1#*4$*#+,))"+*1#$)2#"5+4$)6"1#7),89"26"#,)9')":#$)2#$*#+,)0"%")+"1#$)2#"&")*1;
72)5$40$25*)5#$()564-*8923:2-'9*#0&'()'*923345)(6
<')7"2=) >,,69"? =@A>#B=>
C,%$13$*'$91'6
,%$+9"13$*'$91'6C6-$'9;+,-
Copyright © 2018, Oracle and/or its affiliates. All rights reserved. |
Analytics and Data SummitAll Analytics. All Data. No Nonsense.
March 12 – 14, 2019
Formerly called the BIWA Summit with the Spatial and Graph SummitSame great technical content…new name!
www.AnalyticsandDataSummit.org
Call for Speakers now open! Submit an abstract to share your use case or technical session