Latest Activity In Study Groups

Join Your Study Groups

VU Past Papers, MCQs and More

We non-commercial site working hard since 2009 to facilitate learning Read More. We can't keep up without your support. Donate.

CS614 ALL Current Final Term Papers Fall 2015 & Past Final Term Papers at One Place from 27 February 2016 to 16 March 2016

CS614 ALL Current Final Term Papers Fall 2015 & Past Final Term Papers at One Place from 27 February 2016 to 16 March 2016 

You Can Download Solved Final Term PapersShort Notes, Lecture
Wise Questions Answers Files, Solved MCQs, Solved Quizzes , Solved Final Term Subjective Papers , Solved Final Term Objective Papers From This Discussion For Preparation Final Term Papers of 2016

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.

You Can download papers by a simple click on file. All the uploaded filed are in Zip file or PDF format So Install Adobe Reader and Winrar Software’s to open these Files

Note: If you download files with Internet Download Manager (IDM), you would face problem of damage files. All files are correct and no damage file, If you face this problem, Open IDM > Click on Options > Click on File Types > Remove PDF and ZIP from files types and save. After it download again files, files will work properly.OR Press alt+click the file ...

Thanks and Regards,

VU Students.ning Social Network

Views: 6564

Replies to This Discussion

pls is current papers ko solve kr k file upload b krta jayee sath sath jazak allah

: Identify the given statements as correct or incorrect and justify your answer in either
case.
1. “Median is an example of Distributive Aggregate”.q2;supervised learning in data mining q3:down any four ways to identify the session in World Wide Web
q4:we have seen many issues during data acquisition & cleansing in agriculture data
warehouse case study. In your point of view why those issues have arisen? Briefly
explain….5m q;
Briefly explain any two types of precedence constraints that we can use in DTS….
Identify kerna tha k ye statement correct he ya incorrect aur reason btana tha
Bayesian modeling is an example of unsupervised learning”

ik table diyahoatha bitmap index table
: Types of partitioning used in shared nothing environment

Which script languages are used to perform complex transformation in DTS
package?

Persistent cookies limitations

here is the solved all current above questions.

Attachments:

parallel Hardware Architectures:
======================
Symmetric Multi Processing (SMP)
Distributed Memory or Masively parallel processing (MPP)
Non-Uniform Memory Access (NUMA)

Parallel software Architectures:
======================
Share Memory
Share Disk
Share Nothing

Scripting languages are used to perform complete transformation in DTS packages.
=============================
VB- Script and J-Script

A data warehouse project is more like scientific research than anything in traditional IS!
=========================
agree with this statement
The normal Information System (IS) approach emphasizes on knowing what the expected
results are before committing to action. In scientific research, the results are unknown up
front, and emphasis is placed on developing a rigorous, step-by-step process to uncover
the truth.

Static Attributes Dynamic Attributes
1 Farmer Name 1 Date of Visit
2 Farmer Address 2 Pest Population
3 Field Acreage 3 CLCV
4 Variety(ies) Sown 4 Predator Population
5 Sowing date 5 Pesticide Spray Dates
6 Sowing method 6 Pesticide(s) Used

Drawbacks of traditional web searches:
============================
Limited to keyword based matching.
Can not distinguish between the contexts in which a link is used.
Coupling of files has to be done manually

How would you determine out table in Nested-Loop join?
==========================================
The smallest number of qualifying rows, and/or
The largest numbers of I/Os required to locate the rows.

Write names of first two steps of Kimball DWH lifecycle?
=======================================
Project planning
Business Requirements Definition

Write at least three name of Shared nothing RDBMS architecture? (3 marks)
======================================
Hash partitioning
Key range partitioning.
List partitioning.

Why RAD methodology is successful, write at least two reasons? (5 marks)
===========================================
Rapid Application Development (RAD) is an iterative model consisting of stages
like scope, analyze, design, construct, test, implement, and review. It is much better suited
to the development of a data warehouse because of its iterative nature and fast iterations.

Pest scouting:
============
Pest scouting is a systematic field sampling process that provide field specific information on pest pressure and crop injury.

what is reverse proxy?
==================
Reverse Proxy Another type of proxy server, called a reverse proxy, can be placed in front of our enterprise's Web servers to help
them offload requests for frequently accessed content.

How gender guide is used if large number of records, gender is missing?
======================================
If for very large number of records gender is missing, it would become impossible for us to manually check
each and every individual‘s name and identify the gender. In such cases we can formulate a mechanism to
correct gender. We can either use a standard gender guide or create a new table Gender_guide. Gender_guide
contains only two columns name and gender. Populate Gender_guide table by a query for selecting all distinct
first names from student table. Then manually placing their gender.

The pest scouting data is being constantly recorded by:
======================================
the Directorate of Pest Warning and Quality Control of Pesticides (DPWQCP), Punjab
since 1984.

