Scribd
Upload
873 views1 page

Data Warehousing Lab Experiments

The document outlines the practical exercises and course outcomes for a data warehousing lab experiments course. The practical exercises include exploring and integrating data with WEKA, applying WEKA for data validation, planning real-time application architecture, writing schema definitions, designing data warehouses for real-time applications, analyzing dimensional modeling, and conducting case studies using OLAP and OTLP. The course outcomes are for students to be able to design data warehouse architectures, apply OLAP technology, analyze partitioning strategies, analyze schema differentiation, and define process and system manager roles. The course duration is 60 periods.

Uploaded by

arul mamce
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
873 views1 page

Data Warehousing Lab Experiments

The document outlines the practical exercises and course outcomes for a data warehousing lab experiments course. The practical exercises include exploring and integrating data with WEKA, applying WEKA for data validation, planning real-time application architecture, writing schema definitions, designing data warehouses for real-time applications, analyzing dimensional modeling, and conducting case studies using OLAP and OTLP. The course outcomes are for students to be able to design data warehouse architectures, apply OLAP technology, analyze partitioning strategies, analyze schema differentiation, and define process and system manager roles. The course duration is 60 periods.

Uploaded by

arul mamce
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

PAGE NO:136

DATA WAREHOUSING LAB EXPERIMENTS

PRACTICAL EXERCISES: 30 PERIODS


1. Data exploration and integration with WEKA
2. Apply weka tool for data validation
3. Plan the architecture for real time application
4. Write the query for schema definition
5. Design data ware house for real time applications
6. Analyse the dimensional Modeling
7. Case study using OLAP
8. Case study using OTLP
9. Implementation of warehouse testing.

COURSE OUTCOMES:
At the end of the course the
students should be able to CO1:
Design data warehouse architecture for
various Problems CO2: Apply the
OLAP Technology
CO3: Analyse the partitioning strategy
CO4: Critically analyze the differentiation of various schema for given problem
CO5: Frame roles of process manager & system manager
TOT
AL:
60
PERI
ODS
TEXT BOOKS
1. Alex Berson and Stephen J. Smith “Data Warehousing, Data
Mining & OLAP”, Tata McGraw – Hill Edition, Thirteenth
Reprint 2008.
2. Ralph Kimball, “The Data Warehouse Toolkit: The
Complete Guide to Dimensional Modeling”, Third edition,
2013.

You might also like