1. Trafodion :
It is a Transnational 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.
2. Weaviate :
It is an open-source GraphQL-based Smart Graph with the core features- semantic search, automatic classification, and knowledge representation. Primary database model is Search Engine and secondary database models is Graph DBMS. It allows our data to represent in a large graph format based on the GraphQL query language. Its search graph based on a graph embedding mechanism called the Contextionary ect.
Difference between Trafodion and Weaviate :
|1||Developed by Apache Software Foundation, originally developed by HP and initially released on 2014.||Developed by SeMI Technologies B.V. and initially released on 2017.|
|2||Current release on February 2019.||Current release on January 2020.|
|3||Linux is server, operating systems of Trafodion.||No such server operating systems in Weaviate.|
|4||Primary database model is Relational DBMS.||Primary database model is Search Engine.|
|5||Absence of Secondary database models in Trafodion.||Secondary database models is Graph DBMS.|
|6||All languages supporting JDBC/ODBC/ADO. Net are programming languages.||No such supported programming languages in Weaviate.|
|7||ADO.NET, JDBC, ODBC are the APIs and other access methods of Trafodion.||GraphQL query language and RESTful HTTP/JSON API are the APIs and other access methods.|
|8||Yes, Trafodion has Data Schema.||Data scheme is based on maps to GraphQL interface.|
|9||It has Implementation language Java and C++.||Implementation language of Weaviate is Go.|
|10||Yes, Trafodion has ACID Transaction concepts.||Absence of transaction concepts in Weaviate.|
|11||Via HBase is replication methods of Trafodion.||Replication methods of Weaviate is Master-master replication an Master-slave replication.|
|12||It holds Immediate Consistency concept.||It has Eventual Consistency concept.|
|13||Yes, It holds Foreign keys.||It doesn’t holds 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.