Topic 1.3
Building Blocks & Trends
Overview & Concepts
Subject Incharge : Pratidnya S. Hegde Patil
Questions before building a DW
Before deciding to build a data warehouse for your
organisation, you need to ask the following basic and
fundamental question
Scanned by CamScanner
Scanned by CamScanner
Scanned by CamScanner
Scanned by CamScanner
Scanned by CamScanner
Scanned by CamScanner
Scanned by CamScanner
Scanned by CamScanner
Scanned by CamScanner
Assignment no.1
Subject: DWDM (B.TECH CE & IT)
Q1) Design a schema for University mark sheet system?
Q2) Design a schema for library fine system?
Q3) Explain the trends in Data warehousing?
1.
The datafication of the enterprise requires more capable data
Digital Filter
A filter is a circuit network that selectively changes
the wave shapes of a signal in desired manner.
Digital filters often operate on a digital input
Design and Implementation of a Digital Filter
Filters are a basic component of all signa
IIR FILTERS
The Filter designed by considering all the infinite
samples of impulse response are called IIR filters.
In digital domain, the processing of infinite
samples of impulse response is practically not
possible .
Therefore, the analog IIR filter
Fourier series
DFT(Discrete Fourier Transform)
and FFT(Fast Fourier Transform)
TIME DOMAIN-FREQ. DOMAIN
FOURIER TRANSFORM
FT
INVERSE FOURIER TRANSFORM
IFT
FOURIER TRANSFORM
DIGITIZATION=SAMPLING + QUANTIZATION
F(t)
Time
0111
0110
0110
0011
0011
g(t)
t
Sam
FFT(Fast Fourier Transform)
FFT
The basic objective is to achieve computational efficiency
by a divide and conquer method.
Radix r FFT:
FFT
In a N-point sequence, where N=r m.
Hence the given sequence can be decimated(divided)
Into r-point sequence.
r-p
Roll No.: 137
Name: Rohit Murarka
Prog./Year/Sem.: B.Tech I.T./4th/8
Batch: A2
Date of Experiment: 10/2/2014
Date of Submission: 16/2/2014
EXPERIMENT 5- OLAP & Relational Data Mining Model
(Clustering Using Decision Tree)
Aim: Creating a OLAP Data Mining
Roll No.: 137
Prog./Year/Sem.: B.Tech I.T./4th/8
Date of Experiment: 13/1/2014
Name: Rohit Murarka
Batch: A2
Date of Submission: 25/1/2014
EXPERIMENT 2- Parent Child Relation and Calculated Member
Aim: Design Star Schema, identifying parent-child relation
Roll No.: 137
Prog./Year/Sem.: B.Tech I.T./4th/8
Date of Experiment: 03/2/2014
Name: Rohit Murarka
Batch: A2
Date of Submission: 09/2/2014
EXPERIMENT 4- Data Mining Model (Classification Using Decision Tree)
Aim: Creating a Classification Data Mining Mode
Topic 1.1
Need for Data Warehousing
Overview & Concepts
Subject Incharge : Pratidnya S. Hegde Patil
Introduction to Data Warehouse
Textbook :
Data Warehousing Fundamentals A comprehensive guide
for IT Professionals, by Paulraj Ponniah, Publisher: John
Wil
Topic 4.1
Data Design & Preparation
Dimensional Modeling
Subject Incharge : Pratidnya S. Hegde Patil
Dimension Modeling
The information package diagrams form the basis for the logical data design for the
data warehouse. The data design process results in
Topic 4.3
Data Design & Preparation
Data Quality
Subject Incharge : Pratidnya S. Hegde Patil
What is Data Quality ?
1.
If the data is fit for the purpose for which it is intended,
we can then say such data has quality.
2.
It is to be related to the usage
Topic 3
Data Design, Architecture,
Infrastructure & Metadata
Data Design, Architecture, Metadata
Subject Incharge : Pratidnya S. Hegde Patil
Importance of Data Design
The data warehouse environment is an information
delivery system where the users themsel
Topic 2.1
Developing a DW
Planning & Requirements
Subject Incharge : Pratidnya S. Hegde Patil
Planning of Data Warehouse
Improper planning and inadequate project management tend to result
in failures.
Determine if your company really needs a data warehous
Topic 1.2
Features & Objects
Overview & Concepts
Subject Incharge : Pratidnya S. Hegde Patil
1
Goal of a Data Warehouse
Collect Data-Scrub, Integrate & Make It
Accessible
Provide Information - For Our Businesses
Start Managing Knowledge
So Our Business Pa
Topic 5.1
Information Access & Delivery
OLAP, MOLAP, ROLAP
Subject Incharge : Pratidnya S. Hegde Patil
Types of Data
Operational Data (OLTP applications).
Data that works
Frequent updates and queries
Normalized tables for efficient search and
updates (min
Topic 6.1
Implementation & Maintenance
Physical Design Process,
Deployment & Monitoring
Subject Incharge : Pratidnya S. Hegde Patil
Physical Design Objectives
Where to place the database objects in physical
storage?
What is the storage medium and what are
Topic 4.2
Data Design & Preparation
Advanced Topic
Subject Incharge : Pratidnya S. Hegde Patil
Conditions for the tables
The model should provide the Best Data Access. (Model
should provide easy access to the data in the DW). Model
provides easy access by
Roll No.: 137
Name: Rohit Murarka
Prog./Year/Sem.: B.Tech I.T./4th/8
Batch: A2
Date of Experiment: 17/2/2014
Date of Submission: 23/2/2014
EXPERIMENT 6- DATA MINING ALGORITHM ON CLUSTERING
Aim: Partitional Clustering : Simulation of k-Means Algorithm thro
Roll No.: 137
Prog./Year/Sem.: B.Tech I.T./4th/8
Date of Experiment: 6/1/2014
Name: Rohit Murarka
Batch: A2
Date of Submission: 25/1/2014
EXPERIMENT 1- BUILD, EDIT AND BROWSE A CUBE
Aim: Design Star Schema, identifying dimensions with dimension hierarchy
Roll No.: 137
Name: Rohit Murarka
Prog/Yr/Sem: B.Tech I.T./4th/8
Batch: A2
Date of Experiment: 03/3/2014
Date of Submission: 23/3/2014
Experiment No - 8
1. Problem Statement :
The classes with the assigned points are to be inputted.
Calculate the centroid
In an LTI system the input x(n) = cfw_1, 2, 3 and the impulse response h(n) = cfw_1 , -1. Determine the response
of the LTI system by radix2 DIT FFT.
Solution
The response y(n) of LTI system is given by linear convolution of input x(n) and impulse respons