Apache Trafodion

From Wikipedia, the free encyclopedia
  (Redirected from Trafodion)
Jump to navigation Jump to search
Apache Trafodion logo.svg
Developer(s)Apache Software Foundation
Stable release
2.3.0 / February 28, 2019; 2 years ago (2019-02-28)
RepositoryTrafodion Repository
Written inC++, Java
Operating systemLinux
TypeSQL-on-Hadoop DBMS
LicenseApache License 2.0

Apache Trafodion is an open-source Top-Level Project at the Apache Software Foundation. It was originally developed by the information technology division of Hewlett-Packard Company and HP Labs to provide the SQL query language on Apache HBase targeting big data transactional or operational workloads.[1] The project was named after the Welsh word for transactions.[1] As of April 2021, it is no longer actively developed.[2]


Trafodion is a relational database management system that runs on Apache Hadoop,[3] providing support for transactional or operational workloads in a big data environment.[1] The following is a list of key features:

  • ANSI SQL language support[3]
  • JDBC and Open Database Connectivity (ODBC) connectivity for Linux and Windows clients[3]
  • Distributed ACID transaction protection across multiple statements, tables, and rows[3]
  • Compile-time and run-time optimizations for real-time operational workloads[3]
  • Support for large data sets using a parallel-aware query optimizer and a parallel data-flow execution engine[3]

Transaction management features include:

  • Begin, commit, and rollback work syntax, including SET TRANSACTION[3]
  • READ COMMITTED transactional isolation level[3]
  • Multiple SQL processes participating in the same transaction concurrently[3]
  • Recovery after region server, transaction manager, or node failure[3]
  • Support for region splits and balancing[3]


Trafodion was launched by HP as an open-source project on June 10, 2014.[4]

A version of Trafodion was released on January 29, 2015.[5]

Trafodion became an Apache Incubation Project in May 2015.[6]

Trafodion graduated from the Apache Incubator to become a Top-Level Project at the Apache Software Foundation in January 2018.[7]

See also[edit]


  1. ^ a b c "Trafodion: Transactional SQL-on-HBase". June 9, 2014. Archived from the original on July 25, 2014. Retrieved July 17, 2014.
  2. ^ "Apache Trafodion - Apache Attic".
  3. ^ a b c d e f g h i j k "Trafodion: First Release Features (Release 0.8.0)". May 29, 2014. Retrieved October 21, 2015.[permanent dead link]
  4. ^ "Introducing Trafodion - HP Enterprise Business Community". June 17, 2014. Retrieved July 17, 2014.
  5. ^ "Release of Trafodion 1.0.0". January 30, 2015. Archived from the original on February 24, 2015. Retrieved February 23, 2015.
  6. ^ "Apache Incubation Project List". Retrieved October 19, 2015.
  7. ^ "The Apache Software Foundation Announces Apache Trafodion as a Top-Level Project". Retrieved February 13, 2018.

External links[edit]