Difference between Vertica and Yaacomo

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. Yaacomo :
Yaacomo is a Relational, OpenCL based in-memory database management system for real-time analytics and big data solutions was developed as a plug-and-play solution. Yaacomo is designed for efficiently utilizing the hardware via parallel computing.

Difference between Vertica and Yaacomo :

S.NO.	Vertica	Yaacomo
1	Developed 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 Q2WEB GmbH and initially released on 2009.
2	Server operating systems of Vertica is Linux	Server operating systems of Yaacomo is Android, Linux, Windows.
3	Its primary database model is Relational DBMS.	Its primary database model is Relational DBMS.
4	Secondary database models of Vertica is Document store	Absence of secondary database models in Yaacomo.
5	Vertica supports C++, Java, Perl, Python, R, programming languages.	It does not support any programming languages
6	APIs and other access methods of Vertica is ADO.NET, JDBC, Kafka, ODBC, Proprietary protocol, RESTful HTTP, API.	APIs and other access methods of Yaacomo is JDBC, ODBC.
7	Yes, Vertica has a Data Schema.	Yaacomo has a Data Schema.
8	It doesn’t has any Implementation language.	It doesn’t has any Implementation language.
9	Vertica- Transaction concepts is ACID ( Atomicity, Consistency, Isolation, and Durability).	It has Transaction concepts- is ACID ( Atomicity, Consistency, Isolation, and Durability).
10	Replication methods of Vertica is Master-slave replication	Replication methods of Yaacomo is Master-slave replication.
11	Vertica has Immediate Consistency concept.	Yaacomo has Immediate Consistency concept.