Category: Analytics
Couchbase Intro for MongoDB Developers and NoSQL Experts
Six thousand years ago, the Sumerians invented writing for transaction processing — Gray & Reuter By any measure, MongoDB is a popular document-oriented JSON database. In the last dozen years, it has grown from its humble beginnings of a single...
Keshav Murthy
April 25, 2020
Couchbase for Oracle Developers – Part 4 : Data types
Link to the series home page: https://www.couchbase.com/blog/couchbase-oracle-developers-part-2-architecture/ As part of data remodeling, while moving from the relational model to the JSON model, you’ll have to consider the data type mapping. In Oracle, you’ll have to create and declare the types...
Keshav Murthy
March 25, 2020
Part 2: N1QL: To Query or To Analyze?
When you need to query documents using SQL, there are two options available in Couchbase. The Query service and the Analytics service. Our blog, N1QL: To Query or To Analyze? provides a detailed overview of both services. I highly recommend...
Evan Pease
March 4, 2020
Extend Couchbase Analytics with Power BI using CData
Extend Couchbase Analytics with Power BI using CData. This article will guide you through the steps needed to setup the connection from Couchbase Analytics to Power BI Desktop using the CData Power BI driver for Couchbase. More details regarding this...
Justin Simpson, Solutions Engineer, Couchbase
January 31, 2020
Announcing Couchbase Server 6.5 GA – What’s New and Improved
We are pleased to announce the release of Couchbase Server 6.5 GA 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...
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...
Keshav Murthy
January 7, 2020
Using Multiple Disks to Speed Up Couchbase Analytics Queries
Typical ad-hoc analytical queries have to process much more data than 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...
Murtadha Al Hubail, Principal Software Engineer, Couchbase
November 17, 2019
Extend Couchbase Analytics with SQL Server using CData
Extend Couchbase Analytics with SQL Server using CData. This article will guide you through the steps needed to setup the connection from Couchbase Analytics to SQL Server using the CData ODBC driver for Couchbase. More details regarding this driver can...
Justin Simpson, Solutions Engineer, Couchbase
November 13, 2019
Deep Dive: Window functions in Couchbase Analytics
Couchbase Server 6.5 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 provide...
Dmitry Lychagin, Principal Engineer, Couchbase
September 20, 2019
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...
Sachin Smotra, Director Product Management, Couchbase
September 4, 2019
Customer 360 – Part 4 – Analyzing Your Data
OK, so we’ve looked at building aspects of a Customer 360 solution in previous posts. We looked at an overview of what’s involved in part 1, and since you’re reading this, I’m assuming that the threat of having to think...
Davis Chapman
August 13, 2019
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...
Sachin Smotra, Director Product Management, Couchbase
August 12, 2019