Tag: oracle

Couchbase for Oracle Developers – Part 4 : Data types

Link to the series home page: https://blog.couchbase.com/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...

/ March 25, 2020

It’s the workload, stupid!

As an application architect, eventually, you’d to choose the database or database service to power your newest application or a micro-service. Selecting one of the databases among relational databases was easier.  The use cases were roughly divided into OLTP and...

/ November 14, 2018
"POC21 - Proof of Concept" by POC21 licensed through creative commons https://www.flickr.com/photos/poc21cc/22114029108

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

/ January 29, 2018

Couchbase for Oracle developers — Part 3 : Database Objects

Here’s the home page for the series: https://blog.couchbase.com/couchbase-oracle-developers-part-1-overview/ 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...

/ January 27, 2018
Glass ochem by Purpy Pupple, licensed through Creative Commons https://commons.wikimedia.org/wiki/File:Glass_ochem.png

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

/ January 26, 2018
Glass ochem by Purpy Pupple, licensed through Creative Commons https://commons.wikimedia.org/wiki/File:Glass_ochem.png

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

/ January 25, 2018

Couchbase for Oracle Developers – Part 2 : Architecture

Back in November, Raju Suravarjjala, (Sr. Director, Couchbase QE & Performance) and I  presented “Mindmap: Oracle to Couchbase For Developers”. You can see the slide deck here: http://bit.ly/2mPdJfo. Overview article for the series is at is at https://blog.couchbase.com/couchbase-oracle-developers-part-1-overview/  This series is written in...

/ January 22, 2018
ETL diagram by JakobVoss licensed through Creative Commons 3.0 https://commons.wikimedia.org/wiki/File:Etl-process.svg

CSV tooling for migrating to Couchbase from Relational

CSV (Comma-seperated values) is a file format that can be exported from a relational database (like Oracle or SQL Server). It can then be imported into Couchbase Server with the cbimport utility. Note: cbimport comes with Couchbase Enterprise Edition. For...

/ January 18, 2018

Couchbase for Oracle Developers – Part 1 : Overview

Back in November, Raju Suravarjjala,(Sr. Director, Couchbase QE & Performance) and I  presented “Mindmap: Oracle to Couchbase For Developers”. You can see the slide deck here: http://bit.ly/2mPdJfo. Overview article for the series is at is at https://blog.couchbase.com/couchbase-oracle-developers-part-1-overview/  This series is written in collaboration...

/ January 17, 2018

Oracle Date Format: N1QL and Support for Date-Time Functions – Pt 1

Read the pdf version here. Date and Time functions and formats can vary for different databases. In the article we shall compare Couchbase N1QL Date-Time functions with Oracle ISO Date format. In Oracle, date format and timezones feature multiple data types,...

/ September 22, 2017