Oracle expanded MySQL HeatWave with a Lakehouse solution. The solution allows organizations to apply OLTP and OLAP directly to files in object stores. According to Oracle, query speeds are seventeen times higher than Snowflake, a competing service.
Oracle MySQL HeatWave was introduced in 2021. The service allows organizations to manage and process MySQL databases with online transaction processing (OLTP) and online analytical processing (OLAP). Some organizations use separate databases for OLTP and OLAP. Oracle MySQL HeatWave supports both, eliminating the need to move data between databases.
Oracle recently expanded the service with a Lakehouse solution. MySQL HeatWave Lakehouse allows data to be processed directly in object stores. The solution supports various file types, including CSV, Parquet and Avro.
Until now, organizations had to move data from object stores to MySQL HeatWave in order to process the data. The process — also known as extract, transform and load (ETL) — is time-consuming and expensive. The new solution makes ETL unnecessary. MySQL HeatWave Lakehouse is directly applicable to object stores.
Faster than Snowflake
File types like CSV, Parquet and Avro are automatically structured for MySQL. Snowflake and Amazon Redshift offer similar solutions, but the performance of MySQL HeatWave Lakehouse is remarkable.
Oracle used the TPC-H Benchmark industry standard to compare the speed of the services. Queries in MySQL HeatWave Lakehouse were seventeen times faster than Snowflake and six times faster than Amazon Redshift. Load speeds were eight times higher than Amazon Redshift and 2.7 times higher than Snowflake.
Oracle MySQL HeatWave Lakehouse
MySQL HeatWave Lakehouse supports MySQL Autopilot, an existing feature for MySQL HeatWave. The feature automates various management tasks, including file mapping and schema optimisation.
In addition, MySQL Autopilot allows MySQL HeatWave Lakehouse to automatically adjust its performance to the performance of the object store being processed. As a result, the service never uses too much capacity, which ultimately cuts costs.
MySQL HeatWave Lakehouse is available immediately.