Wavenet Technology runs one million-plus queries in seconds with MySQL HeatWave

Digital marketing company Wavenet Technology helps global brands across the Asia and Pacific region optimize online marketing campaigns. It uses artificial intelligence and big data analytics to enable customers to track and fine-tune marketing activities 24 hours a day in real time.

As part of the Wavenet Technology service, customers access a web dashboard to consult the latest figures on their campaigns’ performance. As the number of simultaneous dashboard queries went beyond one million, the time to extract, transform, and load (ETL) data for the reports became increasingly time-consuming. Eventually, the amount of processing exceeded the capacity of Wavenet Technology’s systems, which were running on AWS Redshift.  Customers had to wait several minutes for the systems to respond.

Because the situation began to hamper Wavenet Technology’s business development plans, the company began looking for a high-performance, secure, and affordable database that would provide the speed, power, and confidence to achieve its growth targets.

Wavenet Technology selected Oracle MySQL HeatWave running on Oracle Cloud Infrastructure (OCI) because it could support current and future processing requirements.

The company also liked the cost-effectiveness of the service and the support from the Oracle MySQL development team, which gave Wavenet confidence that security risks would be minimized, and its investment would be well protected.

OCI also provided a simple architecture that was easy to administer with limited management resources. “Oracle MySQL HeatWave could accelerate data processing, so we wouldn’t have to run ETL processes anymore,” says CTO Hung Chih Chieh.

With Oracle MySQL HeatWave running on OCI, Wavenet gained the fastest, most efficient, and cost-effective way to support its data processing needs. Plus, by moving from AWS Redshift to Oracle MySQL HeatWave, the company also reduced the infrastructure’s total cost of ownership by at least 30%.

“Since we started using MySQL HeatWave, we’re saving a lot of time and labor on exploring data and algorithms. Also, response times are very fast when modeling raw data using HeatWave. It helps to design the best algorithm for modeling our data,” says Hung Chih Chieh.

Wavenet Technology now has the processing power to develop new solutions for automating online marketing. Also, data management is significantly simpler. As a result, data managers can work directly with the raw data stored in MySQL HeatWave, eliminating the ETL process.

Response times for customer queries were slashed from several minutes to just a few seconds. Also, the company can analyze data in more sophisticated ways. “It’s easier for VIP-level customers to submit specific queries and get insights into their data. This is a very good selling point for them,” says Hung Chih Chieh.

Wavenet Technology is also using MySQL Autopilot to automate functions run through Oracle MySQL HeatWave. “We rely on Autopilot to fine-tune performance for us. It helps us dynamically configure parameters and optimize data queries,” says Johnny Hong, a data scientist at Wavenet Technology.

Next, the company will integrate Oracle Analytics Cloud for data visualization and reporting so that Wavenet can easily create and view reports on any data set within its database.