Rockset > Case Studies > How Dimona Built a Real-Time Inventory Management System on Rockset

How Dimona Built a Real-Time Inventory Management System on Rockset

Customer Company Size

Large Corporate

Region

America

Country

Brazil
United States

Product

Amazon Aurora
Rockset
Amazon Database Migration Service (DMS)

Tech Stack

MySQL
AWS
REST API

Implementation Scale

Enterprise-wide Deployment

Impact Metrics

Productivity Improvements
Customer Satisfaction

Technology Category

Analytics & Modeling - Real Time Analytics
Platform as a Service (PaaS) - Data Management Platforms

Applicable Industries

Apparel

Applicable Functions

Warehouse & Inventory Management
Logistics & Transportation

Use Cases

Inventory Management
Real-Time Location System (RTLS)

Services

System Integration

About The Customer

Dimona is a prominent apparel company based in Brazil, with a rich history spanning 55 years. Specializing in t-shirts, Dimona designs, manufactures, and sells its products both online and through five retail stores located in Rio de Janeiro. The company also caters to B2B clients, offering custom designs and drop shipping services in Brazil and the United States. Since its inception, Dimona has been at the forefront of innovation in the Latin American apparel industry, introducing APIs and fast-turnaround drop shipping. This has allowed the company to grow rapidly, now serving over 80,000 B2B customers with factories in Rio de Janeiro and South Florida. Dimona's vertically-integrated business model and extensive supply chain require meticulous tracking of raw materials and finished products, making efficient inventory management crucial for its operations.

The Challenge

Dimona, a leading apparel company in Latin America, faced significant challenges with its inventory management system due to its vertically-integrated business model and extensive supply chain. The company needed to track raw fabric, t-shirts in various production stages, and finished products across multiple locations. The existing off-the-shelf ERP systems were inadequate, as they only allowed for end-of-day inventory counts, leading to errors and mistrust in the data. Additionally, the company's use of Amazon Aurora for its custom-built inventory management system resulted in performance issues as the volume of data increased, especially with the expansion of warehouses and stores. The COVID-19 pandemic further exacerbated the situation, as international demand for Dimona's drop shipment services increased, leading to an unusable inventory management system and high costs for simple data aggregations.

The Solution

To address the challenges faced by Dimona, the company explored various technology solutions before selecting Rockset as the core of its new inventory management system. Rockset, a real-time analytics database, was chosen for its ability to handle large data sets and perform fast, automated queries. Dimona continued to use Amazon Aurora for data ingestion, while Amazon's Database Migration Service (DMS) was employed to replicate data from Aurora to Rockset. This setup allowed Rockset to perform all data processing, aggregations, and calculations, providing near-real-time, accurate views of inventory. Rockset's Query Lambda capability enabled Dimona to pre-create named, parameterized SQL queries, simplifying management and enhancing security. The integration with MySQL and the speed of DMS replication ensured that inventory data was available to users instantly, improving the overall efficiency of Dimona's operations.

Operational Impact

Rockset provided Dimona with precise, accurate views of inventory in near-real time, enhancing the company's ability to track its supply chain and predict demand spikes and shortages.
The use of Rockset's Query Lambdas and APIs reduced the amount of data processing required, accelerating response times for customer inquiries and internal searches.
Rockset eliminated database timeouts, ensuring consistent performance and reliability for Dimona's inventory management system.
The integration with Rockset allowed Dimona to maintain confidence in the accuracy of its inventory data without the need for constant double-checking against daily counts.
Rockset's implementation enabled Dimona to thrive during peak periods, such as Black Friday and Christmas, by providing unprecedented visibility into inventory and supply chain operations.

Quantitative Benefit

Rockset's integration allowed for the replication of over one million Aurora documents to Rockset every minute, ensuring data availability to users instantly.