
MOLAP types of OLAP, servers, 3 – Tier data warehouse architecture, distributed and virtual data warehouses, data warehouse manager. Data warehouse process & architecture, OLTP vs. data warehouse, Data marts, Metadata, Multidimensional data mode, Data cubes, Schemas for Multidimensional Database: stars, snowflakes and fact constellations. Section – A Data ware housing Definition, usage and trends, DBMS vs. Use of nonprogrammable calculators is allowed. For Candidates: Candidates are required to attempt five questions in all selecting one question from each of the sections A, B, C and D of the question paper and all the subparts of the questions in section E. Section A, B, C and D will have two questions from the respective sections of the syllabus and each section will carry 15% of the total marks of the semester end examination for the course.

Section E will be Compulsory, it will consist of a single question with 10-20 subparts of short answer type, which will cover the entire syllabus and will carry 40% of the total marks of the semester end examination for the course. For Paper Setters: The question paper will consist of five sections A, B, C, D, and E. Data Warehouse And Data Mining (IT-8003) Course Codeĥ2 (1 Hr Each) (L= 39, T = 13 for each semester)Ĭontinuous Assessment (based on sessional tests (2) 50%, Tutorials/Assignments 30%, Quiz/Seminar 10%, Attendance 10%)
