Open In App

Difference between Trafodion and Virtuoso

Improve
Improve
Like Article
Like
Save
Share
Report

1. Trafodion :
Trafodion 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. Virtuoso :
Virtuoso is a middleware that supports management of data represented as relational tables and/or property graphs. It is a multi-model hybrid-RDBMS which holds primary database models as Graph DBMS, Native XML DBMS, Relational DBMS, RDF store and Search engine. It is designed for taking advantages of operating system threading support and multiple CPUs. Virtuoso Object-relational database (ORDBMS) supports entity integrity and referential integrity.


Difference between Trafodion and Virtuoso :

S.NO. Trafodion Virtuoso
1. It was developed by Apache Software Foundation and originally developed by HP. It was developed by Virtuoso.
2. Initially released in 2014. Initially released in 1998.
3. Linux is the server operating system of Trafodion. AIX, FreeBSD, HP-UX, Linux, OS X, Solaris and Windows are the server operating systems of Virtuoso.
4. Primary database model is Relational DBMS. Primary database models are Graph DBMS, Native XML DBMS, Relational DBMS, RDF store and Search Engine.
5. There is an absence of secondary database model in Trafodion. Secondary database model of Virtuoso is Document Store.
6. All programming languages supporting JDBC/ODBC/ADO.Net are supported by Trafodion. .Net, C, C#, C++, Java, JavaScript, Perl, PHP, Python, Ruby and Visual Basic are the supporting programming languages of Virtuoso.
7. Trafodion has Data Schema. Virtuoso also has Data Schema.
8. Implementation languages of Trafodion are Java and C++. Implementation language of Virtuoso is C.
9. Trafodion has ACID transaction concepts. Virtuoso also has ACID transaction concepts.
10. Replication method of Trafodion is via HBase. Replication methods of Virtuoso are based on Chain, Star, and Bi-Directional Replication, Master-Master Replication and Master-Slave Replication.
11. Trafodion holds Immediate Consistency concept. Virtuoso also holds Consistency concept.


Last Updated : 02 Jul, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads