S.NO. |
UniData, UniVerse |
Vertica |
1 |
Developed by Rocket Software and initially released on 1985. |
Developed by Vertica / Micro Focus and initially released on 2005 and 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 UniData, UniVerse is AIX, HP-UX, Linux, Solaris, Windows. |
Linux is the Server operating system. |
3 |
Primary database model is Multivalue DBMS. |
Primary database model is Relational DBMS. |
4 |
Absence of Secondary database models. |
Secondary database models of Vertica is Document store. |
5 |
UniData, UniVerse supports .Net, Basic, C, Java, programming languages. |
Supports C++, Java, Perl, Python, R, programming languages. |
6 |
APIs and other access methods of UniData, UniVerse is Proprietary protocol, RESTful HTTP API, Java API, JDBC, ODBC, OLE DB, SOAP-based API. |
Vertica supports ADO.NET, JDBC, Kafka, ODBC, Proprietary protocol, RESTful HTTP, API. |
7 |
Yes, UniData, UniVerse has a schema-free Data Schema. |
Yes, Vertica has a Data Schema. |
8 |
It has Implementation language C . |
It doesn’t has any Implementation language. |
9 |
ACID (atomicity, consistency, isolation, durability) Transaction concepts in UniData, UniVerse. |
Transaction concepts of VoltDB is ACID ( Atomicity, Consistency, Isolation, and Durability). |
10 |
Replication methods of UniData, UniVerse is Master-slave replication. |
Replication methods of Vertica is Master-slave replication. |
11 |
UniData, UniVerse doesn’t hold Consistency concept. |
Yes, Vertica has Immediate Consistency concept. |
12 |
Absence of Partitioning methods in UniData, UniVerse. |
Sharding partitioning methods is present. |
13 |
It doesn’t holds Foreign keys. |
It holds Foreign keys. |