1. 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.
2. VoltDB :
It is an ACID-compliant RDBMS and distributed In-Memory NewSQL RDBMS that uses a shared nothing architecture. Database designed by Michael Stonebraker, Sam Madden, and Daniel Abadi. Initially VoltDB database includes graphs for cluster throughput and latency as well as CPU and memory usage. It is based on H-Store and scales with the increasing core-per-CPU counts on multi-core servers.
Difference between Trafodion and VoltDB :
|1||Developed by Apache Software Foundation, originally developed by HP and initially released on 2014.||Developed by VoltDB Inc. and initially released on 2010.|
|2||Current release on February 2019.||Current release on April 2019.|
|3||Linux is server, operating systems of Trafodion .||Linux, OS X are server operating systems of VoltDB.|
|4||Primary database model is Relational DBMS.||Primary database model is Relational DBMS.|
|6||ADO.NET, JDBC, ODBC are the APIs and other access methods of Trafodion.||Java API, JDBC, RESTful HTTP/JSON API are APIs and other access methods.|
|7||Trafodion has Data Schema.||It also has Data Schema.|
|8||It has Implementation language Java and C++ .||Implementation language of VoltDB is Java, C++.|
|9||Trafodion has ACID Transaction concepts.||ACID (Atomicity, Consistency, Isolation, and Durability) is Transaction concepts.|
|10||Via HBase is replication methods of Trafodion.||Replication methods of VoltDB is Master-master replication and Master-slave replication.|
|11||Trafodion holds Immediate Consistency concept.||It does not holds Consistency concept.|
|12||It has concept of Foreign keys.||It also has concept of 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.