Patent ID: 9152627
Filing Date: 2015-10-06
Classification: G06F,G06Q

Abstract:
1. A method of automatically generating data validation rules from data stored in a column of a table, the method comprising: determining, using a processor of a machine, a quantity of an outlier for the data by analyzing a profiling statistic for the data, the profiling statistic having a type and wherein the outlier is an element of the data that is numerically distant from other elements of the data; determining if the quantity of the outlier exceeds a predefined limit; automatically generating a data validation rule based on non-outliers detected in the data through the analysis of the profiling statistic, the generated data validation rule also being based on the type of the profiling statistic and the quantity of the outlier; and applying the data validation rule on data subsequently entered for the column, causing at least a portion of the data subsequently entered for the column to be rejected.