Tag: JSON

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: Nobel Prize Winners dataset.

Nobel prizes are announced over a week in October and the award ceremony is today, December 10th (“It’s already tomorrow in Australia”). There is an interesting story of the how C. V. Raman (of Raman effect) booked his ticket to...

/ December 9, 2018

JSON to Insights: Analyzing US healthcare Data.

“Nothing is certain except for death and taxes.” This isn’t a dataset made with a bed of roses or manicured green grass. A bit more serious. Let’s see if we can quickly learn anything here. The dataset is the following. “name”...

/ December 7, 2018

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

Understanding Cross Datacenter Replication (XDCR) – Part 1

If you have any familiarity with Couchbase, you definitely know XDCR. If you use Couchbase for any of your applications, you are very likely using XDCR. I wouldn’t be wrong if I said, XDCR is indeed one of our customers’...

On Par with Window Functions.

  Use golf analogy when explaining to executives. Use a car analogy for all others.  — Confucius. The purpose of window functions is to translate the business reporting requirements declaratively and effectively to SQL so query performance and developer/business-analyst efficiency...

/ November 22, 2018

It’s the workload, stupid!

As an application architect, eventually, you’d to choose the database or database service to power your newest application or a micro-service. Selecting one of the databases among relational databases was easier.  The use cases were roughly divided into OLTP and...

/ November 14, 2018

YCSB-JSON: Implementation for Couchbase and MongoDB

YCSB is a great benchmarking tool built to be easily extended by any driver which supports and implements basic operations like: insert, read, update, delete and scan. Plain synthetic data introduced by YCSB fits this paradigm perfectly. But when it comes...

/ October 6, 2018

YCSB-JSON: Benchmarking JSON databases by extending YCSB

Bruce Lindsay once said, “There are three things important in the database world: Performance, Performance, and Performance”.  Most enterprise architects know, as we progress in database features and architectures, it’s important to measure performance in an open way so they can compare...

/ September 10, 2018

TPCx-IoT benchmark with Cisco & Couchbase.

The Internet of Things (IoT) application brings a new dimension to the database workload.  What makes IoT click is the availability of data from the edge devices at the gateways, servers for instant analysis, rollups, etc.  Data generated is heterogeneous...

/ August 4, 2018