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. |
Contact Us