Taobao.com is one of the world’s largest e-commerce websites. It currently has nearly 500 million registered users and has more than 60 million regular visitors every day. The number of products online per day has exceeded 800 million, and an average of 48,000 products are sold per minute. The favorites feature is very popular among Taobao (Tmall) users. When browsing Taobao.com, users add their favorite products or stores to favorites so that they can view these products or stores later. Users can also share their favorite products or stores with friends. The favorites feature of Taobao has served 800 million users and has a data volume of hundreds of terabytes.

The write throughput of Taobao favorites is tens of millions per day. The maximum number of writes is tens of thousands per second. Queries of favorites are join queries of favorites records and product information. On average, each query involves hundreds of favorites records. During the Double 11 Shopping Festival, up to hundreds of thousands of favorites records are queried per second. The favorites feature has high requirements on database performance.

ApsaraDB for OceanBase allows the data of a single table to be distributed across dozens of affordable micro-servers. These servers support high-intensity writes every day, which ensures optimal write performance. ApsaraDB for OceanBase has been deployed across three data centers for disaster recovery. If one data center fails, user access is not affected. The materialized view feature provided by ApsaraDB for OceanBase eliminates the need for join queries and improves the query capability of the database by dozens of times. This ensures that users are satisfied with their experience when querying favorites during the Double 11 Shopping Festival.