NO SQL

Explain Oracle NoSQL database?

Explain Oracle NoSQL database?

The Oracle NoSQL Database is a key-value database that is distributed. It's made to store data in a highly reliable, scalable, and available manner over a configurable collection of storage nodes. Data is saved as key-value pairs that are written to certain storage node(s) based on the primary key's hashed value. To provide high availability, rapid failover in the event of a node loss, and effective load balancing of queries, storage nodes are replicated. To read and write data, customer apps employ an easy-to-use Java/C API.

When should I use a NoSQL database instead of a relational database?

ACID is enforced by a relational database. As a result, you'll have transaction-oriented data stores that are schema-based. It's been tested and proved to work in 99 percent of real-world scenarios. Relational databases allow you to perform almost anything. When it comes to enormous high-availability data warehouses, however, there are speed and scaling restrictions.

Google and Amazon, for example, have terabytes of data in their enormous data centres. Because of the blocking/schema/transaction characteristics of the RDBMs, querying and inserting are not per formant in these cases. That is why, for tremendous performance and scalability, they have created their own databases (really, key-value stores). NoSQL databases have been existing for a long time; the phrase is only recently coined. Graph, object, column, XML, and document databases are some examples.

Compare NoSQL & RDBMS

Summary:

  • NoSQL is a non-relational database management system (DBMS) that does not require a set schema, avoids joins, and is scalable.
  • The concept of NoSQL databases has gained traction among Internet behemoths such as Google, Facebook, Amazon, and others who deal with massive amounts of data.
  • Carlo Strozzi used the term NoSQL to describe his open-source, lightweight relational database in 1998.
  • NoSQL databases are either schema-free or have loose schemas, and they never follow the relational model.
  • There are four types of NoSQL databases: 1)
  • Key-value Piar Based 2) Column-oriented Graph 3). Graph –Based 4).Document-oriented.
  • Structured, semi-structured, and unstructured data are all handled equally well by NOSQL.
  • Consistency, Availability, and Partition Tolerance are the three words that make up the CAP theorem.
  • BASE stands for Basic Access, Soft State, and Eventual Consistency.
  • To achieve high availability and scalability, the term "eventual consistency" refers to having copies of data on several machines.
  • The query capabilities of NOSQL are limited.