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

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

Transcript

1. ElasticSearch
2. (27) 
 2021/6 Another works 2018/4 Sier 

3. ෳۀΛ͍ͨ͠ਓͱෳۀਓࡐΛొ༻͍ͨ͠اۀ༷Λͭͳ͙ ϚονϯάϓϥοτϑΥʔϜ ஥հख਺ྉͳ͠ɺఆֹͰ࠾༻͠์୊
4. ElasticSearch 2 ElasticSearch ElasticSearch
5. Join SQL 
 1 RDS
6. 2 - ex) - ( ) 
 

7. 1 RDS 2
8. ElasticSearch Elastic (and,or,not )
9. 1 RDS Ϣʔβߋ৽ 3%4 Ϣʔβݕࡧ Write Read - (Write) 
 
 - (Read) 
 1 
 ϘτϧωοΫ
10. Ϣʔβߋ৽ 3%4 ఆظόον ݕࡧ͠΍͍͢ܗʹ੔ܗͯ͠σʔλΛ౤ೖ
    &MBTUJD4FBDI Ϣʔβݕࡧ Write Read 2s 0 . 5 s 1 RDS 1 !! γϯϓϧʹ
11. 2 WHERE 
 

12. JE UFYU
     ΧπΦ͸αβΤͷఋ ( ) ☓ ( ) 8)&3&
    VTFSOBNF
    
    
     
    
13. ngram ex)kuromoji sudachi ΧπΦ͸αβΤͷఋ ΧπΦ
    c
    αβΤ
    c
    ఋ ׍ɹc
    ӫཐ
    ɹc
    ఋ ͔͓ͭc
    ͑͟͞
    c
    ͓ͱ͏ͱ
14. ngram ΧπΦ͸αβΤͷఋ N 2 Χπ πΦ
    Φ͸
    αβ
    βΤ Τͷ
    ͷఋ N 1
15. Ngram /HSBN ܗଶૉղੳ
16. 1 RDS Ϣʔβߋ৽ 3%4 &MBTUJD4FBD Ϣʔβݕࡧ Write Read 2