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. Yaacomo :
Yaacomo is an OpenCL, Relational based in-memory database management system for real-time analytics and big data solutions were developed as a plug-and-play solution. Yaacomo was designed for efficiently utilizing the hardware via parallel computing.
Difference between Trafodion and Yaacomo :
|1.||Trafodion was developed by Apache Software Foundation and originally developed by HP.||Yaacomo was developed by Q2WEB GmbH and initially released in 2009.|
|2.||Linux is server operating systems of Trafodion.||Android, Linux and Windows are server operating systems of Yaacomo.|
|3.||Its primary database model is Relational DBMS.||Its primary database model is Relational DBMS.|
|4.||All programming languages supporting JDBC/ODBC/ADO.Net are supported by Trafodion.||Yaacomo does not support any programming language.|
|5.||ADO.NET, JDBC, ODBC are the APIs and other access methods of Trafodion.||JDBC and ODBC are APIs and other access methods of Yaacomo.|
|6.||It has Data Schema.||It also has Data Schema.|
|7.||Implementation languages of Trafodion are Java and C++.||Yaacomo does not have any implementation language.|
|8.||It has ACID transaction concepts.||It also has ACID transaction concepts.|
|9.||Replication method of Trafodion is via HBase.||Replication method of Yaacomo is Master-Slave Replication.|
|10.||Sharding is a partitioning method of Trafodion.||Horizontal partitioning is a partitioning method of Yaacomo.|
|11.||It holds Immediate Consistency concept.||It also holds Immediate Consistency concept.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.