Stock Aggregation
🏹

Stock Aggregation

Project Overview
Stock aggregation
Category
batch data processing
Collaborators
Date
Dec 14, 2021
My Role
Technical Architecture
Backend Developer
Data Engineer

Project Overview

 
notion image
 
An enterprise has warehouses across the globe
Each warehouse has a local data center
A stock management application runs in each warehouse
A local MariaDB database keeps track of warehouse stock
Stock maintained by item and day - opening stock, receipts, and issues
 

Requirements

Create and manage a central, consolidated stock database
Item stock aggregated across locations on a daily basic
Batch processing to upload warehouse data into a central cloud and manage stock
Scalable to hundreds of warehouses
 

Batch processing Design

notion image