Alliance Rules for Data Warehouse Cleansing

Data Cleansing is an activity performed on the data sets of data warehouse to enhance and maintain the quality and consistency of the data. This paper addresses the problems related with dirty data, entrance of dirty data and detection of dirty data in the data warehouse. The paper perceives the procedure of data cleansing from a different perspective. It provides an algorithm for the detection of errors and dirty data in the data sets of an already existing data warehouse. The paper characterizes the alliance rules based on the concept of mathematical association rules to determine the dirty and faulty data in data warehouse. The research marks the use of q-grams [1] to determine the errors in a prominent way.