Association Rules Mining: An Intelligent Implementation Technique Based-On Sql

Sq Shan,L Liu
2002-01-01
Abstract:We study the problem of implementation technique of mining association rules in large database. A lot of algorithms of mining association rules are heap-mining algorithms That is said, the mining algorithms are used to mine the association rules from the heap of transaction data. The efficiency of the algorithms is the bottleneck of mining association rules because the huge amount of transaction data. An intelligent implementation technique based on SQL is proposed in the paper. I-Apriori algorithm, complete implemented by Structured Query Language (SQL), is a point-mining algorithm. That is said, I-Apriori algorithm is only used to mine association rules at the time when a new transaction is inserted into the transaction database. In this paper, the intelligent technique is described in three aspects: 1) the definitions of transaction with item amount constraint are given, 2) I-Apriori algorithm is described in detail, and 3) some key techniques are detail explored.
What problem does this paper attempt to address?