We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

CS614_Share Your Current Papers of Mid Term ,Fall 2015 at one Place from 19 Dec to 31 Dec 2015.

CS614 ALL Current Mid Term Papers

Fall 2015 at One Place

from 19 Dec 2015 to 31 Dec 2015  

 

For Important Helping Material related to this subject (Solved MCQs, Short Notes, Solved past Papers, E-Books, FAQ,Short Questions Answers & more). You must view all the featured Discussion in this subject group.

For how you can view all the Featured discussions click on the Back to Subject Name Discussions link below the title of this Discussion & then under featured Discussion corner click on the view all link.

Or visit this link 

Click Here For Detail.

 

Solutions for not opening files..
 

PDF Files downloading Solution from ning..

 
Problem in downloading PDF files..

    

Thanks and Regards!


+ 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)


Views: 4307

Replies to This Discussion

  1. What is the purpose of "aggregate awareness"? (2 marks)

Ans: Aggregate awareness allows using pre-built summary tables by some

front-end tools.

     2. The problems associated with the extracted data can correspond to non-primary keys.List down any four problems associated with the non-primary key. (2 marks)

     3.What is “ranking” in data source selection? Explain with an example. (3 marks)

Ranking is all about selecting the “right” source system. Rank establishment has to be based on which source system is known to have the cleanest data for a particular attribute.

For example, consider the case of the gender data coming from two different source systems A and B. It may be the case that the highest quality data is from source system A, where the boxes for the gender were checked by the customers themselves. But what if someone did not check the gender box? Then you go on to the next cleanest source

system i.e. B, where the gender was guessed based on the name. 

     4. Identify the given statement as correct or incorrect and justify your answer in either case. (3 marks)

     5. In context of MOLAP cube, identify the proportionality relation between the cardinality of dimension and cube size. Justify your answer with logical reason. (5 marks)

When the cardinality of a dimension forces a cube to become larger than what can reasonably be supported in a single cube, it is common practice to partition the cube into multiple “sub-cube” instantiations.  The  sub-cubes are usually defined around logical partitions within the dimensional hierarchies.  For example, if there are a large number of

entries at the most detailed level in a product hierarchy, it may be advisable to create distinct cubes along product category boundaries to divide-and-conquer.

     6. Identify the types of transformations used for the following two scenarios. (5 marks)

  • One data element form the source system is mapped to several columns in the DWH.
  • One set of values is mapped to another set of values using straightforward rules.
  • •   Simple one-to-one scalar transformations.
  • •   One-to-many element transformations.

    •   Complex many-to-many element transformations. ....See  More page 144 from handouts (softcopy)

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

20 Mcqz (50 to 60 % from Past Papers)

1-      Two limitation of aggregation? … (2 Marks)

ƒ  Aggregation limits the questions that can be answered.

ƒ   What, when, why, where, what-else, what-next

ƒ  Aggregation can hide crucial facts.

ƒ  The average of 100 & 100 is same as 150 & 50

2-      One too Many Transformation with example … (2 Marks)

A one-to-many transformation is more complex than scalar transformation. As a data element form the source system results in several columns in the DW. Consider the 6×30 address field (6 lines of 30 characters each), the requirement is to parse it into street address lines 1 and 2, city, sate and zip code by applying a parsing algorithm.

3-      What is “ranking” in data source selection? Explain with an example. (3 Marks) Rep

4- Performance vs Trade Space? (3 Marks)

ƒ  Maximum performance boost implies using lots of disk space for storing every  pre-calculation.

ƒ  Minimum performance boost implies no disk space with zero pre-calculation.

ƒ  Using Meta data to determine best level of pre-aggregation from which all other aggregates can be computed.      

 

5- Given a table of DATE, PRODUCT, CITY, SALES_Amount, Average … Choose Additive Facts and described it? (5 Marks)

6- Two Statement given … Tell them Correct or incorrect and described it? (5 Marks)


