Shenzhen Irobotbox Tech Co., Ltd. (hereinafter referred to as Irobotbox) uses AnalyticDB for MySQL in combination with Quick BI to implement a fine-grained advertisement management solution. This solution not only improves the creation efficiency and performance of advertisements, but also provides insights to help allocate advertising campaign budgets based on real-time business intelligence (BI) reports to maximize enterprise benefits.
Requirements
Irobotbox is a technical service company that delivers innovative solutions. As the number of users increases, the company identifies the following requirements for the databases they use.
- High concurrency and timeliness
When users search for products by keyword on a third-party e-commerce platform, highly concurrent query requests are generated.
- Storage of large amounts of historical data
Some users may generate 100 million rows of data each year. Storing data for 300 such users each year consumes 18 TB of storage.
- High throughput
Irobotbox allows their users to view the conversion rate and return on investment (ROI) of advertisements from dashboards in real time. During business peaks, a dashboard may make more than 100 complex queries per second (QPS).
- Fast response speed
In actual business scenarios, the ideal query response time is within 20 seconds. However, on the online transaction processing (OLTP) databases provided by some cloud vendors, the response time of GROUP BY statements may be longer than 40 seconds. This is insufficient to meet business requirements.
Solution
To meet the preceding requirements, Alibaba Cloud has developed the following solution for Irobotbox through a combination of AnalyticDB for MySQL and Quick BI. For more information, see What is AnalyticDB for MySQL?
The solution uses an AnalyticDB for MySQL cluster to store business data. The AnalyticDB for MySQL cluster is of the Cluster Edition and contains 16 C8 node groups. It can handle tens of thousands of transactions per second (TPS) and can return responses for queries that involve terabytes of data within seconds. The nodes and storage space of the cluster can be easily scaled.
Benefits
Aided by the fine-grained advertisement management solution, Irobotbox is able to deliver the following features to their users:
- Centrally manage keyword advertisements across multiple e-commerce sites and stores. Users no longer need to switch between sites.
- Identify search terms with high conversion rates through real-time analysis of large amounts of data. This helps users quickly launch advertising campaigns and improves the creation efficiency and performance of advertisements.
- Leverage the analysis results generated from large amounts of data to adjust prices by time range or business changes, so that users can avoid missing out on prime times for price adjustment.
- Query each gross profit from advertisements in real time.
- Quickly analyze keywords that are efficient or inefficient and allocate advertising campaign budgets in an appropriate manner to maximize benefits.