Difference between Trafodion and ToroDB
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
Share your thoughts in the comments
Please Login to comment...