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.

trafod2

 

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

 

trafodion

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.

Banner


Android Studio Iguana With Crash Reports
05/03/2024

Google has announced that the latest version of Android Studio, Iguana, is now stable. It has version control system support in App Quality Insights and new built-in support for creating baseline prof [ ... ]



Flox Releases Flox Hub
13/03/2024

Flox has announced that its Command Line Interface (CLI) and FloxHub are now generally available. The CLI is open source and FloxHub is free for anyone to use.


More News

raspberry pi books

 

Comments




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

Last Updated ( Thursday, 29 March 2018 )