Lookup and complex query


#1

Hi!
I've understood that join and lookup are very complex problems in NoSQL technologies.
Neverthless,I need of help.
I have a list of events that are indexed in elasticsearch. For example:

id_product = "152t36"
id_profile ="1"
current_pressure=121.00
current_temperature=23

Each id_profile defines a correct operation profile with range values. For example

Id_profile="1"
min_pressure=100
max_pressure=150
min_temperature=10
max_temperature=30

Id_profile="2"
min_pressure=104
max_pressure=123
min_temperature=11
max_temperature=34

I need of a query that signal all devices that have values out of range.

What's the best strategy?
If I index also correct operation profile, how can I join profiles and make the necessary controls?

Thank you very much!


(system) #2