Menu
Oracle adds analytics to MySQL in the cloud

Oracle adds analytics to MySQL in the cloud

Oracle MySQL Database Service with the MySQL Analytics Engine combines OLTP and OLAP in the same MySQL database in the Oracle Cloud

Credit: Dreamstime

Oracle is combining OLTP (online transaction processing) and OLAP (online analytical processing) services in its open source MySQL database in the Oracle Cloud, via Oracle MySQL Database Service with the MySQL Analytics Engine.

With this Oracle Cloud service being introduced December 2, users gain the ability to run sophisticated analytics against their operational MySQL database. The MySQL Analytics Engine is an in-memory analytics accelerator that can scale to thousands of Oracle Cloud Infrastructure (OCI) cores.

Positioned to compete with the Amazon Redshift cloud data warehouse, the Oracle MySQL Database Service with the MySQL Analytics Engine saves users from having to integrate with a separate analytics database. Database administrators and developers gain a unified platform for OLTP and OLAP workloads. OLAP has not been a specialty of MySQL in the past.

Capabilities of the MySQL Analytics Engine include:

  • In-memory, hybrid columnar processing
  • Inter-node and intra-node parallelism optimised for Oracle Cloud Infrastructure
  • Distributed query processing algorithms

To add the analytics capabilities, the MySQL optimiser was enhanced to support analytics while the parser itself was unaltered. Hence, the existing MySQL syntax continues to work as is. With the analytics not requiring maintenance or development of any indexes, data updates made by users are propagated to the analytics engine and available to be queried immediately.

Supporting large volumes of data and complex queries, MySQL Database Service with MySQL Analytics Engine has use cases such as fraud detection or decision support.


Follow Us

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags Oraclemysql

Featured

Slideshows

The Kiwi channel gathers for the 2020 Reseller News Women in ICT Awards

The Kiwi channel gathers for the 2020 Reseller News Women in ICT Awards

Hundreds of leaders from the New Zealand IT industry gathered at the Hilton in Auckland on 17 November to celebrate the finest female talent in the Kiwi channel and recognise the winners of the Reseller News Women in ICT Awards (WIICTA) 2020.

The Kiwi channel gathers for the 2020 Reseller News Women in ICT Awards
Leading female front runners honoured at the 2020 Reseller News Women in ICT Awards

Leading female front runners honoured at the 2020 Reseller News Women in ICT Awards

The leading female front runners of the New Zealand ICT industry joined together for the annual Reseller News Women in ICT Awards event at the Hilton in Auckland, during which hundreds of guests celebrated 13 outstanding individuals who won awards, chosen from more than 50 finalists representing over 30 organisations.

Leading female front runners honoured at the 2020 Reseller News Women in ICT Awards
Channel gathers to celebrate the Reseller News Innovation Awards 2020 winners

Channel gathers to celebrate the Reseller News Innovation Awards 2020 winners

More than 500 channel leaders gathered in Auckland on 21 October at the ​Reseller News Innovation Awards ​2020 to celebrate the achievements of the New Zealand technology industry's top partners, start-ups, vendors, distributors and individuals.

Channel gathers to celebrate the Reseller News Innovation Awards 2020 winners
Show Comments