Upgrade to Pro — share decks privately, control downloads, hide ads and more …

複雑な検索処理をElasticSearchで駆逐する

 複雑な検索処理をElasticSearchで駆逐する

tomoya-kamaji

July 03, 2022
Tweet

More Decks by tomoya-kamaji

Other Decks in Programming

Transcript

  1. ElasticSearch


    View Slide

  2. (27)



    2021/6 Another works


    2018/4 Sier


    View Slide

  3. ෳۀΛ͍ͨ͠ਓͱෳۀਓࡐΛొ༻͍ͨ͠اۀ༷Λͭͳ͙
    ϚονϯάϓϥοτϑΥʔϜ
    ஥հख਺ྉͳ͠ɺఆֹͰ࠾༻͠์୊

    View Slide

  4. ElasticSearch
    2
    ElasticSearch


    ElasticSearch

    View Slide

  5. Join SQL



    1 RDS

    View Slide

  6. 2
    -


    ex)


    - ( )




    View Slide

  7. 1 RDS
    2

    View Slide

  8. ElasticSearch
    Elastic


    (and,or,not )


    View Slide

  9. 1 RDS
    Ϣʔβߋ৽
    3%4
    Ϣʔβݕࡧ
    Write
    Read


    - (Write)
    
 

    - (Read)

    1

    ϘτϧωοΫ

    View Slide

  10. Ϣʔβߋ৽ 3%4
    ఆظόον ݕࡧ͠΍͍͢ܗʹ੔ܗͯ͠σʔλΛ౤ೖ
    &MBTUJD4FBDI
    Ϣʔβݕࡧ
    Write
    Read


    2s
    0
    .
    5
    s


    1 RDS
    1 !!
    γϯϓϧʹ

    View Slide

  11. 2
    WHERE





    View Slide

  12. JE UFYU
    ΧπΦ͸αβΤͷఋ
    ( )
    ☓ ( )
    8)&3&VTFSOBNF

    View Slide

  13. ngram
    ex)kuromoji sudachi
    ΧπΦ͸αβΤͷఋ
    ΧπΦcαβΤcఋ
    ׍ɹcӫཐɹcఋ
    ͔͓ͭc͑͟͞c͓ͱ͏ͱ

    View Slide

  14. ngram
    ΧπΦ͸αβΤͷఋ
    N 2
    Χπ πΦ Φ͸ αβ βΤ Τͷ ͷఋ
    N
    1

    View Slide

  15. Ngram
    /HSBN ܗଶૉղੳ

    View Slide

  16. 1 RDS
    Ϣʔβߋ৽ 3%4
    &MBTUJD4FBD
    Ϣʔβݕࡧ
    Write
    Read
    2

    View Slide