Civil Aviation Authority of Nepal2077 BSQuestion 15 of 18
Write a brief note on Data Warehouse and Data Mining.
5 marks
Question source
- Exam year
- 2077 BS / 2021 AD
- Level
- Level 5 (Prabidhik, IT, Barishtha Sahayak)
- Paper
- Paper II – Sewa Sambandhi
- Section
- Section B
Model answer
Data Warehouse is a central, historical, read-only store merging data from many sources for analysis (not daily transactions). Example: all CAAN flight, passenger and revenue records 2070–2080 in one warehouse. Features: subject-oriented, time-variant, non-volatile.
Data Mining is discovering hidden patterns from that store using statistics/ML. Example: mine warehouse to find "Friday evening Pokhara flights 95% full → add extra flight". Techniques: classification, clustering, association ("passengers booking X also book Y").
Warehouse = organized library, Mining = finding insights from it.