Create entry

vertica vs. ActivePivot

vertica ActivePivot + Add column
Category
Preference (50% global votes) (100% global votes)
Website www.​vertica.​com activeviam.​com
License
Design
Database model
Data storage
Embeddable No No
Features
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
Integrity model
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Transactions Yes Yes
Referential integrity Yes Yes
Revision control ? Yes
Locking model ?
Indexing
Secondary Indexes No Yes
Composite keys No Yes
Full text search Yes ?
Geospatial Indexes Yes ?
Graph support ? Yes
Distribution
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode ?
Sharding Yes Yes
Shared nothing architecture Yes Yes
Restrictions
Value size max. 956 PB 10 TB
System requirements
Operating system
Native driver ?
Memory minimum 8 GB 4 GB
Architecture
Programming language
More
Description Column based, distributed, scalable, high performance, ANSI-SQL analytic query engine. Memory based database
Brand
Multi-user system Yes Yes
Extension/Plug-in Yes Yes
Multilingual content Yes ?
Multiple projects Yes ?
Software distribution ?
Release Date 2007 ?
Documentation level ★★★★☆ ★★★☆☆
RESTful No Yes
Free to use Conditional No
Active Yes Yes
Database Connection Pooling Yes ?
Real time analytics Yes Yes
API Good Good
Cloud platform support ?
Log Yes Yes
Download https:/​/​my.​vertica.​com/​community/​ ?
Level of access authorization ?
Query Cache Yes Yes
Ease of use ★★★★☆ ★★★☆☆
Free for commercial use Yes No
Sorts Yes Yes
Open Source No No
Perfomance ★★★★★ ★★★★★
Geospatial Yes ?
Server Side Java Script Yes ?
JSON Yes Yes
Flexible Table(Schema) Yes Yes
Stored Procedure No Yes
Auto-Sharding Yes ?
Free edition Yes No
Kafka Integration Yes ?
SQL Queries Yes ?
420 Friendly? Yes ?
Multi-statement Transactions Yes ?
memcached protocol No ?
Monitoring UI Yes ?
Recursive queries No ?
CLI` Yes ?
Columner Yes ?
Monitoring and Management ?
Hadoop Integration Yes ?
Apache Spark Integration Yes ?
Price rating ? ★★★★☆
WSDL ? Yes
Web interface ? Yes
Implementation flexibility (0% global votes) (75% global votes)
Backup functionality ? Good
Event Driven Architecture ? Yes
Maven support ? Yes
Cloud-enabled ? Yes
Spring Data Support ? Yes
Predictive Analytics ? Yes
Concurrency ? Yes
Delta read ? Yes
Delta Update ? Yes
Aggregators ? Yes
Continuous query ? Yes
LDAP Integration ? Yes
In business since ? 2004
24/7 support ? Yes
Distributed code Deployment ? Yes
Offheap Memory ? Yes
+ Add row ++
vertica ActivePivot
  • 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