Method of efficient target query selection ranging
AssigneeMypoints.Com Inc.
InventorsJames John Bohannon, Andre Calvin Burgoyne
Life of this patent
Estimating the term…
Abstract
A method for providing efficient target parameter selection ranging includes assigning each record at least one persistent identifier. The persistent identifier may be ordered so that a selected range of the persistent identifier may allow a user to select a number of consecutively-identifiable, but apparently randomly-selected records. By only choosing records from a range of persistent identifiers, mutually exclusive or disjoint sets of records may be efficiently selected without performing a database join operation or storing the lists for comparison or later use. In one example, the persistent identifier may be a large random number assigned to a record at is creation.
Claims19
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.
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.
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.
Dependencies are inferred from the claim text.