Oracle has integrated analytics to MySQL in the cloud

Spread the love

 201 views

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.

RECOMMENDED READ:  Taiwan says that its TSMC-led semiconductor industry has ample water until May

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.

-infoworld

READ ALSO:
Taiwan says that its TSMC-led semiconductor industry has ample water until May

The nation has been facing the worst drought in 56 years Taiwan has eased concerns that global semiconductor shortages could Read more

Dell’s redesigned G15 gaming laptop packs with RTX 3000 graphics and a speckled paint job.

It will initially be sold in China, but Dell did not announce any pricing for any of the three models. Read more

NFTs,  new crypto craze explained

NFTs are authenticating the originality of digital products If you've been watching tech or financial news late, you may have Read more

Leave a Reply

Your email address will not be published. Required fields are marked *