Category: Data Modeling

Why NoSQL JSON Databases Are So Useful

Why NoSQL JSON Databases Are So Useful

My family hears me talk about JSON databases rather frequently. Naturally, I had to explain that Jason is not the owner of my company! Instead, many modern databases use JSON as a data format. They usually leave the room at...

What is SQL? Navigating Databases for DBAs and Developers

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 With Couchbase

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

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

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

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...

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
How To Migrate to Scopes and Collections in Couchbase 7.0

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

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
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...