Apache Releases Trafodion
Written by Kay Ewbank   
Thursday, 29 March 2018

Apache Trafodion has been moved from incubator status to become a high level project. Trafodion is a webscale SQL-on-Hadoop solution enabling transactional or operational workloads on Apache Hadoop. 

Trafodion was incubated at HP Labs to develop an enterprise-class SQL-on-HBase solution targeting big data transactional workloads. Its name is Welsh for Transactions, in case you were wondering, and was chosen to emphasize the differentiation that Trafodion provides in closing a critical gap in the Hadoop ecosystem. The gap is in transactional integrity. Trafodion guarantees transactional integrity and operational workloads so extending the types of big data applications that run on Hadoop.

Because Trafodion works with HBase, it can be integrated with Hadoop and HDFS, and it  can also run on Hive, Hadoop’s main data warehouse software.



Trafodion has fully functional support for ANSI SQL, so making it possible to use existing knowledge of SQL when creating transactions rather than having to use MapReduce, which is a scarcer skill. It also has distributed ACID data protection across multiple statements, tables and rows.

Running on top of HBase using the HBase APIs to perform the typical SQL functions of insert, update, delete, and query data with transactional protection, Trafodion delivers a full-featured and optimized transactional SQL-on-HBase DBMS solution with full transactional data protection. These capabilities help overcome basic Hadoop limitations in supporting transactional workloads. There are also plans to include database capabilities using the coprocessor mechanism provided by HBase.

Trafodion comes with a parallel-aware query optimizer that supports large data sets, so ensuring queries run in the most efficient manner. It also has compile-time and run-time optimizers to provide performance improvements for OLTP workloads.

Trafodion can be used with existing Apache Hadoop tools and solutions, such as Hive, Ambari, Flume, Kafka, and Oozie. It comes with JDBC/ODBC support for Linux and Windows clients. 


More Information

Trafodion Website



Related Articles

Hadoop 3 Adds HDFS Erasure Coding

HBase 1.4 With New Shaded Client 

Hadoop 2.9 Adds Resource Estimator

Hadoop Adds In-Memory Caching

Hadoop SQL Query Engine Launched

Hadoop 2 Introduces YARN

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on, Twitter, Facebook or Linkedin.


Oracle In-Memory Data Grid Now Open Source

Oracle has released an open source version of their Coherence in-memory data grid product. Coherence is a Java-based distributed cache and in-memory data grid designed to offer high availability, high [ ... ]

New Udacity Cloud Nanodegree Programs

This week the Udacity School of Cloud Computing is opening its classrooms for a third nanodegree. The new addition, which prepares you for the role of Cloud Architect, is at advanced level. Udaci [ ... ]

More News





or email your comment to: comments@i-programmer.info

Last Updated ( Thursday, 29 March 2018 )