Apriori algorithm-find all frequent large itemsets, Database Management System

Your friend owns a computer store in Yuen Long, selling Desktop and Notebook PCs and other computer peripherals. Having been rather successful with his business there, he decided to venture into the infamous Mongkok Computer Center and has already been there for three months. As expected, compared to his Yuen Long store, his new store has been recording much larger revenue but when it comes to profit, he is not so sure. He needs to pay several times more in rent! In order to stimulate sales, your friend feels that he needs to understand his customers in Mongkok more. To help him do so, you have asked for a sample of the transactional data he collected and they are shown in Table.

a)  Set the Minimum Support to 18% and Minimum Confidence to 80%, find all frequent large itemsets (for product items) and all interesting rules using the Apriori algorithm.

(Please show your work step by step clearly and discuss what you would do with the item "Maintenance".)

b) By setting the Lift Ratio to 2, which rules you discovered in Part (a) are still interesting?

c) How many possible association rules (even though both the support and confidence are 0) would be generated from the following itemsets: {Case, Desktop, Maintenance, Mouse, Speaker, Webcam} and {Computer, Printer, Peripherals, Notebook_PC}. Compare the results, what you can conclude?



Posted Date: 4/5/2013 5:19:31 AM | Location : United States

Related Discussions:- Apriori algorithm-find all frequent large itemsets, Assignment Help, Ask Question on Apriori algorithm-find all frequent large itemsets, Get Answer, Expert's Help, Apriori algorithm-find all frequent large itemsets Discussions

Write discussion on Apriori algorithm-find all frequent large itemsets
Your posts are moderated
Related Questions

Why containment is important in oosystems? Containment is an significant concept in oosystems because it allows dissimilar users to view data at different granularities.

What do you mean by Correlated subquery? Subqueries, or nested queries, are used to bring back a set of rows to be used by the parent query. Depending on how the subquery is writ

what would go in order patient#, patient name, patien address, surgeon#, surgeon name, surgery date, surgery type, drug admin

explain exhausitively the problems associated with er diagrams with ellustrations

Question 1 Explain ER model Question 2 What are the characteristics of a computer provided information? Question 3 What are facts and guidelines to be considered when se

Explain in detail the consistency model of the distributed file system you studied (GFS or AFS). Present the consistency model chosen and how it was achieved through design. Clarit

What are the benefits of decomposing a system? The benefits of decomposing a system into subsystems are that after decomposition, each individual component become smaller and e

Explain the difference between optimistic locking and pessimistic locking. Optimistic locking supposes no transaction conflict will occur and deals with the consequences if it

What are the benefits of document scanning? Document scanning, in addition to being cost-efficient, also enhances productivity. This service enhances security as you set the pa