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:
Lengthy ETL process with only periodic updates of data rather than real-time data
Stale data that makes it challenging to make critical decisions
Additional expenses of maintaining two separate databases
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.
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
Leverage ML-based automation to improve performance, scalability, and ease of use of Oracle MySQL HeatWave.
Enable MySQL users to train models and generate inferences and explanations without needing extensive ML expertise.
Automate database lifecycle operations - including provisioning, data loading, query processing, and error handling.
Create a dashboard by creating a connection in the OAC instance to connect to the MySQL database service.
Accelerate and maximize your Oracle-powered digital transformation
© Copyrights Aspire Systems