Technique for data mining of large scale relational databases using SQL
    1.
    发明授权
    Technique for data mining of large scale relational databases using SQL 有权
    使用SQL的大型关系数据库的数据挖掘技术

    公开(公告)号:US06484163B1

    公开(公告)日:2002-11-19

    申请号:US09516524

    申请日:2000-03-01

    IPC分类号: G06R1730

    摘要: A technique for enhanced data mining of large scale relational databases is described. User defined functions (UDF) are created by a user and distributed by a managing node of a database to each node of the database. Upon the issuance of a prespecified SQL command, the UDF is executed by each node relative to the data controlled by each node. Specifically, targeted tuples in the data controlled by each node are scored based on criteria contained in the UDF. A new data field is added to each target tuple, and the score is placed therein. The score is then used to determine whether, for example, a customer which is represented by the tuple should be included in an advertising campaign or to tailor a mailing to a customer based on the score contained in the new data field.

    摘要翻译: 描述了一种用于增强大型关系数据库的数据挖掘的技术。 用户定义的功能(UDF)由用户创建并由数据库的管理节点分发给数据库的每个节点。 在发出预先指定的SQL命令之后,每个节点相对于每个节点控制的数据执行UDF。 具体来说,根据UDF中包含的标准对每个节点控制的数据中的目标元组进行评分。 将新的数据字段添加到每个目标元组,并将得分置于其中。 然后,该分数用于确定例如,由元组表示的客户是否应包含在广告活动中,或者基于新数据字段中包含的分数来定制对客户的邮寄。