Tag: JSON

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

/ August 7, 2019

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

Introducing the Couchbase .NET SDK 3.0 “Alpha” Releases

What’s in an SDK? Couchbase Server offers multiple services for storing, retrieving, querying and analyzing your data. Each service exposes a public API either as REST API or via lower level, extended, Memcached binary protocol. With the proper Authentication and...

Approaches to Query Optimization in NoSQL.

A man returned home after walking around the globe for eleven years.  Next day, when he told his wife he’s going to the corner store, she asked him: “are you taking the short route or the long one?”. Queries can...

/ May 5, 2019
couchbase mobile 2.5

Couchbase Mobile 2.5 Released

Today we are announcing the general availability of Couchbase Mobile 2.5, our most advanced NoSQL data platform for mobile applications to date. This release builds on the strong architectural foundation that was laid out with the release of Couchbase Mobile...

The Unreasonable Effectiveness of SQL

Two score and five years ago two young IBM researchers brought forth on databases, a new language, conceived in relational, dedicated to the proposition that data can be manipulated declaratively and easily.   In the years since Don Chamberlin and Ramond...

/ April 2, 2019

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