Getting started with NoSQL Database Service on Oracle Cloud Infrastructure

Lucas Jellema
10 min readFeb 29, 2020

This morning I discovered a new entry in the menu on my Oracle Cloud Infrastructure Tenancy (on Ashburn, USA): the NoSQL Database service had been added overnight.

The service offers a key-(schema-less) document store. It also supports ACID transactions, SQL on JSON documents, joins across tables, structured tables and if needed also relaxed (eventual) consistency. This is NoSQL in the “Not Only” SQL sense of the term, because there is quite a bit of “SQL” (ACID, structured, relational and SQL) available. If you are looking for a cheap, simple, scalable, fully managed, H/A relational database (on Oracle Cloud), you might be well served by this NoSQL Database service as alternative to the Autonomous Database which is based on the Oracle Database flagship product.

I had been waiting for this service for some time — as it is crucial element of a cloud native application solution. The service was previously available on Oracle Cloud Classic — for a while as the Oracle Data Hub Cloud Service. Now it has been fully integrated with Oracle Cloud Infrastructure (Gen 2 Cloud). This makes it ready to be used for real.

Data in the NoSQL Database is held in tables that can contain a mix of structured columns — in a relational style — and columns of JSON document type. Data — both…

--

--

Lucas Jellema

Lucas Jellema is CTO and IT architect at Conclusion, The Netherlands. He is Oracle ACE Director, one time JavaOne Rockstar and programmer