AUTOMATED DETECTION OF NULL FIELD VALUES AND EFFECTIVELY NULL FIELD VALUES
First Claim
1. A computer implemented method of detecting and treating one or more field values as null field values in records of an electronic database, the computer implemented method comprising:
- selecting a field of the records;
determining, using a programmed computer, a frequency for each field value of the field, the frequency comprising an amount of the records in which the field value of the field appears;
calculating, using a programmed computer, a critical frequency for the field based on the frequency of each field value of the field; and
treating, using a programmed computer, each field value of the field with a frequency that is greater than the critical frequency of the field as a null field value and each field value of the field with a frequency that is less than the critical frequency of the field as a non-null field value.
2 Assignments
0 Petitions
Accused Products
Abstract
Disclosed are systems for, and methods of, automatically detecting and treating field values of a particular field as null field values in records of a database. The system and method provide automatic treatment of these field values as null field values by calculating a critical frequency for the field. Based on the critical frequency of the field, the system and method treats field values that occur more than the critical frequency of the field as null field values and treats field values that occur less than the critical frequency as non-null field values.
-
Citations
22 Claims
-
1. A computer implemented method of detecting and treating one or more field values as null field values in records of an electronic database, the computer implemented method comprising:
-
selecting a field of the records; determining, using a programmed computer, a frequency for each field value of the field, the frequency comprising an amount of the records in which the field value of the field appears; calculating, using a programmed computer, a critical frequency for the field based on the frequency of each field value of the field; and treating, using a programmed computer, each field value of the field with a frequency that is greater than the critical frequency of the field as a null field value and each field value of the field with a frequency that is less than the critical frequency of the field as a non-null field value. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A computer implemented system of detecting and treating one or more field values as null field values in records of an electronic database, the computer implemented system comprising:
-
a first computing apparatus configured to select a field of the records; a second computing apparatus configured to determine a frequency for each field value of the field, the frequency comprising an amount of the records in which the field value of the field appears; a third computing apparatus configured to calculate a critical frequency for the field based on the frequency of each field value of the field; and a fourth computing apparatus configured to treat each field value of the field with a frequency that is greater than the critical frequency of the field as a null field value and each field value of the field with a frequency that is less than the critical frequency of the field as a non-null field value. - View Dependent Claims (13, 14, 15, 16, 17, 18, 19, 20, 21, 22)
-
Specification