Scribd
Upload
6 views1 page

DWM Notes

The document covers the fundamentals of Data Warehousing and Mining Techniques, detailing the structure and purpose of data warehouses, including ETL processes and metadata. It discusses data warehouse modeling with OLAP operations and various schemas, as well as data mining basics such as market basket analysis and classification techniques. Additionally, it explores clustering methods, including K-Means and hierarchical clustering.

Uploaded by

adityapatil12564
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views1 page

DWM Notes

The document covers the fundamentals of Data Warehousing and Mining Techniques, detailing the structure and purpose of data warehouses, including ETL processes and metadata. It discusses data warehouse modeling with OLAP operations and various schemas, as well as data mining basics such as market basket analysis and classification techniques. Additionally, it explores clustering methods, including K-Means and hierarchical clustering.

Uploaded by

adityapatil12564
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

DATA WAREHOUSING AND MINING TECHNIQUES (DWM)

UNIT I to UNIT V Notes

UNIT I: Basics of Data Warehousing

Data Warehouse is a centralized system storing integrated, historical data for analysis.

Need: scattered data, slow operational DB, need for analysis and decision making.

ETL: Extract, Transform, Load.

Metadata: Data about data.

Models: Enterprise, Data Mart, Virtual Warehouse.

UNIT II: Data Warehouse Modelling & OLAP

Data Cube: Multidimensional model.

Schemas: Star, Snowflake, Fact Constellation.

Dimensions: Time, Product, Location.

OLAP Operations: Roll-up, Drill-down, Slice, Dice.

UNIT III: Data Mining Basics

Market Basket Analysis: Finding item relationships.

Frequent Itemsets and Association Rules.

Apriori Algorithm: Finds frequent patterns.

Closed and Max Patterns.

UNIT IV: Classification Techniques

Classification: Supervised learning.

Decision Tree: Tree-based model.

Bayes Classification: Probability-based.

Rule-Based: IF-THEN rules.

UNIT V: Cluster Analysis

Clustering: Unsupervised learning.

K-Means and K-Medoids.

Hierarchical Clustering: Agglomerative and Divisive.

You might also like