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
Identification of concurrency Identification of concurrency: Dynamic model identifies concurrency. Two objects are said to be parallel (concurrent) if they can receive events a

Un-Normalized Form (UNF) If a table having non-atomic values at every row, it is said to be in UNF. An atomic value is something that cannot be further decomposed. A non-atomic

CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., cruise control) that were sold at a de

Differentiate between horizontal & mixed horizontal fragmentation?

What are the Requirements of algorithm designer Algorithm designer should: i) Select proper algorithm so as to minimize implementation cost ii) Find most appropriate d

State the Design of Associations Before designing associations, it is essential to know the way they are used. For this, analysis of association traversals is required. It is

Illustrate the Deployment Diagram A deployment diagram shows all nodes on network, their processor execution and interconnections. In a dynamic model, this is used to represen

Explain Thomas' Write rule.  Show how it is different from timestamp ordering protol Ans: In timestamp-based concurrency control the thomas Write rule is a rule. Given a Timest

What is the initial step for object-oriented designing The initial step for object-oriented designing is object modeling. Before we go into deep about object modeling first of

create an e-r diagram usuing graphical dipicted software that could theoritically be used in resturant application