The present application relates to a kind of automatic discovery
data quality inspection rule method.The
present method includes that for the data table that has been entered in the warehouse,
system automatically executes rule discovery task, and forms single table rule;Management personnel according to
system current standard and experience judge whether the single table rule formed in the previous step has secondary
cascade relationship, if the single table rule has secondary
cascade relationship, then manually confirm, then using the single table rule after confirmation to the data table for discovering the single table rule carries out quality inspection, and after quality inspection is completed, the single table rule changes into quasi rule;All quasi rules found in multiple data tables are subjected to similarity check, and the same or similar quasi rules of multiple data tables are combined to generate general rule, and the generated general rule is used for the quality inspection of all data tables.The
present method can be based on the discovery of single table rule, and the combination of multi-table quality inspection rule is carried out by
similarity test, so as to provide the basis for the discovered general
data quality inspection rule applicable to all data tables.