Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

larclall audi lectronic niversity is materializing the cells of only interesting

ID: 3727610 • Letter: L

Question

larclall audi lectronic niversity is materializing the cells of only interesting cuboids? a Closed cube b. Iceberg cube c. Full cube d. Shell fragmentation 8. Consider a data cube with the dimensions month, city, and customer is the price. The base cell is a. (Jan, Toronto, Business, 150) b.(Jan, . Business, 2000) c .Toronto,,3000) d. (Jan". 2100) The rules 9. is a seminal algorithm for mining frequent itemsets for a. Confidence interval b. Apriori algorithm c. Lanier Analysis d. None of the Above 10. Any subset ofa frequent itemset must a closed b. frequent c. open d. not frequent

Explanation / Answer

7.

(b) Iceberg cube

Explanation: Iceberg cube is materializing the cells of only interesting cuboids. It computes the cuboid cells whose count or other aggregates satisfies a particular condition. It calculates only the data above a certain threshold which refers to calculating the interesting cuboids.

8.

(a) (Jan, Toronto, Business, 150)

Explanation: A base cell is a cell in the base cuboid which simply contains values. An aggregated dimension is basically represented by an asterisk symbol (). Since all other choices except (a) contain the asterisk symbol, they are not the base cell. Hence, the base cell is the choice (a).

9.

(b) Apriori algorithm

Explanation: The apriori algorithm is used for mining frequent itemsets using the candidate generation seminal algorithm which was proposed by R. Agrawal and R. Srikant.

10.

(b) frequent

Explanation: Any subset of the frequent itemset must be frequent. It is a subset property which is used by Apriori algorithm.