Open In App

Difference between Vertica and YugabyteDB

Last Updated : 27 Jul, 2020
Improve
Improve
Like Article
Like
Save
Share
Report

1. YugabyteDB :
YugabyteDB is the open source, cloud native and high-performance distributed SQL database globally-distributed document store. YugabyteDB aims to make applications agile. Yugabyte is headquartered in Sunnyvale, CA. YugabyteDB is distributed and developed as an Apache 2.0 open source project .

2. 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.



Difference between Vertica and YugabyteDB :

S.No. Vertica YugabyteDB
1 Developed by Vertica / Micro Focus and initially released on 2005. Developed by Yugabyte Inc. and initially released on 2017 and current release on March 2020.
2 Current release date- Vertica 10.0 Software, May 2020 and Vertica for SQL on Hadoop 10.0 Software, May 2020. Current release date- March 2020.
3 Server operating systems of Vertica is Linux. Server operating systems of YugabyteDB is Linux, OS X.
4 Its primary database model is Relational DBMS. Its primary database model is Relational DBMS.
5 Secondary database models of Vertica is Document store. Secondary database models of YugabyteDB is Document store and Wide column store.
6 Vertica supports C++, Java, Perl, Python, R, programming languages. YugabyteDB supports C, C#, C++, Go, Java, JavaScript (Node.js), Python, Ruby programming languages.
7 APIs and other access methods of Vertica is ADO.NET, JDBC, Kafka, ODBC, Proprietary protocol, RESTful HTTP, API. YugabyteDB supports YCQL, an SQL-based flexible-schema API with its roots in Cassandra Query Language.
8 It has Data Schema. Data scheme of YugabyteDB is depending on used data model.
9 It does not has any Implementation language. Implementation language of YugabyteDB is C and C++.
10 Transaction concepts is ACID (Atomicity, Consistency, Isolation, and Durability). Its Transaction concepts is Distributed ACID with Serializable & Snapshot Isolation. Inspired by Google Spanner architecture.
11 Replication methods of Vertica is Master-slave replication. Replication methods of YugabyteDB is based on Raft distributed consensus protocol, minimum 3 replicas for continuous availability.
12 It has Immediate Consistency concept. It has strong consistency on writes and tunable consistency on reads.


Like Article
Suggest improvement
Share your thoughts in the comments

Similar Reads