How to implement such a search?

Question

Search engines

I have in a DB some tables, machines clients and services. Is it possible to do a search on aggregated data using elasticsearch (or something else)?
for example query: find all cars that were sold to Austria without warranty. Or is this a problem not so much in the search engine as in splitting the query into the right tokens?

Answer 1

This can be done not only by elaskik, but also by elastic, of course. And the query example itself is not about aggregation, but about filtering. Aggregation usually answers the question - how much. For example: how many cars were delivered by country without insurance.
It is more a matter of organizing data, because each tool has its own characteristics.

Answer 2

Thanks, maybe I didn't express myself correctly. It means that all this data is stored in a relational database, maximally decomposed (?).
That is, I thought I could say to elastic, automatically collect such data sets from tables, search for them.
And so, in theory, you can create such lookup tables in the database itself and parse the client request. I thought there was something like this out of the box in the elastic.