SYLLABUS - M.Tech 3rd Semester (CSE)

Unit - I

Data Warehousing:

Introduction to Data Warehousing: Evolution of Data Warehousing, Data Warehousing concepts, Benefits of Data Warehousing, Comparison of OLTP and Data Warehousing, Problems of Data Warehousing.

Data Warehousing Architecture

Architecture: Operational Data and Datastore, Load Manager, Warehouse Manager, Query Manager, Detailed Data, Lightly and Highly summarized Data, Archive/Backup Data, Meta-Data, architecture model, 2-tier, 3-tier and 4-tier data warehouse, End user Access tools.

Unit - II

Data Warehousing Tools and Technology

Tools and Technologies: Extraction, cleaning and Transformation tools, Data Warehouse DBMS, Data Warehouse Meta-Data, Administration and management tools, operational vs. information Systems. OLAP & DSS support in data warehouse.

Unit-3

Types of Data Warehouses & Data Warehouse Design

Host based, single stage, LAN based, Multistage, stationary distributed & virtual data-warehouses. Data warehousing Design: Designing Data warehouse Database, Database Design Methodology for Data Warehouses, Data Warehousing design Using Oracle.

Unit-4

Data Mining

Basic Data Mining tasks, Knowledge discovery in databases, Issues, OLTP systems, Fuzzy sets and Fuzzy logic, Information Retrieval, Dimensional Modeling, OLAP, Web search engines, Data Mining Techniques

Unit-5

Classification

Statistical based algorithms, Distance based algorithms

Clustering

Minimum Spanning tree, K-means clustering, Nearest neighbor algorithm

Association Rules

Large items sets, Basic Algorithms

Web Mining