Apache Phoenix vs. Apache Trafodion vs. MySQL vs. MySQL Data Access Components Comparison Chart

Apache Trafodion is a webscale SQL-on-Hadoop solution enabling transactional or operational workloads on Apache Hadoop. Trafodion builds on the scalability, elasticity, and flexibility of Hadoop. Trafodion extends Hadoop to provide guaranteed transactional integrity, enabling new kinds of big data applications to run on Hadoop. Full-functioned ANSI SQL language support. JDBC/ODBC connectivity for Linux/Windows clients. Distributed ACID transaction protection across multiple statements, tables, and rows. Performance improvements for OLTP workloads with compile-time and run-time optimizations. Support for large data sets using a parallel-aware query optimizer. Reuse existing SQL skills and improve developer productivity. Distributed ACID transactions guarantee data consistency across multiple rows and tables. Interoperability with existing tools and applications. Hadoop and Linux distribution neutral. Easy to add to your existing Hadoop infrastructure.

Enjoy the highest performance and unlimited possibilities when working with MySQL. MySQL Data Access Components (MyDAC) is a library of components that provides direct access to MySQL and MariaDB from Delphi and C++Builder, including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. Applications based on MyDAC can connect directly to MySQL server or work through the MySQL client library. MySQL Data Access Components are designed to help programmers develop MySQL database applications faster and easier. MyDAC is a complete replacement for standard MySQL connectors and presents an efficient alternative to the Borland Database Engine (BDE) and standard dbExpress driver for access to MySQL.