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