Oracle Case Studies Wavenet Technology Enhances Query Speed and Efficiency with MySQL HeatWave

Edit This Case Study Record

	Wavenet Technology Enhances Query Speed and Efficiency with MySQL HeatWave Oracle

Wavenet Technology Enhances Query Speed and Efficiency with MySQL HeatWave

Oracle

Technology Category	Analytics & Modeling - Big Data Analytics Application Infrastructure & Middleware - Data Visualization
Applicable Industries	Cement Construction & Infrastructure
Applicable Functions	Product Research & Development Sales & Marketing
Use Cases	Construction Management Track & Trace of Assets
Services	Cloud Planning, Design & Implementation Services Data Science Services
Challenge	Wavenet Technology, a digital marketing company, assists global brands in optimizing their online marketing campaigns using artificial intelligence and big data analytics. Customers access a web dashboard to monitor their campaigns’ performance in real time. However, as the number of simultaneous dashboard queries exceeded one million, the time to extract, transform, and load (ETL) data for the reports became increasingly lengthy. The processing exceeded the capacity of Wavenet Technology’s systems, which were running on AWS Redshift, causing customers to wait several minutes for the systems to respond. This situation began to hinder Wavenet Technology’s business development plans, prompting the company to seek a high-performance, secure, and affordable database that could support its growth targets. Read More
About Customer	Wavenet Technology is a digital marketing company that assists global brands across the Asia and Pacific region in optimizing their online marketing campaigns. The company uses artificial intelligence and big data analytics to enable customers to track and fine-tune their marketing activities 24 hours a day in real time. Customers access a web dashboard provided by Wavenet Technology to consult the latest figures on their campaigns’ performance. The company was facing challenges with the increasing number of simultaneous dashboard queries, which exceeded the capacity of their systems running on AWS Redshift. Read More
Customer Name	Wavenet Technology Read More
Solution	Wavenet Technology chose Oracle MySQL HeatWave running on Oracle Cloud Infrastructure (OCI) to support its current and future processing requirements. The company was attracted by the cost-effectiveness of the service and the support from the Oracle MySQL development team, which assured Wavenet that security risks would be minimized and its investment would be well protected. OCI also offered a simple architecture that was easy to administer with limited management resources. Oracle MySQL HeatWave could accelerate data processing, eliminating the need to run ETL processes. Wavenet Technology is also using MySQL Autopilot to automate functions run through Oracle MySQL HeatWave, which helps dynamically configure parameters and optimize data queries. The company plans to integrate Oracle Analytics Cloud for data visualization and reporting. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Big Data Analytics

Application Infrastructure & Middleware - Data Visualization

Applicable Industries

Cement

Construction & Infrastructure

Applicable Functions

Product Research & Development

Sales & Marketing

Use Cases

Construction Management

Track & Trace of Assets

Services

Cloud Planning, Design & Implementation Services

Data Science Services

Challenge

Wavenet Technology, a digital marketing company, assists global brands in optimizing their online marketing campaigns using artificial intelligence and big data analytics. Customers access a web dashboard to monitor their campaigns’ performance in real time. However, as the number of simultaneous dashboard queries exceeded one million, the time to extract, transform, and load (ETL) data for the reports became increasingly lengthy. The processing exceeded the capacity of Wavenet Technology’s systems, which were running on AWS Redshift, causing customers to wait several minutes for the systems to respond. This situation began to hinder Wavenet Technology’s business development plans, prompting the company to seek a high-performance, secure, and affordable database that could support its growth targets.

About Customer

Wavenet Technology is a digital marketing company that assists global brands across the Asia and Pacific region in optimizing their online marketing campaigns. The company uses artificial intelligence and big data analytics to enable customers to track and fine-tune their marketing activities 24 hours a day in real time. Customers access a web dashboard provided by Wavenet Technology to consult the latest figures on their campaigns’ performance. The company was facing challenges with the increasing number of simultaneous dashboard queries, which exceeded the capacity of their systems running on AWS Redshift.

Customer Name

Wavenet Technology

Solution

Wavenet Technology chose Oracle MySQL HeatWave running on Oracle Cloud Infrastructure (OCI) to support its current and future processing requirements. The company was attracted by the cost-effectiveness of the service and the support from the Oracle MySQL development team, which assured Wavenet that security risks would be minimized and its investment would be well protected. OCI also offered a simple architecture that was easy to administer with limited management resources. Oracle MySQL HeatWave could accelerate data processing, eliminating the need to run ETL processes. Wavenet Technology is also using MySQL Autopilot to automate functions run through Oracle MySQL HeatWave, which helps dynamically configure parameters and optimize data queries. The company plans to integrate Oracle Analytics Cloud for data visualization and reporting.

Impact #1	With Oracle MySQL HeatWave running on OCI, Wavenet Technology found the fastest, most efficient, and cost-effective way to support its data processing needs. The company now has the processing power to develop new solutions for automating online marketing. Data management has become significantly simpler, allowing data managers to work directly with the raw data stored in MySQL HeatWave, thereby eliminating the ETL process. The company can now analyze data in more sophisticated ways, making it easier for VIP-level customers to submit specific queries and gain insights into their data. This has become a strong selling point for them. Wavenet Technology is also using MySQL Autopilot to automate functions run through Oracle MySQL HeatWave, which helps dynamically configure parameters and optimize data queries.

Impact #1

With Oracle MySQL HeatWave running on OCI, Wavenet Technology found the fastest, most efficient, and cost-effective way to support its data processing needs. The company now has the processing power to develop new solutions for automating online marketing. Data management has become significantly simpler, allowing data managers to work directly with the raw data stored in MySQL HeatWave, thereby eliminating the ETL process. The company can now analyze data in more sophisticated ways, making it easier for VIP-level customers to submit specific queries and gain insights into their data. This has become a strong selling point for them. Wavenet Technology is also using MySQL Autopilot to automate functions run through Oracle MySQL HeatWave, which helps dynamically configure parameters and optimize data queries.

Benefit #1	Reduced the infrastructure’s total cost of ownership by at least 30%
Benefit #2	Slashed response times for customer queries from several minutes to just a few seconds
Benefit #3	Eliminated the need to run ETL processes

Benefit #1

Reduced the infrastructure’s total cost of ownership by at least 30%

Benefit #2

Slashed response times for customer queries from several minutes to just a few seconds

Benefit #3

Eliminated the need to run ETL processes

Download PDF Version

Overview

Wavenet Technology Enhances Query Speed and Efficiency with MySQL HeatWave

Operational Impact

Quantitative Benefit