Tag: JSON
It’s SQL. Again.
[crayon-5da7b529149b7903058419/] [crayon-5da7b529149c5205545856/] — In the spirit of Alexander Pope and Sir John Squire.
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,...
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....
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...
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...
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...
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...
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”...