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

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

by tomoya-kamaji

Speaker Deck

Tweet

Tweet

Slide 1

Slide 1 text

ElasticSearch

Slide 2

Slide 2 text

(27)   2021/6 Another works 2018/4 Sier  

Slide 3

Slide 3 text

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

Slide 4

Slide 4 text

ElasticSearch 2 ElasticSearch ElasticSearch

Slide 5

Slide 5 text

Join SQL   1 RDS

Slide 6

Slide 6 text

2 - ex) - ( )    

Slide 7

Slide 7 text

1 RDS 2

Slide 8

Slide 8 text

ElasticSearch Elastic (and,or,not )

Slide 9

Slide 9 text

1 RDS Ϣʔβߋ৽ 3%4 Ϣʔβݕࡧ Write Read - (Write)     - (Read)   1   ϘτϧωοΫ

Slide 10

Slide 10 text

Ϣʔβߋ৽ 3%4 ఆظόον ݕࡧ͠΍͍͢ܗʹ੔ܗͯ͠σʔλΛ౤ೖ &MBTUJD4FBDI Ϣʔβݕࡧ Write Read 2s 0 . 5 s 1 RDS 1 !! γϯϓϧʹ

Slide 11

Slide 11 text

2 WHERE    

Slide 12

Slide 12 text

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

Slide 13

Slide 13 text

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

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

Ngram /HSBN ܗଶૉղੳ

Slide 16

Slide 16 text

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