Granted Patent B2

US 7,792,835 · App. 11/782,340 · Granted Sep 7, 2010

Assignee: Mypoints.Com Inc.

Abstract

Claims (57)

1. A method for selecting mutually exclusive sets of database records from a database system comprising:

storing a plurality of database records including at least one target parameter in the database system;

assigning at least one randomly generated persistent identifier to each of the plurality of database records;

selecting a range of the at least one persistent identifier that is assigned to the plurality of database records; and

identifying a set of database records, the set of database records contained within the range of the at least one persistent identifier;

wherein the at least one persistent identifier is associated with a database record of the set of database records;

wherein the at least one database record includes at least one targeted parameter;

determining if the set of database records contains a desired number of database records;

expanding the range of the at least one persistent identifier if the desired number of database records is not contained within the set of database records; and

determining a variance between a number of database records contained within the set of database records and the desired number of database records.

2. The method of claim 1 , wherein the at least one persistent identifier is a random number including at least one of a 32-bit or a 64-bit random number.

3. The method of claim 1 , wherein identifying the set of database records comprises:

selecting at least one database record having a desired parameter;

wherein the desired parameter is common to each database record of the set of database records.

4. The method of claim 1 , further comprising determining if the range of the at least one persistent identifier conflicts with a second range of the at least one persistent identifier.

5. The method of claim 1 , wherein the at least one persistent identifier is a member of an ordered set of persistent identifiers; and

wherein a randomly selected first persistent identifier of the ordered set of persistent identifiers and a selected second persistent identifier of the set of persistent identifiers are substantially unique.

6. The method of claim 1 , further comprising:

selecting a plurality of ranges of the at least one persistent identifier; and

identifying at least one set of database records, the at least one set of database records contained within at least one of the plurality of ranges.

7. The method of claim 6 , wherein all sets of the at least one set of database records are mutually exclusive.

8. The method of claim 1 , further comprising storing the database records in a plurality of database server groups; and

selecting the range of the at least one persistent identifier across the plurality of database server groups.

9. A method of selecting disjoint sets of records from a distributed data system without performing a database join function comprising:

assigning a plurality of first randomly generated persistent identifiers to a corresponding plurality of database records;

assigning a plurality of second persistent identifiers to the corresponding plurality of database records;

selecting a range of both the plurality of first persistent identifiers and the plurality of second persistent identifiers; and

identifying a set of database records, each database record of the set of database records corresponding to both one of the plurality of first persistent identifiers and to one of the plurality of second persistent identifiers;

wherein the set of database records is within the range of both the plurality of first persistent identifiers and the plurality of second persistent identifiers;

determining if the set of database records contains a desired number of database records;

expanding the range of the at least one first persistent identifier if the desired number of database records is not contained within the set of database records; and

determining a variance between a number of database records contained within the set of database records and the desired number of database records.

10. The method of claim 9 , further comprising:

identifying a plurality of sets of database records;

wherein the plurality of sets of database records are substantially mutually exclusive.

11. The method of claim 9 , wherein identifying a set of database records comprises:

selecting at least one database record having a desired parameter;

wherein the desired parameter is common to each database record of the set of database records.

12. The method of claim 9 , further comprising expanding the range of the plurality of persistent identifiers when the set of database records does not contain a desired number of qualifying database records.

13. The method of claim 9 , further comprising determining if the range of the plurality of first persistent identifiers conflicts with the range of the plurality of second persistent identifiers.

14. The method of claim 13 , wherein the plurality of first persistent identifiers or the plurality of second persistent identifiers corresponds to a unique one of a first randomly-generated identifier, a second randomly-generated identifier, a random number, a time associated with a record function, a birth date, a social security number, or a result of applying a hashing algorithm to a permanent attribute of each of the plurality of database records.

15. The method of claim 14 , wherein the record function is at least one of a record creation, a record modification, or a record deletion.

16. The method of claim 9 , wherein the plurality of persistent identifiers are members of an ordered set of persistent identifiers; and

wherein a randomly selected first persistent identifier of the ordered set of persistent identifiers and a selected second persistent identifier of the set of persistent identifiers are substantially unique.

17. A method of selecting mutually exclusive sets of database records comprising:

assigning a plurality of randomly generated persistent identifiers to each database record of a plurality of database records;

selecting a first and second range of at least one of the plurality of persistent identifiers; and

identifying a first set of database records corresponding to the first range of at least one of the plurality of persistent identifiers; and

identifying a second set of database records corresponding to the second range of at least one of the plurality of persistent identifiers, each database record of the first and second set including a target query parameter;

wherein identifying the first and second set of database records includes arranging a marketing campaign based on the target query parameter;

wherein each of the plurality of persistent identifiers are members of an ordered set of persistent identifiers;

wherein a randomly selected first persistent identifier of the ordered set of persistent identifiers being identical to a selected second persistent identifier of the set of persistent identifiers is statistically insignificant with respect to arranging the marketing campaign based on the target query parameter;

determining if the first and second range of database records contains a desired number of database records;

expanding the range of the at least one first persistent identifier if the desired number of database records is not contained within the set of database records; and

determining a variance between a number of database records contained within the set of database records and the desired number of database records.

18. The method of claim 17 , wherein the persistent parameter includes a unique persistent identifier, a randomly-generated identifier, a social security number, a birth date, a biological attribute, a DNA identifier, or a unique combination of non-persistent identifiers.

19. The method of claim 17 , wherein the non-persistent parameter includes a telephone number, a zip code, a state of residence, a job description, a most recent online transaction, a hair color, a body weight, a branded product preference, or a favorite merchant.

Assignments (11)

Continuity (2)