Oracle is integrating OLTP (online deal processing) and OLAP (online analytical processing) services in its open source MySQL database in the Oracle Cloud, through Oracle MySQL Database Service with the MySQL Analytics Engine.
With this Oracle Cloud service being presented December 2, users get the capability to run advanced analytics versus their functional MySQL database. The MySQL Analytics Engine is an in-memory analytics accelerator that can scale to countless Oracle Cloud Facilities (OCI) cores.
Placed to take on the Amazon Redshift cloud information storage facility, the Oracle MySQL Database Service with the MySQL Analytics Engine conserves users from needing to incorporate with a different analytics database. Database administrators and designers get a combined platform for OLTP and OLAP work. OLAP has actually not been a specialized of MySQL in the past.
Abilities of the MySQL Analytics Engine consist of:
- In-memory, hybrid columnar processing
- Inter-node and intra-node parallelism enhanced for Oracle Cloud Facilities
- Dispersed inquiry processing algorithms
To include the analytics abilities, the MySQL optimizer was boosted to support analytics while the parser itself was unchanged. For this reason, the existing MySQL syntax continues to work as is. With the analytics not needing upkeep or advancement of any indexes, information updates made by users are propogated to the analytics engine and readily available to be queried right away.
Supporting big volumes of information and complicated questions, MySQL Database Service with MySQL Analytics Engine has usage cases such as scams detection or choice assistance. The signup for the service can be discovered at oracle.com.
Copyright © 2020 IDG Communications, Inc.