今日から始める全文検索 その２

2019年2月19日に開催されたオタクが最新技術を追うライトニングトークイベン 3回目のライトニングトーク資料です。

Transcript

1.        Copyright (C) 2019 Toranoana Inc. All Right Reserved.   
    ~    ~ 
   ΦλΫ͕࠷৽ٕज़Λ௥͏ϥΠτχϯάτʔΫΠϕϯτճ໨   
2. .* .* .* .* . * .* Copyright (C) 2019 Toranoana Inc. All Right Reserved.  "% • 201810# .*) • Fantia2'31& • 
   /0 - Ruby, JavaScript, Java •   -  , SAO  • $!  - (,  2 -+
3.       Copyright (C) 2019 Toranoana Inc. All Right Reserved. • *%-( • ). . ◦    ◦  /101'* •  /101)   "   !#  &)
   2$3 •  /101) + • ,'- 3 
   
4.        Copyright (C) 2019 Toranoana Inc. All Right Reserved.  2747+' *% &!-"  • 0/ 1!# 83965 1
   $&.#' •  27471$&.#(01 ,/)' 4 
   
5. % " % " % " % " % " % " Copyright (C) 2019 Toranoana Inc. All Right Reserved.  ( • !#+* #
    ,' )  - • !# # 
   
   &$ 5
6. %! %! %! %! % ! %! Copyright (C) 2019 Toranoana Inc. All Right Reserved. #  ID  1  2  *
   3  7 &(+#(, ID  2, 3  1, 2  3  1, 2, 3  1, 3 * 2 
   2 # ()$  ) "' or N-Gram
7. 3 . 3 . 3 . 3 . 3 . 3 . Copyright (C) 2019 Toranoana Inc. All Right Reserved. ! &9 • 82 47 ' #%/5 ( N-Gram > – )0+16 ⇒ N-Gram  –
   
   $ ⇒ #%/5(  – )0+*
   
   $ )0
   ⇒ N-Gram + #%/5( , <>-; :"
   = 8
8.        Copyright (C) 2019 Toranoana Inc. All Right Reserved.    
      9
9. $" $" $" $" $ " $" Copyright (C) 2019 Toranoana Inc. All Right Reserved. 1 0 !#  !# !# Apache Lucene)Java* Whoosh)Python*  Apache Solr Elasticsearch Groonga)C&'*  Google!# Fess    % 
    !# (
10. $ " $ " $ " $ " $ " $ " Copyright (C) 2019 Toranoana Inc. All Right Reserved. #  
     #% #& ≒  # ! 11
11.       Copyright (C) 2019 Toranoana Inc. All Right Reserved.   1. Groonga 2. Apache Lucene 3.
    MySQL  12
12. $ $ $ $ $  $ Copyright (C) 2019 Toranoana Inc. All Right Reserved. 1. Groonga! •  #"  Groonga
     &%  13
13. F> F> F> F> F > F> Copyright (C) 2019 Toranoana Inc. All Right Reserved. GroongaMN • L=C67'
    67J;*:DM#% / 9A?N • 9A%  
    CIJ!! " )<,D • N-Gram23@H8(Mecab)&4)<,D • 50G.B- ) !$K 1MMroonga, PGroonga?N 14 +E(COGroonga#
14. < 6 < 6 < 6 < 6 < 6 < 6 Copyright (C) 2019 Toranoana Inc. All Right Reserved. Mroonga@ A • Groonga ' MySQL$'&& • SQL!&Groonga)
    @SQL01 = +/28A • MySQL *,3:@$#'"&7A )
     • Groonga5.)4  • MySQL FULLTEXT&  ?> 15 -;(9BGroonga%
15. 3 - 3 - 3 - 3 - 3 - 3 - Copyright (C) 2019 Toranoana Inc. All Right Reserved. PGroonga4 
    5 • PostgreSQL %$*1 • Groonga , 1 • LIKE+." 4'#SQL !( &)/ 15 16 206Groonga
16.        Copyright (C) 2019 Toranoana Inc. All Right Reserved. Groonga • Mroonga PGroonga
    CloudSQL GCP RDSAWS    17
17.        Copyright (C) 2019 Toranoana Inc. All Right Reserved. 2. Apache Lucene • Apache Lucene   
     18
18. .+ .+ .+ .+ . + .+ Copyright (C) 2019 Toranoana Inc. All Right Reserved. Apache Lucene 2 3 • Apache1) Java/!%&, 23 • Java(jar)$   • " (-  19 Apache Lucene
    Apache Software Foundation*0#'#' 
