Category: Data Modeling
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...
james.oquendo
November 23, 2020
Scopes and Collections for Modern Multi-Tenant Applications: 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...
james.oquendo
November 17, 2020
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...
james.oquendo
August 4, 2020
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...
james.oquendo
July 30, 2020
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...
james.oquendo
June 8, 2020
Implementing a robust portable cron like 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...
james.oquendo
May 22, 2020
Couchbase for Oracle Developers – Part 4 : Data types
Link to the series home page: https://staging.couchbase.com/blog/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...
james.oquendo
March 25, 2020
The Unreasonable Effectiveness of SQL in NoSQL Databases: A Comparative Study.
The business applications have requirements: take customer orders, deliver customer orders, track shipping, generate inventory report, end of the day/month/quarter business report, generate business dashboards and more. These requirements evolve slowly. They remain even when you choose a NoSQL database....
james.oquendo
May 26, 2019
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...
james.oquendo
February 17, 2019
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 adoption, the “Broad Replatforming” of Enterprise Application. I want to provide an...
james.oquendo
January 21, 2019
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...
james.oquendo
October 6, 2018
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...
james.oquendo
May 14, 2018