Oracle floats its HeatWave system into Amazon's cloud
Avoiding data movement saves $$$ but rivals have own approaches to doing analytics, transactions on same data
Oracle has made its Heatwave combined analytics and transactional data system available on cloud platform AWS for the first time, and a product on Microsoft's Azure is expected to follow shortly.
The Safra Catz led software biz has only promoted its own cloud infrastructure (OCI) and until now its MySQL-based Heatwave system was not available on rival cloud platforms.
Introduced in December 2020, Heatwave was designed as an analytics system that MySQL customers could use without having to export data from their transactional applications to a specialist analytics system such as Teradata, Snowflake, or AWS Redshift. In March 2022, Oracle added autoML, real-time elasticity, and control of price-performance trade-offs.
This week, Big Red fulfilled an earlier commitment to make the database service available on AWS.
The strategy shift allows AWS users to run transaction processing, analytics, and machine learning workloads in one service, without requiring time-consuming extract-transform-load duplication between separate databases such as Amazon Aurora for transaction processing, Amazon Redshift or Snowflake on AWS for analytics and SageMaker for machine learning, Oracle said in a statement.
- Want to know the future of FOSS? You can look it up in a database
- Oracle adds autoML to its MySQL HeatWave service
- New graph database features eschew need for DBAs
- Oracle contracts and pricing a 'challenge', says Gartner
- Oracle, Microsoft agree to shared custody of your workloads in the cloud
In a pre-canned statement, Edward Screven, Oracle chief corporate architect, said: "Many of our MySQL HeatWave customers migrated from AWS. Others wish to continue running parts of their application on AWS. Those customers face serious challenges including exorbitant data egress fees charged by AWS and higher latency when accessing a database service running in Oracle's cloud. We are addressing these issues while delivering outstanding performance and price performance across transaction, analytics, and machine learning compared to other database cloud providers."
Oracle claims MySQL HeatWave on AWS offers superior price performance to other systems on AWS. For example, it claims that when it ran queries derived from the 4TB TPC-H benchmark, MySQL HeatWave on AWS delivered price performance that is seven times better than Amazon Redshift, 10 times better than Snowflake, 12 times better than Google BigQuery, and 4 times better than Azure Synapse.
Doing analytics and transactions on a single database has become more popular in the last year or so. Just three months ago, Snowflake rolled out the ability to do transactions within its analytics database directly in Snowflake's own platform, which includes the developer framework Snowpark. SingleStore and MongoDB also offer technologies to address this concept.
Meanwhile, Oracle also announced its results this week. In the first fiscal quarter of its FY2023 ended 31 August, it reported revenue that met market expectations, growing 18 percent compared with the same quarter a year earlier to reach $11.4 billion. Net income was $1.5 billion, up 14 per cent. ®