Create entry

vertica vs. BigTable

vertica BigTable + Add column
Category
Preference (50% global votes) (26% global votes)
Website www.​vertica.​com en.​wikipedia.​org/​wiki/​BigTable
License
Design
Database model
Data storage
Embeddable No ?
Features
Query language
Data types ?
Conditional entry updates Yes No
Map and reduce Yes Yes
Unicode Yes Yes
TTL for entries Yes ?
Compression Yes Yes
Integrity
Integrity model
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes No
Durability (data storage) Yes Yes
Transactions Yes Yes
Referential integrity Yes ?
Revision control ? Yes
Locking model ? No
Indexing
Secondary Indexes No Yes
Composite keys No ?
Full text search Yes No
Geospatial Indexes Yes Yes
Distribution
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode ?
Sharding Yes Yes
Shared nothing architecture Yes ?
Restrictions
Value size max. 956 PB ?
System requirements
Operating system ?
Memory minimum 8 GB ?
Architecture
Programming language
More
Description Column based, distributed, scalable, high performance, ANSI-SQL analytic query engine. Key-value
Brand
Multi-user system Yes Yes
Extension/Plug-in Yes ?
Multilingual content Yes ?
Multiple projects Yes ?
Software distribution ?
Release Date 2007 ?
Documentation level ★★★★☆ ?
RESTful No ?
Free to use Conditional ?
Active Yes Yes
Database Connection Pooling Yes ?
Real time analytics Yes Yes
API Good ?
Cloud platform support
Log Yes ?
Download https:/​/​my.​vertica.​com/​community/​ ?
Level of access authorization ?
Query Cache Yes Yes
Ease of use ★★★★☆ ★★★★☆
Free for commercial use Yes ?
Sorts Yes ?
Open Source No ?
Perfomance ★★★★★ ?
Geospatial Yes No
Server Side Java Script Yes ?
JSON Yes ?
Flexible Table(Schema) Yes ?
Stored Procedure No ?
Auto-Sharding Yes ?
Free edition Yes No
Kafka Integration Yes ?
SQL Queries Yes Yes
420 Friendly? Yes ?
Multi-statement Transactions Yes ?
memcached protocol No Yes
Monitoring UI Yes ?
Recursive queries No ?
CLI` Yes Yes
Columner Yes ?
Monitoring and Management ?
Hadoop Integration Yes ?
Apache Spark Integration Yes ?
Max rows in query result ? 5
ORM Join Support ? No
24/7 support ? Yes
+ Add row ++
vertica BigTable
  • vsChart is like a wiki

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

  • blue
    = good
    darker
    = better
    Legend
  • 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.

Type
Review
Comment