Icons made by Freepik from www.flaticon.com (With SQL) Your app is sitting on a Ferrari-style compute engine. — Lukas Eder 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. The SQL databases have added text search within them, albeit for a single node SMP systems. Couchbase Full-Text Search (FTS) is created with three main motivations: Transparently search across multiple fields within a document Go beyond the exact matching of values by providing language based stemming , fuzzy matching, etc. Provide the search results based on relevance 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. In addition to the search, it supports aggregation via search facets . In the NoSQL world, Luce...
A blog about all things data and data processing issues and interests. SQL, NoSQL, flexible schema, scale-up, scale-out, transactions, high availability.