Elasticsearch

A presentation at Coter Numérique (private event) in November 2021 in Paris, France by David Pilato

Slide 1

Slide 1

Elastic Stack Overview Search. Observe. Protect.

Slide 2

Slide 2

$ curl http://localhost:9200/speaker/_doc/dpilato “nom” : “David Pilato” “jobs” : [ { “boite” : “SRA Europe (SSII)”, “mission” : “bon à tout faire”, “date” : “1995” } { “boite” : “SFR”, “mission” : “touche à tout”, “date” : “1997” } { “boite” : “e-Brands / Vivendi”, “mission” : “chef de projets”, “date”: “2000” } { “boite” : “DGDDI (douane)”, “mission” : “mouton à 5 pattes”, “date” : “2005” } { “boite” : “IDEO Technologies”, “mission” : “CTO”, “date” : “2012” } { “boite” : “elastic”, “mission” : “développeur”, “date” : “2013” } ] “passions” : [ “famille”, “job”, “deejay” ] “blog” : “http://david.pilato.fr/” “twitter” : [ “@dadoonet”, “@elasticfr” ] “email” : “david@pilato.fr } , , , , , , , , , ” , 2 { Who?

Slide 3

Slide 3

The Elastic Platform Enterprise Search Observability Security Kibana Explore, Visualize, Engage Elasticsearch Store, Search, Analyze Integrations Connect, Collect, Alert Public cloud Hybrid On-premises

Slide 4

Slide 4

Elastic Enterprise Search Enterprise Search Observability Security Kibana Explore, Visualize, Engage Elasticsearch Store, Search, Analyze Integrations Connect, Collect, Alert Public cloud Hybrid On-premises

Slide 5

Slide 5

Elastic Observability Enterprise Search Observability Security Kibana Explore, Visualize, Engage Elasticsearch Store, Search, Analyze Integrations Connect, Collect, Alert Public cloud Hybrid On-premises

Slide 6

Slide 6

Elastic Security Enterprise Search Observability Security Kibana Explore, Visualize, Engage Elasticsearch Store, Search, Analyze Integrations Connect, Collect, Alert Public cloud Hybrid On-premises

Slide 7

Slide 7

Slide 8

Slide 8

CREATE TABLE use name VARCHAR(100) comments VARCHAR(1000 ) INSERT INSERT french INSERT INSERT INTO user VALUES (‘David Pilato’, ‘Developer at elastic’) INTO user VALUES (‘Malloum Laya’, ‘Worked with David at customs service’) INTO user VALUES (‘David Gageot’, ‘Engineer at Doctolib’) INTO user VALUES (‘David David’, ‘Who is that guy?’); David ; ; ) ; , r 8 ; ( A typical search implementation…

Slide 9

Slide 9

Search on term INSERT INTO user VALUES (‘David Pilato’, ‘Developer at elastic’) Empty set (0,00 sec) David ; 9

Slide 10

Slide 10

Search like INSERT INTO user VALUES (‘David Pilato’, ‘Developer at elastic’) +———————+——————————-| name | comments +———————+——————————-| David Pilato | Developer at elastic | David Gageot | Engineer at Doctolib | David David | Who is that guy? +———————+——————————— David ; + | | | + | + 10

Slide 11

Slide 11

Search for terms INSERT INTO user VALUES (‘David Pilato’, ‘Developer at elastic’) +———————+——————————-| name | comments +———————+——————————-| David Pilato | Developer at elastic +———————+——————————— David Pilato ; + | + | + 11

Slide 12

Slide 12

Search with inverted terms INSERT INTO user VALUES (‘David Pilato’, ‘Developer at elastic’) Empty set (0,00 sec SELECT * FROM user WHERE name LIKE “%Pilato%David%” Empty set (0,00 sec Pilato David ; ; ) ) 12

Slide 13

Slide 13

Search for terms INSERT INTO user VALUES (‘David Pilato’, ‘Developer at elastic’) name LIKE “%Pilato%” +———————+——————————-| name | comments +———————+——————————-| David Pilato | Developer at elastic +———————+——————————— Pilato David ; + | + | + 13

Slide 14

Slide 14

Search in two fields INSERT INTO user VALUES (‘David Pilato’, ‘Developer at elastic’) comments LIKE “%David%” +———————+——————————————————————| name | comments +———————+——————————————————————| David Pilato | Developer at elastic | Malloum Laya | Worked with David at french customs service | David Gageot | Engineer at Doctolib | David David | Who is that guy? +———————+——————————————————————-+ David | | | | + | + ;

14

Slide 15

Slide 15

Slide 16

Slide 16

Search with typos INSERT INTO user VALUES (‘David Pilato’, ‘Developer at elastic’) Empty set (0,00 sec Dadid ; ) 16

Slide 17

Slide 17

Search with typos INSERT INTO user VALUES (‘David Pilato’, ‘Developer at elastic’) name LIKE “%D_did%” OR name LIKE “%Da_id%” OR name LIKE “%Dad_d%” OR name LIKE “%Dadi_%” +———————+——————————-| name | comments +———————+——————————-| David Pilato | Developer at elastic | David Gageot | Engineer at Doctolib | David David | Who is that guy? +———————+———————————+

; | | | + | + 17

Slide 18

Slide 18

Slide 19

Slide 19

Search engine? Moteur d’indexation de documents Moteur de recherche dans les index 19

Slide 20

Slide 20

En action !