Oracle has announced the general availability of its managed MySQL Database Service, along with a feature that integrates online analytical processing (OLAP) into the platform.
The company claims its offering is faster and lower-cost than competing systems such as Amazon’s Redshift cloud data warehouse, Google Cloud SQL and Microsoft SQL Database.
It is based on the popular MySQL database software, which Oracle acquired with Sun Microsystems in 2010. Sun previously bought MySQL in 2008.
MySQL is widely used for online transaction processing (OLTP) applications, managing data from retail or financial transactions, for instance.
But organisations have often maintained a second database for data analysis or OLAP actions, such as finding customer trends based on the analysis of sales data.
Oracle’s system aims to remove this additional complexity, automatically populating the MySQL data into the in-memory analytics engine.
The analytical engine scales to thousands of cores and supports real-time analytics, Oracle said, claiming it is 2.7 times faster and one-third the cost of AWS Redshift.
The engine, available exclusively on Oracle Cloud Infrastructure (OCI), uses in-memory, hybrid columnar processing with massive inter- and intra-node parallelism optimised for Oracle’s cloud.
A query optimiser within the service has also been enhanced to support analytical queries as well as OLTP queries, Oracle said.
It said the service works with all MySQL-compatible tools and applications and automatically routes queries to the MySQL Analytics Engine, improving performance.
Any changes to the database are populated to the analytics engine in real time, simplifying application development and decreasing costs.
“Until today, MySQL users have been forced to move their data into separate incompatible data warehouses for analytics, leading to higher costs and delayed answers,” said Oracle chief corporate architect Edward Screven.
He said the new system offers developers and database administrators a “single, unified platform”.
European Commission says Microsoft's hiring of Inflection AI's staff will not be investigated under EU…
Alphabet urges Competition Appeal Tribunal to dismiss mass lawsuit seeking up to £7bn ($9.3bn) for…
The US will host the first meeting of the International Network of AI Safety Institutes,…
EU General Court upholds European Commission €242m antitrust fine against Qualcomm, after it allegedly forced…
Google wins court challenge. Europe's second highest court rules EC's €1.49bn antitrust fine should be…
Russian state media networks including RT, Rossiya Segodnya etc banned by Meta Platforms for “foreign…