Tag: analytics

Partner Blog: Couchbase 4.5 – Native BI Support

Partner Blog: Couchbase 4.5 – Native BI Support

Earlier this week, Couchbase launched the latest version of its flagship NoSQL database, 4.5, with powerful additions to N1QL, faster queries and indexing, role based security and a range of other features. At Cloud9 Charts, we are pleased to add...

james.oquendo June 27, 2023
Introducing Charts for Query & Analytics

Introducing Charts for Query & Analytics

Couchbase Web Console is a browser-based, interactive graphical user interface that supports the management of all services in Couchbase Server. It also includes the Query & Analytics Workbench that allows developers to interactively manipulate Couchbase data, explore the schema, and...

shyamraj June 27, 2023
Query Admission Control in Couchbase Analytics

Query Admission Control in Couchbase Analytics

Couchbase Analytics is optimized to perform ad-hoc analytical queries, which typically process more data than one can fit in memory. It employs a massively parallel processing (MPP) engine that attempts to fully utilize the available processing power in any given...

james.oquendo November 27, 2020
What’s New and Improved in Couchbase Server 6.6

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

james.oquendo August 12, 2020
Couchbase Data Platform Partner Training

Couchbase Data Platform Partner Training

Thanks to Binh Le, Jon Strabala & Keshav Murthy for contributing to this post. Introduction Couchbase provides a wide variety of self paced online courses as well as in-person (or virtual) training through both Couchbase’s training portal. Advent of open...

james.oquendo May 19, 2020
Simple dataviz with N1QL and Google Sheets.

Simple dataviz with N1QL and Google Sheets.

Do whatever it takes to present the data to aid analysis and thinking.  — Edward Tufte How do you create graphs like these if you don’t already have some ready-made cool dataviz tool? You can run queries to wrangle the...

james.oquendo January 7, 2020
Utilizing Multiple Disks to Speed Up Couchbase Analytics Queries

Utilizing Multiple Disks to Speed Up Couchbase Analytics Queries

Typical ad-hoc analytical queries have to process much more data that can fit in memory. Consequently, those queries tend to be I/O bound. When the Analytics service was introduced in Couchbase 6.0, it allowed users to specify multiple “Analytics Disk...

james.oquendo November 17, 2019
Window functions in Couchbase Analytics

Window functions in Couchbase Analytics

Co-author:  Till Westmann,  Senior Director, Engineering The 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 the...

james.oquendo August 12, 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...

james.oquendo July 26, 2019
The Unreasonable Effectiveness of SQL in NoSQL Databases: A Comparative Study.

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

james.oquendo May 26, 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://staging.couchbase.com/blog/part-2-n1ql-to-query-or-to-analyze/] Couchbase’s Query and Analytics Services both support N1QL (SQL...

james.oquendo January 24, 2019
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...

james.oquendo November 27, 2018