------------------------------------------------------------------------------------

1. Additive and non additive facts    2 marks

Additive facts are those facts which give the correct result by an addition operation. Examples of such facts could be number of items sold, sales amount etc. Non-additive facts can also be added, but the addition gives incorrect results. Some examples of non-additive facts are average, discount, ratios etc.

2. One to many transformation with example 3 marks 

rep

  1. Aik statement d hoi thi about timestamp  btana tha true hae yan false with reason.

Time Stamps  page 150

4.Star aur snow flock schema ki digrame thi and identify karna tha k kon sa schema hai.

The two Schemas

Figure-13.3: The two schemas

StarSnow-flake         page 105

5. What is murge/purge when we performed the cleansing in the dataware house 5 marks

Records referring to the same entity are represented in different formats in the different data sets or are represented erroneously. Thus, duplicate records will appear in the merged database. The issue is to identify and eliminate these duplicates.

The problem is known as the merge/purge problem

6.    5 Marks

Product Id

Region ID

Period

Quantity

1

N

Month

25

2

N

Month

  50

2

S

Week

30

Find the dimension, primary key & dimension.---------------------------------------------

1-      Two limitation of aggregation? … (2 Marks)

Rep

One too Many Transformation with example … (2 Marks) Rep

What is “ranking” in data source selection? Explain with an example. (3 Marks) Rep
4- Performance vs Trade Space? (3 Marks) Rep

 

5- Given a table of DATE, PRODUCT, CITY, SALES_Amount, Average … Choose Additive Facts and described it? (5 Marks) Rep

6- Two Statement given … Tell them Correct or incorrect and described it Rep

following were the subjective questions;

     1. What is the purpose of "aggregate awareness"? (2 marks) Rep

  1.      2. The problems associated with the extracted data can correspond to non-primary keys.List down any four problems associated with the non-primary key. (2 marks) Rep

 

     3.What is “ranking” in data source selection? Explain with an example. (3 marks) Rep

     4. Identify the given statement as correct or incorrect and justify your answer in either case. (3 marks) Rep

 

     5. In context of MOLAP cube, identify the proportionality relation between the cardinality of dimension and cube size. Justify your answer with logical reason. (5 marks) Rep

     6. Identify the types of transformations used for the following two scenarios. (5 marks) One data element form the source system is mapped to several columns in the DWH.

  • One set of values is mapped to another set of values using straightforward rules. rep


-----------------------------------------------------------------------------

Q1  : Write two disadvantages of MOLAP?   (2marks)

     1)Long load time ( pre-calculating the cube may take days!).

ƒ   2) Very sparse cube (wastage of space) for high cardinality (sometimes in small

                      hundreds). e.g. number of heaters sold in Jacobabad or Sibi.

 

 Q2; What is merge/purge problem in data cleansing?(2 marks) Rep

 

Q3: Identify the given statement as correct or incorrect and justify your answer in either case. 3    “ROLLUP” is used for transfer the data(something like that sorry I forget full statement)

ƒ  Rollup: summarize data

ƒ  e.g., given sales data, summarize sales for last year by product category

and region... page #80

Q4: The problems associated with the extracted data can correspond to non-primary keys. List down any four problems associated with the non-primary key? 3 Rep

Q5:  What is “ranking” in data source selection? Explain with an example.? 5 Rep

Q6:  The table is given and need to identified the additive fact ? 5  See  lec#15 page 119

 Answer plzzzz???

Q#1The problems associated with the extracted data can correspond to non-primary keys.List down any four problems associated with the non-primary key????

Q#2

 Given a table of DATE, PRODUCT, CITY, SALES_Amount, Average … Choose Additive Facts and described it? (5 Marks)

Q#3

Product Id

Region ID

Period

Quantity

1

N

Month

25

2

N

Month

  50

2

S

Week

30

Find the dimension, primary key & dimension.

