SQL-based analytic algorithms
AssigneeNCR Corporation
InventorsTimothy Edward Miller, Brian Don Tate, James Dean Hildreth, Todd Michael Brye, Anthony Lowell Rollins, James Edward Pricer, Tej Anand
Life of this patent
Estimating the term…
Abstract
A method, apparatus, and article of manufacture for performing data mining applications in a relational database management system. At least one analytic algorithm (110) is performed by a computer directly against a relational database (116), wherein the analytic algorithm includes SQL statements performed by the relational database management system (114) and optional programmatic iteration, and the analytic algorithm creates at least one analytic model within an analytic logical data model from data residing in the relational database.
Claims24
A computer-implemented system for performing data mining applations, comprising:
- (a) a computer having one or more data storage devices connected thereto;
- (b) a relational database management system, executed by the computer, for managing a relational database stored on the data storage devices;
- and
- (c) at least one t algorithm performed by the computer, wherein the analytic algorithm includes SQL statements performed by the relational database management system directly against the relational database and optional programmatic iteration, the analytic algorithm creates at least one analytic model within a analytic logical data model from data residing in the relational database, and the analytic algorithm is implemented by a Data Reduction Utility Program chat reduces data from the relational database in bulk using SQL followed by a non-SQL iterative program.
A method for performing data mining applications, comprising:
- (a) managing a relational database stored on one or more data storage devices connected to a computer;
- and
- (b) performing at least one analytic algorithm in the computer, wherein the analytic algorithm includes SQL statements performed by a relational database management system directly against the relational database and optional programmatic iteration, the analytic algorithm creates at leaser one analytic model within an analytic logical data model from data residing in the relational database, and the an c algorithm is implemented by a Data Reduction Utility Program that reduces data from the relational database in bulk using SQL followed by a non-SQL iterative program.
An article of manufacture comprising logic embodying a method for performing data mining applications, comprising:
- (a) managing a relational database stored on one or more data storage devices connected to a computer;
- and
- (b) performing at least one analytic algorithm in the completer, wherein the analytic algorithm includes SQL statements performed by a relational database management system directly against the relational database and optional programmatic iteration, the analytic algorithm creates at least one analytic model within an analytic logical data model from data residing in the relational database, and the analytic algorithm is implemented by a Data Reduction Utility Program that reduces data from the relational database in bulk using SQL followed by a non-SQL iterative program.
Dependencies are inferred from the claim text.