Create entry

BigTable vs. HBase

BigTable HBase + Add column
Preference (26% global votes) (47% global votes)
Website en.​wikipedia.​org/​wiki/​BigTable hbase.​apache.​org
Database model
Data storage
Embeddable ? No
Query language
Data types
Conditional entry updates No 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 No Yes
Durability (data storage) Yes Yes
Transactions Yes No
Referential integrity ? Yes
Revision control Yes Yes
Locking model No
Secondary Indexes Yes No
Composite keys ? Yes
Full text search No No
Geospatial Indexes Yes Yes
Graph support ? No
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode ?
Sharding Yes Yes
Shared nothing architecture ? Yes
Value size max. ? 2 TB
System requirements
Operating system ?
Native driver ?
Programming language
Description Key-value A distributed database based on Hadoop
Multi-user system Yes Yes
Active Yes Yes
Real time analytics Yes Conditional
Cloud platform support ?
Query Cache Yes No
Ease of use ★★★★☆ ★★★★☆
Geospatial No ?
Max rows in query result 5 ?
ORM Join Support No ?
24/7 support Yes ?
Free edition No Yes
SQL Queries Yes ?
memcached protocol Yes ?
CLI` Yes ?
Standard compliance ? No
Software distribution ?
Release Date ? 2ⁿᵈ February 2009
Documentation level ? ★★★★☆
RESTful ? Yes
Distributed Counter ? Yes
Free to use ? Yes
Database Connection Pooling ? Yes
Web interface ? Yes
API ? Good
Online backup ? No
Partial Index ? No
Function Based Index ? No
Log ? Yes
Download ? www.​apache.​org/​dyn/​closer.​cgi/​hbase/​
Level of access authorization ?
Backup functionality ? Basic
In-Place Update ? No
Free for commercial use ? Yes
Sorts ? No
Capped Collections ? No
Tuneable write concerns ? Yes
Read preferences ? Yes
Open Source ? Yes
Triggers ? Yes
Server side custom code ? Yes
Perfomance ? ★★★★☆
Pipeline Aggregation ? Yes
Spring Data Support ? Yes
Re-Reduce ? Yes
Stored Procedure ? Yes
Auto-Sharding ? Yes
420 Friendly? ? No
+ Add row ++
BigTable HBase
  • 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.