Open In App

Difference Between Trafodion and Vertica

Improve
Improve
Like Article
Like
Save
Share
Report

1. Trafodion :
Trafodion is a Transactional SQL-on-Hadoop DBMS. It is a webscale SQL-on-Hadoop solution enabling transactional or operational workloads on Apache Hadoop. The name “Trafodion” pronounced as “Tra-vod-eee-on”. It is a relational database management system that runs on Apache Hadoop which provides support for transactional or operational workloads in a big data environment and for large data sets using a parallel-aware query optimizer.

2. Vertica :
Vertica is a Columnar relational DBMS that 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 Trafodion and Vertica :

S.No. Trafodion Vertica
1. Trafodion was developed by Apache Software Foundation and originally developed by HP. Vertica was developed by Vertica / Micro Focus.
2. Trafodion was initially released in 2014. Vertica was initially released in 2005.
3. Linux is server operating system of Trafodion. Linux is server operating system of Vertica.
4. Primary database model is Relational DBMS. Primary database model is Relational DBMS.
5. There is an absence of Secondary database model in Trafodion. Secondary database model of Vertica is Document Store.
6. All programming languages supporting JDBC/ODBC/ADO.Net are supported by Trafodion. C++, Java, Perl, Python and R are supported programming language by Vertica.
7. ADO.NET, JDBC, ODBC are the APIs and other access methods of Trafodion. ADO.NET, JDBC, Kafka, ODBC, Proprietary protocol, RESTful HTTP, API are the APIs and other access methods of Vertica.
8. Trafodion has Data Schema. Vertica also has Data Schema.
9. Implementation languages of Trafodion are Java and C++. Vertica does not have any implementation language.
10. Trafodion has ACID transaction concepts. Vertica also has ACID transaction concepts.
11. Replication method of Trafodion is via HBase. Replication method of Vertica is Master-Master Replication.
12. Trafodion holds Immediate Consistency concept. Vertica also holds Immediate Consistency concept.


Last Updated : 06 Jul, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads