CS614 Final Term Subjective

CS614 – Final Upto 2015 - Muhammad Kamran Khan

Q1. Nested loop join variants?

1. Typically used in OLTP environment.
2. Limited application for DSS and VLDB
3. In DSS environment we deal with VLDB and large sets of data.

Nested-Loop Join: Variants

1. Naive nested-loop join
2. Index nested-loop join
3. Temporary index nested-loop join

Q2. Define click stream?

Clickstream is every page event recorded by each of the company's Web servers

•  Web-intensive businesses
•  Although most exciting, at the same time it can be the most difficult and most frustrating.
•  Not JUST another data source.

Q3. What SSL stands for?

Secure Socket’s Layer

Q4. Kimball preferred which approach interview or session?

Kimball prefers using a hybrid approach with interviews to gather the gory details and then facilitation to bring the group to consensus. However, the forum choice depends on the team's skills, the organization’s culture, and what you've already subjected your users to. This is a case in which one size definitely does not fit all.

Q5. Reason of web searching? P-350

Web is large, actually very large. To make it useful must be able to find the page(s) of interest/relevance.

Q6. Limitation of using http secure socket layer briefly explain?

•  To track the session, the entire information exchange needs to be in high overhead SSL
•  Each host server must have its own unique security certificate.
•  Visitors are put-off by pop-up certificate boxes.

Q7. Write one implication of data ware housing if data documentation is not correctly done? Lack of documentation may stall system operations as management people cannot manage what they don’t know. Also, it may ultimately be used for educating the end users, prior to roll out.

Improper documentation

Usually by this time most, if not all, of the developers will have left the project, so it is essential that proper documentation is left for those who are handling production maintenance. There is nothing more frustrating than staring at something another person did, yet unable to figure it out due to the lack of proper documentation.

Q8. Inverted index consist of bit vectors correct or not if correct, then justify?

No, Bitmap Index consists of a number of bit vectors or bitmaps.

Q9. Calculate gender using classification rule of the given table?

The model in our case is a rule that if the per item minutes for any customer is greater or equal than 6 than the customer is female else a male i.e. IF Items/Time >= 6 Then Gender= ‘F’ Else Gender = ‘M’ The above rule is based on the common notion that females spend more time.

Q10. Write 5 activities to measure success criteria of mail campaign?

Measure customer's interest for campaigns, ads, e-mails?

Common measurements include:

1. Number of visitors
2. Number of sessions
3. Most requested page
4. Most requested download
5. Most accessed directories
6. Leading referrer sites
7. Leading browser and operating system
8. Visits by geographic breakdown, and many others

This information can be used to modify the design of the Web site, change ad campaigns or develop partnering relationships with other sites.

Q11. Nested loop join, calculate the cost?

Player · Player_ID · Player_Name · Team

PK-01 Wasim Pakistan PK-02 Misbah Pakistan SA-03 AB Devillier

Award · Award_ID · Match_ID · Player_ID

PK-01 PK-01 PK-02 SA-03