Job Search

Sunday, April 24, 2016

Comparison Oracle RDBMS vs. Oracle NoSQL


Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system produced and marketed by Oracle Corporation.

Oracle NoSQL Database is a NoSQL-type distributed key-value database by Oracle Corporation. It provides transactional semantics for data manipulation, horizontal scalability, and simple administration and monitoring.
Oracle NoSQL Database provides a very simple data model to the application developer. Each row is identified by a unique key, and also has a value, of arbitrary length, which is interpreted by the application. The application can manipulate (insert, delete, update, read) a single row in a transaction. The application can also perform an iterative, non-transactional scan of all the rows in the database. 

NoSQL (originally referring to "non SQL" or "non relational") database provides a mechanism for storage and retrieval of data which is modeled in means other than the tabular relations used in relational databases. Such databases have existed since the late 1960s, but did not obtain the "NoSQL" moniker until a surge of popularity in the early twenty-first century, triggered by the needs of Web 2.0 companies such as FaceBook, Google and Amazon.com. NoSQL databases are increasingly used in big data and real-time web applications. NoSQL systems are also sometimes called "Not only SQL" to emphasize that they may support SQL-like query languages.

Comparison Oracle RDBMS vs. Oracle NoSQL
Name
Oracle
Oracle NoSQL
Description
Widely used RDBMS
Key-value store based on Berkeley DB Java Edition
Database model
Relational DBMS
Key-value store
Website
Technical documentation
Developer
Oracle
Oracle
Initial release
1980
2011
Current release
12 Release 1 (12.1.0.2), July 2014
License
commercial 
Open Source 
Database as a Service (DBaaS) 
no
no
Implementation language
C and C++
Java
Server operating systems
AIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
Linux
OS X
Windows
Data scheme
yes
schema-free
Typing 
yes
no
XML support 
yes
Secondary indexes
yes
no
SQL
yes
no
APIs and other access methods
ODP.NET
Oracle Call Interface (OCI)
JDBC
ODBC
Java API
Supported programming languages
C
C#
C++
Clojure
Cobol
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual Basic
Java
Server-side scripts 
PL/SQL 
Triggers
yes
Partitioning methods 
horizontal partitioning 
Sharding 
Replication methods 
Master-master replication
Master-slave replication
Master-slave replication
MapReduce
no 
no
Consistency concepts 
Immediate Consistency
Eventual Consistency
Immediate Consistency 
Foreign keys 
yes
no
Transaction concepts 
ACID 
configurable 
Concurrency 
yes
yes
Durability 
yes
yes
In-memory capabilities 
yes
User concepts 
fine grained access rights according to SQL-standard
no

I hope you all have enjoyed reading this article. Comments are welcome....

No comments:

Post a Comment