Category: Data Modeling

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

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

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

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

Sam Redman, Solutions Engineer 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...

Tyler Mitchell January 27, 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...

Keshav Murthy 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

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

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