1. Oracle :
Oracle is a relational database management system (RDBMS). It was developed by Oracle Corporation in 1980. It is the first database designed for grid computing that provides the most flexible and cost-effective way to manage information and application. It runs on major platforms like Windows, Unix, Linux, and macOS. It is a relational database in which data is accessed by users through application or query language called SQL.
2. Oracle NoSQL :
Oracle NoSQL is a NoSQL type distributed key-value database from Oracle. It provides transactional semantics for data manipulation, horizontal scalability, and simple administration and monitoring. It was developed By Oracle in 2011.
Difference between Oracle and Oracle NoSQL :
|1.||It is developed By Oracle in 1980.||It is developed By Oracle in 2011.|
|2.||It is commercial.||It is open-source.|
|3.||Server operating systems for Oracle is AIX, HP-UX, Linux, OS X, Solaris, Windows, z/OS.||Server operating systems for Oracle NoSQL is Linux, Solaris SPARC/x86.|
|4.||Its primary database model is Relational DBMS.||Its primary database model is Key-Value Store.|
|5.||It supports XML.||It does not support XML.|
|6.||It supports SQL.||It supports SQL-like DML and DDL statements.|
|7.||APIs and other access methods for Oracle is JDBC, ODBC, ODP.NET, Oracle Call Interface (OCI).||APIs and other access methods for Oracle NoSQL is RESTful HTTP API.|
|9.||It supports server-side scripting using user PL/SQL.||It does not supports server-side scripting.||10.||It supports partitioning methods using horizontal partitioning.||It supports partitioning methods using sharding.||11.||It has foreign keys.||It does not have foreign keys.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- Difference between SQL and NoSQL
- Difference between Relational database and NoSQL
- Introduction to NoSQL
- Apache Cassandra (NOSQL database)
- NoSQL Data Architecture Patterns
- Cassandra (NoSQL) Database
- Difference between Oracle and MongoDB
- Difference between Impala and Oracle
- Difference between Hive and Oracle
- Difference between Oracle and PostgreSQL
- Difference between Oracle and Cassandra
- Difference between Oracle and Couchbase
- Difference between Oracle and CouchDB
- Difference between Oracle and MariaDB
- Difference between Oracle and MySQL
- Difference between Oracle and Firebase
- Difference between Oracle and Derby
- Difference between Oracle and dBASE
- Difference between Oracle and PouchDB
- Comparisons between Oracle vs SQL Server
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.