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...
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...
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...
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...
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,...
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...
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...
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...
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...
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...
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...
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...