Your customer wants to determine “market baskets.” What do you recommend?
A.
Use Oracle OLAP Option.
B.
Use Oracle SQL Analytic Functions.
C.
Use associations algorithm in Oracle Data Mining.
D.
Use regression analysis in Oracle Data Mining
Explanation:
Association is a data mining function that discovers the probability of the cooccurrence of items in a collection. The relationships between co-occurring items are expressed
as association rules.
Market-Basket Analysis
Association rules are often used to analyze sales transactions. For example, it might be noted that
customers who buy cereal at the grocery store often buy milk at the same time. In fact, association
analysis might find that 85% of the checkout sessions that include cereal also include milk. This
relationship could be formulated as the following rule.
Cereal implies milk with 85% confidence
This application of association modeling is called market-basket analysis. It is valuable for direct
marketing, sales promotions, and for discovering business trends. Market-basket analysis can also
be used effectively for store layout, catalog design, and cross-sell.
Association Algorithm
Oracle Data Mining uses the Apriori algorithm to calculate association rules for items in frequent
itemsets.
Reference: Oracle Data Mining Concepts 11g Release 2
http://docs.oracle.com/cd/E11882_01/datamine.112/e16808/market_basket.htm