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. UniData,UniVerse :
It is a MultiValue database and application server with SQL mapping layer and meta database capabilities. UniData makes for easier database design, eliminating the constraints of SQL normalization. UniVerse is a component of the MultiValue application platform, Its advantages is fast, flexible data server for developing enterprise apps. UniVerse-based applications maximizing processing throughput of available resources, dynamically allocate available resources.
Difference between Trafodion and UniData,UniVerse :
|1||It is developed by Apache Software Foundation, originally developed by HP. Initially released on 2014 and Current release on February 2019..||It is developed by Rocket Software and initially released on 1985.|
|2||Linux is server, operating systems of Trafodion .||AIX, HP-UX, Linux, Solaris, Windows are server operating systems of UniData,UniVerse|
|3||Primary database model is Relational DBMS.||Primary database model is Multivalue DBMS.|
|4||All languages supporting JDBC/ODBC/ADO.Net are programming languages.||.Net,Basic, C, Java are supporting programming languages.|
|5||It holds Foreign keys.||It does not hold Foreign keys.|
|6||Sharding partitioning methods is present.||Absence of Partitioning methods in UniData,UniVerse.|
|7||ADO.NET, JDBC, ODBC are the APIs and other access methods of Trafodion.||Proprietary protocol, RESTful HTTP API, Java API, JDBC, ODBC, OLE DB, SOAP-based API are APIs and other access methods.|
|8||It has Data Schema.||It has a schema-free Data Schema.|
|9||It has Implementation language Java and C++.||Implementation language is C.|
|10||Trafodion has ACID( Atomicity, Consistency, Isolation, and Durability) Transaction concepts.||UniData,UniVerse has ACID ( Atomicity, Consistency, Isolation, and Durability) Transaction concepts.|
|11||Trafodion has replication method via HBase.||Replication methods of UniData,UniVerse is Master-slave replication.|
|12||Immediate Consistency concept present in Trafodion.||Absence of Consistency concept in UniData,UniVerse.|
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.