Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

Difference between Vertica and VoltDB

  • Last Updated : 26 Jun, 2020

1. Vertica :
Vertica is a Columnar relational DBMS which is designed to handle modern analytic workloads and enables fast query performance. Its headquarters is in Cambridge, MA, United States. It is an infrastructure-independent through which it supports deployments on multiple cloud platforms (AWS, Google Cloud, Azure), on-premises and natively on Hadoop nodes. Its Analytics Platform Community Edition was made available for free with certain limitations.

2. VoltDB :
VoltDB is distributed In-Memory NewSQL RDBMS and an ACID-compliant RDBMS that uses a shared nothing architecture. This database designed by Michael Stonebraker, Sam Madden, and Daniel Abadi. Initially VoltDB database includes graphs for cluster throughput and latency as well as CPU and memory usage. VoltDB is based on H-Store and scales with the increasing core-per-CPU counts on multi-core servers.

Difference Between Vertica and VoltDB :

1Developed by Vertica / Micro Focus and initially released on 2005. Current release date- Vertica 10.0 Software, May 2020 and Vertica for SQL on Hadoop 10.0 Software, May 2020.Developed by VoltDB Inc. and initially released on 2010 and current release on April 2019.
2Server operating systems of Vertica is LinuxIt has Linux, OS X server operating systems.
3Its primary database model is Relational DBMS.Its primary database model is Relational DBMS.
4Secondary database models of Vertica is Document storeAbsence of secondary database models is VoltDB.
5Vertica supports C++, Java, Perl, Python, R, programming languages.It supports C#, C++, Erlang, Go, Java, JavaScript, PHP, Python programming languages.
6APIs and other access methods of Vertica is ADO.NET, JDBC, Kafka, ODBC, Proprietary protocol, RESTful HTTP, API.VoltDB supports Java API, JDBC, RESTful HTTP/JSON API.
7Yes, It has server-side scriptsServer-side scripts of VoltDB is Java.
8It doesn’t has any Implementation language.Implementation language of VoltDB is Java, C++.
9Vertica- Transaction concepts is ACID ( Atomicity, Consistency, Isolation, and Durability).Transaction concepts of VoltDB is ACID ( Atomicity, Consistency, Isolation, and Durability).
10Replication methods of Vertica is Master-slave replicationReplication methods of VoltDB is Master-master replication and Master-slave replication.
11Vertica has Immediate Consistency concept.It doesn’t holds Consistency concept.

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!