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 ...
A blog about all things data and data processing issues and interests. SQL, NoSQL, flexible schema, scale-up, scale-out, transactions, high availability.