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.

Comments

Make a Comment or View Existing Comments Using Disqus

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