DBMS > IBM Db2 warehouse vs. Oracle vs. VoltDB
System Properties Comparison IBM Db2 warehouse vs. Oracle vs. VoltDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||IBM Db2 warehouse formerly named IBM dashDB Xexclude from comparison||Oracle Xexclude from comparison||VoltDB Xexclude from comparison|
|Description||Cloud-based data warehousing service||Widely used RDBMS||Distributed In-Memory NewSQL RDBMS Used for OLTP applications with a high frequency of relatively simple transactions, that can hold all their data in memory|
|Primary database model||Relational DBMS||Relational DBMS||Relational DBMS|
|Secondary database models||Document store|
Graph DBMS with Oracle Spatial and Graph
RDF store with Oracle Spatial and Graph
Spatial DBMS with Oracle Spatial and Graph
|Current release||21c, January 2021||11.3, April 2022|
|License Commercial or Open Source||commercial||commercial restricted free version is available||Open Source AGPL for Community Edition, commercial license for Enterprise, AWS, and Pro Editions|
|Cloud-based only Only available as a cloud service||yes||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Implementation language||C and C++||Java, C++|
|Server operating systems||hosted||AIX|
OS X for development
|Data scheme||yes||yes Schemaless in JSON and XML columns||yes|
|Typing predefined data types such as float or date||yes||yes||yes|
|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.||no Import/export of XML data possible||yes|
|SQL Support of SQL||yes||yes with proprietary extensions||yes only a subset of SQL 99|
|APIs and other access methods||.NET Client API|
Oracle Call Interface (OCI)
RESTful HTTP/JSON API
|Supported programming languages||Java|
Erlang not officially supported
|Server-side scripts Stored procedures||PL/SQL, SQL PL||PL/SQL also stored procedures in Java possible||Java|
|Partitioning methods Methods for storing different data on different nodes||Sharding||Sharding, horizontal partitioning||Sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||yes||Multi-source replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no can be realized in PL/SQL||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||yes||yes||no FOREIGN KEY constraints are not supported|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID isolation level can be parameterized||ACID Transactions are executed single-threaded within stored procedures|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes Data access is serialized by the server|
|Durability Support for making data persistent||yes||yes||yes Snapshots and command logging|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||yes Version 12c introduced the new option 'Oracle Database In-Memory'|
|User concepts Access control||fine grained access rights according to SQL-standard||fine grained access rights according to SQL-standard||Users and roles with access to stored procedures|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Navicat for Oracle improves the efficiency and productivity of Oracle developers and administrators with a streamlined working environment.|
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|IBM Db2 warehouse formerly named IBM dashDB||Oracle||VoltDB|
|DB-Engines blog posts|
MySQL is the DBMS of the Year 2019 The struggle for the hegemony in Oracle's database empire Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
The struggle for the hegemony in Oracle's database empire Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
|Recent citations in the news|
IBM Collaborates with AWS to Launch a New Cloud Database ...
In A Parallel Universe, There Is An IBM i Data Warehouse, Too
IBM named a Leader in The Forrester Wave™: Data Management ...
IBM colabora com AWS para lançar oferta de banco de dados em ...
IBM werkt samen met Amazon Web Services om een nieuw ...
provided by Google News
Oracle Named a Leader in 2023 Gartner® Magic Quadrant™ for ...
Datometry Announces Datometry OpenDB, the Industry's First Multi ...
Oracle Cloud Infrastructure Utilized by Microsoft for Bing ...
A look at computer industry trends and the bidirectional effects of ...
Stelo Enables Mirroring and Streaming Data Replication into Google ...
provided by Google News
Rethinking How Data is Stored and Processed Brings Scale and ...
Unveiling Volt Active Data's game-changing approach to limitless ...
VoltDB Aims for Fast Big Data Development -- ADTmag
NoSQL vs. NewSQL: Comparing Database Technologies
AI Empowers Microfinance: Revolutionizing Fraud Detection
provided by Google News
Sr. Solution Architect
Sr. Network Architect
Engineer Architect, SME
Data Entry Technician - Textbooks
Oracle Database Administrator
Oracle Cloud Engineers
Oracle Database Administrator DBA
Lead Database Engineer
Share this page