| 利用SQL语言的数据挖掘系统的设计 |
| |
| 引用本文： | 罗英辉.利用SQL语言的数据挖掘系统的设计[J].广东教育学院学报,2007,27(3):89-92. |
| |
| 作者姓名： | 罗英辉 |
| |
| 作者单位： | 广东教育学院计算机科学系 广东广州510303 |
| |
| 摘 要： | 设计了一种简单实用的计算关联规则的解决方案,在零售业务关系型数据库中挖掘出二种不同商品之间的关联规则,即商品间的置信度和支持度.该方案利用关系型数据库本身强大的SQL查询功能,以相关专家知识作为挖掘过程的元数据支持,更准确地计算商品间的关联,避免了由于商品在销售过程的商品之间的可替代性而引起的信息衰减.
|
| 关 键 词： | SQL 元数据 关联规则 数据挖掘 |
| 文章编号： | 1007-8754（2007）03-0089-04 |
| 修稿时间： | 2007-03-27 |
The Design of a Data Mining System Based on SQL |
| |
| LUO Ying-hui.The Design of a Data Mining System Based on SQL[J].Journal of Guangdong Education Institute,2007,27(3):89-92. |
| |
| Authors: | LUO Ying-hui |
| |
| Institution: | Dept. of Computer Science, Guangdong Education Institute, Guangzhou, Guangdong, 510303, P. R. China |
| |
| Abstract: | This paper brings out a simple and applied solution for calculation relating rules.It can mine the relating rules between the two kinds of goods in the retail services data,that is,the degrees of confidence and support between goods.With the help from the powerful query performance of SQL and the special knowledge as metadata during mining process,this solution can calculate more exactly the relations among goods and avoid the information attenuation caused by alternative goods. |
| |
| Keywords: | SQL metadata relating rules data mining |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
