Create entry

vertica vs. Netezza

vertica Netezza + Add column
Preference (50% global votes) (62% global votes)
Website www.​vertica.​com www-01.​ibm.​com/​software/​data/​netezza/​
Database model
Data storage ?
Embeddable No Yes
Query language
Data types ?
Conditional entry updates Yes Yes
Map and reduce Yes Yes
Unicode Yes Yes
TTL for entries Yes ?
Compression Yes Yes
Integrity model
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Transactions Yes Conditional
Referential integrity Yes No
Revision control ? No
Locking model ?
Secondary Indexes No No
Composite keys No Yes
Full text search Yes No
Geospatial Indexes Yes Yes
Graph support ? No
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode
Sharding Yes Yes
Shared nothing architecture Yes Yes
Value size max. 956 PB 2.5 PB
System requirements
Operating system
Native driver ?
Memory minimum 8 GB 5 TB
Programming language ?
Description Column based, distributed, scalable, high performance, ANSI-SQL analytic query engine. AMPP implementation
Multi-user system Yes Conditional
Extension/Plug-in Yes ?
Multilingual content Yes Yes
Multiple projects Yes ?
Software distribution No
Release Date 2007 January 2005
Documentation level ★★★★☆ ★★★★☆
RESTful No ?
Free to use Conditional No
Active Yes Yes
Database Connection Pooling Yes Yes
Real time analytics Yes Conditional
API Good ?
Cloud platform support ?
Log Yes Yes
Download https:/​/​my.​vertica.​com/​community/​ ?
Level of access authorization ?
Query Cache Yes No
Ease of use ★★★★☆ ★★★★☆
Free for commercial use Yes No
Sorts Yes Yes
Open Source No Yes
Perfomance ★★★★★ ★★★★☆
Geospatial Yes Yes
Server Side Java Script Yes Yes
JSON Yes Yes
Flexible Table(Schema) Yes Yes
Stored Procedure No Yes
Auto-Sharding Yes ?
Free edition Yes Yes
Kafka Integration Yes ?
SQL Queries Yes Yes
420 Friendly? Yes ?
Multi-statement Transactions Yes ?
memcached protocol No ?
Monitoring UI Yes Yes
Recursive queries No Yes
CLI` Yes Yes
Columner Yes No
Monitoring and Management ?
Hadoop Integration Yes ?
Apache Spark Integration Yes Yes
Database ?
Price rating ? ★★★★☆
Standard compliance ? Yes
Community Driven ? No
Web interface ? Yes
Versioning ? Good
Data encryption ? Yes
Online backup ? Yes
Partial Index ? No
Implementation flexibility (0% global votes) (40% global votes)
Backup functionality ? Good
In-Place Update ? Yes
XInclude Support ? Yes
Triggers ? Yes
Predictive Analytics ? Yes
Text Analytics ? Yes
OData ? Yes
HTML5 Charts ? Yes
Decision Tables ? Yes
Concurrency ? Yes
24/7 support ? Yes
Websphere Dyna Cache Integration ? Yes
Online backup (no locking) ? Yes
+ Add row ++
vertica Netezza
  • 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.