Difference between Trafodion and XAP

1. Trafodion :
It is a Transnational 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. XAP :
It is a distributed, highly-scalable, In Memory Data Grid. It is a High performance in-memory data grid for mission critical applications and provides an essential set of data store features, such as transactions, indexes, and query language (SQL-like queries). It is a file format used to install and distribute application software.

Difference between Trafodion and XAP :

S.NO.	Trafodion	XAP
1	Developed by Apache Software Foundation, originally developed by HP and initially released on 2014.	Developed by Gigaspaces Technologies and initially released on 2000.
2	Current release on February 2019.	Current release on June 2019.
3	Linux is server, operating systems of Trafodion.	Linux, macOS, Solaris, Windows are server operating systems of XAP.
4	Primary database model is Relational DBMS.	Primary database model is Document store and Key-value store.
5	Absence of Secondary database models in Trafodion.	Secondary database models is Object oriented DBMS.
6	All languages supporting JDBC/ODBC/ADO.Net are programming languages.	.Net, C++, Java are supporting programming languages.
7	ADO.NET, JDBC, ODBC are the APIs and other access methods of Trafodion.	GigaSpaces LRMI, Hibernate, JCache, JDBC, JPA, ODBC, RESTful HTTP API, Spring Data are the APIs and other access methods.
8	It has Data Schema.	Data scheme of XAP is schema-free.
9	It has Implementation language Java and C++.	Implementation language of XAP is Java, C++, .Net.
10	It has ACID Transaction concepts.	It also has ACID Transaction concepts.
11	Via HBase is replication methods of Trafodion.	Replication methods of XAP- Master-master replication and Master-slave replication.
12	It holds Immediate Consistency concept.	It has Immediate Consistency concept.
13	It holds Foreign keys.	It does not holds Foreign key.