CS-614 Data Warehousing
Q & A
Online Test
Course Category: Computer Science/Information Technology
Course Level: Imdregraduate
Credit Hours: 3
Pre-requisites: CS101, CS403, CS610
Course Contents:
Introduction to Data Ware Housing, Normalization, De-Normalization, De-Normalization Techniques, Issues of De-Normalization, Online Analytical Processing (OLAP, Multidimensional OLAP (MOLAP, Relational OLAP (ROLAP, Dimensional Modeling (DM, Process of Dimensional Modeling, Issues of Dimensional Modeling,Extract Transform Load (ETL), Issues of ETL, ETL Detail: Data Extraction & Transformation, ETL Detail: Data Cleansing, Data Duplication Elimination & BSN Method, Introduction to Data Quality Management (DQM), DQM: Quantifying Data Quality, Total DQM Need for Speed: Parallelism, Need for Speed: Hardware Techniques, Conventional Indexing Techniques, Need for Speed: Special Indexing Techniques, Join Techniques, A Brief Introduction to Data mining (DM, What Can Data Mining Do Supervised Vs. Unsupervised Learning, DWH Lifecycle: Methodologies, DWH Implementation: Goal Driven Approach I, DWH Implementation: Goal Driven Approach II, DWH Life Cycle: Pitfalls, Mistakes, Tips., Course Project, Case Study: Agri-Data Warehouse Part-I, Case Study: Agri-Data Warehouse Part-II, Web Warehousing: An introduction, Web Warehousing: Issues, Lab Lecture-1: Data Transfer Service (DTS, Lab Lecture-2: Lab Data Set, Lab Lecture-3: Extracting Data Using Wizard, Lab Lecture-4: Data Profiling, Lab Lecture-5: Data Transformation & Standardization
 CS614_Midterm Solved MCQs With References by moaaz  CS614_Midterm Solved Subjectives With References by moaaz
Course Instructor

Dr. Ahsan Abdullah
PhD Computer Science
Scotland, UK.

Building the Data Warehouse
by W. H. Inmon

Data Warehousing Fundamentals
by Paulraj Ponniah