Category: Analytics

Couchbase 6.5 – Scan Consistency in Analytics

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

Extend Couchbase Analytics with RapidMiner using CData

Extend Couchbase Analytics with RapidMiner using CData

Extend Couchbase Analytics with RapidMiner using CData This article will guide you through the steps needed to setup the connection from RapidMiner to Couchbase Analytics using the CData JDBC driver for Couchbase. More details regarding this driver can be found...

Cost Based Optimizer for Couchbase N1QL (SQL for JSON)

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
Analytics – Love the Doc Model You’re With

Analytics – Love the Doc Model You’re With

In business applications, the data is often modeled for a large number of concurrent low latency queries. If you want to gain insight by looking at trends, however, you end up wishing you had an entirely different data model. The...

July 26, 2019
The Unreasonable Effectiveness of SQL in NoSQL Databases

The Unreasonable Effectiveness of SQL in NoSQL Databases

Business applications have requirements: take customer orders, deliver customer orders, track shipping, generate inventory report, end of the day/month/quarter business report, generate business dashboards and more.  These requirements evolve slowly. They remain even when you choose a NoSQL database. On...

May 26, 2019
Build Real-time Dashboards – Couchbase Analytics & Tableau

Build Real-time Dashboards – Couchbase Analytics & Tableau

This blog covers how to set up a Couchbase Analytics cluster in under 5 clicks and create a real-time visualization dashboard with Tableau.  Introduction Couchbase Server is a hybrid NoSQL database that supports operational and analytical workloads. Couchbase Analytics in...

The Unreasonable Effectiveness of SQL

The Unreasonable Effectiveness of SQL

Two score and five years ago two young IBM researchers brought forth on databases, a new language, conceived in relational, dedicated to the proposition that data can be manipulated declaratively and easily.   In the years since Don Chamberlin and Ramond...

April 2, 2019
N1QL: To Query or To Analyze?

N1QL: To Query or To Analyze?

Note: This recommendation note was written in collaboration with Till Westmann and Mike Carey, who lead the Couchbase analytics R&D. [Part 2 of this article by Even Pease is at: https://www.couchbase.com/blog/part-2-n1ql-to-query-or-to-analyze/] Couchbase’s Query and Analytics Services both support N1QL (SQL...

January 24, 2019
JSON to Insights: Fast and Easy

JSON to Insights: Fast and Easy

Co-author:  Sitaram Vemulapalli, Principal Engineer, Couchbase R&D. “The answer my friend is hiding in JSON” – Bob Dylan There are a lot of public JSON datasets and then is awesome JSON datasets. Every company, including yours, has stored a lot of...

December 1, 2018
Connecting to Couchbase via ODBC

Connecting to Couchbase via ODBC

Couchbase Analytics Couchbase Data Platform now supports hybrid transaction/analytical processing (HTAP) workloads. Plus, our massively parallel processing (MPP) query engine lets users run ad-hoc analytical queries that deliver faster insights without impacting performance. Couchbase Analytics reduces the time to insight...

Announcing Couchbase Server 6.0 with Analytics

Announcing Couchbase Server 6.0 with Analytics

We are proud to announce that Couchbase Server 6.0 is now available, with the central theme of helping reduce the time to insight from enterprise applications. As part of this release, Couchbase Analytics service is now officially available. After two...