Open In App

Difference between Trafodion and ToroDB

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 transnational 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 transnational or operational workloads in a big data environment and for large data sets using a parallel-aware query optimizer.

1. ToroDB :
It is a MongoDB-compatible JSON document store, built on top of PostgreSQL and it is a technology designed to fulfill the gap between document oriented and SQL databases. It is an open source NoSQL database that runs on top of a RDBMS which is compatible with MongoDB protocol and APIs. ToroDB is an open source project that reads a NoSQL document, automatically infers its structure, and transforms it into a set of tables and columns that represent the data into a relational form.



Difference between Trafodion and ToroDB :

S.NO. Trafodion ToroDB
1 Developed by Apache Software Foundation, originally developed by HP and initially released on 2014. Current release on February 2019. Developed by 8Kdata and initially released on 2016.
2 Linux is server, operating systems of Trafodion. All OS with a Java 7 VM is server, operating systems of ToroDB.
3 Primary database model is Relational DBMS. Primary database model is Document store.
4 All languages supporting JDBC/ODBC/ADO. Net are programming languages. Absence of any supported programming languages.
5 ADO.NET, JDBC, ODBC are the APIs and other access methods of Trafodion. Absence of APIs and other access methods in ToroDB.
6 It has Data Schema. It has schema-free Data Schema.
7 It has implementation language Java and C++. Its implementation language is Java.
8 Trafodion has ACID Transaction concepts. Absence of Transaction concepts in ToroDB.
9 Via HBase is replication methods of Trafodion. Master-slave replication methods in ToroDB.
10 It holds Immediate Consistency concept. Has Eventual Consistency and Immediate Consistency concept.
11 It holds Foreign keys. No, It doesn’t hold Foreign keys.


Last Updated : 30 Jun, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads