Data validation and service

Abstract

A data validation service includes providing a user interface to a subscriber of the service via a computer device of the subscriber, receiving a data validation rule specified by the subscriber and an address of a database subject to the data validation, and generating a configuration file that includes the address of the database. The service also includes transmitting the configuration file and a thin client application to the computer device over a network, the thin client application configured to read the configuration file and pull data from the database. The service further includes receiving the data from the computer device via the network, performing the data validation by executing the data validation rule with respect to the data, and compiling results of the data validation and providing the results to the computer device.

1 . A method of performing data validation as a service, comprising:
 providing a user interface to a subscriber of the service via a computer device of the subscriber;   receiving, via the user interface, a data validation rule specified by the subscriber and an address of a database subject to the data validation;   generating a configuration file that includes the address of the database;   transmitting the configuration file and a thin client application to the computer device over a network, the thin client application configured to read the configuration file and pull data from the database;   receiving the data from the computer device via the network;   performing the data validation by executing the data validation rule with respect to the data; and   compiling results of the data validation and providing the results to the computer device.   
     
     
         2 . The method of  claim 1 , further comprising:
 receiving a metadata model of the database, the metadata model specifying a schema of the database.   
     
     
         3 . The method of  claim 1 , further comprising:
 receiving, via the user interface, a user-specified format selection for the results; and   entering the user-specified format in the configuration file;   wherein providing the result to the computer device includes formatting the results in the user-specified format.   
     
     
         4 . The method of  claim 1 , wherein the data validation rule includes at least one of:
 a missing data task;   a range check; and   a regular expression check.   
     
     
         5 . The method of  claim 1 , wherein the data validation rule is configured to operate on multiple database tables in the database. 
     
     
         6 . The method of  claim 1 , wherein the data validation rule is configured to perform an aggregate function on the data. 
     
     
         7 . A system for performing data validation as a service, comprising:
 a service provider computer system; and   validation services logic executable by the service provider computer system, the validation services logic configured to implement a method, the method comprising:   providing a user interface to a subscriber of the service via a computer device of the subscriber;   receiving, via the user interface, a data validation rule specified by the subscriber and an address of a database subject to the data validation;   generating a configuration file that includes the address of the database;   transmitting the configuration file and a thin client application to the computer device over a network, the thin client application configured to read the configuration file and pull data from the database;   receiving the data from the computer device via the network;   performing the data validation by executing the data validation rule with respect to the data; and   compiling results of the data validation and providing the results to the computer device.   
     
     
         8 . The system of  claim 7 , wherein the validation services logic is further configured to perform:
 receiving a metadata model of the database, the metadata model specifying a schema of the database.   
     
     
         9 . The system of  claim 7 , wherein the validation services logic is further configured to perform:
 receiving, via the user interface, a user-specified format selection for the results; and   entering the user-specified format in the configuration file;   wherein providing the result to the computer device includes formatting the results in the user-specified format.   
     
     
         10 . The system of  claim 7 , wherein the data validation rule includes at least one of:
 a missing data task;   a range check; and   a regular expression check.   
     
     
         11 . The system of  claim 7 , wherein the data validation rule is configured to operate on multiple database tables in the database. 
     
     
         12 . The system of  claim 7 , wherein the data validation rule is configured to perform an aggregate function on the data. 
     
     
         13 . A computer program product for performing data validation as a service, the computer program product comprising a storage medium encoded with computer-readable instructions, which when executed by a service provider computer causes the service provider computer to implement a method, the method comprising:
 providing a user interface to a subscriber of the service via a computer device of the subscriber;   receiving, via the user interface, a data validation rule specified by the subscriber and an address of a database subject to the data validation;   generating a configuration file that includes the address of the database;   transmitting the configuration file and a thin client application to the computer device over a network, the thin client application configured to read the configuration file and pull data from the database;   receiving the data from the computer device via the network;   performing the data validation by executing the data validation rule with respect to the data; and   compiling results of the data validation and providing the results to the computer device.   
     
     
         14 . The computer program product of  claim 13 , wherein the method further comprises:
 receiving a metadata model of the database, the metadata model specifying a schema of the database.   
     
     
         15 . The computer program product of  claim 13 , wherein the method further comprises:
 receiving, via the user interface, a user-specified format selection for the results; and   entering the user-specified format in the configuration file;   wherein providing the result to the computer device includes formatting the results in the user-specified format.   
     
     
         16 . The computer program product of  claim 13 , wherein the data validation rule includes at least one of:
 a missing data task;   a range check; and   a regular expression check.   
     
     
         17 . The computer program product of  claim 13 , wherein the data validation rule is configured to operate on multiple database tables in the database. 
     
     
         18 . The computer program product of  claim 13 , wherein the data validation rule is configured to perform an aggregate function on the data. 
     
     
         19 - 24 . (canceled)