データサイエンティスト 御用達にしたい クエリーエンジンの開発

Transcript

1. σʔλαΠΤϯςΟετ
   ޚ༻ୡʹ͍ͨ͠
   ΫΤϦʔΤϯδϯͷ։ൃ ϑΝϯίϛϡχέʔγϣϯζ
 αʔϏε։ൃ෦
   ઒࡚ɹହҰ 
   !େࡕ৘ใίϯϐϡʔλઐ໳ֶߍ
2. 4FSWJDF
   %FWFMPQNFOU
   %FQU ࣗݾ঺հ ໊લɿ઒࡚ɹହҰ
   ॴଐɿϑΝϯίϛϡχέʔγϣϯζ
   2JJUBɿ
   ZBLBXB
   
   LBXB
   (JUIVCɿZBLBXB
   
   ZBLBXB
   
   LBXB
   5XJUUFSɿ಺ॹʢ࠷ۙݟΔઐʣ
   &EJUPSɿ
   FNBDT
   ݴޠɿ೔ຊޠ
   
   1ZUIPO
   
   $ݴޠ
   
   (P
3. 4FSWJDF
   %FWFMPQNFOU
   %FQU झຯʢඇ*5ܥʣ  ͓ञΛͨ͠ͳΉ
    ৸Δ
    தࠃ݁
    ͱΜ΅ۄ
    ϖϯΪϯΛѪͰΔ
    ࣸਅ
    όΠΫʢ໔ڐͱ͚ͬͨͩʣ
4. 4FSWJDF
   %FWFMPQNFOU
   %FQU झຯʢ*5ܥʣ  04࡞Γ
    ϓϩάϥϛϯάݴޠ࡞Γ
    %BUB#BTF
   .BOBHFNFOU
   4ZTUFNʢ%#.4ʣ࡞Γ
5. 4FSWJDF
   %FWFMPQNFOU
   %FQU ܦྺʢए͔Γ͠ࠒʣ খ͘Β͍ɿ$ݴޠ
   
   $"4-
   
   #"4*$ʹ;ΕΔ
   CZ
   '91
   ߴ͘Β͍ɿ+BWB4DSJQUʹ͸·Δ
   ߴ̎͘Β͍ɿ
   $ݴޠʹճؼ
   ߴ̏͘Β͍ɿ
   7JTVBM
   $ Ͱɺ8JOEPXT"QQ࡞੒
   ɹɹɹɹɹɹ
   8FCΛ࡞ͬͯެ։
   େ͘Β͍ɿ
   %/41014.51)551αʔόΛࣗ୐ʹઃஔ
   େ̎͘Β͍ɿ1FSMʹ৮ΕΔ
   
   7JNΛѪ༻͢Δ
   େ̐ʙ.·Ͱɿ$
   
   'PSUSBOͰؾ৅γϡϛϨʔλʔΛ࡞Δ
6. 4FSWJDF
   %FWFMPQNFOU
   %FQU ܦྺʢब৬ޙʣ ࣾ໨ɿͱ͋Δؾ৅ձࣾʢ*5ܥࡶ༻܎ʣ
    ੈքைྲྀ༧ଌσʔλ
   $ݴޠʣ
    ؾ৅؍ଌσʔλϕʔε
   ʢ1FSM
   
   1ZUIPOʣ
    ؾ৅σʔλ෼ੳඳըγεςϜʢ1FSMʣ
    ۓٸ஍਒଎ใܭࢉγεςϜʢ$ݴޠʣ
    ஍਒؍ଌػʢ)8
   "4.ʣ
    Ֆค؍ଌػʢ)8
   $ݴޠ
   1FSMʣ
    αʔόߏஙɺઃஔ
    อकϝϯς
   
   ΦϯίʔϧରԠ
   
   ো֐ରԠ
7. 4FSWJDF
   %FWFMPQNFOU
   %FQU ܦྺʢब৬ޙʣ ࣾ໨ɿͱ͋Δωοτ޿ࠂձࣾ
    ΠϯϑϥΤϯδχΞ
    ৽نࣄۀαʔόαΠυ
   
   ΠϯϑϥΤϯδχΞ
    σʔλαΠΤϯςΟετ
    ΤϯδχΞ)3
8. 4FSWJDF
   %FWFMPQNFOU
   %FQU σʔλαΠΤϯςΟετͱ͸ w σʔλΛோΊָͯ͠ΜͰΔਓͰ͢
   w ෢ث͸ɺ3%#
   
   /P42-
   
   3
   
   1ZUIPO
   
   QBOEBT ͳͲͰ͢
9. 4FSWJDF
   %FWFMPQNFOU
   %FQU Πϝʔδਤ 42-ʢࠇຐज़ʣ ݁Ռʢ$47ʣ
10. 4FSWJDF
    %FWFMPQNFOU
    %FQU ݱ࣮ "84
    
    #JH2VFSZ
    
    5% σʔλ ΦϯϓϨͷϚελʔσʔλ SE
    1BSUZσʔλ 42- େ͖ͳσʔλ 42- ػີ৘ใ
