~/talk

Things I Learned the Hard Way Building a Search Engine

Talkat EuRuKo 2017 · 2017-09-29..09-30· [data-engineering]
links:none on file
slides:none on file

Replaced a PostgreSQL text search with Elasticsearch and reconstructs why ranking needs more than keyword matching: builds an inverted index, vectorizes documents and queries, applies cosine similarity with TF‑IDF + pivot length normalization, adds stop‑word removal, stemming/lemmatization, synonym lists and query‑expansion, boosts exact‑term and full‑term‑coverage matches, and considers misspellings. Demonstrates the model on a toy corpus, shows better ordering but some surprising mismatches, and notes BM25f as an alternative for record‑like data.

AI-written summary · about

  1. 0:00Introduction
  2. 1:10PostgreSQL to Elasticsearch
  3. 2:39What is information retrieval
  4. 5:36How information retrieval works
  5. 9:55Building an inverted index
  6. 11:49Text similarity with vectors
  7. 15:07Stop words and stemming
  8. 17:18Term frequency in ranking
  9. 20:20Document frequency explained
  10. 21:48TF-IDF for relevance
  11. 23:11Normalizing document length
  12. 24:58Final ranking function
  13. 26:05Synonyms for better results
  14. 27:56Ranking thresholds
  15. 29:19Text search principles
  16. 31:26User search intent
  17. 33:14Q&A
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.