PDA

View Full Version : cs614 dataware house solved quiz for 2012



rabeel
12-31-2011, 03:40 AM
The goal of ___________ is to look at as few blocks as possible to find the matching records(s).
Indexing
There are many variants of the traditional nested-loop join. When the entire table is scanned it is called


The goal of ideal parallel execution is to completely parallelize those parts of a computation that are not constrained by data dependencies. The smaller the portion of the program that must be executed __________, the greater the scalability of the computation.
Sequentially

There are many variants of the traditional nested-loop join. If the index is built as part of the query plan and subsequently dropped, it is called
Naive nested-loop join
Data mining derives its name from the similarities between searching for valuable business information in a large database, for example, finding linked products in gigabytes of store scanner data, and mining a mountain for a _________ of valuable ore.
Data mining is a/an __________ approach, where browsing through data using data mining techniques may reveal something that might be of interest to the user as information that was unknown previously.
Exploratory
The technique that is used to perform these feats in data mining is called modeling, and this act of model building is something that people have been doing for a long time, certainly before the _________ of computers or data mining technology.
Access
An optimized structure which is built primarily for retrieval, with update being only a secondary consideration is
Inverted Index
Data mining uses _________ algorithms to discover patterns and regularities in data.
Statistical
In nested-loop join case, if there are ‘M’ rows in outer table and ‘N’ rows in inner table, time complexity is
O (MN)