Friday Jun 24, 2016

Learn about NoSQL Failover

View this video to see how failover works in Oracle NoSQL Database.  This is fairly short and explains what to do if some of your servers go down.  An excellent video.

Take a look at:

Dont forget to frequently our main Oracle NoSQL Database page -

Join our LinkedIn Group at:

Wednesday Jun 15, 2016

4.0 Features Described

To understand more about the new features in our recent release of Oracle NoSQL Database 4.0 , take a look at a short pdf that describes the features.  We have also thrown in some of the 3.5 features from a few months ago.The pdf is HERE

Thursday May 26, 2016

Oracle NoSQL Database Licensing

We have received a number of questions about the Oracle NoSQL Database licensing  policy, so we wanted to clear things up.

Oracle NoSQL Database consists of two versions, each with a client and server license. The two versions of the distribution are commonly referred to as the Community Edition (CE) and the Enterprise Edition (EE). Each version contains a client license (where the application runs) and the server license (where the application data is stored).

Enterprise Edition (EE):


  • Client License:  Apache License, Version 2
  • Server License: Oracle commercial license 


Community Edition (CE):


  • Client License: Apache License, Version 2
  • Server License: GNU Affero General Public License, Version 3 


Apache License – The details can be found at:

GNU Affero General Public License (AGPL) Version 3 – Details on this license can be found at:

Thursday May 19, 2016

Techtarget writes about Oracle NoSQL

Jack Vaughn of TechTarget has written about Oracle NoSQL Database.  In it, Jack describes the history of Oracle NoSQL Database and how this new type of technology will be needed for new types of cloud applications. In addition, the article contains some comments from industry analysts.  Take a read at:

Thursday May 12, 2016

Charles Pack Examines the Benefits of Oracle NoSQL for the Oracle RDBMS DBA

Take a look at this article, where Charles Pack of CSX Technologies talks about the benefits of using Oracle NoSQL Database for Oracle RDBMS DBA's. Read the story HERE.

Thursday May 05, 2016

Oracle NoSQL Database on display

Come see and learn about Database at the Big Data Summit in NYC on May 10 and 11. Info at:

Learn about the new features of Oracle NoSQL Database at the event. Bring your toughest questions.

Thursday Apr 28, 2016

Submit your OOW 2016 Proposals

If you have a great story or solution that includes Oracle NoSQL Database and want to talk about it, please submit at:

Closes on May 9, 2016

  • Conference location: San Francisco, California, USA
  • Date: Sunday, September 18 to Thursday, September 22, 2016

Friday Apr 22, 2016

Oracle Open World 2016 - Call for Proposals

The call for proposals for Oracle Open World 2016 is open.  Please submit your proposals by May 9, 2016.  The proposal web site is:

 Submit if you have an interesting use of Oracle NoSQL Database to talk about. 

Wednesday Mar 16, 2016

Oracle NoSQL Database Cluster YCSB Testing with Fusion ioMemory™ Storage

Highly distributed systems with large data stores in the form of NoSQL databases are becoming increasingly important to enterprises, not just to hyperscale organizations. NoSQL databases are being deployed for capturing patient sensors data in health care, smart meter analysis in utilities, customer sentiment analysis in retail, and various other use cases in different industries. NoSQL database systems help organizations store, manage, and analyze huge amounts of data on distributed system architecture. The sheer volume of data and the distributed system design needed to manage this large data at a reasonable cost necessitated a different category of database systems, leading to NoSQL databases. Oracle NoSQL Database is part of the NoSQL database family and is based on a distributed, key-value architecture.

This technical white paper describes a three-node Oracle NoSQL Database Cluster deployment procedure on Fusion ioMemory™ storage. The following points are emphasized:

  • Highlights performance and scalability advantages compared to traditional spinning disks.
  • Because enterprises evaluate and assess new technologies for enterprise-wide adaptability, Yahoo Cloud Serving Benchmark (YCSB) is the standard benchmark tool employed for testing and is the same tool used in this paper to evaluate Oracle NoSQL Database for YCSB Benchmark Testing.
  • Analysis and discussion are provided for throughput and latency testing results with YCSB.


Download now at:

Tuesday Mar 01, 2016

Support for Oracle NoSQL Database CE available

For those of you who have downloaded  Oracle NoSQL Database Community Edition  (CE) , did you know that support in two forms is available for this ?  Some customers may think that by downloading the CE Version that they are left on their own.  This is not true.  Questions and answers can be posted to:   where lots of users monitor the questions and respond to these inquiries. 

In addition, support from Oracle is available to anyone.  Go to:,6:P6_LPI:124789930244771286351865     where details are available.

Thanks to all who use Oracle NoSQL Database and continue to create innovative applications and use the family of Oracle products. 

Tuesday Feb 23, 2016

Oracle NoSQL Database Sessions at All India Oracle Users Group (AIOUG)

Come listen to two talks by members of the Oracle NoSQL team at the AIOUG event in Hyderabad, India on February 27, 2016. Ashutosh Naik and Anand Chandak will be presenting on how to set up an Oracle NoSQL Database environment and will discuss innovative customers and how they are taking advantage of the Oracle NoSQL Database. Details can be found below.  The full announcement is at:

