Method and computer program product for creating a plurality of mixed pseudo-records composed of weighted mixtures of existing records in a database

A method for creating a set of mixed pseudo-records that are composed of weighted mixtures of existing records comprising N key fields and one or more data fields that requires minimal user input of information, the method comprising:

• selecting the type of mixture by selecting one of the N key fields as the mix key field in response to user choice;
• assigning weights to one or more of the values of the selected key field to create a mixed value for the selected key field in response to user choice;
• choosing one or more values for each of the N-1 remaining key fields F.sub.i, where i=1 to N-1 remaining key fields, in response to user choice the total number of values being X.sub.i for each key field F.sub.i ;
• creating record groups having the chosen N-1 key field values by searching the database of records;
• and
• forming a plurality of pseudo-records corresponding to each of said individual record groups, each pseudo-record having a formulaic hybrid value for the selected mix key field based on said assigned weights to said one or more values of the mix key field, values for the N-1 remaining key fields F.sub.i based on said individual record group, values for each data field based on applying said assigned weights to corresponding data fields in records in said record group having said mix field values to derive a weighted average value.

A method for creating a set of mixed pseudo-records that are composed of weighted mixtures of existing records comprising N key fields and one or more data fields that requires minimal user input of information, the method comprising:

• selecting the type of mixture by selecting one of the N key fields as the mix key field;
• assigning weights to one or more of the values of the selected key field to create a formulaic hybrid value for the selected key field;
• choosing one or more values for each of the N-1 remaining key fields F.sub.i, where i=1 to N-1 remaining key fields in response to user choices the total number of values being X.sub.i for each key field F.sub.i ;
• and
• creating a plurality of pseudo-records, each data record having data values mixed from existing records and the formulaic hybrid value for the mix key field.

A computer program product comprising:

• a computer usable medium;
• and
• computer readable program code means embodied in said medium for use in a computer system comprising a CPU, a display means controlled by the CPU, and an input means operated by a user connected to the CPU, said computer readable program code means for creating a plurality of mixed pseudo-records composed of weighted mixtures of existing records in a database, each record having data fields with N of those data fields designated as key fields, the creation of pseudo-records requiring minimal user input of information, said computer readable program code means comprising;
• means for displaying on the displaying on the display means the key fields and values for said key fields;
• means for designating one of the key fields as the mix field in response to user selection through the interface means;
• means for assigning weights to one or more of the values of the designated mix field according to mix field data type to create a mixed value in response to user selection through the interface means;
• means for designating from each of the N-1 remaining key fields F.sub.i, where i=1 to N-1 remaining key fields, one or more values, the total number of values being X.sub.i for each key field F.sub.i, the designation in response to user selection through the interface means;
• means for searching existing records having the X.sub.i values for each of the N-1 remaining key fields F.sub.i in said database to form a plurality of pseudo-record bases;
• wherein each unique set of values resulting from the search becomes a valid pseudo-record base referencing a group of existing records including data records and pseudo-records;
• and
• means for forming a pseudo-record from each individual pseudo-record base, the pseudo-record having a hybrid value for the mix field based on the selected mix key values and assigned weightings, values for the remaining N-1 key fields F.sub.i corresponding to the individual pseudo-record base, and each data field having a value calculated from the mix field hybrid value applied to the group of records in the individual pseudo-record base.

A computer program product comprising:

• a computer usable medium;
• and
• computer readable program code means embodied in said medium for creating a set of mixed pseudo-records that are composed of weighted mixtures of existing records comprising N key fields and one or more data fields that requires minimal user input of information, said computer readable program code means comprising;
• means for selecting the type of mixture by selecting one of the N key fields as the mix key field in response to user choice;
• means for assigning weights to one or more of the values of the selected key field to create a mixed value for the selected key field in response to user choice;
• means for choosing one or more values for each of the N-1 remaining key fields F.sub.i, where i=1 to N-1 remaining key fields in response to user choice the total number of values being X.sub.i for each key field F.sub.i ;
• means for creating record groups having the chosen N-1 key field values by searching the database of records;
• and
• means for forming a plurality of pseudo-records corresponding to each of said individual record groups, each pseudo-record having a formulaic hybrid value for the selected mix key field based on said assigned weights to said one or more values of the mix key field, values for the N-1 remaining key fields F.sub.i based on said individual record group, values for each data field based on applying said assigned weights to corresponding data fields in records in said record group having said mix field values to derive a weighted average value.

A computer program product comprising:

• a computer usable medium;
• and
• computer readable program code means embodied in said medium for creating a set of mixed pseudo-records that are composed of weighted mixtures of existing records comprising N key fields and one or more data fields that requires minimal user input of information, said computer readable program code means comprising;
• means for selecting the type of mixture by selecting one of the N key fields as the mix key field;
• means for assigning weights to one or more of the values of the selected key field to create a formulaic hybrid value for the selected key field;
• means for choosing one or more values for each of the N-1 remaining key fields F.sub.i, where i=1 to N-1 remaining key fields, in response to user choices the total number of values being X.sub.i for each key field F.sub.i ;
• and
• means for creating a plurality of pseudo-records, each data record having data values mixed from existing records and the formulaic hybrid value for the mix key field.