Create entry

BigTable vs. Apache

BigTable Apache + Add column
BigTable Spark
Preference 75% votes 25% votes
Website en.​wikipedia.​org/​wiki/​BigTable cassandra.​apache.​org
Database model
Data storage
Embeddable ? Yes
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 ? No
Revision control Yes Yes
Locking model No
Secondary Indexes Yes Yes
Composite keys ? Yes
Full text search No No
Geospatial Indexes Yes Yes
Graph support ? Yes
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode ?
Sharding Yes Yes
Shared nothing architecture ? Yes
Value size max. ? 2 GB
System requirements
Operating system ?
Native driver ?
Memory minimum ? 512 MB
Programming language
Description Key-value Second Generation Distributed Database
Multi-user system Yes Yes
Active Yes Yes
Real time analytics Yes Yes
Cloud platform support
Query Cache Yes Yes
Ease of use ★★★★☆ ★★★☆☆
Geospatial No No
Max rows in query result 5 1 000 000
ORM Join Support No No
24/7 support Yes ?
Free edition No Yes
SQL Queries Yes Yes
memcached protocol Yes No
CLI` Yes Yes
Extension/Plug-in ? Yes
Database ?
Price rating ? ★★★★☆
Standard compliance ? No
Software distribution ?
Object-Relational Mapping (ORM) ? Yes
Release Date ? 2008
Documentation level ? ★★★★☆
RESTful ? Yes
Lines of code ? 383 k
Distributed Counter ? Yes
Free to use ? Yes
Database Connection Pooling ? Yes
Creation Date ? 2008
Community Driven ? Good
Web interface ? Yes
Color ?
Online backup ? Yes
Log ? Yes
Implementation flexibility (0% global votes) (9% global votes)
Download ? cassandra.​apache.​org/​download/​
Level of access authorization ?
Backup functionality ? Good
In-Place Update ? Yes
Free for commercial use ? Yes
Sorts ? Yes
Capped Collections ? No
Tuneable write concerns ? Yes
Read preferences ? Yes
Open Source ? Yes
XInclude Support ? No
XQuery Support ? No
Global Assembly Cache ? Yes
Triggers ? Yes
Perfomance ? ★★★★★
Cloud-enabled ? Yes
Minimal memory footprint ? 512 MB
Materialized Views ? Yes
Spring Data Support ? Yes
Server Side Java Script ? No
JSON ? Yes
Flexible Table(Schema) ? Yes
Geo-distributed ? Yes
Re-Reduce ? Yes
Clustering over WAN ? Yes
Fully Distributed ? Yes
Stored Procedure ? Yes
Concurrency ? Yes
Auto-Sharding ? Yes
Native Adsense Integration ? No
Contributors ? 185
Aggregators ? Yes
Maximum Database Size ? 1 PB
Monitoring UI ? Yes
Abstracts complexity of UI Components ? No
Apache Spark Integration ? Yes
+ Add row ++
BigTable Apache
  • 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)

Reviews & Comments

  • Review
    I believe this item سازگاری با مهدی باقری is something not related to databases.
    Google translate says: "Compatibility with Mehdi Bagheri"
    Leo Caseiro29. Jan 2016 / 00:37

Write a review or comment

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