Oracle NoSQL is, what bets can be described, as a middle of the road option, based on client server technology that Oracle does so well. It is based on the Berkeley DB edition, with Java. this means it is not able to run Scala and other newer technologies, natively.
The server is based on a number of nodes, the main key of which is incorporated to the server that a record belongs to, by way of a simple hash key. there is only a single master, but multiple replica DB system. one of the problems is that it can take a long time to update the shards- by updating the key-value pairs - though it does not need the shutdown as many other systems are.
One of the better benefits is the way noSQL updates the nodes if the master shard feels - the database if it cannot repair based on a database transaction it will attempt a PAXOS transaction. this means that the database will stay up longer than those which basically fail if the main goes down.
it also makes the normal Oracle mechanisms to provide ACID transactions in cases where noSQL does not. Review collected by and hosted on G2.com.
Many of the most desired features - including external tables - are currently only available on the EE edition. this means checking carefully whether you need a feature which only comes with the premium model. Review collected by and hosted on G2.com.
NoSQL was named due to the fact that it is no longer using the traditional relational database technology. You would want to pick this if your environment was posed for utilizing big data. Otherwise, you would want to continue using a traditional SQL implementation. Review collected by and hosted on G2.com.
The learning curve for using a database without relations can be quite difficult. One data model uses key-value storage (which is what I've used in my experience) and it can be a very big change for developers. When using a local database deployment with prefilled data, it can be quite slow even on a new machine. Review collected by and hosted on G2.com.
High availablity and fault tolerance.acid complaint transactions as well Review collected by and hosted on G2.com.
Does not support all data formats. Need to mature. Does not provide atomicity and support for java only. Review collected by and hosted on G2.com.
High availability and fault-tolerance and ACID compliant transaction Review collected by and hosted on G2.com.
Supports only Java. No support for other programming languages. Need to mature. Review collected by and hosted on G2.com.
Seamless integration with several BI tools and the ease of building Analytics. POC cluster could hold several terabytes of data with superior performance. Ability to perform ETL into the Hadoop cluster and then into NoSQL database. Review collected by and hosted on G2.com.
Does not support all data formats. Does not provide atomicity and the ability to provide a robust transactional integrity. Business Continuity and Disaster Recovery methodologies are not fully proven. Review collected by and hosted on G2.com.
highly reliable, scalable and available
Data is stored as key-value pairs, which are written to particular storage node(s), based on the hashed value of the primary key. Review collected by and hosted on G2.com.
Manageblity
Need more GUI capability to Achieve true potential Review collected by and hosted on G2.com.