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. |