RGTU/RGPV MCA-501 Data Warehousing and Mining Syllabus
MCA 5th Sem Data Warehousing and Mining Syllabus
MCA 5th - Fourth Semester Syllabus
MCA-501 Data Warehousing and Mining Course Contents:
UNIT – IMotivation, importance, Data type for Data Mining : relation Databases, Data Warehouses, Transactional databases, advanced database system and its applications, Data mining Functionalities: Concept/Class description, Association Analysis classification & Prediction, Cluster Analysis, Outlier Analysis, Evolution Analysis, Classification of Data Mining Systems, Major Issues in Data Mining.
UNIT – IIData Warehouse and OLAP Technology for Data Mining: Differences between Operational Database Systems and Data Warehouses, a multidimensional Data Model, Data Warehouse Architecture, Data Warehouse Architecture, Data Warehouse Implementation, Data Cube Technology.
UNIT- III
Data Preprocessing: Data Cleaning, Data Integration and Transformation, Data Reduction, Discretization and Concept Hierarchy Generation. Data Mining Primitives, Languages, and System Architectures, Concept Description: Characterization and Comparison, Analytical Characterization.
UNIT – IV
Mining Association Rules in Large Databases: Association Rule Mining: Market Basket Analysis, Basic Concepts, Mining Single-Dimensional Boolean Association Rules from Transactional Databases: the Apriori algorithm, Generating Association rules from Frequent items, Improving the efficiency of Apriory, Mining Multilevel Association Rules, Multidimensional Association Rules, Constraint-Based Association Mining.
UNIT – V
Classification & Prediction and Cluster Analysis: Issues regarding classification & prediction, Different Classification Methods, Prediction, Cluster Analysis, Major Clustering Methods, Applications & Trends in Data Mining: Data Mining Applications, currently available tools.
BOOKS
1. J. Han and M. Kamber, “Data Mining: Concepts and Techniques”, Morgan Kaufmann Pub.
2. Berson “Dataware housing, Data Mining & DLAP, @004, TMH.
3. W.H. Inmon “ Building the Datawarehouse, 3ed, Wiley India.
4. Anahory, “Data Warehousing in Real World”, Pearson Education.
5. Adriaans, “Data Mining”, Pearson Education.
6. S.K. Pujari, “Data Mining Techniques”, University Press, Hyderabad.
Note : Paper is to be set unit wise with internal choice.
ConversionConversion EmoticonEmoticon