Relational database management system for Apache Hadoop
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]
Features
Trafodion was a relational database management system that ran 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]
History
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]
