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 :
|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.|
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.