Open In App

Difference between Trafodion and YugabyteDB

Last Updated : 30 Jun, 2020
Improve
Improve
Like Article
Like
Save
Share
Report

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 :

S.NO. Trafodion 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.
5 All languages supporting JDBC/ODBC/ADO.Net are programming languages. C, C#, C++, Go, Java, JavaScript (Node.js), Python, Ruby are supporting programming languages.
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.


Like Article
Suggest improvement
Share your thoughts in the comments

Similar Reads