Category: Full-Text Search

Arrays in JSON: Modeling, Querying and Indexing Performance

Arrays in JSON: Modeling, Querying and Indexing Performance

Array is THE difference between the relational model and the JSON model.   — Gerald Sangudi Abstract JSON array gives you flexibility in the type of elements,  number of elements, size of the elements, and the depth of the elements.  This...

August 4, 2020
FIRST CLASS SQL for FULL-TEXT SEARCH

FIRST CLASS SQL for FULL-TEXT SEARCH

Over time, the database industry has realized full-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...

July 7, 2020
Fully Configured Couchbase on Red Hat OpenShift in 5 Minutes

Fully Configured Couchbase on Red Hat OpenShift in 5 Minutes

I recently did a presentation at Red Hat Users Group – North Texas on Couchbase NoSQL Operator on OpenShift. Thank you to the Red Hat Dallas team for extending the invitation for a joint session – Sam Nicholls, John Gammon, and Nick Wallace.  In the...

Implement FHIR REST server with Couchbase

Implement FHIR REST server with Couchbase

This is a follow up to my previous post that covered the topic of FHIR Data Model with Couchbase N1QL. In this blog, I will discuss the topic of how to implement the FHIR Search REST API Server over the...

June 8, 2020
FHIR Data Model with Couchbase N1QL

FHIR Data Model with Couchbase N1QL

Couchbase is a JSON database that has now become an alternative to the traditional RDBMS. It has achieved this, not only by providing the industry-leading Key-Value store and the same query and ACID translation capabilities that organizations have come to...

April 25, 2020
FTS and N1QL: Better MongoDB in Operator Performance Querying Multiple Arrays

FTS and N1QL: Better MongoDB in Operator Performance Querying Multiple Arrays

Introduction Couchbase Full Text Search (FTS) is a great fit for indexing multiple arrays and executing queries with multiple filter predicates in arrays.  In this article, I’ll demonstrate the advantages of using FTS over GSI (Global Secondary Index) for array...

Announcing Couchbase Server 6.5 GA – What’s New and Improved

Announcing Couchbase Server 6.5 GA – What’s New and Improved

We are pleased to announce the release of Couchbase Server 6.5 GA with stellar features that lead the innovation in the NoSQL database market. We are excited to once again pioneer some of the most sought-after relational capabilities in the...

Introducing Geo Bounded Polygon Query in Full Text Search

Introducing Geo Bounded Polygon Query in Full Text Search

Geo Bounded Polygon Query The ability to perform text search with geospatial query capabilities is a very powerful and effective feature from full text search(FTS). And we are bringing the more flexible geo bounded polygon query feature to FTS in...

January 16, 2020
Full Text Search Indexing Best Practices by Use Case

Full Text Search Indexing Best Practices by Use Case

Introduction Full text search (FTS) indexing can be challenging for those who are not familiar with search in general.  In this post, we’ll take some common search use cases and work through the creation of appropriate indexes following best practices...

Introducing FTS with N1QL

Introducing FTS with N1QL

Topics this article will cover What’s good with N1QL? What about FTS? But why FTS within N1QL? Basic N1QL+FTS queries Deploying N1QL+FTS Syntax(es) Abilities & limitations N1QL+FTS Internals Covered-index vs Non-covered-index queries More N1QL+FTS query examples What’s next? 1. Couchbase’s...

Few Index Management Tips – FTS Best Practices Part II

Few Index Management Tips – FTS Best Practices Part II

We have already seen a handful of best practices for defining an FTS index in part1, now let’s explore a few useful tips about the operational and maintenance aspects of an index.   A user who is new to the...

September 23, 2019
Running FTS Queries in N1QL

Running FTS Queries in N1QL

We already discussed how the Like % clause is potentially harmful for your application at scale, and why you should consider using Couchbase Full-Text Search instead. One thing we haven’t mentioned yet is why you might prefer Couchbase FTS over any...