Create entry

LMDB vs. Netezza

LMDB Netezza + Add column
Preference (57% global votes) (62% global votes)
Website symas.​com/​mdb www-01.​ibm.​com/​software/​data/​netezza/​
Database model
Data storage ?
Embeddable Yes Yes
Query language
Data types
Conditional entry updates No Yes
Map and reduce No Yes
Unicode No Yes
TTL for entries No ?
Compression No Yes
Integrity model
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Transactions Yes Conditional
Referential integrity No No
Revision control No No
Locking model
Secondary Indexes No No
Composite keys No Yes
Full text search No No
Geospatial Indexes No Yes
Graph support No No
Horizontal scalable No Yes
Replication No Yes
Replication mode
Sharding No Yes
Shared nothing architecture ? Yes
Value size max. 4 GB 2.5 PB
System requirements
Operating system
Native driver
Memory minimum 64 kB 5 TB
Programming language ?
Description Memory-Mapped, Copy-on-Write AMPP implementation
Multi-user system Yes Conditional
Price rating ★★★★★ ★★★★☆
Software distribution No
Release Date September 2011 January 2005
Documentation level ★★★★★ ★★★★☆
Lines of code 7 k ?
Free to use Yes No
Active Yes Yes
Real time analytics Yes Conditional
Creation Date 2009 ?
Community Driven Good No
API Basic ?
Online backup Yes Yes
Function Based Index No ?
Implementation flexibility (50% global votes) (40% global votes)
Download gitorious.​org/​mdb ?
Backup functionality Good Good
Query Cache No No
Ease of use ★★★★☆ ★★★★☆
In-Place Update Yes Yes
Free for commercial use Yes No
Sorts Yes Yes
Read preferences No ?
Open Source Yes Yes
Maximum size 9.2 EB ?
Perfomance ★★★★★ ★★★★☆
JSON Yes Yes
Batch Loading Yes ?
Corruption Resistant Yes ?
Multilingual content ? Yes
Standard compliance ? Yes
Database Connection Pooling ? Yes
Web interface ? Yes
Versioning ? Good
Data encryption ? Yes
Partial Index ? No
Log ? Yes
XInclude Support ? Yes
Triggers ? Yes
Predictive Analytics ? Yes
Geospatial ? Yes
Text Analytics ? Yes
Server Side Java Script ? Yes
OData ? Yes
HTML5 Charts ? Yes
Decision Tables ? Yes
Flexible Table(Schema) ? Yes
Stored Procedure ? Yes
Concurrency ? Yes
24/7 support ? Yes
Free edition ? Yes
Websphere Dyna Cache Integration ? Yes
SQL Queries ? Yes
Monitoring UI ? Yes
Recursive queries ? Yes
Online backup (no locking) ? Yes
CLI` ? Yes
Columner ? No
Apache Spark Integration ? Yes
+ Add row ++
LMDB 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.