The Story of Revamping the Ranking System

The ranking GNB on Oliveyoung's online mall is a core area that records high inflow rate and conversion rate. Previously, it used an Oracle procedure to calculate rankings by category and merge them, but faced problems such as batch time delays due to ranking segmentation and reduced efficiency in DB resource consumption.

To solve this, a Serverless architecture was adopted to separate storage and compute resources. The goal was to secure scalability while minimizing the load on the existing online mall DB.

The main technology stack and implementation details are as follows:

• AWS Glue: Introduced to simplify the ETL process and manage the data catalog, and it performs efficient data transformation through the Visual ETL feature.
• Crawler: Used to automatically scan and transform the data schema.
• Connector: Configured to securely connect to external DBs such as RDB from ETL Jobs.

Through this revamp, a structure that makes future service expansion easy was established, including adding ranking types, integrating Open Search, and introducing real-time data Queuing.