PostgreSQL and SQL:2023 - Property Graph Queries の話題と各RDBの実装

Slide 1

Slide 1 text

1PTUHSF42-$POGFSFODF+BQBO /PW 1PTUHSF42-BOE42- 1SPQFSUZ(SBQI2VFSJFTͷ࿩୊ ͱ֤3%#ͷ࣮૷ ,PKJ"OOPVSB ҊӜߒೋ LPKJ!BOOPVSBDPN 4PVSDF೔ຊ1PTUHSF42-Ϣʔβձ IUUQTXXXQPTUHSFTRMKQOQPMPHP

Slide 2

Slide 2 text

8IPBN* ⿣ *MPWF ⿣ /FPK(SBQI%BUBCBTF ⿣ /FPK6TFST(SPVQ5PLZP ⿣ *BNPOFPGUIFGPVOEFST ⿣ (SBQI$PNNVOJUZ.71 ⿣ "QBDIF)PQ ⿣ %BUB0SDIFTUSBUJPO"QQ ⿣ "QBDIF6TFS(SPVQ+BQBO ⿣ *BNBGPVOEFS

Slide 3

Slide 3 text

"HFOEB ⿣ 42-1(2 ⿣ ,FZXPSET ⿣ 42- ⿣ %BUBCBTFT ⿣ 42-1(2 ⿣ PQFO$ZQIFS

Slide 4

Slide 4 text

42-1(2 ⿣ 1SPQFSUZ(SBQI2VFSZ ⿣ IUUQTXXXJTPPSHTUBOEBSEIUNM ⿣ 42- *40*&$ ⿣ 1BSU ⿣ (FOFSBMJOGPSNBUJPO ⿣ 4UBUVT 1VCMJTIFE ⿣ 1VCMJDBUJPOEBUF ⿣ 4UBHF*OUFSOBUJPOBM4UBOEBSEQVCMJTIFE ⿣ &EJUJPO ⿣ /VNCFSPGQBHFT ⿣ 5FDIOJDBM$PNNJUUFF *40*&$+5$4$ 4PVSDF*40 IUUQTXXXJTPPSHTUBOEBSEIUNM

Slide 5

Slide 5 text

42-1(2BOE(2- ⿣ 42-1(2 ⿣ 42-JODMVEFT 1SPQFSUZ(SBQI2VFSZ ⿣ 0SBDMF%BUBCBTFD ⿣ (2- ⿣ *OUFSOBUJPOBM4UBOEBSE ⿣ XJMMSFMFBTF 4PVSDFPQFO$ZQIFSIUUQTXXXHRMTUBOEBSETPSHIPNF

Slide 6

Slide 6 text

,FZXPSET ⿣ 5ZQFTPG%BUBCBTFT ⿣ 42- ⿣ /P42- ⿣ (SBQI ⿣ /BUJWF(SBQI ⿣ /PO/BUJWF(SBQI ⿣ -BOHVBHF ⿣ $ZQIFS ⿣ PQFO$ZQIFS ⿣ (2- ⿣ (SBQI2-

Slide 7

Slide 7 text

5ZQFTPG%BUBCBTFT ⿣ 42- ⿣ /P42- ⿣ ,FZrWBMVFTUPSF ⿣ %PDVNFOUTUPSF ⿣ 8JEFDPMVNOTUPSF ⿣ (SBQITUPSF ⿣ /BUJWF(SBQI ⿣ /PO/BUJWF(SBQI ⿣ *ONFNPSZTUPSF 4PVSDF8JLJQFEJB IUUQTFOXJLJQFEJBPSHXJLJ/P42-

Slide 8

Slide 8 text

/FPK ⿣ 0O1SFNJTFT ⿣ /FPK(SBQI%BUBCBTF ⿣ $MPVE ⿣ /FPK"VSB%# ⿣ (PPHMF ⿣ "84 ⿣ "[VSF 4PVSDF/FPK IUUQTOFPKDPNQSPEVDUOFPKHSBQIEBUBCBTF

Slide 9

Slide 9 text

/FPK ⿣ (FO"*BQQT ⿣ --. ⿣ 7FDUPS ⿣ ,OPXMFEHFHSBQIT 4PVSDF/FPK IUUQTOFPKDPN

Slide 10

Slide 10 text

/BUJWF(SBQI ⿣ (SBQI%BUBCBTF ⿣ /BUJWF(SBQI ⿣ /FPK ⿣ /PO/BUJWF(SBQI ⿣ (SBQITUPSBHF ⿣ 3%# ⿣ 8JEF$PMVNO ⿣ 0UIFS/P42-

Slide 11

Slide 11 text

/BUJWFWT/PO/BUJWF ⿣ (SBQI%BUBCBTF ⿣ /BUJWF(SBQI ⿣ /FPK $ZQIFS ⿣ .FNHSBQI PQFO$ZQIFS ⿣ 5JHFS(SBQI (42- ⿣ /PO/BUJWF(SBQI ⿣ .JDSPTPGU"[VSF$PTNPT%# 42- ⿣ +BOVT(SBQI (SFNMJO ⿣ "NB[POF/FQUVOF (SFNMJO PQFO$ZQIFS 41"32- ⿣ 4UBS%PH 41"32-

Slide 12

Slide 12 text

+BOVT(SBQI ⿣ +BOVT(SBQI ⿣ 5IF-JOVY'PVOEBUJPO ⿣ 7FSTJPO 0DUPCFS ⿣ +BWB ⿣ %BUB4UPSBHF ⿣ "QBDIF$BTTBOESB ⿣ "QBDIF)#BTF ⿣ (PPHMF$MPVE#JHUBCMF ⿣ 0SBDMF#FSLFMFZ%# ⿣ 4DZMMB%# 4PVSDF*40 IUUQTKBOVTHSBQIPSH

Slide 13

Slide 13 text

)PXJTJUCFJOHVTFE ⿣ (SBQI%BUBCBTF ⿣ 6TBHFTJNJMBSUP#* ⿣ /PUSFBMUJNF CVUHBJOJOHJOTJHIUT GSPNEBUBSFMBUJPOTIJQT ⿣ /BUJWFHSBQIVTBHF ⿣ 3FBMUJNFBOBMZTJTJO*P5 JOTVSBODF BOEDSFEJUDBSEGSBVEEFUFDUJPOEVF UPVOEFSTUBOEJOHEBUBSFMBUJPOTIJQT ⿣ 4FBSDIJOHUIFTDPQFPGJNQBDUPG GBVMUEFUFDUJPOJOSFBMUJNF

Slide 14

Slide 14 text

2VFSZ-BOHVBHF ⿣ 3%# ⿣ 42- ⿣ (SBQI%BUBCBTF ⿣ (2- ⿣ $ZQIFS /FPK "NB[PO/FQUVOF 4"1 ⿣ 1(2- 0SBDMF ⿣ ($03& -%#$ ⿣ (42- 5JHFS(SBQI ⿣ 41"32- "NB[PO/FQUVOF ⿣ (SFNMJO "[VSF$PTNPT%# +BOVT(SBQI "NB[PO/FQUVOF 4PVSDF1FUFS&JTFOUSBVU IUUQQFUFSFJTFOUSBVUPSHCMPHQPTUHSFTRMBOETRM

Slide 15

Slide 15 text

$ZQIFS ⿣ "OESÉT5BZMPS ⿣ "4$**"SU ⿣ /PEF <3&-"5*0/4)*1> /PEF ⿣ $ZQIFS ⿣ 8)&3&BOE03%&3#:GSPN42- ⿣ 1BUUFSONBUDIJOHGSPN41"32- ⿣ $PMMFDUJPOTFNBOUJDTGSPN)BTLFMM BOE1ZUIPO 4PVSDF."53*98JLJ IUUQTNBUSJYGBOEPNDPNXJLJ$ZQIFS

Slide 16

Slide 16 text

41:º'".*-: ⿣ 41:º'".*-: ࡗמݖՈՈ ⿣ +BQBOFTFNBOHBTFSJFTXSJUUFO BOEJMMVTUSBUFECZ5BUTVZB&OEP ⿣ $IBSBDUFST ⿣ -PJE'PSHFS ⿣ :PS'PSHFS ⿣ "OZB'PSHFS ⿣ #POE'PSHFS 4PVSDF41:Y'BNJMZIUUQTTQZGBNJMZOFUUWTFSJFT

Slide 17

Slide 17 text

/FPK(SBQI%BUBCBTF ⿣ (SBQI.PEFM ⿣ (SBQI /PEFT 3FMBUJPOTIJQ ⿣ $PNQPOFOUT ⿣ /PEFT ⿣ -BCFMT ⿣ 3FMBUJPOTIJQT ⿣ 1SPQFSUJFT

Slide 18

Slide 18 text

3%#WT/FPK ⿣ 3%# ⿣ #FGPSFMPBEJOHEBUB $3&"5&5"#-&JT OFDFTTBSZ ⿣ +0*/PQFSBUJPOTBSFQFSGPSNFEXIFO RVFSZJOHVTJOH42- ⿣ $PMVNOTSFRVJSFTPNFWBMVF JODMVEJOH OVMM ⿣ /FPK 8IJUFCPBSE'SJFOEMZ ⿣ $3&"5&5"#-&JTOPUSFRVJSFECFGPSF MPBEJOHEBUB ⿣ 3FMBUJPOTIJQTBSFTUPSFEEJSFDUMZ

Slide 19

Slide 19 text

$PNQPOFOUT ⿣ /PEFT ⿣ #SBLFUT ⿣ ⿣ .VMUJQMFMBCFMTDBOCFBUUBDIFEUPB OPEF ⿣ 1FSTPO ⿣ 1FSTPO4QZ $3&"5& 1FSTPO\OBNF`-PJE'PSHFS`^ <."33*&%> 1FSTPO\OBNF`:PS'PSHFS`^

Slide 20

Slide 20 text

3FMBUJPOTIJQTPS&EHF ⿣ 3FMBUJPOTIJQTPS&EHF ⿣ #SBDLFUT 4RVBSFCSBDLFUT ⿣ <."33*&%> ⿣ 3FMBUJPOIBTEJSFDUJPO ⿣ <."33*&%> $3&"5& 1FSTPO\OBNF`-PJE'PSHFS`^ <."33*&%> 1FSTPO\OBNF`:PS'PSHFS`^

Slide 21

Slide 21 text

1SPQFSUJFT ⿣ 1SPQFSUJFT ⿣ 1SPQFSUJFTDBOCFBEEFEGPSCPUIOPEFT BOESFMBUJPOTIJQT ⿣ $VSMZCSBDLF ⿣ \OP OBNF`"#$`^ $3&"5& 1FSTPO\OBNF`-PJE'PSHFS`^ <."33*&%> 1FSTPO\OBNF`:PS'PSHFS`^

Slide 22

Slide 22 text

PQFO$ZQIFS ⿣ PQFO$ZQIFS ⿣ IUUQTPQFODZQIFSPSH ⿣ 0DU ⿣ $ZQIFSJNQMFNFOUBUJPOT ⿣ "HFOT(SBQI ⿣ "NB[PO/FQUVOF ⿣ $"14$ZQIFSGPS"QBDIF4QBSL ⿣ $ZQIFSGPS(SFNMJO ⿣ ,BUBOB(SBQI ⿣ .FNHSBQI 4PVSDFPQFO$ZQIFS IUUQTPQFODZQIFSPSH

Slide 23

Slide 23 text

PQFO$ZQIFS ⿣ PQFO$ZQIFS*NQMFNFOUFST.FFUJOH ⿣ (FSNBOZ P$*. ⿣ 'JSTU'FCSVBSZ ⿣ -POEPO P$*. ⿣ 4FDPOE.BZ ⿣ 'SBODF P$*. ⿣ 5IJSE/PWFNCFS ⿣ %FONBSL P$*. ⿣ 'PVSUI.BZ ⿣ (FSNBOZ P$*. ⿣ 'JGUI.BSDI

Slide 24

Slide 24 text

PQFO$ZQIFS ⿣ 8$ ⿣ (SBQI%BUB8PSLTIPQ ⿣ .BSDI ⿣ 0QFO$ZQIFSNFFUVQ ⿣ .BSDI

Slide 25

Slide 25 text

1(2- ⿣ 1SPQFSUZ(SBQI2VFSZ-BOHVBHF ⿣ 42-MJLFRVFSZMBOHVBHF 4PVSDF0SBDMF IUUQTQHRMMBOHPSH

Slide 26

Slide 26 text

(2-㱠(SBQI2- ⿣ (2- ⿣ 2VFSZMBOHVBHFMJLF$ZQIFS ⿣ (SBQI2- ⿣ 2VFSZ-BOHVBHFGPS"1* ⿣ "1* ⿣ 3&45 ⿣ (SBQI2- 4PVSDF(SBQI2- IUUQTHSBQIRMPSH

Slide 27

Slide 27 text

(SBQI2- ⿣ (SBQI2- ⿣ &WFOUT ⿣ (SBQI2-$POG ⿣ IUUQTHSBQIRMPSHDPOG ⿣ (3"1)2-46..*5 ⿣ IUUQTTVNNJUHSBQIRMDPN ⿣ 0DUPCFS ⿣ 4BO%JFHP ⿣ 0DUPCFS ⿣ %PXOUPXO/FX:PSL$JUZ

Slide 28

Slide 28 text

(SBQI2-"2VFSZ-BOHVBHFGPS"1*T ⿣ 2VFSZ-BOHVBHFGPS"1* ⿣ 40"1 "QS ⿣ 4JNQMF0CKFDU"DDFTT1SPUPDPM ⿣ IUUQTXXXXPSH53TPBQ ⿣ 3&45 ⿣ 3&QSFTFOUBUJPOBM4UBUF5SBOTGFS ⿣ 0QFO"1* ⿣ UIFNPTUXJEFMZBDDFQUFEGPSNBU ⿣ (SBQI2- +VOF ⿣ IUUQTHSBQIRMPSH 4PVSDF(SBQI2-PSH IUUQTMBOETDBQFHSBQIRMPSHDBSENPEF

Slide 29

Slide 29 text

(SBQI2- ⿣ 'BDFCPPL ⿣ .PCJMFBQQTCFDBNFNPSFDPNQMFY ⿣ 1PPSQFSGPSNBODF ⿣ 'SFRVFOUMZDSBTIFE ⿣ (SBQI2- ⿣ 3FCVJME'BDFCPPL`TOBUJWF NPCJMFBQQMJDBUJPOT ⿣ XBTQVCMJDMZSFMFBTFEJO 4PVSDF(SBQI2-PSH IUUQTTQFDHSBQIRMPSH+VMZɹ

Slide 30

Slide 30 text

3&45WT(SBQI2- ⿣ 3&45 ⿣ 1045NPWJFT ⿣ (&5NPWJFT ⿣ (&5NPWJFT\JE^ ⿣ 1"5$)NPWJFT\JE^ ⿣ %&-&5&NPWJFT\JE^ ⿣ (SBQI2- ⿣ 1045HSBQIRM 4PVSDF(SBQI2-PSH IUUQTMBOETDBQFHSBQIRMPSHDBSENPEF

Slide 31

Slide 31 text

(SBQI2VFSZ-BOHVBHF ⿣ 2VFSZ-BOHVBHFGPS(SBQI ⿣ (2- 8$ ⿣ $ZQIFS /FPK 4"1ʜ ⿣ 1(2- 0SBDMF ⿣ ($03& -%#$ ⿣ (42- 5JHFS(SBQI ⿣ 41"32- "NB[PO/FQUVOF ⿣ (SBQI2- /FPK ⿣ (SFNMJO "[VSF$PTNPT%# +BOVT(SBQI "NB[PO/FQUVOF 4PVSDFIUUQTHRMUPEBZ

Slide 32

Slide 32 text

(SBQI2VFSZ-BOHVBHF ⿣ (SBQI"OBMZTJTPG$BOEJEBUF(2- 'FBUVSFT ⿣ 5IPNBT'SJTFOEBM ⿣ &YJTUJOH-BOHVBHFT ⿣ $ZQIFS ⿣ 1(2- ⿣ (42- ⿣ 42-1(2 ⿣ ($03& 4PVSDFIUUQTHRMUPEBZ