Concept and Review of Oracle NoSQL Database or ONDB – Part Two

In the first part of this article, the concept of Oracle NoSQL Database (or ONDB) and its architecture are explored. In this paper, the second part of this series of articles addresses some of the features of this technology, including Indexing and Table Data Model … we will pay.

Table data model in ONDB

The structure of the table data with the effect on the main concepts of the design of Schema, facilitates the process of modeling the data of the program. This model is at the forefront of the Distributed Key / Value structure, and it also has the ability to simplify the design of the program by integrating with SQL-based applications in addition to having some benefits.

Secondary Index on the ONDB

Primary Key, based on indexing, limits the number of low-latency access paths. Sometimes the program needs a few Non-Primary-Key paths to support the overall Real-Time system. Despite the ability to define the secondary index in each value field, the queries function greatly improved.


Oracle NoSQL Database (or ONDB), includes Java and C language APIs. Simple APIs allow executing CRUD operations in the Oracle NoSQL Database for application developers. Meanwhile, these libraries also include Avro support, which enables developers to periodically serialize and deserialize Key-Value records between C and Java programs.

Supports Python and NodeJS in the Oracle NoSQL Database

Given that Python and NodeJS drivers have been added to ONDB today, users can now use Python and NodeJS to search, create, update, or delete stored data in Oracle NoSQL Database.
Oracle RESTful service

Support for displaying ONDB tables as Endpoint REST APIs is provided in Oracle NoSQL Database. Using REST with JSON filters , you can create, search, update, and delete saved data in the table. Therefore, users are able to create a REST based application that has access to data in Oracle Database or Oracle NoSQL Database.

Supports large Objects

Stream based APIs are designed to read and write large Objects, or LOBs (such as audio and video files), without having to apply Value to all of them in memory; this results in Low Latency operations in Objects workloads. With different sizes.

Apache Hadoop integration

KV Avro lnput Format and KV lnput Format classes are intended to perform data read operations from Oracle NoSQL Database to Hadoop Map / Reduce. Reading the ONDB records from Oracle Loader for Hadoop is one of the uses of this class.

Oracle database integration through external tables

The ability to fetch Oracle NoSQL Database data from this database is provided by using SQL commands including (*) Select, Select Count, etc. with the support of external tables or external tables. When Oracle NoSQL Database data is provided through external tables, data access is possible through the standard JDBC driver or visualized using the Enterprise Business Intelligence tool.

Integrate with other Oracle products

Oracle Event Processing, or OEP, provides readability for ONDB through the ONDB Cartridge. If you have Cartridge setup, you can use CQL Query to search for data.

The Oracle Semantic Graph (Oracle Semantic Graph) provides the Jena Adapter for storing large volumes of RDF data (triple / quadruple) for the Oracle NoSQL Database. This adapter provides quick access to the data stored in the ONDB by the SPARQL queries.

The process of integrating this technology with the Oracle Coherence product was used for Oracle Coherence applications to use ONDB as a Cache. In addition to integrating the two above mentioned, it has made it possible to directly access the Cached Data in the Oracle NoSQL Database.

Integrate Oracle Big Data SQL and Hive

Oracle Big Data SQL is a common SQL access layer for data stored in Hadoop, HDFS, Hive, and Oracle NoSQL Database, and it is possible to run queries on the ONDB from Hive or Oracle Database. Users can also use MapReduce for data stored in ONDB, which is configured for secure access purpose. It should be noted that the latest version supports a variety of primary and complex data (Primitive and Complex).
In the next section of this article, which will be the final part, we will examine the benefits and uses of this technology.

Concept and Review of Oracle NoSQL Database Parts

Concept and Review of Oracle NoSQL Database or ONDB – Part One

Concept and Review of Oracle NoSQL Database or ONDB – Part One

Related posts