Skip to toolbar
Solved143 viewsVirtual University
0

Assignment No.  3
Semester: Spring 2020

CS614 – Data Warehousing

Objectives:

After completing this assignment, the students will be able to:

  • compare Parallel Processing and Serial Processing
  • describe what and when to Parallelize
  • calculate Speed up using Amdahl’s Law

Instructions

Please read the following instructions carefully before submitting assignment:

It should be clear that your assignment will not get any credit if:

 

  • Assignment is submitted after due date.
  • Submitted assignment does not open or file is corrupt.
  • Assignment is copied (From internet/ to from students).
  • Assignment is submitted other than word format (.doc, .docx).

 

 

Question is closed for new answers.
admin Selected answer as best
Add a Comment
1

Scenario:

XYZ isa fabric manufacturing company. This company is planning to implement DWH for its existing OLTP system implemented in 300 + stores all over Pakistan. Size of company’s Databaseis approx. 298 GB that grows at the rate of 0.8 GB per day approximately. Company has designed a state of the art DWH in its head office in terms of hardware and software. Hardware consists of 7 Systems having quad-core processors. In ideal situation, a complex query would return results in 27 minutes on single processor (serial execution).

After analyzing the scenario given above, you are required to answer the following questions;

Question # 1 – If a complex query is executed parallel on 6 single-core processors then what would be the quantified speed up time.

Answer:

Question # 2 – CalculateSpeed up ratio using Amdahl’s Law, if80% of query processing is done through parallel execution on DWH hardware.

Answer:

 

solution file cs614

 

admin Selected answer as best
Add a Comment