BAMU Final Year IT syllabus

BAMU · Final Year B.E. Information Technology · CBCS (2019)

Data Warehousing and Data Mining

CSE401 · Semester VII · 4 credits · CT 20 + theory 80

All notes for this subject
  1. Unit 1: Data Warehousing

    6 hours

    Data warehouse basics, the multitiered architecture, enterprise warehouses and data marts, ETL and the metadata repository.

    Examined in the 80-mark end-semester paper

    • Data warehouse architecture
    • Data warehouse components and metadata
    • ETL
  2. Unit 2: Data Warehouse Modeling and Implementation

    8 hours

    The data cube and star, snowflake and fact-constellation schemas; concept hierarchies and measures; OLAP operations; data objects, attribute types, statistical descriptions and similarity measures.

    Examined in the 80-mark end-semester paper

    • Star, snowflake and fact constellation schemas
    • Data cube and OLAP operations
    • OLAP: ROLAP, MOLAP and HOLAP
    • Measuring data similarity and dissimilarity
  3. Unit 3: Data Mining

    6 hours

    Kinds of data, data mining functionalities and interestingness of patterns, classification of systems, task primitives, integration with a warehouse, issues and preprocessing.

    Examined in the 80-mark end-semester paper

    • Active databases and the KDD process
    • Data mining functionalities and system classification
    • Data cleaning and transformation
  4. Unit 4: Association Rule Mining and Classification

    8 hours

    Frequent patterns, association and correlation mining, constraint-based mining; decision trees, Bayesian and rule-based classification, SVMs and regression models.

    Examined in the 80-mark end-semester paper

    • Association rules and the Apriori algorithm
    • Decision tree and Bayesian classification
    • Support vector machines and regression models
  5. Unit 5: Clustering

    6 hours

    Cluster analysis; k-means, hierarchical, agglomerative and divisive clustering; web content, structure and usage mining.

    Examined in the 80-mark end-semester paper

    • Clustering: partitioning, hierarchical and density-based methods
    • Web content, structure and usage mining
  6. Unit 6: Business Intelligence

    6 hours

    Business intelligence, its tools, infrastructure and applications; BI versus data warehousing and data mining; the future of BI.

    Examined in the 80-mark end-semester paper

    • Business intelligence tools and applications

Unit contents are summarised from the official BAMU syllabus . AiCanCode.org is not affiliated with Dr. Babasaheb Ambedkar Marathwada University (BAMU).