1. Trafodion :
It is Transactional SQL-on-Hadoop DBMS. It is 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. VelocityDB :
It is .NET Object Database that can be embedded/distributed and extended to graph data model (VelocityGraph) Database is fast and low memory consuming. It is an extremely high performance, easy to use, scalable, embeddable and distributable object database system.
Difference between Trafodion and VelocityDB :
|1||Developed by Apache Software Foundation, originally developed by HP and initially released on 2014.||Developed by VelocityDB Inc and initially released on 2011.|
|2||Current release on February 2019.||Current release of VelocityDB is 7.x.|
|3||Linux is server, operating systems of Trafodion .||.NET is server operating systems of VelocityDB.|
|4||Primary database model is Relational DBMS.||Primary database model is Graph DBMS and Object oriented DBMS.|
|5||All languages supporting JDBC/ODBC/ADO.Net are programming languages.||.Net is supporting programming languages.|
|6||ADO.NET, JDBC, ODBC are the APIs and other access methods of Trafodion.||APIs and other access methods of VelocityDB is .Net|
|7||Trafodion has Data Schema.||It also has a Data Schema.|
|8||It has Implementation language Java and C++ .||Implementation language of VelocityDB is C#.|
|9||Trafodion has ACID Transaction concepts.||ACID ( Atomicity, Consistency, Isolation, and Durability) is Transaction concepts.|
|10||Via HBase is replication methods of Trafodion.||Absence of Replication methods in VelocityDB.|
|11||Trafodion holds Immediate Consistency concept.||VelocityDB has Immediate Consistency concept.|
|12||It holds Foreign keys.||It does not 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.