Tag: analytics

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

Announcing Couchbase 6.0

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

A Couchbase Analytics Example using the Go SDK

This post illustrates the use of Couchbase Analytics with the Couchbase Go SDK. Couchbase Analytics is a new service available in Couchbase Server 6.0, you can read more at https://docs.couchbase.com/server/6.0/analytics/introduction.html. In this post we’re going to use a real world...

6.0 beta couchbase analytics

Announcing Couchbase Server 6.0 Beta

The innovation engine at Couchbase is in full swing and we’ve made significant updates in the 6.0 beta to the Analytics, Eventing, and Full-Text Search services. Couchbase Analytics Service is now officially in beta – it’s been 2 years since...

Analytics Example

The Couchbase Data Platform in Action: Analytics

Contents What is CBAS and how does it compare to “standard” Couchbase? Example Data and Configuration Code and Queries Web Client Web Server and Queries Querying with SQL++ Query Optimization Query Results and REST Response Conclusion Postscript With the release...

SQL++

Changes to the Couchbase Analytics Service

Contents 6.0 Data Definition Language Postscript The Couchbase Analytics Service uses the SQL++ query language. SQL++ is an modern query language designed to work with semi-structured data and the JSON data model. SQL++ is backwards-compatible with SQL. The Coucbase Analytics...