Chaining database records that represent a single customer or multiple customers living in a household
US6912540B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | May 3, 2002 |
| Grant date | Jun 28, 2005 |
| Priority date | — |
| Expiry date | May 23, 2023 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99945
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.