Internal database validation
AssigneeMicrosoft Corporation
InventorsJohn C. Delo, Carolyn L. Napier
Life of this patent
Estimating the term…
Abstract
Internal database validation is disclosed. In one embodiment, the 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 using the validation value to validate a data value in the data column of the data row.
Claims30
A computerized 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;
- and
- a database validation module operative to read a validation value from the validation column of the validation row and using the validation value to validate a data value in the data column of the data row.
A method of 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;
- and
- setting a results indicator based on the comparison.
A method of validating a database comprising:
- determining a column to validate;
- reading a validation row from a validation table in the database, said validation table including a table name column, a column name column, and a key identifier column;
- identifying a data column in a candidate row using the table name column and the column name column;
- and
- determining if the data column in the candidate row refers to a data row of the database identified by the key identifier column.
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;
- 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 using the validation value to validate a data value in the data column of the data row.
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 comparison.
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 in the database, said validation table including a table name column, a column name column, and a key identifier column;
- identifying a data column in a candidate row using the table name column and the column name column;
- and
- determining if the data column in the candidate row refers to a data row of the database identified by the key identifier column.
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.
A method of communicating between a client application process and a database validation module, the method comprising:
- issuing, by the client application process a function call having a plurality of parameters comprising a database view handle, an enumerated type, and a record handle;
- receiving by the validation module the function call and parsing the function call to retrieve the parameters;
- and
- issuing by the validation module an indicator signal indicating the status of the function call.
Dependencies are inferred from the claim text.