Abstract: Mining maximum frequent item sets is the key issues in the application of data mining association rules. Combined with features of SQL language, improvement on Apriori algorithm can make efficiency improvements to a certain extent, because improved Apriori algorithm does not need to scan the database many times and narrows the search space constantly. The paper puts the application into frequently visiting in the page mining to find out the association rules of Web visited information, to better organize the Web site space for the convenience of users.

Key words: SQL, frequent access pages, association rule, Apriori algorithm