Category: Data Modeling
Proof of Concept: Making a case to move from relational
Proof of concept may be just what you need to start when you’re evaluating Couchbase. We’ve been blogging a lot about the technical side of moving from a relational database like Oracle or SQL Server to Couchbase. Here are some...
Matthew Groves
January 29, 2018
Couchbase for Oracle developers — Part 3 : Database Objects
Here’s the home page for the series: https://www.couchbase.com/blog/couchbase-oracle-developers-part-2-architecture/ Oracle DBAs work with clusters, machines, storage systems, disks, etc. Oracle developers and their applications work with databases, tables, rows, columns, partitions, users, data types within the Oracle database system. Let’s compare and...
Keshav Murthy
January 27, 2018
JSON Modeling for RDBMS Users (video)
JSON modeling was covered in a previous blog post which was, in turn, based on a CSV import blog post that came before that. While writing the post on JSON modeling, it occurred to me that it might be useful...
Matthew Groves
January 26, 2018
JSON Data Modeling for RDBMS Users
JSON data modeling is a vital part of using a document database like Couchbase. Beyond understanding the basics of JSON, there are two key approaches to modeling relationships between data that will be covered in this blog post. The examples...
Matthew Groves
January 25, 2018
Comparing Couchbase Views with Couchbase N1QL & Indexing.
As Couchbase data platform evolved, services like N1QL and GSI Indexing handled the use cases Couchbase VIEWS used to handle and much more. It’s logical to ask the comparative question between them. Here is a table comparing both. This is...
Keshav Murthy
December 4, 2017
Oracle Date Format: N1QL and Support for Date-Time Functions
Date and Time functions and formats can vary for different databases. In this article, we shall compare Couchbase ISO-based Date-Time functions with Oracle Date format. Date formats vary between relational and NoSQL database due to the nature of NoSQL JSON...
Couchbase Product Marketing
September 22, 2017
Aggregate grouping with N1QL / MapReduce
Aggregate grouping is what I’m titling this blog post, but I don’t know if it’s the best name. Have you ever used MySQL’s GROUP_CONCAT function or the FOR XML PATH('') workaround in SQL Server? That’s basically what I’m writing about...
Matthew Groves
August 22, 2017
Handle Data Modeling Errors in a Golang with Couchbase Application
I’ve been developing with Couchbase and the Go SDK for a while now, but recently I ran into an issue that I deemed to be a bug in the SDK after hours of troubleshooting. I was trying to execute a...
Nic Raboy, Developer Advocate, Couchbase
August 22, 2017
Converting XML to JSON In C# Using Json.NET
Converting XML to JSON data that can be loaded into Couchbase Server can be accomplished with a little bit of .NET. Depending on the source of the data, you might be able to use a tool like Talend. But you...
Matthew Groves
July 6, 2017
Bringing SQL to NoSQL – Rich, Declarative Querying for JSON
Couchbase Server is a document-oriented NoSQL database. Most NoSQL systems force you to sacrifice the rich querying capabilities of SQL in trade for the other benefits they offer. At Couchbase, we’ve developed the N1QL query language to solve this problem....
Hod Greeley, Developer Advocate, Couchbase
July 5, 2017
Persist and Abstract Data in a Nativescript Typescript Application
Couchbase is a great tool to persist data inside our app. If you haven’t heard of it, it’s a document object storage that allows you to save your data. If you are using NativeScript-Angular, there are already some great tutorials...
Data Modeling NoSQL Documents in MongoDB vs Couchbase Server
When I’m out at events, I get a lot of questions regarding the differences between MongoDB and Couchbase Server as they are both in the NoSQL space and are both document databases. One particular question is related to data modeling....
Nic Raboy, Developer Advocate, Couchbase
May 11, 2017