DATA PERTURBATION OF NON-UNIQUE VALUES

• US 20080263065A1
• Filed: 01/28/2008
• Published: 10/23/2008
• Est. Priority Date: 01/26/2007
• Status: Active Grant

• Current Assignee: Information Resources Incorporated
• Original Assignee: Information Resources Incorporated
• Inventors: West, John Randall
• Granted Patent: US 8,504,598 B2
• Time in Patent Office: Days
• US Class Current: 707/100
• CPC Class Codes: G06F 16/24556 Aggregation; Duplicate elimination
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06Q 30/0201 Market modelling; Market analysis; Collecting market data

Abstract

In embodiments of the present invention, improved capabilities are described for perturbing non-unique values may comprise finding the non-unique values in a data table, perturbing the non-unique values to render unique values, and using the non-unique values as an identifier for a data item.

Claims

1. A method comprising:

finding non-unique values in a data table;

perturbing the non-unique values to render unique values; and

using the non-unique value as an identifier for a data item.

2. The method of claim 1 wherein the data table includes sales data collected at a point of sale.

3. The method of claim 1 wherein the data table includes information collected from a panel of consumers.

4. The method of claim 1 wherein the data table includes survey data from a consumer survey.

5. The method of claim 1 wherein the data table includes data from a loyalty program.

6. The method of claim 1 wherein the data table includes data related to a sales projection.

7-16. -16. (canceled)

17. A method comprising:

finding non-unique values in a dimension data table;

perturbing the non-unique values to render unique values; and

using the non-unique value as an identifier for a data item.

18. The method of claim 17 wherein the dimension is a hierarchy.

19. The method of claim 17 wherein the dimension is a category.

20. The method of claim 17 wherein the dimension is a data segment.

21. The method of claim 17 wherein the dimension is a time.

22. The method of claim 17 wherein the dimension is a venue.

23. The method of claim 17 wherein the dimension is a geography.

24. The method of claim 17 wherein the dimension is a demographic.

25. The method of claim 17 wherein the dimension is a behavior.

26. The method of claim 17 wherein the dimension is a life stage.

27. The method of claim 17 wherein the dimension is a consumer segment.

28. A method comprising:

finding non-unique values in a data table;

perturbing the non-unique values to render unique values in a post-perturbation data table;

associating an availability condition with the perturbed data table; and

based on the availability condition, using the non-unique value as an identifier for a data item.

29. The method of claim 28 wherein the availability condition is based on statistical validity.

31. The method of claim 28 wherein the availability condition is based on permission to release data.

30. (canceled)

32-35. -35. (canceled)