Tag: oracle
A Tool to Ease Your Transition From Oracle PL/SQL to Couchbase JavaScript UDF
What is PL/SQL? PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax. It includes procedural language elements such as conditions and loops, and can handle exceptions (run-time errors). PL/SQL is native to Oracle databases, and...
Data Migration from Oracle to Couchbase
You may know Couchbase as the fastest, most scalable NoSQL platform available. However, did you know that Couchbase can also be a relational database? Couchbase is a data platform that can operate with multiple simultaneous personalities all in the same...
How to Denormalize Imported Documents from RDBMS Tables Using N1QL
Data migration is full of challenges. While migrating from a relational database (RDBMS) like SQL Server or Oracle, your main challenge comes at the time of denormalizing migrated documents as per the target data models. With the introduction of scopes...
Level Up Your Database Platform Best Practices at Couchbase Connect
My colleagues have already told you a lot about how amazing Couchbase ConnectONLINE will be. This free two-day tech conference is the premier event for exploring modern data, NoSQL technology and the cloud. John spoke about the need for modernization,...
Have a Happy Day of the Programmer!
Today’s your day, devs. The international Day of the Programmer is celebrated annually on the 256th day of the year (on 13 September in non-leap years). Why the 256th day? I mean, you already know, but I’ll explain it to...
Couchbase for Oracle Developers – Part 4 : Data types
Link to the series home page: https://www.couchbase.com/blog/couchbase-oracle-developers-part-2-architecture/ 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...
It’s the Workload, Stupid!
As an application architect, eventually, you’d have to choose the database or database as a service (DBaaS) to power your newest application or a micro-service. Selecting one of the databases among relational databases was easier. The use cases were roughly...
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...
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...
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...
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...
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://www.couchbase.com/blog/couchbase-oracle-developers-part-2-architecture/. This series is written in...