1. Trafodion :
It 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. YugabyteDB :
It is high-performance, cloud native and open source distributed SQL database globally-distributed document store. It aims to make applications agile. Yugabyte is headquartered in Sunnyvale, CA. It is distributed and developed as an Apache 2.0 open source project.
Difference between Trafodion and YugabyteDB :
|1||Developed by Apache Software Foundation, originally developed by HP and initially released on 2014.||Developed by Yugabyte Inc. and initially released on 2017.|
|2||Linux is server, operating systems of Trafodion.||Linux, OS X are server operating systems of YugabyteDB.|
|3||Primary database model is Relational DBMS.||Primary database model is Relational DBMS.|
|4||Absence of Secondary database models in Trafodion.||Secondary database models is Document store and Wide column store.|
|6||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.|
|7||It has Data Schema.||Its data scheme is depending on used data model.|
|8||It has Implementation language Java and C++.||Its implementation language of YugabyteDB is C and C++.|
|9||Yes, Trafodion has ACID Transaction concepts.||Distributed ACID with Serializable Snapshot Isolation. Inspired by Google Spanner architecture is Transaction concepts.|
|10||Via HBase is replication methods of Trafodion.||Replication methods is based on Raft distributed consensus protocol, minimum 3 replicas for continuous availability.|
|11||It has immediate Consistency concept.||It has strong consistency on writes and tunable consistency on reads.|
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.