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

Wavenet Technology Enhances Query Speed and Efficiency with MySQL HeatWave

Oracle Logo
 Wavenet Technology Enhances Query Speed and Efficiency with MySQL HeatWave - IoT ONE Case Study
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
The 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.
The Customer

Wavenet Technology

About The 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.
The 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.
Operational Impact
  • 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.
Quantitative Benefit
  • Reduced the infrastructure’s total cost of ownership by at least 30%
  • Slashed response times for customer queries from several minutes to just a few seconds
  • Eliminated the need to run ETL processes

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.