# CS614 : Data Warehousing

### CS614: Data Warehousing Assignment No 3 fall 2017

This topic contains 1 reply, has 1 voice, and was last updated by  Cyberian. This post has been viewed 175 timespk 5 months, 2 weeks ago. This post has been viewed 175 times

Viewing 2 posts - 1 through 2 (of 2 total)
• Author
Posts
• #6409

Cyberian.pk
Keymaster
Points: 1,459

Assignment No. 3 Semester Fall 2016 Data Warehousing–
CS614 Total Marks: 10 Due Date: 18-01-2017
Objective: This assignment has been designed to develop your understanding of parallelism in a Data warehousing environment. Instructions: Please read the following instructions carefully before solving & submitting the assignment: 1. The assignment will not be accepted after due date. 2. Zero marks will be awarded to the assignment that does not open or the file is corrupt. 3. The assignment file must be an MS Word (.doc) file format; Assignment will not be accepted in any other format. 4. Zero marks will be awarded to the assignment if copied (from other student or copied from handouts or internet). 5. Zero marks will be awarded to the assignment if the Student ID is not mentioned in the assignment file. For any query about the assignment, contact only at [email protected] Please do not post queries related to assignment on MDB.

Question 1: [5 Marks]

Use the Amdahl’s Law (mentioned below) to prove that the speed up does not remain the same, as the ratio of
sequential code and number of processors (on which this code is executed) is doubled.
Initial fraction of code that can be executed sequentially = 10%
Initial number of processors = 100
Note: Assumes zero (0) overhead and “perfect” parallelism.
You have to compare both the results (initial result and result after doubling the given values)

Question 2: [5 Marks]

Suppose, we are performing 20 tasks sequentially using a machine each task taking 5 seconds. Now we are
How much speed up, we will get after applying the pipelining concept.
Note: You have to perform and show the mathematical calculations in the solution.
Note: Deadline for Assignment submission is 18th January, 2017.

Welcome to Cyberian.pk
Please Discuss your assignment/Quiz/GDB for the best solution. Cyberian.pk main motive to provide the best platform to discuss the problem in your Study material. Cyberian.pk with you to facilitate online and offline for your learning and skills, we will not appreciate the idea of duplicate and copyright solutions.

Helping Material related to following subject

1. Solved MCQs,
2. Short Notes,
3. Solved Past Papers,
4. E-Books,
5. Short Questions Answers & more).

#6446

Cyberian.pk
Keymaster
Points: 1,459

Welcome to Cyberian.pk
Please Discuss your assignment/Quiz/GDB for the best solution. Cyberian.pk main motive to provide the best platform to discuss the problem in your Study material. Cyberian.pk with you to facilitate online and offline for your learning and skills, we will not appreciate the idea of duplicate and copyright solutions.

Helping Material related to following subject

1. Solved MCQs,
2. Short Notes,
3. Solved Past Papers,
4. E-Books,
5. Short Questions Answers & more).

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.