Category: Data Modeling

Get a Bigger Picture with N1QL Window Functions and CTE

Get a Bigger Picture with N1QL Window Functions and CTE

Whether it is a personal need to understand your spending pattern from looking at the bank transactions, or seeking to improve the sales performance in your organization by looking at the sales activities, the real insights are only visible with...

March 12, 2019
N1QL query with Self Referencing Hierarchy

N1QL query with Self Referencing Hierarchy

A data construct that often appears in business application is the hierarchical data structure. Hierarchy captures the parent-child relationship often between the same object. For instance a company structure captures the reporting line between employees. Business organization captures the relationship...

February 17, 2019
Relational to NoSQL – CRM Application Data Visibility

Relational to NoSQL – CRM Application Data Visibility

As a follow up to my previous webcast on the subject of Relational to NoSQL database where I discussed that we are in the third phase of the NoSQL database adoption, the “Broad Replatforming” of Enterprise Application. I want to provide...

January 21, 2019
JSON to Insights: Fast and Easy

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
NDP Episode #25: Nathan Voxland on Liquibase

NDP Episode #25: Nathan Voxland on Liquibase

Liquibase is the focus of the latest episode of The NoSQL Database Podcast. Nathan Voxland joins as the special guest to talk about source control for your database. I’m also joined by special co-host Denis Rosa, a developer advocate who...

November 13, 2018
YCSB-JSON: Implementation for Couchbase and MongoDB

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
Using YCSB to Benchmark JSON Databases

Using YCSB to Benchmark JSON Databases

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
How to Join JSON: Couchbase N1QL vs. MongoDB Query

How to Join JSON: Couchbase N1QL vs. MongoDB Query

As NoSQL databases evolved, each added higher level APIs or languages to help programmers to complex things easily. SQL, having done that for relational data, showed the way. In SQL, developers say WHAT needs to be done and the database...

July 11, 2018
Data Modeling for Couchbase with erwin DM NoSQL

Data Modeling for Couchbase with erwin DM NoSQL

Given the architecture and design of NoSQL systems, especially the document family databases like Couchbase that do not enforce schema on write, data modeling for NoSQL can often be challenging when migrating from relational systems to NoSQL or when building...

A Guide to N1QL features in Couchbase 5.5: Special Edition

A Guide to N1QL features in Couchbase 5.5: Special Edition

N1QL was first released with Couchbase 4.0 in the fall of 2015.  After two and a half years, it’s great to release Couchbase 5.5 and this N1QL 5.5 feature booklet with it at the New York Couchbase Connect. This special...

May 10, 2018
New Features in Index Service in Couchbase Server 5.5

New Features in Index Service in Couchbase Server 5.5

In the last major release, Couchbase Server 5.0, we introduced Plasma – New Storage Engine and also the support for Index Replicas in the Index Service. We have continued to build on these new features in our upcoming release. The themes...