Patent ID: 6549910
Filing Date: 2003-04-15
Classification: G06F,Y10S

Abstract:
A computer-implemented system for performing data mining applications, comprising:(a) a computer having one or more data storage devices connected thereto, wherein a relational database is stored on one or more of the data storage devices; (b) a relational database management system, executed by the computer, for accessing the relational database stored on the data storage devices; and (c) an analytic application programming interface (API), executed by the computer, that generates an automated, adaptive, histogram bin data description assist function performed directly within the relational database management system, (d) wherein the automated, adaptive, histogram bin data description assist function counts a number of occurrences of values in value ranges for a numeric data element in a column of a table stored in the relational database, (e) wherein the automated, adaptive, histogram bin data description assist function creates a plurality of bins, and each of the bins stores a selected range of values for the numeric data element; and (e) wherein the automated, adaptive, histogram bin data description assist function accepts one or more parameters selected from a group comprising: a table name, a name of a numeric column in the table, a desired number of equal sized bins, a frequency percentage above which a value of the numeric data element should be treated as a spike, a percentage above which a bin should be further subdivided into sub-bins, a WHERE clause that reduces a beginning and ending range of the bins, and a WHERE clause that filters rows.