Ganga Conference Hall

Tech Mahindra Learning world (Just Adjacent to Oracle India Office- Hi Tech City)

TechMahindra Infocity Campus
Hi-Tech City


Monday Feb 15, 2016

New Oracle NoSQL Database Whitepaper on Bulk Put and Bulk Get

A new whitepaper is available, describing the new Bulk Get and Bulk Put API's in the Oracle NoSQL Database product.  Download from our Oracle NoSQL Database page, under Whitepapers.

Monday Feb 08, 2016

SQL Developer 4.1 now supports Oracle NoSQL

SQL Developer now supports Oracle NoSQL database. Support includes Developer and DBA roles, KVLite Store deployment and seeding, Store Reporting, Store Statistics and Administration.  Learn more at the Oracle NoSQL main page. Click Here.  (Additional Resources)

Monday Feb 01, 2016

Oracle NoSQL BulkPut


Our customers have often asked us “what’s the fastest and most efficient way to insert large number of records in Oracle NoSQL database? “ Very recently, a shipping company reached out to us with specific requirement of using Oracle NoSQL database for their ship management application,which is used to track the movements of their container ships that moves the cargo from port to port. The cargo ships are all fitted with GPS and other tracking devices, which relays ship's location after few seconds into the application . The application is then queried for  1) The location of all the ships displayed on the map 2) A specific ship's trajectory over a given period of time displayed on the map too.As the volume of the location data started growing, company is finding hard to scale the application and is now looking at a back-end system that can ingest this large data-set very efficiently.

Historically, we have supported the option to execute a batch of operations for records that share the same shard key, which is what our large airline customer (Airbus) has done. They pre-sort the data by the shard key and then perform a multi-record insert when the shard key changes. Basically, rather than sending and storing a record at a time they can send a large number of records in a single operation. This certainly saved network trips, but they could only batch insert records that shared same shard key. With Oracle NoSQL Database release 3.5.2, we have added the ability to do a bulk insert or a bulk put records across different shards,allowing application developers to work more effectively with very large data-sets.

The BulkPut API is available for table as well as the key/Value data model. The API provides significant performance gains over single row inserts by reducing the network traffic round trips as well as by doing ordered inserts in batch on internally sorted data across different shards in parallel. This feature is release in a controlled fashion, so there aren’t java docs available for this API with this release, but we encourage you to use it and give us feedback.


KV interface: loads Key/Value pairs supplied by special purpose streams into the store.

public void put(List<EntryStream<KeyValue>> streams, BulkWriteOptions bulkWriteOptions)

Table interface: loads rows supplied by special purpose streams into the store.

public void put(List<EntryStream<Row>> streams, BulkWriteOptions bulkWriteOptions)
streams the streams that supply the rows to be inserted.
bulkWriteOptions non-default arguments controlling the behavior the bulk write operations

Stream Interface :

public interface EntryStream<E> {
String name();
E getNext();
void completed();
void keyExists(E entry);
void catchException(RuntimeException exception, E entry);


We ran the YCSB benchmark with the new Bulk-Put API on 3x3 (3 shards each with 3 copies of data) NoSQL Cluster running on bare metal servers, ingesting 50M records per shard or 150M records across the datastore, using 3 parallel thread per shard or total 9 ( 3x3) for the store and 6 parallel input streams per SN or total 54 ( 6 *9) across the store. The results for the benchmark run are shown in the graph below

The above graph compares the throughput (ops/sec) of Bulk vs Simple Put API with NoSQL store having 1000 partitions with durability settings of None and Simple Majority. As seen from the above charts there is over a 100% increase in throughput with either durability settings.

Sample Example

Here's link program uploaded to the github repository, the sample demonstrate how to use the BulkPut API in your application code. refer to the readme file for details related to the program execution.


If you are looking at bulk loading data into Oracle NoSQL Database the latest Bulk Put API provides the most efficient and fastest (as demonstrated by the YCSB) way to ingest large amount of data. Check it out now and download the latest version of the Oracle NoSQL Database at:

I'd like to thanks my colleague Jin Zhao for inputs on the performance numbers.

Monday Jan 04, 2016

Oracle NoSQL BulkGet API

Recently, we have been getting queries from our developer community and customers who wanted to know what is the most efficient way to retrieve large amounts of data in a single operation using Oracle NoSQL Database. An example of such a request would be on an eCommerce website, where potential customers want to retrieve all the phones in the price range $ 200 to $ 500 from Apple, Samsung, Nokia, Motorola (for example) and a host of other manufacturers to return all the details including the images of the product.

[Read More]

This blog is about everything NoSQL. An open place to express thoughts on this exciting topic and exchange ideas with other enthusiasts learning and exploring about what the coming generation of data management will look like in the face of social digital modernization. A collective dialog to invigorate the imagination and drive innovation straight into the heart of our efforts to better our existence thru technological excellence.


« June 2016