Oracle Analytics Cloud Dashboard Solutions | MySQL Heatwave

Challenges of MySQL for OLTP Processing

As you may know, MySQL is only optimized for OLTP - but it isn’t designed for analytics processing (OLAP). As a result, you must move your data to another database if required to run analytics efficiently. It can lead to challenges such as:

Mysql

Lengthy ETL process with only periodic updates of data rather than real-time data

Mysql

Stale data that makes it challenging to make critical decisions

Mysql

Additional expenses of maintaining two separate databases

Aspire’s OAC Dashboard-Based Solution

To help overcome these problems, Aspire Systems has built an Oracle Analytics Cloud (OAC) dashboardbased solution that offers 360-degree data analytics. This solution leverages the Oracle MySQL HeatWave to enable rapid-fire query processing with a high real-time analytics performance. It has a single database platform for Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP). Hence, there is no need for ETL data in a separate database for processing analytics.

How The Solution Works

Create a Virtual Cloud Network & allow traffic via MySQL database service port

Create a Bastion host compute instance

Connect to the Bastion host

Install MySQL Shell and download the sample dataset

Create an Oracle Analytics Cloud instance

Create an instance of MySQL in the cloud

Enable HeatWave Cluster to MySQL database service

Configure Private Access Channel – OAC

Import data into MDS and load tables to HeatWave

Execute queries via HeatWave & compare the query execution time

key-solution

Key Solution Differentiators

key-solution

Leverage ML-based automation to improve performance, scalability, and ease of use of Oracle MySQL HeatWave.

key-solution

Enable MySQL users to train models and generate inferences and explanations without needing extensive ML expertise.

key-solution

Automate database lifecycle operations - including provisioning, data loading, query processing, and error handling.

key-solution

Create a dashboard by creating a connection in the OAC instance to connect to the MySQL database service.

oracle

Accelerate and maximize your Oracle-powered digital transformation

Related Content

BLOG

Elevate your business with Oracle Analytics Cloud-driven data-rich insights

Read more

BLOG

Explore new capabilities in Oracle Analytics Cloud Release 5.9

Read more

BLOG

Oracle MySQL Heatwave Improves Analytics Performance, Eliminates ETL and Server Maintenance

Read more

BLOG

How to Transform and Enrich Data in Oracle Analytics Cloud?

Read more

BLOG

Oracle Analytics Cloud: How to Create Services?

Read more

© Copyrights Aspire Systems