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

Abstract:
1. A computer implemented method of determining quality of data stored in a data repository comprising: identifying a plurality of tables storing data important for determining quality of data stored therein, wherein the identifying the plurality of tables is based on schema of the data repository; further determining critical tables from amongst the plurality of identified tables by analyzing the plurality of tables, based on the analysis rules; identifying at least one critical column of data, form amongst the critical tables, stored in a data repository, based on one of an importance index associated with the at least one critical column and based on predefined rules, wherein the importance index is indicative of the sensitivity of the data stored in the at least one critical column, and wherein the at least one critical column stores data important for determining a data quality score; retrieving from a rules repository, at least one data quality analysis rule based on a category of data stored in the at least one critical column; assigning a rule weightage parameter to each of the at least one data quality analysis rule retrieved from the rules repository; assigning a column weightage parameter to each of the identified critical column; analyzing the data stored in the at least one identified column based on the at least one data quality analysis rule retrieved from the rules repository; and computing a data quality score, indicative of the quality of data stored in the data repository, based in part on the analyzing, the rule weightage parameter and the column weightage parameter, wherein the data quality score is at least one of a rule level data quality score, a column level data quality score, a table level data quality score, and a schema level data quality score.