Tag: analytics

Deep Dive: Window functions in Couchbase Analytics

Couchbase Server 6.5 Beta brings a host of new features [1] to the leading NoSQL database. One of the key additions to the N1QL query language is support for window functions. These functions were originally introduced in the SQL:2003 standard and...

Analytics Explain Plan – Part 1

Co-author:  Till Westmann,  Senior Director, Engineering Introduction Couchbase Analytics is the “newest kid on the block” amongst all the services available in Couchbase Server. The new service is providing rapid time to insight in many use cases like ship to...

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

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

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: A Comparative Study.

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

/ May 26, 2019
data analytics dashboard tableau couchbase blog

Building a real-time data visualization dashboard with Couchbase Analytics and 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...

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. Couchbase’s Query and Analytics Services both support N1QL (SQL for JSON).  A common question is: “Which service should run my...

/ January 24, 2019

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

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