Difference Between Trafodion and Vertica
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
Share your thoughts in the comments
Please Login to comment...