Category: Data Modeling

Woman riding a horse in a barrel race as a metaphor for navigating SQL data challenges

What is SQL? Navigating Databases for DBAs and Developers

This article briefly introduces the essentials of SQL – its meaning, definition, and application to different database technologies. We introduce many different types of systems that use SQL – from databases to event stream processing. What is SQL?  Define: SQL...

April 7, 2021
Introduction to Ottoman

Introduction to Ottoman With Couchbase

Ottoman is an Object Data Modeler (ODM) for Couchbase’s Node.js SDK providing JSON schema and validation for NoSQL. Why Use an ODM for Couchbase With Ottoman, you declare schema in your code. Although Couchbase has no schema enforcement for your...

March 30, 2021

Data Structures & Full-Text Search Indexing in Couchbase

This is Part 3 of a series examining Data Structures in NoSQL databases. In this post, we use Full-Text Search natural language queries against data structures in Couchbase. Part 1: Data Structures for NoSQL Applications we used simplified JSON data...

March 16, 2021

Hands-on Migration From Relational to Collections

The key outcome of this blog is to teach you how you can easily migrate your relational data over to Couchbase, lowering your TCO and empowering your data platform to respond to the fast paced release cycles we know and...

February 16, 2021

Recursive Timers for Document Aggregation and Lower TCO with Couchbase Server 6.6

Where does it begin… IOT, Edge devices and NoSQL are all technologies that have increased in popularity in recent years. Allowing people to comfortably create interaction heavy applications, without the worry of stability and availability. One problem with the freedom...

February 2, 2021

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
JSON Data Modeling

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

How To Migrate to Scopes and Collections in Couchbase 7.0

Scopes and Collections are a new feature introduced in Couchbase 7 that allow you to logically organize data within Couchbase.  You should take advantage of scopes and collections for simpler mapping from RDBMS as well as consolidation of hundreds of...

November 23, 2020

Scopes & Collections for Multi-Tenant Apps: Couchbase 7.0

Couchbase 7.0 introduces Scopes and Collections to easily build and deploy microservice based multi-tenant applications. Scopes and Collections allow logical isolation of different types of data, independent lifecycle management and security control at multiple levels of granularity. Application developers will...

November 17, 2020
Bay farm island, Alameda, California

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
Two logos showing a MongoDB migration 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