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

LT会登壇資料：6月25日
https://web-creator-meetup-in-kansai.connpass.com/event/250410/

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