Q#4

     6. Identify the types of transformations used for the following two scenarios. (5 marks)

  • One data element form the source system is mapped to several columns in the DWH.
  • One set of values is mapped to another set of values using straightforward rules.

Q#1The problems associated with the extracted data can correspond to non-primary keys.List down any four problems associated with the non-primary key????
Ans:
(1)Same primary key but different data

(2)Same entity with different keys

(3)Primary key in same information
(4)Source might contain invalid data.

Q#4

     6. Identify the types of transformations used for the following two scenarios. (5 marks)

  • One data element form the source system is mapped to several columns in the DWH.Ans:(One to Many ..)
  • One set of values is mapped to another set of values using straightforward rules.(One to one ..)

Q#3

Product Id

Region ID

Period

Quantity

1

N

Month

25

2

N

Month

  50

2

S

Week

30

Find the dimension, primary key & dimension.

Ans:

Primary key: product Id, region Id
Dimension: Period, quantity
1.Automatic Data Cleansing
1) Statistical
2) Pattern Based3) Clustering
4) Association Rules

RSS

Latest Activity

Ꮆㄩフフ卂尺 liked Hafiza Tehreem Fatima's discussion BIRTHDAY CELEBRATION OUR BELOVED <MEMBER SARAH ABDUL
12 minutes ago
+M.Tariq Malik replied to Muhammad Faizan Alam's discussion STA301 Assignment No.1 | FALL 2020 | Due Date: 8th December, 2020 in the group STA301 Statistics and Probability
12 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion MGT301 Principles of Marketing Assignment 01 Fall 2020 Solution / Discussion in the group MGT301 Principles of Marketing
18 minutes ago
Blessings liked Blessings's profile
19 minutes ago
+M.Tariq Malik replied to shifa arshad's discussion MGT501 GDB Fall 2020 Solution / Discussion Due Date: 09-dec-2020 in the group MGT501 Human Resource Management
27 minutes ago
Mani Siddiqui Ex posted a status
"جینے والوں نے خود کشی کر لی.. رہ گئے جو، اداس رہتے ہیں.."
28 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion MTH633 Group Theory Assignment 01 Fall 2020 Solution / Discussion in the group MTH633 Group Theory
32 minutes ago
+M.Tariq Malik replied to Fragrance of Islam's discussion ENG301 Business Communication GDB No 01 Fall 2020 Solution / Discussion in the group ENG301 Business Communication
36 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion PSY407 Assignment 01 Fall 2020 Solution / Discussion Due Date: 07-12-2020 in the group PSY407 Sport Psychology
37 minutes ago
Ellen Shades posted blog posts
40 minutes ago
Profile IconAyesha, Rabi Rajput, Nabila and 18 more joined Virtual University of Pakistan
42 minutes ago
Ayesha liked +M.Tariq Malik's discussion PSY401 Clinical Psychology Assignment 01 Fall 2020 Solution / Discussion
47 minutes ago
Saba liked +M.Tariq Malik's discussion VU New Grading Scheme For Semester Fall 2020
2 hours ago
Blessings posted a status
"Mn is qabil tu na tha .....................jis qabil mjhe RUB ne bna diya JUMMA MUBBARAK"
2 hours ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion PSY402 Experimental Psychology Assignment 01 Fall 2020 Solution / Discussion Due Date: 07-12-2020 in the group PSY402 Experimental Psychology
3 hours ago
+M.Tariq Malik liked ・༓☾ Shayna ☽༓・'s blog post ✿ Money Can't Buy ✿
4 hours ago
+M.Tariq Malik replied to Muhammad Faizan Alam's discussion STA301 Assignment No.1 | FALL 2020 | Due Date: 8th December, 2020 in the group STA301 Statistics and Probability
4 hours ago
Ali Fahad joined +M.Tariq Malik's group
4 hours ago
Ali Fahad joined +M.Tariq Malik's group
4 hours ago
Ali Fahad joined +M.Tariq Malik's group
4 hours ago

© 2020   Created by +M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.