Patent ID: 6718338
Filing Date: 2004-04-06
Classification: G06F,Y10S

Abstract:
A method for storing data mining clustering results in a relational database for querying and reporting, the method applied to data mining results from scoring of data items in operational data, the method comprising the steps of:reading, from a hierarchical clustering node embodied in a hierarchical representation of data mining results, clustering data describing a clustering, and recording the clustering data in a relational clustering record, wherein the relational clustering record includes a clustering identification field; reading, from a hierarchical cluster node embodied in the hierarchical representation of data mining results, cluster data describing a cluster, and recording the cluster data in a relational cluster record, wherein the hierarchical cluster node is embodied in a position in the hierarchy below the hierarchical clustering node, the relational cluster record is related to the relational clustering record through a first foreign key comprising the clustering identification field; and the relational cluster record includes a cluster identification field; reading, from a hierarchical cluster attribute node embodied in the hierarchical representation of data mining results, cluster attribute data describing a cluster attribute, and recording the cluster attribute data in a relational cluster attribute record, wherein the hierarchical cluster attribute node is embodied in a position in the hierarchy below the hierarchical cluster node, the relational cluster attribute record is related to the relational cluster record through a second foreign key comprising the cluster identification field; the relational cluster attribute record is related to the relational clustering record through a third foreign key comprising the clustering identification field; and the relational cluster attribute record includes a cluster attribute identification field; reading, from a hierarchical cluster attribute bin node embodied in the hierarchical representation of data mining results, cluster attribute bin data describing a cluster attribute bin, and recording the cluster attribute bin data in a relational cluster attribute bin record, wherein the hierarchical cluster attribute bin node is embodied in a position in the hierarchy below the hierarchical cluster attribute node, the relational cluster attribute bin record is related to the relational cluster attribute record through a fourth foreign key comprising the cluster attribute identification field; the relational cluster attribute bin record is related to the relational cluster record through a fifth foreign key comprising the cluster identification field; and the relational cluster attribute bin record is related to the relational clustering record through a sixth foreign key comprising the clustering identification field; wherein the cluster data, the clustering data, the clustering attribute data, and the cluster attribute bin data comprise data mining results generated by at least one data mining operation performed upon operational data using a trained data mining model.