Differentiate between DDS, Data mining and Data Warehouse DWH
===================================================
A DDS is a database that stores the data warehouse data in a different format than OLTP.
Data mining is the process of exploring data to find the patterns and relationships that describe the data and to
predict the unknown or future values of the data. The key value of data mining is the ability to understand why
some things happened in the past and the ability to predict what will happen in the future.
A data warehouse is a system that retrieves and consolidates data periodically from the source systems into a
dimensional or normalized data store.

write any three complete warehouse deliverable:
==================================
? Data
? Analytic applications
? Data access tools
? Education tools

DW Lifecycle- Step 4: Deployment
• The three tracks converge at deployment.
• Not natural, require substantial pre-planning, courage, will-power and honesty.
• Something like waiting for arrival of Baarat, as only then meals can be served
• The Dulaaha is the key like data.
• Should serve uncooked data i.e. Dulaaha under a Sehara (not possible now) or
wait and miss the deadline.

Special Index techniques
==================
? Inverted index
? Bit map index
? Cluster index
? Join indexes

data mininig technique:
=================
classifications
estimation
prediction
market masket analysis
clustering
There are many variants of the traditional nested-loop join. Name any two.
===============================================

There are many variants of the traditional nested-loop join. The simplest case is when an
entire table is scanned; this is called a naive nested-loop join. If there is an index, and that
index is exploited, then it is called an index nested-loop join. If the index is built as part
of the query plan and subsequently dropped, it is called as a temporary index nested-loop
join.

three major approaches when accessing information stored on the Web:
======================================
keyword-based search
querying deep web sources
Random surfing

How it is possible that a sparse index takes even less space than dense index?
==============================================
sparse index Uses even less space than dense index, but the block has to be searched, even for
unsuccessful searches

Time complexity of K-means algorithm is O(tkn). What does “t”, “k” and “n” represent here?
=============================================
Relatively efficient: O(tkn), where n is # objects, k is # clusters, and t is #
iterations. Normally, k, t n. ? Often terminates at a local optimum. The global optimum may be found using techniques such as: deterministic annealing and genetic algorithms large enterprise which uses the same server for the development and production environments. What problems can arise if it uses single server for both purposes? ======================================================== Sometimes it is possible that the server needs to be rebooted for the development environment. Having a separate development environment will prevent the production environment from being effected by this. • There may be interference while having different database environments on a single server. For example, having multiple long queries running on the development server could affect the performance on the production server, as both are same. pipelining concept: ============== Pipelining: Speed-Up Calculation Time for sequential execution of 1 task = T Data Warehousing (CS614) © Copyright Virtual University of Pakistan 215 Time for sequential execution of N tasks = N * T (Ideal) time for pipelined execution of one task using an M stage pipeline = T (Ideal) time for pipelined execution of N tasks using an M stage pipeline = T + ((N-1) × (T/M)) Speed-up (S) =NT/{T+(N-1) * T/M} Data profiling is a process of gathering information about columns, what are the purposes that it must fulfill? =============================================== Data profiling, gathering information about columns, fulfils the following two purposes – Identify the type and extent to which transformation is required – Gives us a detailed view of data quality d-MMM-yy format: ============== Profiling Date needs to change our flow of work. For columns before this we just did profiling and no transformation has been done yet. We can not profile date without transforming it. So we need to transform date first and then profile. The problem is, when we loaded all records to SQL server from text files they are loaded as strings (character arrays). While profiling we may want to get the range of dates (minimum and maximum dates). We can not identify date ranges until or unless we transform it as date data type. In context of Web data warehousing, consider the “web page” dimension, list at least five possible attributes of this dimension. ======================================== Page key Page source Page function Page template Item type Graphic type Animation type Sound type Page file name There are different data mining techniques e.g. “clustering”, “description” etc. Each of the following statement corresponds to some data mining technique. For each statement name the technique the statement corresponds to. ========================================= a) Assigning customers to predefined customer segments (i.e. good vs. bad) classification b) Assigning credit applicants to predefined classes (i.e. low, medium, or high risk) classification c) Guessing how much customers will spend during next 6 months prediction d) Building a model and assigning a value from 0 to 1 to each member of the set. Then classifying the members into categories based on a threshold value. Estimation e) Guessing how much students will score more than 65% grades in midterm. Prediction There are two primary techniques for gathering requirements i.e. interviews or facilitated sessions. Which technique is preferred by Ralph Kimball? ============================================ Both have their advantages and disadvantages. Interviews encourage lots of individual participation. They are also easier to schedule. Facilitated sessions may reduce the elapsed time to gather requirements, although they require more time commitment from each participant. Kimball prefers using a hybrid approach with interviews to gather the gory details and then facilitation to bring the group to consensus. any two types of precedence constraints that we can use in DTS. ============================================= Unconditional on success There are four categories of data quality improvement. Write any two. (2 marks) =============================== The four categories of Data Quality Improvement • Process • ƒSystem • ƒPolicy & Procedure • ƒData Design "One-way clustering is used to get local view and Two-way clustering is used to get global view." ============================== Incorrect One-way clustering gives global view and bi-clustering gives local view Accuracy: ======= Accuracy or confidence level = matches/ total number of matches Is there any strategy to standardize a column: ============================== no List at least 2 barrier of linear speedup. ============================= Amdahl’ Law Startup interference Skew Write 2 limitation of persistent cookies: ============================ • It's possible that the visitor will have his or her browser set to refuse cookies or may clean out
his or her cookie file manually, so there is no absolute guarantee that even a persistent cookie
will survive.
? • Although any given cookie can be read only by the Web site that caused it to be created,
certain groups of Web sites can agree to store a common ID tag that would let these sites
combine their separate notions of a visitor session into a super session

