Application development with Oracle NoSQL Database is straightforward. APIs for basic Create, Read, Update, Delete (CRUD) operations, for iterating through the data set, and also to set the consistency and durability polices are all packaged in a single jar file. Applications can add this jar file in the classpath and can access the database remotely.


CRUD  Operations

Data create and update operations are provided by several put methods:  

  • putIfAbsent method implements creation.
  • putIfPresent method implements update.
  • putIfVersion method that allows applications to implement consistent readmodify-write semantics.
  • put method does both: adding the new key/value pair if the key is not currently present in the database or updating the value if the key does exist. 

The delete and deleteIfVersion methods unconditionally and conditionally remove key/value pairs from the database, respectively. Just as putIfVersion ensures read-modify-write semantics, deleteIfVersion provides deletion of a specific version. 

Data fetch operations are provided by several get methods: 

  • get method implements retrieval of a single record at a time.
  • multiGet method implements retrieval of multiple records at once, so long as they all share the same major path components.




In addition to basic CRUD operations, Oracle NoSQL Database supports two types of iteration: unordered iteration over records and ordered iteration within a Major Key set. The API supports both individual key/value returns using several storeIterator methods and bulk key/value returns within a Major Key Path via the various multiGetIterator methods.


Bulk Operations


In addition to providing single-record operations, Oracle NoSQL Database supports the ability to bundle a collection of operations together using the execute method, providing transactional semantics across multiple updates on records with the same Major Key Path