Category: Analytics
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...
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...
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...
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...
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...
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)
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,...
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...