Difference between Trafodion and Yanza
1. Trafodion :
It is 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. Yanza :
It is Time Series DBMS for Internet of Things (IoT) Applications and Developed by Yanza. Its Server Operating system is Window and supports HTTP API.
Difference between Trafodion and Yanza :
S.NO. | Trafodion | Yanza |
---|---|---|
1 | It is developed by Apache Software Foundation, originally developed by HP. Initially released on 2014. | It is developed by Yanza and initially released on 2015. |
2 | Linux is server, operating systems of Trafodion . | Windows is server operating systems of Yanza. |
3 | Its primary database model is Relational DBMS. | Its primary database model is Time Series DBMS. |
4 | All languages supporting JDBC/ODBC/ADO.Net are programming languages. | It supports any language that supports HTTP calls. |
5 | ADO.NET, JDBC, ODBC are the APIs and other access methods of Trafodion. | YCQL, an SQL-based flexible-schema API with its roots in Cassandra Query Language, APIs and other access methods. |
6 | It has Data Schema. | Data scheme of Yanza is schema-free. |
7 | Its implementation language Java and C++ . | It does not has any implementation language. |
8 | It has ACID Transaction concepts. | Its does not has transaction concepts. |
9 | Via HBase is replication methods of Trafodion. | Absence of Replication methods in Yanza. |
10 | It holds Immediate Consistency concept. | It has Immediate Consistency concept. |
11 | It has concept of Foreign keys. | It does not has concept of Foreign keys. |