Create entry

vertica vs. Essbase

vertica Essbase + Add column
Category
Preference (50% global votes) (71% global votes)
Website www.​vertica.​com www.​oracle.​com/​bi
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 ?
Consistency Yes ?
Isolation Yes ?
Durability (data storage) Yes Yes
Transactions Yes ?
Referential integrity Yes ?
Locking model ?
Indexing
Secondary Indexes No ?
Composite keys No ?
Full text search Yes ?
Geospatial Indexes 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
Native driver ?
Memory minimum 8 GB 64 MB
Architecture
Programming language
More
Description Column based, distributed, scalable, high performance, ANSI-SQL analytic query engine. ?
Brand
Multi-user system Yes Yes
Extension/Plug-in Yes ?
Multilingual content Yes Yes
Multiple projects Yes Yes
Software distribution ?
Release Date 2007 ?
Documentation level ★★★★☆ ★★★★☆
RESTful No ?
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 ?
Flexible Table(Schema) Yes ?
Stored Procedure No Yes
Auto-Sharding Yes ?
Free edition Yes ?
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 ?
Database ?
Price rating ? ★★★★☆
Standard compliance ? Yes
Programming paradigm ?
Community Driven ? No
Web interface ? Yes
Online backup ? Yes
Implementation flexibility (0% global votes) (100% global votes)
Backup functionality ? Good
Community feedback ? ★★★★☆
In-Place Update ? Yes
Easy of Use ? Yes
Triggers ? Yes
Revenue Tracking ? Yes
Predictive Analytics ? Yes
+ Add row ++
vertica Essbase
  • 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