期刊文献+

Apriori算法在SQL中的改进与应用 被引量:5

Application of improved Apriori algorithm with SQL
下载PDF
导出
摘要 Apriori算法是挖掘关联规则的经典算法。在分析该算法的基础上,在实际项目应用当中,结合SQL的特点,提出Apriori算法在SQL中的改进算法——Apriori_Sql。应用Apriori_Sql算法只需扫描一遍数据库,在数据库临时表中建立原始数据库的压缩数据映射,实验表明该算法是一种高效的关联规则的挖掘算法。 Apriori algorithm is a classical algorithm of association rule mining. A new association rule algorithm, improved Apriori algorithm with SQL-Apriori Sql, is presented based on analysis Apriori algorithm. Apply Apriori_Sql algorithm only need one scan of database, building the compressed data mapping of original database in temp table, and practice results show that Apriori_Sql algorithm is an efficient algorithm.
出处 《计算机工程与设计》 CSCD 北大核心 2007年第13期3060-3062,3233,共4页 Computer Engineering and Design
关键词 数据挖掘 关联规则 频繁项目集 APRIORI算法 结构化查询语言 临时表 data mining association rule frequent itemset apriori algorithm SQL temp table
  • 相关文献

参考文献9

二级参考文献65

  • 1王创新.关联规则提取中对Apriori算法的一种改进[J].计算机工程与应用,2004,40(34):183-185. 被引量:32
  • 2李清峰,杨路明,张晓峰,龙艳军.数据挖掘中关联规则的一种高效Apriori算法[J].计算机应用与软件,2004,21(12):84-86. 被引量:29
  • 3徐章艳,刘美玲,张师超,卢景丽,区玉明.Apriori算法的三种优化方法[J].计算机工程与应用,2004,40(36):190-192. 被引量:71
  • 4David Hand,Heikki Mannila,Padhraic.Principles of Data Mining ISBN0-262-08290-X,2001.
  • 5Richard J.Roiger,Michael W.Geatz 著,翁敬弄译.Data Mining A Tutorial-Based Primer,北京:清华大学出版社,2003.
  • 6Agrawal R, Imielinski T, Swami A. Mining association rules between sets of items in large databases [C]. Proceedings of the ACM SIGMOD conference on management of data, 1993, 207-216.
  • 7Han J, Pei J, Yin Y. Mining frequent pattems without candidate generation [C]. Proc 2000 ACM-SIGMOD Int Conf Management of Data(SIGMOD' 00), Dalas, TX, 2000.
  • 8Savasere A, Omiecinski E, Navathe S. An efficient algorithm for mining association rules in large databases[C]. Proceedings of the 21st International Conference on Very large Database,1995.
  • 9Mannila H, Toivonen H, Verkamo A. Efficient algorithm for discovering association rules[C]. AAAI Workshop on Knowledge Discovery in Databases, 1994.181-192.
  • 10Toivonen H. Sampling large databases for association rules[C].Bombay, India: Proceedings of the 22nd International Conference on Very Large Database, 1996.

共引文献154

同被引文献34

引证文献5

二级引证文献8

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部