| 基于SQL的频繁项目集的研究 |
| |
| 引用本文： | 王涛伟,胡锡伟,柴本成. 基于SQL的频繁项目集的研究[J]. 计算机工程与设计, 2006, 27(23): 4494-4497 |
| |
| 作者姓名： | 王涛伟 胡锡伟 柴本成 |
| |
| 作者单位： | 浙江万里学院,计算机与信息学院,浙江,宁波,315100 |
| |
| 摘 要： | Apriori算法是关联规则中挖掘频繁项目集的典型算法。在Apriori算法的基础上，利用关系数据库管理系统的强大功能和SQL语言操作简单，效率高的特点，提出了基于SQL的Apriori算法。该算法实现简单快速，可有效缩小扫描数据库的大小。将该算法应用于经过数据预处理的Web日志文件数据库，实验结果显示谊算法是有效的。
|
| 关 键 词： | 数据挖掘 关联规则 频繁项目集 数据预处理 Web日志文件 |
| 文章编号： | 1000-7024（2006）23-4494-04 |
| 收稿时间： | 2005-11-07 |
| 修稿时间： | 2005-11-07 |
Research on frequent itemsets based on SQL |
| |
| WANG Tao-wei,HU Xi-wei,CHAI Ben-cheng. Research on frequent itemsets based on SQL[J]. Computer Engineering and Design, 2006, 27(23): 4494-4497 |
| |
| Authors: | WANG Tao-wei HU Xi-wei CHAI Ben-cheng |
| |
| Affiliation: | College of Computer Science and Information Technology, Zhejiang Wanli University, Ningbo 315100, China |
| |
| Abstract: | Apriori algorithm is a typical algorithm of mining frequent itemsets for association mle. 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. |
| |
| Keywords: | SQL |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
