G
G
Gregory Kaplan2017-05-04 00:18:38
PostgreSQL
Gregory Kaplan, 2017-05-04 00:18:38

Not full-text search, which DBMS to choose?

Hello everyone!)
There is a line where incomplete data is stored. the unknown number of characters is replaced by *, you need to find the corresponding string using the full one. This is not quite a basic full text search algorithm. there are no "words". Now this is being solved by "enumeration" of all possible options, which is not flexible and takes a long time. The underlying storage is redis.
Example: "fa*la*" (stored in the database), but found using: "fancylang"
There are not very many records (1-5k). Speed ​​is critical.
Thanks in advance to everyone for your help.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
Philipp, 2017-05-04
@zoonman

So far, nothing comes to mind except enum for converting the alphabet into a bit field.
First filter by the presence of the alphabet, and then do the reverse application of the pattern to the string.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question