Search and Indexing strategy

Elastic Stack Elasticsearch
1

Newbie here. This is probably straightforward, but I wanted to get
best-practices recommendations if applicable.

My main ES use and query case is to search for a kind of Event. All Events
are associated with (i.e. contain) a Country object. Besides querying for
other kinds of Event data, queries can contain country-related data (e.g.
name, location, continent, etc.). Since countries are a finite set and the
country data is fairly large, I'd prefer not to duplicate country data
across Event documents. What's the best way to handle this situation?

Best thing I can think of is to 1) create a separate index with the country
data, then 2) run the user query against the country index 3) Pick off the
high match(es) if any and 4) issue a new query against the Event index
using something like the country abbreviation (from the high match) which
would be an Event field. This seems like a lot of work per query. Is there
a better solution?

TIA

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/226e2b6b-7161-4cd4-a51f-6e62274b2483%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

2

That seems like a lot of work for little data reduction, especially as ES
compresses data as well.

Maybe someone else has an idea though.

On 25 November 2014 at 23:30, joshua harr joshua.harr@gmail.com wrote:

Newbie here. This is probably straightforward, but I wanted to get
best-practices recommendations if applicable.

My main ES use and query case is to search for a kind of Event. All Events
are associated with (i.e. contain) a Country object. Besides querying for
other kinds of Event data, queries can contain country-related data (e.g.
name, location, continent, etc.). Since countries are a finite set and the
country data is fairly large, I'd prefer not to duplicate country data
across Event documents. What's the best way to handle this situation?

Best thing I can think of is to 1) create a separate index with the
country data, then 2) run the user query against the country index 3) Pick
off the high match(es) if any and 4) issue a new query against the Event
index using something like the country abbreviation (from the high match)
which would be an Event field. This seems like a lot of work per query. Is
there a better solution?

TIA

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/226e2b6b-7161-4cd4-a51f-6e62274b2483%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/226e2b6b-7161-4cd4-a51f-6e62274b2483%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAF3ZnZ%3DPbgW43taoBqGHxozh_qCaP%3DNuWd%2Bf5GqZKbHk95F6dA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.