---
title: "Short note: data mining and warehousing"
subject: "Information System"
chapter: 4
key: "semester_8/information_system:data-mining-and-warehousing-note"
source: https://www.bctengineer.com/q/semester_8/information_system/data-mining-and-warehousing-note
site: BCT Engineering
---

# Short note: data mining and warehousing

Information System · Chapter 4: Decision support and Intelligent systems

- Asked in: 2072 Asoj, 5 marks
- Video: [Data Warehouse and Data Mining, Information management](https://www.youtube.com/watch?v=6_QLB0q_-vA) — DWIVEDI GUIDANCE
- Answer checked by Claude Opus 5.5 (high effort) on 2026-10-14
- Page: https://www.bctengineer.com/q/semester_8/information_system/data-mining-and-warehousing-note
- Whole chapter: https://www.bctengineer.com/md/semester_8/information_system/chapter-4

## Question

Write a short note on Data mining and data ware housing.

## Short answer

A data warehouse integrates historical data from multiple sources via ETL for analysis. Data mining discovers patterns like classification and clustering from large datasets; it relies on the warehouse for clean, integrated data.

## Answer

#### Data warehousing
A **data warehouse** is a centralised repository of integrated, subject-oriented, time-variant, non-volatile data from multiple operational systems, designed for query, reporting and analysis rather than transaction processing. Data is Extracted, Transformed and Loaded (ETL) into the warehouse, and often organised in star or snowflake schemas. Data marts are smaller departmental subsets. OLAP tools provide roll-up, drill-down, slice and dice.

```text
 Sources -> ETL -> Warehouse -> OLAP / Mining / Reports
```

#### Data mining
**Data mining** is the process of discovering previously unknown, useful patterns and relationships in large databases using statistics, machine learning and database techniques. It is a step of Knowledge Discovery in Databases (KDD).

Main techniques:
- **Classification** - assign records to known classes (loan risk).
- **Clustering** - group similar records (customer segments).
- **Association rules** - items bought together (market basket).
- **Regression/prediction** - forecast values.
- **Anomaly detection** - fraud.

**Relationship:** the warehouse provides clean, integrated data; mining extracts knowledge from it. Applications: retail, banking, telecom, healthcare and fraud detection.

## Check yourself

The answer's key points as multiple-choice questions, with the correct option and why.

1. How does data get into a warehouse?
   A. By typing manually every transaction
   B. Through Extract, Transform, Load (ETL) from operational systems
   C. Directly from users' keyboards
   D. By deleting sources
   Answer: B. ETL loads integrated data from multiple sources. (Key point: Warehouse)

2. What is a data mart?
   A. A shop selling data
   B. A backup tape
   C. A smaller departmental subset of a warehouse
   D. The mining algorithm
   Answer: C. Data marts are smaller departmental subsets. (Key point: Data mart)

3. Grouping similar records into customer segments is which technique?
   A. Classification
   B. Regression
   C. Association rules
   D. Clustering
   Answer: D. Clustering groups similar records without predefined classes; classification assigns to known classes. (Key point: Classification vs clustering)

4. Market basket analysis uses which technique?
   A. Association rules
   B. Clustering
   C. Anomaly detection
   D. Regression
   Answer: A. Association rules find items bought together. (Key point: Association)

5. Data mining is a step of which process?
   A. ETL only
   B. Knowledge Discovery in Databases (KDD)
   C. OLTP
   D. Normalisation
   Answer: B. Mining is a KDD step finding previously unknown useful patterns. (Key point: Mining definition)

## Related in Information System

- [Data warehouse and data mining](https://www.bctengineer.com/question.md?key=semester_8%2Finformation_system%3Adata-warehouse-data-mining) — Information System, chapter 4, asked 2×
- [Data mining and business knowledge](https://www.bctengineer.com/question.md?key=semester_8%2Finformation_system%3Adata-mining-business-knowledge) — Information System, chapter 4

## Related in other subjects

- [Define data warehousing and creation process](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adw-creation-process) — Data Mining, chapter 1
- [Data mining and its applications](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adm-banking-biomedical) — Data Mining, chapter 1
- [Data mining vs DW and applications](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adm-vs-dw-applications) — Data Mining, chapter 1
- [CRM; security and privacy of data mining](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Acrm-security-privacy) — Data Mining, chapter 7