Ncr Corporation

Teradata Us, Inc.

James Edward Pricer

Tej Anand

Brian Don Tate

Anthony Lowell Rollins

Timothy Edward Miller

Todd Michael Brye

Randy G Kerber

James Dean Hildreth

Eric J Kohut

A method, computer program and database system for use in analyzing associations in the order of transactions are disclosed. Data is loaded from the transactions into the database system. The data includes an entry for each transaction and the transactions are grouped into groups. The transactions within each group are put into an order. An analysis of the groups of transactions is performed to find associations in the order of the transactions in the groups.

Analyzing associations in the order of transactions

A data-processing technique improves the process of 'householding' customer data in a company's relational database system. The process involves combining data from two or more attribute columns in one or more relational tables to form a single column of concatenated data. The concatenated data is used in identifying two or more records that share a common value, which indicates that the records all represent a particular customer. A unique identification value is assigned to this customer and is stored with each of the identified records. In some embodiments, the process is used in identifying records that represent multiple customers living together in a single household.

Chaining database records that represent a single customer or multiple customers living in a household

A method, apparatus, and article of manufacture for performing data mining applications in a relational database management system. At least one analytic algorithm ( ) is performed by a computer directly against a relational database ( ), wherein the analytic algorithm includes SQL statements performed by the relational database management system ( ) 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.

SQL-based analytic algorithms

A method, apparatus, and article of manufacture for performing data mining applications in a relational database management system. An analytic algorithm for association is performed by the relational database management system to measure one or more associations between a plurality of items in a stream of transaction data stored in the relational database, wherein the analytic algorithm for association creates at least one analytic model within an analytic logical data model from data residing in the relational database.

Growing community of inventors

San Diego, CA, United States of America

James Edward Pricer