HeatWave is an in-memory query accelerator developed for Oracle MySQL Database Service. It’s a massively parallel, hybrid, columnar, query-processing engine with algorithms for distributed query processing that provide high performance for queries.
N/A
Oracle Autonomous Data Warehouse
Score 10.0 out of 10
N/A
Oracle Autonomous Data Warehouse is optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can discover business insights using data of any size and type. The solution is built for the cloud and optimized using Oracle Exadata.
MySQL Heatwave is suitable for data mining and data analysis for platforms like OLAP. This is very cost effective tool in comparison with peer softwares. Oracle provides multiple pricing options for use of to this software. Which makes the choice of many needee crowd for large number of applications for data handling. It provides the access to database al also.
II would recommend Oracle Autonomous Data Warehouse to someone looking to fully automate the transferring of data especially in a warehouse scenario though I can see the elasticity of the suite that is offered and can see it is applicable in other scenarios not just warehouses.
Very easy and fast to load data into the Oracle Autonomous Data Warehouse
Exceptionally fast retrieval of data joining 100 million row table with a billion row table plus the size of the database was reduced by a factor of 10 due to how Oracle store[s] and organise[s] data and indexes.
Flexibility with scaling up and down CPU on the fly when needed, and just stop it when not needed so you don't get charged when it is not running.
It is always patched and always available and you can add storage dynamically as you need it.
Level of integration or compatibility to connect it to different applications can be improved
The support service is slow
The issue is with the record number limitation of not being able to bring back more than one million records or not being able to export larger datasets to Excel
Does not require continous attention from the DBA, autonomous features allows the database to perform most of the regular admin tasks without need for human intervention.
Allows to integrate multiple data sources on a central data warehouse, and explode the information stored with different analytic and reporting tools.
Understanding Oracle Cloud Infrastructure is really simple, and Autonomous databases are even more. Using shared or dedicated infrastructure is one of the few things you need to consider at the moment of starting provisioning your Oracle Autonomous Data Warehouse.
There is no other product in the market like MySQL Heatwave. The other competitive offerings are Databricks Lakehouse and Cloudera which essentially are Data Analytics Platforms and Data Warehousing Solutions. They do have SQL interfaces through Delta Lake and Hive but they run complicated Spark Jobs which are time consuming and much slower than MySQL Heatwave.
Our organization adopted Oracle almost 20 years ago and there were a few options at that time. Oracle was the leading database tech company at that time and it was a safe choice to us. And they have been evolved and always ahead of new technologies, high performance, and professional business support. We didn't find a good reason to replace Oracle with any other competitors.
Overall the business objective of all of our clients have been met positively with Oracle Data Warehouse. All of the required analysis the users were able to successfully carry out using the warehouse data.
Using a 3-tier architecture with the Oracle Data Warehouse at the back end the mid-tier has been integrated well. This is big plus in providing the necessary tools for end users of the data warehouse to carry out their analysis.
All of the various BI products (OBIEE, Cognos, etc.) are able to use and exploit the various analytic built-in functionalities of the Oracle Data Warehouse.
