Case insensitive SimpleDB search

Question

Since Amazon SimpleDB does not provide a case-insensitive query, what would be the best way to do case-insensitive attribute searches in simpleDB?

One thing that can be done includes a separate attribute, which is a line version of each row, and then use a “similar” query, but it will include a lot of duplication. Is there any elegant way to do the same?

EDIT
At first I tried to save a separate attribute, which was a lowercase version of the text to search, and then used a query like “how”, but “how” is not very fast for the things that I create, as well as the idea of ​​adding redundant data and the complexity of the application is not cool . So I integrated elasticsearch and it works pretty well so far + this gives more control over the search.

Answer 1

I heard that some people advocate a separate idea for an attribute , and I agree that probably the best solution. Only one of the drawbacks leaving so much functionality in the application code, I think.

Answer 2

You can create a whole separate domain, which is an inline mirror of real data. This search domain may also contain other optimizations.

Then try to synchronize the two DBS. Each so often, you can toss a search domain and rebuild it. You can also restore your search domain when you come up with a new search strategy.