Tag: Index
What’s New and Improved in Couchbase Server 6.6
Couchbase Server 6.6 is now generally available with exciting new enhancements that augment our Analytics, Query, Search, and Eventing Services as well as our backup, recovery and tooling capabilities. These enhancements improve developer productivity, simplify cloud deployments, and enable operational...
Chaitra Ramarao, Sr. Product Manager, Couchbase Inc.
August 12, 2020
Migrating Data from MongoDB to Couchbase, Part 2
Prolog The previous article provided details on how to migrate a MongoDB data set to Couchbase Server. This article shows you how to use the Couchbase SDK to access the data via a Java console application. Code snippets show how...
Douglas Bonser, Principal Solution Engineer, Couchbase
July 30, 2020
Flexible Query & Indexing for Flexible JSON Model.
Use N1QL when you’re in a JSON pickle. — Confucius For the JSON data model, the advice is to think of collections as tables, JSON document as denormalized rows and field names as columns – roughly. All this holds in...
Keshav Murthy
April 13, 2020
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...
Brian Kane, Solutions Engineer, Couchbase
March 26, 2020
Couchbase 6.5 – RMS for Indexing Service
Couchbase 6.5 release includes an extensive list of Enterprise Grade Database Query capability that allows customers to expand the adoption of NoSQL database into traditional database applications. The release has added transactional capability, Analytical Window functions, user defined JS functions,...
Binh Le
January 20, 2020
Index Planner for Global Secondary Indexes
Integral aspect of any distributed system is to seamlessly provide high availability (HA) and load balancing capabilities to its user. With little to no input from user, Couhbase’s Global Secondary Indexes1 (GSI) provides its users with both – HA and Load...
Amit Kulkarni
January 5, 2020
Primary Uses for Couchbase Primary Index
A couple of frequently asked questions on N1QL for query service: When do we actually use a primary index? Why the index advisor does not recommend the primary index when that may the only choice? Read on… Couchbase is a...
Keshav Murthy
August 22, 2019
Approaches to Query Optimization in NoSQL
A man returned home after walking around the globe for eleven years. Next day, when he told his wife he’s going to the corner store, she asked him: “are you taking the short route or the long one?”. Queries can...
Keshav Murthy
May 5, 2019
Divide and Conquer: Couchbase GSI Index partitioning.
In Couchbase, data is always partitioned using the consistent hash value of the document key into vbukets which are stored on the data nodes. Couchbase Global Secondary Index (GSI) abstracts the indexing operations and runs as a distinct service within...
Keshav Murthy
April 11, 2018
Understanding Index Grouping And Aggregation in Couchbase N1QL Query
Couchbase N1QL is a modern query processing engine designed to provide aggregate SQL for JSON by index on distributed data with a flexible data model. Modern databases are deployed on massive clusters. Using JSON provides a flexible data mode. N1QL...
Sitaram Vemulapalli
April 3, 2018
Index Partitioning in Couchbase Server 5.5
Index partitioning is a new feature available in Couchbase Server 5.5. Check out the Couchbase Server 5.5 Developer Build announcement and download the release for free right now. In this post, I’m going to cover: Why you might want to use index...
Matthew Groves
March 19, 2018
New Features in Index Service in Couchbase Server 5.5
In the last major release, Couchbase Server 5.0, we introduced Plasma – New Storage Engine and also the support for Index Replicas in the Index Service. We have continued to build on these new features in our upcoming release. The themes...
Venkat Subramanian, Product Manager
March 16, 2018