Write three activities requirement preplanning phase:
=====================================
Requirements preplanning: This phase consists of activities like choosing the
forum, identifying and preparing the requirements team and finally selecting, scheduling
and preparing the business representatives.

1. “Median is an example of Distributive Aggregate”.

Answer :

No. Median is an example of Holistic aggregate.

 

q2;supervised learning in data mining

Answer:

Supervised learning is when you are performing DM the supporting information that helps in the DM process is also available. Information means you may know your data that how many groups or classes your data set contains. What are the properties of these classes or clusters?

 

 q3: down any four ways to identify the session in World Wide Web

Answer:

  There are several ways to do this

ƒ   Using Time-contiguous Log Entries 

ƒ   Using Transient Cookies 

ƒ   Using HTTP's secure sockets layer (SSL)

ƒ   Using session ID Ping-pong

ƒ   Using Persistent Cookies

 

q4:we have seen many issues during data acquisition & cleansing in agriculture data warehouse case study. In your point of view why those issues have arisen? Briefly

explain….5m q;

Answer :

            Data cleansing  and standardization  is probably the  largest  part  in  an  ETL exercise. For Agri-DWH major issues of data cleansing had arisen due to data processing and handling

at four levels by different groups of people i.e. (i) Hand recordings by the scouts at the

field  level  (ii)  typing  hand  recordings  into  data  sheets  at  the  DPWQCP  office  (iii)

photocopying of the scouting sheets by DPWQCP personnel and finally (iv) data entry or digitization by hired data entry operators. 

 

Briefly explain any two types of precedence constraints that we can use in DTS….

Answer :

Unconditional:  If  you  want  Task  2  to  wait  until  Task  1  completes,  regardless  of  the outcome, link Task 1 to Task 2 with an unconditional precedence constraint.

On  Success:  If  you  want  Task  2  to  wait  until  Task  1  has  successfully  completed,  link Task 1 to Task 2 with an On Success precedence constraint.

On Failure: If you want Task 2 to begin execution only if Task 1 fails to execute successfully, link Task 1 to Task 2 with an On Failure precedence constraint. If you want

to run an alternative  branch  of  the  workflow  when an error is encountered, use this constraint.

 

Identify kerna tha k ye statement correct he ya incorrect aur reason btana tha

 

 

Bayesian modeling is an example of unsupervised learning”

Answer :

Bayesian modeling is an example of supervised learning.

 

ik table diya hoa tha btna tha p index table

 

: Types of partitioning used in shared nothing environment

Answer:

There are five Types of partitioning used in shared nothing environment

  1. ƒ   Hash partitioning
  2. ƒ   Key range partitioning.
  3. ƒ   List partitioning.
  4. ƒ   Round-Robin
  5. ƒ   Combinations (Range-Hash & Range-List)

 

Which script languages are used to perform complex transformation in DTS package?

Answer: VB Script or Java Script  

Persistent cookies limitations: It’s possible that the visitor will have his or her browser set to refuse cookies or may clean out his or her cookie file manually, so there is no absolute guarantee that even a persistent cookie will survive.

• Although any given cookie can be read only by the Web site that caused it to be created, certain groups of Web sites can agree to store a common ID tag that would let these sites combine their separate notions of a visitor session into a super session.

RSS

Looking For Something? Search Below

Latest Activity

waseem akram left a comment for Huma Ahmad
3 hours ago
waseem akram left a comment for Huma Ahmad
3 hours ago
Hania Khalid Shariff is now friends with Mr Siren Head and Huma Ahmad
5 hours ago
saba zulfqar posted blog posts
8 hours ago
+ ¢αяєℓєѕѕ gιяℓ updated their profile
9 hours ago
saba zulfqar and Hania Khalid Shariff are now friends
11 hours ago
Mr Siren Head replied to Hania Khalid Shariff's discussion zero semester
17 hours ago
Profile Iconshahzad Hussain and Umar Farooq joined Virtual University of Pakistan
17 hours ago

VIP Member Badge & Others

How to Get This Badge at Your Profile DP

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

Management: Admins ::: Moderators

Other Awards Badges List Moderators Group

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

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