Difference between Vertica and YugabyteDB
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. |
Last Updated :
27 Jul, 2020
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...