Research on frequent itemsets based on SQL

Apriori algorithm is a typical algorithm of mining frequent itemsets for association rule.Based on the apriori algorithm,using powerful functions of relation database management system and simple operation and high efficiency of SQL,an apriori algorithm based on SQL is proposed.Implementation of the algorithm are simple and fast and the scan database is reduced effectively.The algorithm applies to web log file database which has been data-preprocessed,and the result indicates that the algorithm is effective.