Upgrade to Pro — share decks privately, control downloads, hide ads and more …

How SQL Could Drive You Mad: Elastic Search

Dan Draper
August 06, 2015

How SQL Could Drive You Mad: Elastic Search

Elastic Search saves many SQL headaches. Follow my journey of adding ES to the codehire.com Rails app. I go through how different representations of the same data can make life easier in different contexts.

Dan Draper

August 06, 2015

Transcript

24 slides
  1. H O W S Q L C O U L

    D D R I V E Y O U M A D E L A S T I C S E A R C H
  2. Q U E RY P E R F O R

    M A N C E Avg. Query Time (ms) 0 3.5 7 10.5 14 PostgreSQL ES
  3. T H E P O W E R O F

    E L A S T I C • Keyword Analysis + Matching • Facets (e.g. locations with these tags) • Suggestions (“Did you mean”) • Similar Records
  4. D A TA L A Y E R Complex, structured

    Domain Driven Model Optimised for CRUD N O R M A L I S E D S E A R C H L A Y E R Simple, unstructured Document Oriented Optimised for Search/Analysis D E - N O R M A L I S E D

More Decks by Dan Draper

Other Decks in Technology