11. 4FSWJDF
    %FWFMPQNFOU
    %FQU ݱ࣮ "84
    
    #JH2VFSZ
    
    5% σʔλ ΦϯϓϨͷϚελʔσʔλ SE
    1BSUZσʔλ 42- େ͖ͳσʔλ 42- ػີ৘ใ ݁߹͍ͨ͠ʂʂʂʂʂʂ
12. 4FSWJDF
    %FWFMPQNFOU
    %FQU ͳͥ42-Ͱ݁߹Ͱ͖ͳ͍ͷ͔ w ػີ৘ใʢؚΉݸਓ৘ใʣΛΫϥ΢υ؀ڥʹ্͛ͯ ͸ͳΒͳ͍نఆ͕ଘࡏ͢Δ
    w ճ࢖͍੾ΓͷσʔλΛ%#ʹ֨ೲͤͯ͞΋Β͑ͳ ͍ɺ·ͨ͸ɺਓతίετ͕͔͔Γ͗͢Δ
    w ͦ΋ͦ΋ɺͪΒͬͱݟ͍͚ͨͩͷϩʔΧϧͷϑΝΠ ϧ܈Λ͍͍ͪͪ֨ೲ͢Δͷ͕ΊΜͲ͍͘͞
13. 4FSWJDF
    %FWFMPQNFOU
    %FQU ղܾํ๏͸ʁ ݁߹͢ΔϓϩάϥϜΛॻ͚͹͍͍͡Όͳ͍͔ɻ w ຖճ࡞ΔӋ໨ʹͳΔ
    w ϧʔϓʹ͕͔͔࣌ؒΔݴޠͰ࡞Δͱ΋ͷ͘͢͝஗͍
14. 4FSWJDF
    %FWFMPQNFOU
    %FQU ͦͷଞղܾ͍ͨ͠՝୊ w 42-ํݴ໰୊ʢ.Z42-
    
    1PTUHSF42-
    
    1SFTUP
    
    )JWF
    
    #JH2VFSZ
    ʜʣ
    w ҙ֎ͱ$47
    
    +40/ͱ͔ͷϑΝΠϧ΋͋Δ
    w 3&1-ͷ࢖͍উख͕ɻɻɻ
    w Ͳ͜ʹ઀ଓ͢Ε͹͍͍Μ͚ͩͬʁ
15. 4FSWJDF
    %FWFMPQNFOU
    %FQU ͱ͍͏Θ͚Ͱ
16. 4FSWJDF
    %FWFMPQNFOU
    %FQU ૬ख͕ԿͰ͋Ε
    ಁաతʹ42-Λ౤͛ΒΕΔ
    ΫΤϦʔΤϯδϯΛ࡞Ζ͏ʂʂ
17. 4FSWJDF
    %FWFMPQNFOU
    %FQU ίϯηϓτ w ΫΤϦʔઌ͕ԿͰ͋Δ͔Λҙࣝͤ͞ͳ͍ʢNVTUʣ
    w 4USVDUVSFE
    'JMF
    FH
    +40/
    ʜ
    αϙʔτ ʢNVTUʣ
    w "/4*
    42-αϙʔτʢXBOUʣ
18. 4FSWJDF
    %FWFMPQNFOU
    %FQU "OZXIFSF2- $PNJOH
    ͍ͩͿઌʂʂʂʂ IUUQTHJUIVCDPNZBLBXBBOZXIFSF2-
19. 4FSWJDF
    %FWFMPQNFOU
    %FQU ཉ͍͠෺ w (JUIVC
    4UBS
    
    8BUDI
    w ͔͍͍ͬ͜ϩΰ
    w ίϯτϦϏϡʔλʔ
    w ։ൃ࣌ؒʢ੾࣮ʂʣ
    w εϙϯαʔඅ༻
20. 4FSWJDF
    %FWFMPQNFOU
    %FQU ϚΠϧετʔϯ w ೥಺ɿͰ͖Ε͹ΞϧϑΝϦϦʔε͍ͨ͠
21. 4FSWJDF
    %FWFMPQNFOU
    %FQU ͕͜͜ࠔͬͨ w ܕ໰୊
    w 42-ύʔαʔ໰୊ʢ42-ํݴ໰୊ɺ࢓༷ॻ೉͢͠ ͗ɻɻɻʜʣ
22. 4FSWJDF
    %FWFMPQNFOU
    %FQU ܕ໰୊ 4&-&$5

    
    
    OBNF
 '30.

    
    FNQMPZFF
 8)&3&

    
    FOUFS@ZFBS
    
     FOUFS@ZFBS
    ͸ɺ*OUFHFSͰ֨ೲ͞Ε͍ͯΔͷ͔ʁ
23. 4FSWJDF
    %FWFMPQNFOU
    %FQU 42-໰୊ 4&-&$5

    
    
    OBNF
 '30.

    
    AUBCMFA
 8)&3&

    
    Z
    
     4&-&$5

    
    
    OBNF
 '30.

    
    zUBCMFz
 8)&3&

    
    Z
    
     4&-&$5

    
    
    OBNF
 '30.

    
    `UBCMF`
 8)&3&

    
    Z
    
     ਖ਼ղ͸ͲΕʁ
