Difference between Trafodion and Yaacomo
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 :
S.No. | Trafodion | 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. |