munotes®
Sign in
Home / Syllabus / B.E. (Artificial Intelligence and Data Science) / TY BE AI and DS / Semester 5 / Data Warehousing and Mining

B.E. (Artificial Intelligence and Data Science) Data Warehousing and Mining Syllabus - Mumbai University

This is the TY BE AI and DS syllabus under CBCS REV-2019 'C' Scheme, in force from the academic year 2022-23. The University has published no NEP 2020 syllabus for Semesters V to VIII of any engineering branch, so this is the scheme you are examined on — exam form 1T01815 and 1T01816. The first and second years of the degree are on NEP 2020.

Data Warehousing and Mining.pdf
Semester 5 · TY BE AI and DS · 3 credits · CBCS REV-2019 'C' Scheme

Loading syllabus...

Syllabus for Data Warehousing and Mining

Semester 5 · TY BE AI and DS · 3 credits · CBCS REV-2019 'C' Scheme

Module 1 9 hours

  • Data Warehouse and OLAP
  • Data Warehousing, Dimensional Modeling and OLAP The Need for Data Warehousing; Data Warehouse Defined; Benefits of Data Warehousing ; Features of a Data Warehouse; Data Warehouse Architecture; Data Warehouse and Data Marts; Data Warehousing Design Strategies. Dimensional Model Vs ER Model; The Star Schema, The Snowflake Schema; Fact Tables and Dimension Tables; Factless Fact Table; Updates To Dimension Tables, Primary Keys, Surrogate Keys & Foreign Keys; Aggregate Tables; Fact Constellation Schema or Families of Star Need for Online Analytical Processing; OLTP vs OLAP; OLAP Operations in a cube: Roll-up, Drilldown, Slice, Dice, Pivot ; OLAP Models: MOLAP, ROLAP, HOLAP. Major steps in ETL Process

Module 2 8 hours

  • Introduction to Data Mining ,Data Exploration and Data Preprocessing
  • Data Mining Task primitives,Architecture,KDD process,Issues in data Mining,Types of Attributes; Statistical Description of Data; Data Visualization; Measuring similarity and dissimilarity. Why Preprocessing? Data Cleaning; Data Integration; Data Reduction: Attribute subset selection, Histograms, Clustering and Sampling; Data Transformation & Data Discretization: Normalization, Binning, Histogram Analysis and Concept hierarchy generation.

Module 3 6 hours

  • Classification
  • Basic Concepts; Classification methods: 1. Decision Tree Induction: Attribute Selection Measures, Tree pruning. 2. Bayesian Classification: Naïve Bayes‟ Classifier. Prediction: Structure of regression models; Simple linear regression, Multiple linear regression. Accuracy and Error measures, Precision, Recall

Module 4 4 hours

  • Clustering
  • Cluster Analysis: Basic Concepts; Partitioning Methods: K-Means, KMediods; Hierarchical Methods: Agglomerative, Divisive, BIRCH;Density-Based Methods: DBSCAN What are outliers? Types, Challenges; Outlier Detection Methods: Supervised, Semi Supervised, Unsupervised, Proximity based, Clustering Based

Module 5 8 hours

  • Frequent Pattern
  • Market Basket Analysis, Frequent Itemsets, Closed Itemsets, and Association Rules; Frequent Pattern Mining, Efficient and Scalable Frequent Itemset Mining Methods, The Apriori Algorithm for finding Frequent Itemsets Using Candidate Generation, Generating Association Rules from Frequent Itemsets, Improving the Efficiency of Apriori, A pattern growth approach for mining Frequent Itemsets; Mining Frequent itemsets using vertical data formats; Introduction to Mining Multilevel Association Rules and Multidimensional Association Rules; From Association Mining to Correlation Analysis, lift, ; Introduction to Constraint-Based Association Mining

Module 6 4 hours

  • Web Mining
  • Introduction to Web content Mining, Crawlers, Personalization, Webstructure mining, Page rank,, Clever, Web Usage Mining

Text Books

  • 1 Han, Kamber, "Data Mining Concepts and Techniques", Morgan Kaufmann 3nd Edition
  • 2 P. N. Tan, M. Steinbach, Vipin Kumar, "Introduction to Data Mining", Pearson Education.
  • 3 Paulraj Ponniah, "Data Warehousing: Fundamentals for IT Professionals", Wiley India.
  • 4 Raghu Ramakrishnan and Johannes Gehrke, "Database Management Systems" 3rd Edition -McGraw Hill
  • 5 Elmasri and Navathe, "Fundamentals of Database Systems", 6th Edition, PEARSON Education

References

  • 1 Theraja Reema, "Data Warehousing", Oxford University Press, 2009
  • 2 Ralph Kimball, Margy Ross, "The Data Warehouse Toolkit: The Definitive Guide To Dimensional Modeling", 3rd Edition. Wiley India.
  • 3 Michael Berry and Gordon Linoff "Mastering Data Mining- Art & science of CRM", Wiley Student Edition
  • 4 Michael Berry and Gordon Linoff "Data Mining Techniques", 2nd Edition Wiley Publications

Useful Links

  • https://www.coursera.org/learn/data-warehousing-business-intelligence
  • https://www.coursera.org/specializations/data-mining-foundations-practice
  • https://onlinecourses.nptel.ac.in/noc20_cs12/preview
  • https://nptel.ac.in/courses/106105174

Reproduced from the University of Mumbai syllabus for B.E. (Artificial Intelligence and Data Science), item 6.42 (R), under CBCS REV-2019 'C' Scheme, in force from the academic year 2022-23. Wording, module numbering and hours are as printed in that syllabus.

The complete syllabus

This subject is cut from the University circular for its year. Open a document here if you want the whole thing rather than a single subject.

PDF B.E. Artificial Intelligence and Data Science - First Year, Semester I and II - NEP 2020 - Item 7.7 (R-A) NEP 2020, Semesters I and II, in force from 2024-25 Read full PDF Read
PDF B.E. Artificial Intelligence and Data Science - Second Year, Semester III and IV - NEP 2020 - Item 6.20 (N) NEP 2020, Semesters III and IV, in force from 2025-26 Read full PDF Read
PDF B.E. Artificial Intelligence and Data Science - Third Year, Semester V and VI - CBCS REV-2019 C Scheme - Item 6.42 (R) CBCS REV-2019 'C' Scheme, Semesters V and VI, in force from 2022-23 Read full PDF Read
PDF B.E. Artificial Intelligence and Data Science - Fourth Year, Semester VII and VIII - CBCS REV-2019 C Scheme - Item 6.12 (N) CBCS REV-2019 'C' Scheme, Semesters VII and VIII, in force from 2023-24 Read full PDF Read
Report or request
Done!