Planet NoSQL

"There are three things important in the database world: Performance, Performance, and Performance." Bruce Lindsay   Let me start with a real world effect of right modeling on the application performance. Here's the except from a talk by Amadeus engineers on their customer experience management application (traveler loyalty app) which they migrated from an enterprise RDBMS to Couchbase.   Performance comparison between the enterprise RDBMS and Couchbase: "In terms of stability and performance, it was quite amazing as well. It has 100% availability for over one year and counting. In terms of performance, it was night and day compared to what we had before, basically these graphs give you response time percentile. First graph is our previous implementation using standard RDBMS. With RDBMS, in 99 percentile of the cases, we were responding in less than 4 seconds from the database. Now in Couchbase, for 99.9 percentile of the cases, we're responding in less than ...

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 of each column explicitly before you load the data or write queries. In Couchbase, you simply conform to JSON syntax and the data type interpretation is automatic and implicit. Here’s the overview of mappings, conversion, and arithmetic on these data types. [ Here’s the home page for the series:  http://blog.planetnosql.com/2022/01/introduction-to- couchbase-for-oracle.html ] ReModeling: From relational to Document model   Oracle Couchbase Model Relational, Object-relational JSON  model with N1QL (SQL for JSON) Data Types Long list of data types https://docs.couchbase.com/server/current/n1ql/n1ql-language-reference/datatypes.html String Data types CHAR, VARCHAR, VARCHAR2, NCHAR, NVARCHAR, LOONGVARCHAR String, up to 20MB in length. All of the string data in JSON is Unicode. Date and Time ...

Oracle DBAs work with physical clusters, machines, instances, storage systems, disks, etc. All of Oracles users, developers and their applications work with logical entities: databases, tables, rows, columns, partitions, users, data types.  There are a lot of similarities and some differences.  Let’s compare and contrast how this is done on Couchbase. Here’s the home page for the series:  http://blog.planetnosql.com/2022/01/introduction-to-couchbase-for-oracle.html ORACLE Organization Full list of Oracle schema objects are listed here . A database instance can have many databases; A databases many schema; A schema many tables, indexes, functions, etc. COUCHBASE Organization A Couchbase instance can have many buckets; A bucket can have many scopes; A Scope can have many collections, indexes, functions, search indexes, analytic collections, eventing functions. Each bucket comes with a _default scope and _default collection mainly for backward compatibility. You can create n...