Planet NoSQL

SQL is the only 22nd century tool available in 21st century Here are the articles comparing  architecture , database objects , data types and data modeling of Oracle with Couchbase. This will focus on SQL support.   Oracle was the first and staunch  supporter  of  SQL . Oracle's SQL implementation beat IBM to market by two years.  That changed the fortune of one or two people :-)  All of the modern relational databases implement SQL. So much so, relational databases are sometimes called SQL databases, much to the  chagrin of C. J. Date .  Nations are known by their languages... English, French, and American(!). It's not a stretch for a class of database system to be known by their languages as well.  SQL has been so effective, many big data and non-relational systems have picked up SQL as the lingua franca . SQL is here to stay, even for noSQL systems.  SQL > SQL SQL may have started as a structured english query language ...

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