Chaining database records that represent a single customer or multiple customers living in a household
First Claim
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 Assignments
0 Petitions
Accused Products
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.
-
Citations
8 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. - View Dependent Claims (2, 3, 4)
-
-
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. - View Dependent Claims (6, 7, 8)
-
Specification