Method and system for validating data submitted to a database application
First Claim
1. A method of validating data submitted to a database application comprising the steps of:
- receiving data input in response to a query presented to a user;
comparing said data with a predetermined validation criteria; and
adding a criteria exception rule to an exception set class where said data fails to meet said predetermined validation criteria, said exception identifies a data field of said data input which does not meet said validation criteria.
2 Assignments
0 Petitions
Accused Products
Abstract
A system and method for validating data entry in which an exception set class is defined and where, during a validation process, each data entry field is reviewed to determined whether or not certain predetermined validation criteria are met. Where data entry does not meet validation criteria, an exception is added to the exception set class to identify the data entry field that contains data that does not meet the validation criteria. After all data entry fields have been reviewed, the exception set is thrown if it contains any exceptions. Based upon this exception set, the data entry fields will be re-presented (submitted) to the user for correction/revision of the data to meet the validation criteria.
21 Citations
27 Claims
-
1. A method of validating data submitted to a database application comprising the steps of:
-
receiving data input in response to a query presented to a user;
comparing said data with a predetermined validation criteria; and
adding a criteria exception rule to an exception set class where said data fails to meet said predetermined validation criteria, said exception identifies a data field of said data input which does not meet said validation criteria. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 17, 18, 19, 20, 21, 22, 23, 24, 25)
-
-
16. A system for validating data input comprising:
-
a database server comprising a database residing in a memory, said database for storing a plurality of input data;
an interface for receiving input data representing a user response to a presented question; and
a controller for causing said input data to be validated in accordance with a predetermined validation routine, and adding an exception to an exception set class each time said data input fails to meet predetermined criteria for validation.
-
-
26. A system for validating data input comprising:
-
a storage memory for storing a plurality of instructions and a plurality of input data;
a controller for operating on said plurality of input data in accordance with said at least one instruction stored on said storage memory;
wherein said plurality of instructions further includes;
at least one receiving instruction stored on said storage memory for receiving said plurality of input data submitted in response to a query presented to a user;
at least one validating instruction stored on said storage memory for validating said input data; and
at least one exception instruction stored on said storage memory for adding an exception to an exception set class where one of said input data is invalid, said exception identifies a data field of said one input data which is invalid.
-
-
27. A system for validating data input, comprising:
-
client-side terminal for presenting a data entry form to a user; and
database server for receiving a data entry record from said client-side terminal and incorporating it into database where certain pre-determined validation criteria are met.
-
Specification