Chaining database records that represent a single customer or multiple customers living in a household
View Patent ↗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.
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.