CS614 Current Final Term Fall 2013 Shared by Cute_one File 3

My paper

Q1: Describe the names of any two parallel hardware architectures.

Ans: REF (Handouts Page # 206)

1.Symmetric Multi-Processing (SMP)

2.Distributed Memory or Massively Parallel Processing (MPP)

3.Non-uniform Memory Access (NUMA)

Q2: What is the importance of educating the end user?

Ans: REF (Handouts Page # 309)

Since the user community must accept the warehouse for it to be deemed successful, education is critical. The education program needs to focus on the complete warehouse deliverable: data, analytic applications and the data access tools (as appropriate). Consider the following for an effective education program i. understand your target audience, don’t overwhelm. ii. Don’t train the business community early prior to the availability of data and analytic applications. iii, No release, no education: Postpone the education (and deployment) if the data warehouse is not ready to be released. iv. Gain the sponsor’s commitment to a “No education, No access” policy.

Q3: According to Amdahl’s Law prove that the speedup does not remain same if the fraction of the problem and number of processors are doubled. Please note that 0 overhead and “perfect” parallelism is used. Use following examples

a)      Fraction of the problem that must be computed sequentially is 5% and number of processors is 100.

b)      Fraction of the problem that must be computed sequentially is 10% and number of processors is 200.

Ans: REF (Handouts Page # 204,205)

Amdahl’s law: S ≤ 1 / f + ( 1 – f ) / N

a)      1 / 0.05 + ( 1 – 0.05 ) / 100 = 16.81

b)      1 / 0.10 + ( 1 – 0.10 ) / 100 = 9.57

Hence it is evident that the speedup does not remain same if we double the fraction and number of processors.

Q4: What are the characteristics of the inner table?

Ans: REF (Handouts Page # 242)

1.The largest number of qualifying rows

2.The smallest number of reads required to locate rows.

Q5: Consider the following table:

Name	Time	Items	Gender
Tahir	20	1	Male
Younas	3	1	Male
Yasin	10	2	Male

Now consider the model in this case is a rule that if the per item minutes for any customer is greater than or equal to 6 than the customer is female else male i. e.

If

           Items/Time >=6

Then

           Gender = ‘Female’

Else

           Gender = ‘Male’

Answer the following questions:

a)      Calculate the accuracy percentage of the above given classification model (assume that the table contains only 3 records)

b)      What would be the Gender assigned to some customer named Amjad if that customer spend 7 minutes and buys 1 item?

Ans: REF (Handouts Page # 278)

a)      2 / 3 = 66%

b)      The Gender Female would be assigned to Amjad

Q6: What are the first two key steps of DWH Lifecycle (Kimball’s Approach)

Ans: REF (Handouts Page # 290)

1.Project Planning

2.Business Requirements Definition

Q7: Describe any 4 cotton pest scouting dynamic attributes recorded by WPWQCP surveyors.

ANS: REF (Handouts Page # 342)

1.Date of visit

2.Pest population

3.CLCV

4.Predator population

5.Pesticide spray dates

6.Pesticide(s) used

Q8: Describe Reasons for web warehousing.

ANS: REF (Handouts Page # 350)

1.Searching the web (Web mining)

2.Analyzing web traffic

3.Archiving the web

Q9: What are the methods used to identify session in web warehousing?

ANS: REF (Handouts Page # 364)

1.Using Time-contiguous Log entries

2.Using transient cookies

3.Using HTTP’s secure socket layer (SSL)

4.Using session ID ping pong

5.Using persistent cookies

Q10: What are the limitations of using HTTP’s secure sockets layer (SSL)?

ANS: REF (Handouts Page # 366)

1.To track the session, the entire information exchange needs to be in high overhead SSL

2.Each host server must have its own unique security certificate

3.Visitors are put-off by pop-up certificate boxes.