Tag: database

N1QL (Query) Basic Order of Execution.

Query syntax is limited. Queries are unlimited. Predicate pushdown, group by pushdown, offset pagination, keyset pagination, join optimization, search optimization, we’ve discussed it all. Still, it’s important to understand the default, simple — albeit slow — execution flow of the...

/ June 8, 2019

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
riding the nosql wave forrester

Riding the NoSQL Wave at Couchbase

Today, Forrester Research Inc. has recognized Couchbase as a Leader in its “The Forrester Wave™: Big Data NoSQL, Q1 2019.” [download here] Recognition from Forrester is a great honor, because when they say something, the industry sits up and pays...

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

Understanding Index Grouping And Aggregation in Couchbase N1QL Query

Couchbase N1QL is a modern query processing engine designed to provide SQL for JSON on distributed data with a flexible data model. Modern databases are deployed on massive clusters. Using JSON provides a flexible data mode. N1QL supports enhanced SQL...

/ April 3, 2018

Using Couchbase Analytics with Node.js and JavaScript

Note: This post uses the the Couchbase Analytics Data Definition Language as of the version 5.5 preview release.  For updates and information on breaking changes in newer versions, please refer to Changes to the Couchbase Analytics Service. The Couchbase Analytics Service,...