Create entry

vertica vs. oracle

vertica oracle + Add column
Category
Preference (50% global votes) (100% global votes)
Website www.​vertica.​com https:/​/​www.​oracle.​com/​kr…s/​index.​html
License
Design
Database model
Data storage
Embeddable No Yes
Features
Query language
Conditional entry updates Yes Yes
Map and reduce Yes No
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 ?
Transactions Yes Yes
Referential integrity Yes Yes
Indexing
Secondary Indexes No Yes
Composite keys No ?
Full text search Yes Yes
Geospatial Indexes Yes Yes
Distribution
Horizontal scalable Yes ?
Replication Yes Yes
Replication mode ?
Sharding Yes ?
Shared nothing architecture Yes No
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. ?
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 ?
Database Connection Pooling Yes ?
Real time analytics Yes ?
API Good ?
Cloud platform support ?
Log Yes ?
Download https:/​/​my.​vertica.​com/​community/​ https:/​/​www.​oracle.​com/​kr…s/​index.​html
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 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 ?
Function Based Index ? Yes
Backup functionality ? Good
Triggers ? Yes
Cloud-enabled ? Yes
Materialized Views ? Yes
Text Analytics ? Yes
Batch Loading ? Yes
Clustering over WAN ? Yes
Fully Distributed ? Yes
24/7 support ? Yes
User and Group role based security model ? Yes
+ Add row ++
vertica oracle
  • 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