19. @; @; @; @; @ ; @; Copyright (C) 2019 Toranoana Inc. All Right Reserved. Apache Solr H ''I • ApacheD9 Lucene#'5='! • '"&' • C/.>(2006/~)
    *F1G • N-Gram02<A4(kuromoji)(3)8,? • Elasticsearch7$
    '%& E+ 20 Apache Solr
    Apache Software Foundation:B-6 -6 
20. 62 62 62 62 6 2 62 Copyright (C) 2019 Toranoana Inc. All Right Reserved. Elasticsearch :  ! ; • $"0(,4  • Elastic19/ Lucene!,4! • ! ! • RESTful API CRUD*#&5:-
    8 ) ; • %+.57':Kibana, Logstash3; 21
21. )% )% )% )% ) % )% Copyright (C) 2019 Toranoana Inc. All Right Reserved. Kibana- . • Elastic$+ • Elasticsearch !&  "'
    *#
       22 ,(  https://www.elastic.co/jp/products/kibana
22. OI OI OI OI O I OI Copyright (C) 2019 Toranoana Inc. All Right Reserved. Elasticsearch V  ) W • &"#
    " )'(J1V&"#0=SR  W • N-Gram:<KP?(kuromoji,Sudachi)+>.D2M • Apache Solr;GVv1.020149~W/$% NH7Q 
    T9U-  68 • 4D3 @L(!(AEC5*F,B 23
23. @< @< @< @< @ < @< Copyright (C) 2019 Toranoana Inc. All Right Reserved. Elasticsearch E
    ) F • $!) 0)"15-  – Amazon Elasticsearch Service • AWS968 ,:/? 4BA  • AWS()'* =.&+3  • #&(Kibana, Logstash • %))2>C7;D  24
24. KF KF KF KF K F KF Copyright (C) 2019 Toranoana Inc. All Right Reserved. Elasticsearch M  .N • '".!7.$8;2  – Elastic CloudMAWS, GCPN • @:ElasticE;2 %,'".!.$M.#J 0AWS, GCP4DN • 3&*-1D6I • (..9HL>1 • ?<#.)-++.=1 • #.)- &G5 •
    A/+.)-CBAWS 25
25. E? E? E? E? E ? E? Copyright (C) 2019 Toranoana Inc. All Right Reserved. Elasticsearch H . I • (%.$6.& 7:1 – ElasticsearchHGoogle Click to DeployI • A3* ! Elasticsearch"',4C •
    - !- D/D2@< 9F • 5>'*-
    )..8BG;0=4C HD2- #.+ 9FI 26
26.        Copyright (C) 2019 Toranoana Inc. All Right Reserved.  1. Groonga – Groonga"! – Mroonga"MySQLGroonga – Gproonga"PostgreSQLGroonga 2. Apache Lucene – Apache Solr"  – Elasticsearch" 
     27
27. ' # ' # ' # ' # ' # ' # Copyright (C) 2019 Toranoana Inc. All Right Reserved. 3.   … • MySQL
    Hyper Estraier
    Namazu$ ( 
     )"!  MySQL &% 29
28. '# '# '# '# ' # '# Copyright (C) 2019 Toranoana Inc. All Right Reserved. MySQLFULLTEXT  • MySQL! &+v3.23.23*, • v5.7
    ) • N-Gram$((Mecab)" & • SQL%& • CloudSQLRDS"& 30
29. ! ! ! ! !  ! Copyright (C) 2019 Toranoana Inc. All Right Reserved.  # 1. %$ 
    &  # 2.  " # 31
30. 
    
    
    
    
    
     Copyright (C) 2019 Toranoana Inc. All Right Reserved.  32 MySQL PostgreSQL 
    Oracle
31. 
    
    
    
    
    
    Copyright (C) 2019 Toranoana Inc. All Right Reserved. MySQL
     33 MySQL 
      FULLTEXT   
32. 
     
     
     
     
     
     Copyright (C) 2019 Toranoana Inc. All Right Reserved. PostgreSQL
     34 PostgreSQL 
     
33.        Copyright (C) 2019 Toranoana Inc. All Right Reserved.
     Oracle  35
    Oracle    
34. , + , + , + , + , + , + Copyright (C) 2019 Toranoana Inc. All Right Reserved. -(  MySQL Mroonga / .*&
    %$FULLTEXT 0 PostgreSQL PGroonga  " Elasticsearch   #)
    Elasticsearch!' Elasticsearch
    
     36
35. # # # # # # Copyright (C) 2019 Toranoana Inc. All Right Reserved. #  Fantia !" 
    !   & <%> DB)CloudSQL'MySQL( →Mroonga 
    Elasticsearch$ 37
36.       Copyright (C) 2019 Toranoana Inc. All Right Reserved.
       38