Back to results
US 6,389,414 B1Granted
Internal database validation
AssigneeMicrosoft Corporation
InventorsJohn C. Delo, Carolyn L. Napier
Life of this patent
Estimating the term…
Abstract
Internal database validation system comprises a database having a data table and a validation table. The data table has at least one data column and at least one data row and the validation table has a plurality of validation columns and a validation row. Also included is a database engine module for maintaining the database and a database validation module operative to read a validation value from the validation column of the validation row and for using the validation value to validate a data value in the data column of the data row.
Claims19
A computerized internal database validation system comprising:
- a database engine module for maintaining a database, said database having a data table and a validation table, said data table having at least one data column and at least one data row, said validation table having a plurality of validation columns and a validation row, wherein the validation columns include a column specifying a set of invalid values for the data column;
- and
- a database validation module operative to read a validation value from a validation column of the validation row and use the validation value to validate a data value in the data column of the data row, said database validation module forming a module included within the database engine module.
A computerized internal database validation system comprising:
- a database engine module for maintaining a database, said database having a data table and a validation table, said data table having at least one data column and at least one data row, said validation table having a plurality of validation columns and a validation row, wherein the validation columns include a column specifying a validation category for the data column;
- and
- a database validation module operative to read a validation value from a validation column of the validation row and use the validation value to validate a data value in the data column of the data row, said database validation module forming a module included within the database engine module.
A method of internally validating a database comprising:
- determining a column to validate;
- reading a validation row from a validation table, said validation table including a table name column, a column name column, a column category column, and a valid value column;
- identifying a data column in a candidate row using the table name column and the column name column;
- performing a validation of a data value in the data column prior to a database operation on the candidate row;
- and
- setting a results indicator based on the validation comparison.
3 more elements
A computer comprising:
- a processor;
- a computer-readable medium;
- a database having a data table and a validation table, said data table having at least one data column and at least one data row, said validation table having a plurality of validation columns and a validation row, wherein the validation columns include a column specifying a minimum value, a column specifying a maximum value, and a column specifying a set of valid values or a set of invalid values;
- a database engine module for maintaining the database;
- and
- a database validation module operative to read a validation value from a validation column of the validation row and use the validation value to validate a data value in the data column of the data row, wherein the database validation module is a module contained within the database engine module.
3 more elements
A computer comprising:
- a processor;
- a computer-readable medium;
- a database having a data table and a validation table, said data table having at least one data column and at least one data row, said validation table having a plurality of validation columns and a validation row, wherein the validation columns include a column specifying a validation category for the data column;
- a database engine module for maintaining the database;
- and
- a database validation module operative to read a validation value from a validation column of the validation row and use the validation value to validate a data value in the data column of the data row, wherein the database validation module is a module contained within the database engine module.
3 more elements
A computer-readable medium having computer-executable instructions for performing a method comprising:
- determining a column to validate;
- reading a validation row from a validation table, said validation table including a table name column, a column name column, a column category column, and a valid value column;
- identifying a data column in a candidate row using the table name column and the column name column;
- performing a validation of a data value in the data column;
- and
- setting a results indicator based on the validation comparison.
3 more elements
A computer-readable medium having stored thereon a data structure comprising:
- a first data field containing data specifying a table name of a database;
- a second data field containing data specifying a column name of the database;
- a third data field containing a minimum value, wherein during a predetermined data processing operation a data field in a column identified by the first data field and the second data field is compared to the third data field;
- a fourth data field containing a maximum value, wherein during a predetermined data processing operation a data field in the column identified by the first data field and the second data field is compared to the fourth data field;
- a fifth data field containing a set of values, wherein during a predetermined data processing operation a check is made to determine if the data field in a column identified by the first data field and the second data field is included in the set of values;
- a sixth data field containing a category, wherein during a predetermined data processing operation a data field in a column identified by the first data field and the second data field is compared to a syntax specified by the category;
- a seventh data field containing a key table name;
- and
- an eighth data field containing a key column number wherein during a predetermined data processing operation a data field in a column identified by the first data field and the second data field is compared to a data value identified by the seventh data field and the eighth data field.
6 more elements
Dependencies are inferred from the claim text.