Difference between Valentina Server and Vertica

1. Vertica :
It 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.

Valentina Server :
It is a Object-relational database and reports server and fast object-relational database server. It includes integrated database servers, Valentina Database Server and SQLite Database Server. It is a full featured, standards compliant multi-user access SQLite based database server.

Difference between Valentina Server and Vertica :

S.NO.	Valentina Server	Virtuoso
1	Developed by Paradigma Software and initially released on 1994 and Current release of Valentina Server is 5.7.5 .	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.
2	Server operating systems of Valentina Server is Linux, OS X, Windows.	Server operating systems of Vertica is Linux
3	Its primary database model is Relational DBMS.	Its primary database model is Relational DBMS.
4	Valentina Server supports .Net, C, C#, C++, Objective-C, PHP, Ruby, Visual Basic, Visual Basic.NET, programming languages.	Vertica supports C++, Java, Perl, Python, R, programming languages.
5	APIs and other access methods of Valentina Server is ODBC.	APIs and other access methods of Vertica is ADO.NET, JDBC, Kafka, ODBC, Proprietary protocol, RESTful HTTP, API.
6	Yes, Valentina Server has a Data Schema.	Yes, Vertica has a Data Schema.
7	Absence of Transaction concepts in  Valentina Server.	Vertica has Immediate Consistency concept.
8	Valentina Server doesn’t hold Consistency concept.	Yes, Vertica has Immediate Consistency concept.
9	Yes, It holds Foreign keys.	It holds Foreign keys.
10	Absence of Replication methods in Valentina Server.	Replication methods of Vertica is Master-slave replication
11	Absence of Partitioning methods in Valentina Server.	It holds sharding partitioning methods.