Create entry

IBM DB2 vs. green

IBM DB2 green + Add column
Description Rdbms Column based, distributed, scalable, high performance, ANSI-SQL analytic query engine.
Multi-user system Yes Yes
Accelerometer sensor No ?
Memory minimum 256 MB 8 GB
Extension/Plug-in Conditional Yes
Operating system
Programming language
Database ?
Website www.​ibm.​com/​software/​data/​db2 www.​vertica.​com
Database model
Query language
Transactions Conditional Yes
Unicode Yes Yes
Referential integrity Yes Yes
Price rating ★★★★☆ ?
Standard compliance Yes ?
Sharding Yes Yes
Replication Yes Yes
Map and reduce No Yes
Revision control Yes ?
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Horizontal scalable Yes Yes
Integrity model
Software distribution
Full text search Yes Yes
Preference (55% global votes) (50% global votes)
Object-Relational Mapping (ORM) Yes ?
Documentation level ★★★★☆ ★★★★☆
RESTful Yes No
Value size max. 2 EB 956 PB
Conditional entry updates Yes Yes
Composite keys Yes No
Free to use Conditional Conditional
Active Yes Yes
Database Connection Pooling Yes Yes
Compression Yes Yes
Real time analytics Yes Yes
Community Driven No ?
Shared nothing architecture Yes Yes
Web interface Yes ?
Data encryption Yes ?
API Good Good
Secondary Indexes Yes No
Graph support Yes ?
Embeddable No No
Geospatial Indexes Yes Yes
Locking model ?
Data storage
Replication mode
Native driver ?
Cloud platform support
Online backup Yes ?
Data types ?
Partial Index Yes ?
Function Based Index Yes ?
Log Yes Yes
Implementation flexibility (0% global votes) (0% global votes)
Download www-01.​ibm.​com/​software/​data/​db2/​ https:/​/​my.​vertica.​com/​community/​
Level of access authorization
Backup functionality Excellent ?
Query Cache Yes Yes
Ease of use ★★★★☆ ★★★★☆
In-Place Update Yes ?
Free for commercial use Yes Yes
Sorts Yes Yes
Read preferences Yes ?
Open Source No No
Triggers Yes ?
Perfomance ★★★★★ ★★★★★
Cloud-enabled Yes ?
Pause Test Yes ?
Materialized Views Yes ?
Predictive Analytics Yes ?
Geospatial Yes Yes
Text Analytics Yes ?
JSON Yes Yes
Flexible Table(Schema) Yes Yes
Max rows in query result 5 ?
Stored Procedure Yes No
Concurrency Yes ?
24/7 support Yes ?
Free edition Yes Yes
SQL Queries Yes Yes
Recursive queries Yes No
Online backup (no locking) Yes ?
CLI` Yes Yes
Point In Time Recovery Yes ?
Multilingual content ? Yes
Multiple projects ? Yes
Release Date ? 2007
TTL for entries ? Yes
Server Side Java Script ? Yes
Auto-Sharding ? Yes
Kafka Integration ? Yes
420 Friendly? ? Yes
Multi-statement Transactions ? Yes
memcached protocol ? No
Monitoring UI ? Yes
Columner ? Yes
Monitoring and Management ?
Hadoop Integration ? Yes
Apache Spark Integration ? Yes
+ Add row ++
IBM DB2 green
  • vsChart is like a wiki

    Just click a data cell to edit it.
    Take part and share your knowledge with the world.

  • blue
    = good
    = better
  • Embed it on your site
  • Copy & Share
  • Creative Commons License License
  • EnglishGerman (Deutsch)

Write a review or comment

Please login (with Facebook, Twitter or OpenID) to use this form.