Create entry

MariaDB vs. vertica

MariaDB vertica + Add column
Category
Preference (57% global votes) (50% global votes)
Website https:/​/​mariadb.​org/​ www.​vertica.​com
License
Design
Database model
Data storage
Embeddable Yes No
Features
Query language
Data types ?
Conditional entry updates Yes Yes
Map and reduce No Yes
Unicode Yes Yes
TTL for entries No 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
Locking model ?
Indexing
Secondary Indexes Yes No
Composite keys Yes No
Full text search Yes Yes
Geospatial Indexes Yes Yes
Graph support Yes ?
Distribution
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode
Sharding No Yes
Shared nothing architecture No Yes
Restrictions
Value size max. ? 956 PB
System requirements
Operating system
Native driver ?
Memory minimum 11 MB 8 GB
Architecture
Programming language
More
Description Relational Database System Column based, distributed, scalable, high performance, ANSI-SQL analytic query engine.
Brand
Multi-user system Yes Yes
Extension/Plug-in Yes Yes
Database ?
Multilingual content Yes Yes
Price rating ★★★★★ ?
Multiple projects Yes Yes
Standard compliance Yes ?
Software distribution
Object-Relational Mapping (ORM) Yes ?
Release Date 2009 2007
Documentation level ★★★★☆ ★★★★☆
RESTful No No
Free to use Yes Conditional
Active Yes Yes
Database Connection Pooling Yes Yes
Real time analytics No Yes
Creation Date 2009 ?
Community Driven Good ?
Web interface Yes ?
Data encryption Yes ?
Cloud platform support
Online backup Yes ?
Partial Index No ?
Function Based Index Yes ?
Key length max 255 ?
Log Yes Yes
Implementation flexibility (50% global votes) (0% global votes)
Download https:/​/​downloads.​mariadb.​org/​ https:/​/​my.​vertica.​com/​community/​
Backup functionality Good ?
Query Cache Yes Yes
Ease of use ★★★★★ ★★★★☆
In-Place Update No ?
Free for commercial use Yes Yes
Sorts Yes Yes
Tuneable write concerns Yes ?
Easy of Use Yes ?
Open Source Yes No
Triggers Yes ?
Perfomance ★★★★☆ ★★★★★
Geospatial Yes Yes
JSON Yes Yes
Flexible Table(Schema) No Yes
Stored Procedure Yes No
24/7 support Yes ?
Free edition Yes Yes
SQL Queries Yes Yes
Does your mom understand it No ?
Monitoring UI Yes Yes
CLI` Yes Yes
API ? Good
Level of access authorization ?
Server Side Java Script ? Yes
Auto-Sharding ? Yes
Kafka Integration ? Yes
420 Friendly? ? Yes
Multi-statement Transactions ? Yes
memcached protocol ? No
Recursive queries ? No
Columner ? Yes
Monitoring and Management ?
Hadoop Integration ? Yes
Apache Spark Integration ? Yes
+ Add row ++
MariaDB vertica
  • 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