Dictionary
...
| Function | Efficiency level | Indexed instance data | Search input text | Documentation | Postgres | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Full text search for terms with stemming and stop-word filtering | 2 | { "title": "The Lord of the Rings", ...} | title = Lords of the Ring | ||||||||
| Keyword search (aka exact match). | 2 | {"barcode" : "12345678", ... } | barcode = 12345678 | ||||||||
Full text Search for terms with over all text fields and exact match for all keyword fields. Note: Stemming and Analyzing of various languages is supported, but we need to do use it only for required predefined list of languages. | 2 | { "title": "The Lord of the Rings", "publicNote" : "silver covering", "barcode" : "12345678" ... } | Lord of the Ring silver covers or Lord of the Ring 12345678 | ||||||||
| Range filter | 2 | { "createdDate" : "12-12-2020", ...} | |||||||||
| Autocomplete | 1 | ||||||||||
| Facets | 3 | Wildcard search with * on left and right. Something which starts with Terms that containsin most cases | 3 | , can be 2 if{"hrid" : "12345678", ... } | barcode = 12345* | https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-prefix-query.html | Wildcard search with * on left | 5, but there can be optimizations that make it 2 for certain cases | {"hrid" : "12345678", ... } | barcode = 12345678 | https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-wildcard-query.html or maybe https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-regexp-query.html |
| Wildcard search with * on left and right. Something which starts with Terms that contains | in most cases 3, can be 2 if index_prefixes is on | {"hrid" : "12345678", ... } | barcode = 12345* | https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-prefix-query.html | |
| Wildcard search with * on left | 5, but there can be optimizations that make it 2 for certain cases | {"hrid" : "12345678", ... } | barcode = 12345678 | https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-wildcard-query.html or maybe https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-regexp-query.html |