Source Of Summary:

Lec.8.D. M. spring 2025.pdf

🚀 Data Mining and Data Warehousing

📚 1. Building Data Warehouse

• Data Selection: Choosing relevant data for the warehouse ✅
• Data Pre-processing: Cleaning and preparing data 🔄
• Data Transformation & Integration: Converting and merging data sources 🔗
• Data Loading: Inserting processed data into warehouse 📥
• NB: Data in warehouse is stored in form of fact tables and dimension tables 🗄️

🏛️ 2. Data Warehouse Architectures

2.1 Generic Two-Level Architecture

• ETL: Extraction, Transformation, Loading sequence 🔄
• One company-wide warehouse for periodic extraction (data not completely current) ⏳

2.2 Independent Data Mart Architecture

• Data Marts: Mini-warehouses limited in scope 📊
• Separate ETL for each independent data mart 🔄
• Complex Data Access due to multiple marts ⚠️