S.NO. |
Vertica |
Virtuoso |
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 Virtuoso and initially released on 1998 and current release on May 2019. |
2 |
Server operating systems of Vertica is Linux |
Server operating systems of AIX, FreeBSD, HP-UX, Linux, OS X, Solaris, Windows. |
3 |
Its primary database model is Relational DBMS. |
Its primary database model is Graph DBMS, Native XML DBMS, Relational DBMS, RDF store, Search engine. |
4 |
Secondary database models of Vertica is Document store |
Its secondary database models is Document store. |
5 |
Vertica supports C++, Java, Perl, Python, R, programming languages. |
Virtuoso supports .Net, C, C#, C++, Java, JavaScript, Perl, PHP, Python, Ruby, Visual Basic programming languages. |
6 |
APIs and other access methods of Vertica is ADO.NET, JDBC, Kafka, ODBC, Proprietary protocol, RESTful HTTP, API. |
Virtuoso supports ADO.NET, GeoSPARQL, HTTP API, JDBC, Jena, RDF API, ODBC, OLE DB, RDF4J API, RESTful HTTP API, Sesame REST HTTP Protocol, SOAP, webservices, WebDAV, XPath, XQuery, XSLT. |
7 |
Yes, Vertica has a Data Schema. |
Yes, Virtuoso has a Data Schema. |
8 |
It doesn’t has any Implementation language. |
Implementation language of Virtuoso is C. |
9 |
Vertica- Transaction concepts is ACID ( Atomicity, Consistency, Isolation, and Durability). |
It has transaction concept- ACID ( Atomicity, Consistency, Isolation, and Durability). |
10 |
Replication methods of Vertica is Master-slave replication |
Replication methods of Virtuoso is based on Chain, star, and bi-directional replication, Master-master replication, Master-slave replication. |
11 |
Vertica has Immediate Consistency concept. |
Yes, Virtuoso has Consistency concept. |