1 Reply Latest reply: Oct 29, 2011 9:40 AM by Charles Lamb RSS

    What are the differences between Oracle and other NoSQL database

    896774
      Hi all,

      I would like to know what the differences between Oracle and other NoSQL database are.
      When and why should we use Oracle?
      Is Oracle NoSQL database link with Big Data Appliance?
      Can we use map-reduce on a single personal computer? How should we install Oracle NoSQL database to use map reduce on a single personal computer?
      Do we also have eventual consistency with Oracle NoSQL database? Can we lose data if master node fails?
      Are transactions ACID with Oracle NoSQL database? How can we prove it?

      Thanks.
        • 1. Re: What are the differences between Oracle and other NoSQL database
          Charles Lamb
          893771 wrote:
          Hi all,

          I would like to know what the differences between Oracle and other NoSQL database are.
          When and why should we use Oracle?
          I suggest that you start here:

          http://www.oracle.com/technetwork/database/nosqldb/overview/index.html
          Is Oracle NoSQL database link with Big Data Appliance?
          Yes, Oracle NoSQL Database will be a component of the Big Data Appliance.
          Can we use map-reduce on a single personal computer? How should we install Oracle NoSQL database to use map reduce on a single personal computer?
          Yes, I believe you can run M/R on a single computer. Consult the various pieces of documentation available on the web. You may run Oracle NoSQL Database on the same computer that you are running M/R on, but it is likely that they will compete for CPU and IO resources and therefore performance may suffer.
          Do we also have eventual consistency with Oracle NoSQL database?
          Yes.
          Can we lose data if master node fails?
          If you run Oracle NoSQL Database with the default (recommended) durability settings, then if the master fails, a new one will be elected and data is not lost.
          Are transactions ACID with Oracle NoSQL database? How can we prove it?
          Yes, each operation is executed in an ACID transaction. The API has the concept of "multi" operations which allow the caller to perform multiple operations on sets of records with the same major key, but different minor keys. Those operations are also performed within a transaction.

          Charles Lamb