Source: dzone.com
First Class SQL for Full-Text SearchCategory: Business, Database, Data
Over time, the database industry has realized text search and SQL are two sides of the same coin. Text search needs further query processing, query processing needs text search to efficiently filter for text patterns.
Couchbase Full-Text Search (FTS) is created with three main motivations: FTS achieves this on an inverted index and a rich set of query predicates: from simple word search to pattern matching to complex range predicates.
Here’s an example from N1QL: This includes the following in addition to SEARCH(): You get the FULL benefit of first-class query processing in addition to efficient search.
When the FTS index has created an index with JSON type field (doc_config.type_field in the index definition document) is defined (in this case type = “hotel”) to create the index on the subset of the document, both index selection and search pushdown exploits this predicate.
Couchbase Full-Text Search (FTS) is created with three main motivations: FTS achieves this on an inverted index and a rich set of query predicates: from simple word search to pattern matching to complex range predicates.
Here’s an example from N1QL: This includes the following in addition to SEARCH(): You get the FULL benefit of first-class query processing in addition to efficient search.
When the FTS index has created an index with JSON type field (doc_config.type_field in the index definition document) is defined (in this case type = “hotel”) to create the index on the subset of the document, both index selection and search pushdown exploits this predicate.
Related Articles
Community Partners
DevOps Careers