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

• US 6,912,540 B2
• Filed: 05/03/2002
• Issued: 06/28/2005
• Est. Priority Date: 05/04/2001
• Status: Expired due to Fees

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: NCR Corporation
• Inventors: Pricer, James E., Kohut, Eric J.
• Primary Examiner(s): Robinson, Greta
• Assistant Examiner(s): Black, Linh
• Application Number:
  US10/138,665
• Publication Number:
  US 20020184222A1
• Time in Patent Office: 1,152 Days
• Field of Search: 707 1- 10, 707100-1041, 707200-205, 705 7- 8, 705/10, 705/14, 705 35- 53, 705/57, 705/80, 705/26, 379/211.01, 379/111, 379/112, 379/114.01, 379188-189, 379/67.1, 709217-218, 709/238, 709/200, 709/230
• US Class Current: 1/1
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

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.

Claims

1. In a database system that stores information about the customers of a business in one or more relational tables, a method for use in linking multiple records that represent a particular customer, the method comprising:

combining data from two or more attribute columns in one or more of the relational tables to form a single column of concatenated data;

identifying two or more records that share a common value in the column of concatenated data, indicating that the records all represent a particular customer;

assigning a unique identification value to the customer; and

storing the identification value with each of the identified records.

2. The method of claim 1, where the customer is a group of individuals who all live together in a single household.

3. The method of claim 1, where the customer is a single individual.

4. The method of claim 1, where the concatenated data includes information about both the customer'"'"'s name and customer'"'"'s address.

5. A computer program, stored on a tangible storage medium, for use in linking multiple customer records in a database system that stores information about the customers of a business in one or more relational tables, the program comprising executable instructions that cause a computer to:

combine data from two or more attribute columns in one or more of the relational tables to form a single column of concatenated data;

identify two or more records that share a common value in the column of concatenated data, indicating that the records all represent a particular customer;

assign a unique identification value to the customer; and

store the identification value with each of the identified records.

6. The program of claim 5, where the customer is a group of individuals who all live together in a single household.

7. The program of claim 5, where the customer is a single individual.

8. The program of claim 5, where there concatenated data includes information about both the customer'"'"'s name and customer'"'"'s address.