---
title: "Data warehouse vs database"
subject: "Data Mining"
chapter: 1
key: "semester_7/data_mining:dw-vs-database"
source: https://www.bctengineer.com/q/semester_7/data_mining/dw-vs-database
site: BCT Engineering
---

# Data warehouse vs database

Data Mining · Chapter 1: Introduction

- Asked in: year not given
- Video: [Database vs Data Warehouse vs Data Lake | What is the Difference?](https://www.youtube.com/watch?v=-bSkREem8dM) — Alex The Analyst
- Answer checked by Claude Opus 5.5 (high effort) on 2026-10-14
- Page: https://www.bctengineer.com/q/semester_7/data_mining/dw-vs-database
- Whole chapter: https://www.bctengineer.com/md/semester_7/data_mining/chapter-1

## Question

Differentiate between Data Warehouse and Database.

## Short answer

Databases (OLTP) store current, detailed, normalized data for transactions; data warehouses store historical, summarized, denormalized data for analysis. Warehouses are subject-oriented, larger (GB-TB), support complex queries by few users; databases are application-oriented, smaller (MB-GB), handle many short transactions.

## Answer

A **database** (operational/OLTP database) stores current data for day-to-day transactions. A **data warehouse** stores integrated historical data for analysis and decision making.

| Point | Operational database (OLTP) | Data warehouse |
|---|---|---|
| Purpose | Day-to-day transactions | Analysis and decision support |
| Data | Current, detailed | Historical, summarised and detailed |
| Orientation | Application-oriented | Subject-oriented |
| Update | Frequent insert/update/delete | Periodic bulk load, read-mostly |
| Design | Normalised (ER model) | Denormalised (star/snowflake) |
| Query | Short, simple, predefined | Complex, ad hoc, aggregate |
| Users | Clerks, DBAs (thousands) | Managers, analysts (few) |
| Size | MB to GB | GB to TB |

Example: a bank's database records every deposit and withdrawal as it happens; its warehouse stores 10 years of summarised transactions to analyse customer behaviour.

## Check yourself

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

1. Warehouse orientation is:
   A. Application-oriented
   B. Subject-oriented
   C. Transaction-oriented
   D. User-oriented
   Answer: B. Operational databases are application-oriented. (Key point: Orientation)

2. A data warehouse stores:
   A. Only current data
   B. Integrated historical data for analysis
   C. Only temporary data
   D. Only logs
   Answer: B. Example: 10 years of summarised transactions. (Key point: Data type)

3. Warehouse updates are:
   A. Frequent single-row inserts
   B. Periodic bulk loads, read-mostly
   C. Never loaded
   D. Only deletes
   Answer: B. OLTP DBs have frequent insert/update/delete. (Key point: Update pattern)

## Related in Data Mining

- [DMQL; transactional vs warehouse database](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Admql-transactional-vs-dw) — Data Mining, chapter 2
- [DW characteristics vs operational database](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adw-characteristics-vs-operational) — Data Mining, chapter 1
- [RDBMS vs DW database; DW terms](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Ardbms-vs-dw-terms) — Data Mining, chapter 1
- [Data warehouse, data mart and need](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Awarehouse-datamart-need) — Data Mining, chapter 1
- [Data warehouse architecture and components](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adw-architecture-components) — Data Mining, chapter 1
- [Data warehouse schemas](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adw-schema-types) — Data Mining, chapter 1

## Related in other subjects

- [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×
- [Hybrid data in big data warehouse](https://www.bctengineer.com/question.md?key=semester_8%2Fbig_data_technologies%3Ahybrid-data-warehouse) — Big Data Technologies, chapter 1
- [Primitive vs non-primitive data structure](https://www.bctengineer.com/question.md?key=semester_4%2Fdata_structure_and_algorithm%3Aprimitive-vs-nonprimitive) — Data Structure and Algorithm, chapter 1