Category: N1QL / Query

Index Advisor For Query Workload

Overview As the second feature of Index Advisor released in Couchbase server 6.5 (Developer Preview), Advisor function extends the scope from advising on single query to providing index recommendations for query workload and support on session handling. In this article,...

/ August 15, 2019

Window functions in Couchbase Analytics

Co-author:  Till Westmann,  Senior Director, Engineering The beta bits for Couchbase 6.5, the upcoming release of Couchbase Server, are now available. The Analytics service, which supports efficient parallel query processing, has added support for support for window functions defined in...

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

We are pleased to announce the release of Couchbase Server 6.5 beta 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...

Advanced Filtering with XDCR 6.5

Customers use XDCR for various use cases from high availability to data locality to disaster recovery to cloud migration and hybrid cloud deployments. To meet these use cases, there are a number of circumstances where they would want to replicate...

Index Advisor for N1QL Query Statement

Overview Index advisor is introduced in Couchbase server 6.5 as a developer preview feature. It targets at providing secondary index recommendation to help DBAs and developers optimize N1QL query performance. This version is rule-based, in which the index candidates will...

/ August 9, 2019

Couchbase 6.5 – Scan Consistency in Analytics

Since the GA back in Nov 2018, Couchbase Analytics is being used in multiple verticals for rapid time to insight – ad-hoc analysis by a payment provider,  shopping cart analysis by an e-tailer, next gen ticket booking engine by a...

Cost Based Optimizer for Couchbase N1QL (SQL for JSON)

Authors & Engineering Team: Bingjie Miao, Keshav Murthy,  Marco Greco, Prathibha Bisarahalli. Couchbase, Inc.  A rule-based optimizer knows rules for everything and cost for nothing – Oscar Wilde Abstract Couchbase is a distributed JSON database. It provides distributed data processing,...

/ August 7, 2019

Comparing Postgres JSONB with NoSQL

  The reality is that databases are converging, and in the last few years, it is becoming even more difficult to point what are the best scenarios for each datastore without a deep understanding of how things work under the...

How to use N1QL to migrate Oracle data into Couchbase

Getting the Couchbase server to run on your PC or Mac involves a few simple steps to download the software and spin up a cluster with all the Couchbase services that you need (https://docs.couchbase.com/server/6.0/getting-started/start-here.html). Sample buckets are available with the...

/ July 9, 2019

A Preview of Couchbase 6.5 N1QL Features

Couchbase 6.5 release is going to be one of the largest release content wise for Couchbase. For N1QL Query service, the focus for us is to bring Enterprise Database functionalities to the Couchbase Database. Expanding N1QL with additional functions to...

/ June 22, 2019