{'fraction_non_alphanumeric': 0.01384083044982699, 'fraction_numerical': 0.0, 'mean_word_length': 5.728682170542636, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Inconsistent data repairs in database integrations

In the operations of multiple database integrations, one of the most prominent data quality problems is the existence of inconsistencies. Due to independence of data management among different information sources, there exist several possibilities for repairs of integrated data. In order to get good repairs and preserve the correct data, this paper introduces a new algorithm for repairing inconsistent data among multiple tables based on functional dependencies, which keeps integrity of source databases without deletions of tuples. The algorithm determines the tuples that are potentially updated by analyzing related attribute statistic measures, and is of objective, accurate and effective properties. A repairing system structure is presented, and some comparisons with other related work are given at last.