+ Link For Assignments, GDBs & Online Quizzes Solution |
+ Link For Past Papers, Solved MCQs, Short Notes & More |
Objective: The assignment has been designed to develop your ability to calculate the Bitmap index. Instructions: Please read the following instructions carefully before solving & submitting assignment:
For any query about the assignment, contact only at CS614@vu.edu.pk Do not post queries related to assignment on MDB.
GOOD LUCK
|
Tags:
+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)
+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)
+ Click Here to Search (Looking For something at vustudents.ning.com?) + Click Here To Join (Our facebook study Group)Player_ID |
Player_Name |
Team_ID |
Pool_ID |
IND-06 |
Gangoli |
IND |
A |
IND-01 |
Tandulker |
IND |
A |
SA-07 |
AB Devillier |
SA |
A |
SA-09 |
Dal Styn |
SA |
A |
AU-01 |
Steve Waugh |
AU |
B |
AU-04 |
Maxwell |
AU |
B |
AFG-01 |
Nawroze |
AFG |
B |
AFG-05 |
Najeeb |
AFG |
B |
this is the answer of question no.1
Complete Solution....
Is it right?
guys plz give solution of 2nd question.
Idea Solution.................
Question no. 1:
Consider the following table:
Player_Team
Player_ID |
Player_Name |
Team_ID |
Pool_ID |
WI-06 |
Richordson |
WI |
A |
PK-05 |
Misbah |
PK |
A |
SA-07 |
AB Devillier |
SA |
B |
AU-01 |
Steve Waugh |
AU |
B |
PK-01 |
Hafiz |
PK |
A |
AU-04 |
Maxwell |
AU |
B |
WI-01 |
Ambrose |
WI |
A |
SA-09 |
Dal Styn |
SA |
B |
Consider the following query:
SELECT Count (Player_Team.Pool_ID) AS CountOfPool_ID
FROM Player_Team
GROUP BY Player_Team.Pool_ID;
Answer the following questions:
Answer:
Cluster indexing on Team_ID
Player_ID |
Player_Name |
Team_ID |
Pool_ID |
WI-06 |
Richordson |
WI |
A |
WI-01 |
Ambrose |
WI |
A |
PK-05 |
Misbah |
PK |
A |
PK-01 |
Hafiz |
PK |
A |
SA-07 |
AB Devillier |
SA |
B |
SA-09 |
Dal Styn |
SA |
B |
AU-01 |
Steve Waugh |
AU |
B |
AU-04 |
Maxwell |
AU |
B |
Cluster indexing on Pool_ID
Player_ID |
Player_Name |
Team_ID |
Pool_ID |
WI-06 |
Richordson |
WI |
A |
PK-05 |
Misbah |
PK |
A |
PK-01 |
Hafiz |
PK |
A |
WI-01 |
Ambrose |
WI |
A |
SA-07 |
AB Devillier |
SA |
B |
AU-01 |
Steve Waugh |
AU |
B |
AU-04 |
Maxwell |
AU |
B |
SA-09 |
Dal Styn |
SA |
B |
In this Query the indicate the separate grouping of objects because all the object separately. It’s a one way cluster.
Player
Player_ID |
Player_Name |
Team |
PK-01 |
Wasim |
Pakistan |
PK-02 |
Misbah |
Pakistan |
SA-03 |
AB Devillier |
South Africa |
Award
Award_ID |
Match_ID |
Player_ID |
01 |
01 |
PK-01 |
01 |
02 |
PK-01 |
02 |
03 |
PK-02 |
01 |
04 |
SA-03 |
Consider the following query:
Select * from Player P, Award A where P.Team= ‘Pakistan’ and A.Award_ID = ‘01’ and P.Player_ID = A.Player_ID
Suppose this query is executed using Naive Nested-Loop join (i.e. there is no index created on both Player and Award tables). Mention that which table should be the Outer table to get minimum I/O by manually calculating the cost in both cases i.e. when “Player” is outer table and when “Award” is outer table.
Answer:
Qualifying blocks in table P = 3
Size of Table P=9 Blocks
Qualifying blocks in table A = 4
Size of Table A=12 Blocks
If table_P is outer & table_A is inner
Formula for Join cost = size of blocks of table_P + (table blocks of table_P * size of blocks of table_A
Join cost1(player_table:outer, Award_table::inner)
=9+(3 * 12) =9+36
=45
{ size of table_P +(blocks of table_P * size of table_A)
If table_A is outer & table_P is inner
Formula for Join cost = size of blocks of table_A + (table blocks of table_A * size of blocks of table_P
Join cost2(Award_table:outer, Player_table::inner)
=12+(4 * 9) =12+36
=48
{ size of table_A +(blocks of table_A * size of table_P)
Thanx to all of u guys...
U r really helpful.
All solutions are wrong.............
Read comments on the files mentioned above carefully, these are idea solutions.........
bro menay apka nai kaha i know ap nay just idea dia sab nay asay hi copy paste krlena so kaha k sab wrong samj k kerain and discuss kren hojayegi complete
© 2021 Created by + M.Tariq Malik.
Powered by
Promote Us | Report an Issue | Privacy Policy | Terms of Service
We are user-generated contents site. All product, videos, pictures & others contents on site don't seem to be beneath our Copyrights & belong to their respected owners & freely available on public domains. We believe in Our Policy & do according to them. If Any content is offensive in your Copyrights then please email at m.tariqmalik@gmail.com Page with copyright detail & We will happy to remove it immediately.
Management: Admins ::: Moderators
Awards Badges List | Moderators Group
All Members | Featured Members | Top Reputation Members | Angels Members | Intellectual Members | Criteria for Selection
Become a Team Member | Safety Guidelines for New | Site FAQ & Rules | Safety Matters | Online Safety | Rules For Blog Post