oracle nosql与oracle,Oracle vs. Oracle NoSQL Comparison

Editorial information provided by DB-Engines

NameOracle  Xexclude from comparisonOracle NoSQL  Xexclude from comparison

DescriptionWidely used RDBMSA multi-model, scalable, distributed NoSQL database, designed to provide highly reliable, flexible, and available data management across a configurable set of storage nodes

Secondary database modelsDocument store

Graph DBMS with Oracle Spatial and Graph

RDF store with Oracle Spatial and Graph

Spatial DBMS with Oracle Spatial and Graph

DeveloperOracleOracle

Initial release19802011

Current release19c, February 201920.3, December 2020

License Commercial or Open Sourcecommercial restricted free version is availableOpen Source Proprietary for Enterprise Edition (Oracle Database EE license has Oracle NoSQL database EE covered: details)

Cloud-based only Only available as a cloud servicenono

DBaaS offerings (sponsored links) Database as a Service

Providers of DBaaS offerings, please contact us to be listed.

Implementation languageC and C++Java

Server operating systemsAIX

HP-UX

Linux

OS X

Solaris

Windows

z/OSLinux

Solaris SPARC/x86

Data schemeyes Schemaless in JSON and XML columnsSupport Fixed schema and Schema-less deployment with the ability to interoperate between them.

Typing predefined data types such as float or dateyesoptional

XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.yesno

Secondary indexesyesyes

SQL Support of SQLyes with proprietary extensionsSQL-like DML and DDL statements

APIs and other access methodsJDBC

ODBC

ODP.NET

Oracle Call Interface (OCI)RESTful HTTP API

Supported programming languagesC

C#

C++

Clojure

Cobol

Delphi

Eiffel

Erlang

Fortran

Groovy

Haskell

Java

JavaScript

Lisp

Objective C

OCaml

Perl

PHP

Python

R

Ruby

Scala

Tcl

Visual BasicC

C#

Go

Java

JavaScript (Node.js)

Python

Server-side scripts Stored proceduresPL/SQL also stored procedures in Java possibleno

Triggersyesno

Partitioning methods Methods for storing different data on different nodesSharding, horizontal partitioningSharding

Replication methods Methods for redundantly storing data on multiple nodesMulti-source replication

Source-replica replicationElectable source-replica replication per shard. Support distributed global deployment with Multi-region table feature

MapReduce Offers an API for user-defined Map/Reduce methodsno can be realized in PL/SQLwith Hadoop integration

Consistency concepts Methods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency

Immediate Consistency depending on configuration

Foreign keys Referential integrityyesno

Transaction concepts Support to ensure data integrity after non-atomic manipulations of dataACID isolation level can be parameterizedconfigurable ACID within a storage node (=shard)

Concurrency Support for concurrent manipulation of datayesyes

Durability Support for making data persistentyesyes

In-memory capabilities Is there an option to define some or all structures to be held in-memory only.yes Version 12c introduced the new option 'Oracle Database In-Memory'yes off heap cache

User concepts Access controlfine grained access rights according to SQL-standardAccess rights for users and roles

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,

and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

3rd partiesGeneral SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.

» more

Navicat for Oracle improves the efficiency and productivity of Oracle developers and administrators with a streamlined working environment.

» more

Fivetran: Quickly and easily centralize your on-premise and cloud databases.

» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources

OracleOracle NoSQL