Difference between Trafodion and Transbase

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.

Transbase :
It is a resource-optimized, high-performance, universally applicable RDBMS, developed and maintained by Transaction Software GmbH, Munich. It is a relational database management system that supports all important functions of the SQL standard. The database of Transbase is extensible via additional functions and custom data types also provides parallel execution of queries via dynamic multithreading technology.



Difference between Trafodion and Transbase :

S.NO. Trafodion Transbase
1 Developed by Apache Software Foundation, originally developed by HP and initially released on 2014. Developed by Transaction Software GmbH and initially released on 1987.
2 Current release on February 2019. Current release on September 2019
3 Linux is server, operating systems of Trafodion . FreeBSD, Linux, macOS, Solaris, Windows, are the server, operating systems of Transbase.
4 Primary database model is Relational DBMS. Primary database model is Relational DBMS.
5 Sharding partitioning methods is present. Absence of Partitioning methods in Transbase .
6 All languages supporting JDBC/ODBC/ADO.Net are programming languages. Supports C, C#, C++, Java, JavaScript, Kotlin, Objective-C, PHP, Python are programming languages.
7 ADO.NET, JDBC, ODBC are the APIs and other access methods of Trafodion. ADO.NET, JDBC, ODBC, Proprietary native API are the APIs and other access methods of Transbase.
8 Trafodion has Data Schema. It also has Data Schema.
9 It has Implementation language Java and C++ . It has Implementation language C and C++ .
10 Trafodion has ACID Transaction concepts. It also has Transaction concepts.
11 Via HBase is replication methods of Trafodion. Replication methods of Transbase is Master-slave replication.
12 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.

My Personal Notes arrow_drop_up


If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.