Data Warehousing & Data Mining

Data Warehousing & Data Mining

Analogy with a Warehouse What is a warehouse? How it works? What are the concepts behind a typical warehouse? What service is provided by the warehouse?

DW Architecture

Concepts of DW Multiple sources of Information Stored at a single site (central repository) Stored in Unified Schema Stores current & historical data Management Decision Support Subject Oriented (Prod/Engg./Sales/Cust.) Integrated Time Oriented

Applications of DW Routine business reports in different functional areas – Sales, production, Engineering, Purchase, stores, customers, quality etc. Exclusive and exceptional reports Online reports based on current data Web-based reports (multi location organizations) Reports exclusive to the organizations

Data Mining Analogy with a mining process Going into the depth of data Data mining can be done after data warehousing Non-trivial extraction of data Previously unknown data Potentially useful data Its knowledge discovery in Databases

Technical approaches in DM Detecting anomalies Clustering Data summarization Discovering patterns Hidden information