Oracle MySQL Database Service and MySQL Analytics Engine merge OLTP and OLAP in the same MySQL database in the Oracle Cloud. Oracle integrates OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) services in its open source MySQL database in the Oracle Cloud through the Oracle MySQL Database Service with the MySQL Analytics Engine.
With the launch of the Oracle Cloud service on December 2, users will be able to run sophisticated analytics against their MySQL operating database. MySQL Analytics Engine is an in-memory analytics accelerator that can scale up to thousands of Oracle Cloud Infrastructure (OCI) cores. The Oracle MySQL Database Service with MySQL Analytics Engine, which is positioned to compete with the Amazon Redshift cloud data warehouse, saves users from having to integrate with a separate analytics database.
Database administrators and developers are provided with a single interface for OLTP and OLAP workloads. In the past, OLAP has not been a MySQL speciality.
Capabilities of the MySQL Analytics Engine include:
- In-memory, hybrid columnar processing
- Inter-node and intra-node parallelism optimized for Oracle Cloud Infrastructure
- Distributed query processing algorithms
To add analytics capabilities, the MySQL optimiser was improved to support analytics while the parser itself stayed unchanged. The current MySQL syntax continues to work as it is. In the event that an analysis does not require the maintenance or creation of any indexes, the data changes made by users are promoted to the analytics engine and are available for immediate query.
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. The signup for the service can be found at oracle.com.