- 2063 · 10 marks
Kathmandu Mall warehouse architecture
Short answer
Process architecture: load manager extracts from POS, inventory, supplier, loyalty, and finance; warehouse manager transforms and summarizes; data marts for sales, stock, customer; query manager serves reports, OLAP, mining. Responsibilities go to project manager, business analyst, data architect, ETL developers, warehouse/query manager teams, front-end developers, QA, and support, starting with the sales data mart.
"The Kathmandu Mall" is one of the largest departmental stores in the valley. Assume your project team got the opportunity to build the warehouse system of this departmental store. Develop the process architecture of the warehouse system and explain how you manage the responsibilities to build the warehouse.
Assumptions
The Kathmandu Mall has several branches and departments (grocery, clothing, electronics). Data sources are: point-of-sale (billing) system, inventory system, supplier/purchase system, customer loyalty card database and the HR/finance system. Management wants analysis of sales, stock and customer behaviour.
Process architecture
POS | Inventory | Supplier | Loyalty | Finance
\ | | | /
v v v v v
+-------------------------+
| LOAD MANAGER |
| extract, clean, load |
+-----------+-------------+
v
+-------------------------+
| WAREHOUSE MANAGER |
| transform, summarise, |
| index, back-up, archive |
+-----------+-------------+
v
+---------------------------------------+
| Detailed sales | Summaries | Metadata |
| Data marts: Sales, Stock, Customer |
+-------------------+-------------------+
v
+-------------------------+
| QUERY MANAGER |
+-----------+-------------+
v
Reports | OLAP | Data mining (market basket)
Responsibilities and project management
| Team / module | Responsibility |
|---|---|
| Project manager | Plan, budget, schedule, risk, liaison with mall management |
| Business analyst | Collect requirements, define KPIs (sales per branch, stock turnover) |
| Data architect / DBA | Design star schemas (Sales fact with time, product, branch, customer dimensions), metadata |
| ETL developers (load manager) | Extract from POS and other systems, clean, load nightly |
| Warehouse manager team | Transformation, aggregation, indexing, backup, archiving |
| Query manager team | Query routing, query profiles, access control, performance |
| Front-end developers | Reports, dashboards, OLAP cubes, mining tools |
| QA team | Test data accuracy and performance |
| Support / admin | Training, security, maintenance |
Build order: start with the Sales data mart (highest value), then Inventory, then Customer, following a bottom-up approach, each delivered in a few months and integrated through conformed dimensions (product, time, branch).
✓ Answer checked by Claude Opus 5.5 (high effort)
Related questions
- College warehouse project leader responsibilities · Data Mining, chapter 1
- National data warehouse process architecture · Data Mining, chapter 1
- Warehouse architecture and three phases · Data Mining, chapter 1
- Data warehouse architecture and components · Data Mining, chapter 1
- Typical process flow in warehouse · Data Mining, chapter 1
- Short note: DW process architecture · Data Mining, chapter 1
- Report on sound pollution in Kathmandu Valley · Communication English, chapter 9
- Book store process model · Software Engineering, chapter 2
- Manage risk; qualitative and quantitative system · Project Engineering, chapter 5
- Steps to build a hydro project and sell to NEA · Power Plant Design, chapter 3 · asked 4×