Category: Data Modeling

Data Structures & Queries with Couchbase N1QL (SQL for JSON)

Data Structures & Queries with Couchbase N1QL (SQL for JSON)

In the Data Structures for NoSQL Applications post, we used simplified JSON data access through native collections, maps, and more. This post demonstrates querying that data using higher-level N1QL queries, the SQL-based language for JSON. Developers can focus on managing...

January 27, 2021
A JSON Data Modeling Guide

A JSON Data Modeling Guide

When starting to learn about document databases, it’s nice to have a grip on JSON data modeling best practices. This will help you navigate the space and topics easier having an expanded vocabulary on the subject. Experience with a traditional...

January 20, 2021
Arrays in JSON: Modeling, Querying and Indexing Performance

Arrays in JSON: Modeling, Querying and Indexing Performance

Array is THE difference between the relational model and the JSON model.   — Gerald Sangudi Abstract JSON array gives you flexibility in the type of elements,  number of elements, size of the elements, and the depth of the elements.  This...

August 4, 2020
Migrating Data from MongoDB to Couchbase

Migrating Data from MongoDB to Couchbase

Prologue This article guides you through a one-time MongoDB migration to Couchbase. You will learn how to export from the MongoDB data structure, import to Couchbase, and do some basic transformation on those documents. All code from this blog is...

Implement FHIR REST server with Couchbase

This is a follow up to my previous post that covered the topic of FHIR Data Model with Couchbase N1QL. In this blog, I will discuss the topic of how to implement the FHIR Search REST API Server over the...

June 8, 2020
Handle Binary Data Attachments & Blobs with Couchbase Mobile

Handle Binary Data Attachments & Blobs with Couchbase Mobile

Couchbase Mobile supports a JSON document style NoSQL data model. In addition to supporting the standard JSON data types, Couchbase Mobile also supports binary data that include images, audio, video, PDF files, etc. A JSON document can be associated with...

Implementing a Scheduler Via Couchbase Eventing (Part 1)

Implementing a Scheduler Via Couchbase Eventing (Part 1)

This is the first of a multi-part series to leverage the Couchbase Eventing Service to run multiple scheduled tasks at specific recurring intervals in a cron like fashion completely inside the database without requiring additional infrastructure via a single general-purpose...

The Series on Time Series (in Couchbase): Episode 1

The Series on Time Series (in Couchbase): Episode 1

What Is This About So, you have a time series use case?  So do I, and this blog article is the proof of it. When I learn about a new subject, I like using the method of loci to memorize...

FHIR Data Model with Couchbase N1QL

FHIR Data Model with Couchbase N1QL

Couchbase is a JSON database that has now become an alternative to the traditional RDBMS. It has achieved this, not only by providing the industry-leading Key-Value store and the same query and ACID translation capabilities that organizations have come to...

April 25, 2020
Couchbase for Oracle Developers – Part 4 : Data types

Couchbase for Oracle Developers – Part 4 : Data types

Link to the series home page: https://blog.couchbase.com/couchbase-oracle-developers-part-1-overview/ As part of data remodeling, while moving from the relational model to the JSON model, you’ll have to consider the data type mapping. In Oracle, you’ll have to create and declare the types...

March 25, 2020
SQL to NoSQL – 7 Metrics to Compare Query Language

SQL to NoSQL – 7 Metrics to Compare Query Language

Organizations who want to take advantage of the many benefits of NoSQL document databases, often find that they have two challenges: How to convert their RDBMS schemas to leverage the schema-less document model. Learn a new API/Query  to access the...

March 6, 2020
Is No Processing Better Than Some Processing?

Is No Processing Better Than Some Processing?

Let’s do a little thought experiment. Yeah, I know, thinking. Who wants to do that? Wait! Before you tune me out and browse on to the next post on sexy indexes… At least give me a couple of minutes. Let’s...

October 29, 2019