24. 4FSWJDF
    %FWFMPQNFOU
    %FQU #/' 4&-&$5
    <
    TFU
    RVBOUJpFS>
    TFMFDU
    MJTU
    UBCMF
    FYQSFTTJPO
    UBCMF
    FYQSFTTJPO
    
    GSPN
    DMBVTF
    <
    XIFSF
    DMBVTF
    >
    ʜ
    GSPN
    DMBVTF
    
    '30.
    UBCMF
    SFG
    <
    \
    DPNNB
    UBCMF
    SFG
    ^ʜ>
    UBCMF
    SFG
    
    UBCMF
    OBNF
    <
    DPSSFMBUJPO
    TQFDJpDBUJPO
    >
    ʜ
    UBCMF
    OBNF
    
    RVBMJpFE
    OBNF
    ʜ
    RVBMJpFE
    OBNF
    
    <
    TDIFNB
    OBNF
    
    >
    RVBMJpFE
    JEFOUJpFS
    TDIFNB
    OBNF
    
    <
    DBUBMPH
    OBNF
    
    >
    VORVBMJpFE
    TDIFNB
    OBNF
    DBUBMPH
    OBNF
    
    JEFOUJpFS
    VORVBMJpFE
    TDIFNB
    OBNF
    
    JEFOUJpFS
    RVBMJpFE
    JEFOUJpFS
    
    JEFOUJpFS
    JEFOUJpFS
    
    <
    @
    DIBSBDUFS
    TFU
    TQFD
    >
    BDUVBM
    JEFOUJpFS
    
25. 4FSWJDF
    %FWFMPQNFOU
    %FQU #/' BDUVBM
    JEFOUJpFS
    
    SFHVMBS
    JEFOUJpFS
    c
    EFMJNJUFE
    JEFOUJpFS
    EFMJNJUFE
    JEFOUJpFS
    
    l
    EFMJNJUFE
    JEFOUJpFS
    CPEZ
    l
    EFMJNJUFE
    JEFOUJpFS
    CPEZ
    
    EFMJNJUFE
    JEFOUJpFS
    QBSU
    EFMJNJUFE
    JEFOUJpFS
    QBSU
    
    OPOEPVCMFRVPUF
    DIBSBDUFS
    c
    ll
    
    DIBSBDUFS
    TFU
    TQFD
    
    TUE
    DIBSBDUFS
    SFQFSUPJSF
    OBNF
    TUE
    DIBSBDUFS
    SFQFSUPJSF
    OBNF
    
    DIBSBDUFS
    TFU
    OBNF
    DIBSBDUFS
    TFU
    OBNF
    
    <TDIFNB
    OBNF
    
    >
    42-
    MBOH
    JEFOUJpFS
    42-
    MBOH
    JEFOUJpFS
    
    42-
    MBOH
    JEFOUJpFS
    TUBSU
    <
    \
    @
    c
    42-
    MBOH
    JEFOUJpFS
    QBSU^
    >
    42-
    MBOH
    JEFOUJpFS
    TUBSU
    
    TJNQMF
    MBUJO
    MFUUFS
    42-
    MBOH
    JEFOUJpFS
    QBSU
    
    TJNQMF
    MBUJO
    MFUUFS
    c
    EJHJU
    TJNQMF
    MBUJO
    MFUUFS
    
    <B[";>
    EJHJU
    
    <>
26. 4FSWJDF
    %FWFMPQNFOU
    %FQU #/' SFHVMBS
    JEFOUJpFS
    
    JEFOUJpFS
    CPEZ
    JEFOUJpFS
    CPEZ
    
    JEFOUJpFS
    TUBSU
    <
    \@
    c
    JEFOUJpFS
    QBSU^ >
    JEFOUJpFS
    TUBSU
    
    
    4FF
    UIF
    4ZOUBY
    SVMFT
    JEFOUJpFS
    QBSU
    
    JEFOUJpFS
    TUBSU
    c
    EJHJU
    NPEVMF
    DIBSBDUFS
    TFU
    TQFD
    
    /".&4
    "3&
    DIBSBDUFS
    TFU
    TQFD 1) An <identifier start> is one of: a) A <simple Latin letter> b) A character that is identified as a letter in the character repertoire identified by the <module character set specification> or by the <character set specification> c) A character that is identified as a syllable in the character repertoire identified by the <module character set specification> or by the <character set specification> d) A character that is identified as an ideograph in the character repertoire identified by the <module character set specification> or by the <character set specification>
27. 4FSWJDF
    %FWFMPQNFOU
    %FQU ͓ؾ͖ͮͩΖ͏͔ w όοΫΫΥʔτʢAʣ͸࢖͑ͳ͍
    w γϯάϧΫΥʔτʢ`ʣ΋࢖͑ͳ͍ 42-Ͱ͸
28. 4FSWJDF
    %FWFMPQNFOU
    %FQU ࣭໰͋Δਓ͍Δʁ
29. 4FSWJDF
    %FWFMPQNFOU
    %FQU ͓ΘΓ