1. Developers Guide
  2. Get Started
  3. Getting started with Oracle NoSQL Database

Getting started with Oracle NoSQL Database

Oracle NoSQL Database is a distributed, shared-nothing, non-relational database that provides large-scale storage and access to key/value, JSON, and tabular data. It can deliver predictable, low latencies to simple queries at any scale and is designed from the ground up for high availability.

Oracle NoSQL Database offers highly flexible deployment and various methods to access the data store from your application. For applications that require an embedded, ultra-low latency, zero administration database, it can be directly embedded into a Java application. In this deployment scenario, applications can start and stop the database using APIs. When using the Java Direct Driver , applications can read and write data to the database. In most scenarios, Oracle NoSQL is deployed on a cluster of commodity computers connected by a high-speed network. In this deployment scenario, applications must choose a programming language SDK to communicate with the Oracle NoSQL Database cluster. Oracle NoSQL Database offers two types of language SDKS:
  1. Direct driver: This type of SDK will connect directly to every Oracle NoSQL node in the cluster using TPC/IP. Hence, care must be taken to ensure a network route between the application and every Oracle NoSQL node in the database cluster. Currently, the only supported programming language for direct drivers is Java .
  2. Standard: This type of SDK will connect to the database using the HTTP protocol via the Oracle NoSQL HTTP proxy. Since standard SDKs use HTTP, you need only ensure a network route between your application code and the load balancer if using one, or between the application and the HTTP proxy if not using a load balancer.

Welcome to SQL for Oracle NoSQL Database. This language provides a SQL-like interface to Oracle NoSQL Database. The SQL for Oracle NoSQL Database data model supports flat relational data, hierarchical typed (schema-full) data, and schema-less JSON data. You have the flexibility to create tables with a well-defined schema for applications that require fixed data or a combination of fixed data and schema-less JSON. For pure document-oriented applications, you can use JSON collection tables that do not have any schema definition other than the primary key fields. The SQL for Oracle NoSQL Database is designed to handle all such data seamlessly without any impedance mismatch among the different sub-models. Impedance mismatch is a problem that occurs due to differences between the database model and the programming language model.

Oracle NoSQL Database supports many of the most popular programming languages and frameworks with idiomatic language APIs and data structures, giving your application language native access to data stored in NoSQL Database. It currently supports the following programming languages and frameworks: Javascript (Node.js), Python, Java, Golang, C#/.NET, and Spring Data. You can also navigate the database as you develop your code with plugins for one of the following supported integrated development environments: Visual Studio Code, IntelliJ , or Eclipse .

Pre-requisites: You already have an installation of the Oracle NoSQL Database. You could also use KVLite which is a simplified version of the Oracle NoSQL Database.