{'fraction_non_alphanumeric': 0.0148975791433892, 'fraction_numerical': 0.0, 'mean_word_length': 5.3609467455621305, '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}}
Understanding Data Quality in a Data Warehouse

Data quality has long been recognised as a key factor in the success of data warehousing. Attempts to define data quality typically provide lists of quality dimensions that are vaguely defined, overlapping and not based in sound underlying theory. One promising approach is to define quality dimensions in ontological foundations. This paper presents an alternative approach that uses semiotic theory to develop a framework for understanding data (the content) and metadata (the structure) quality in a data warehouse. Goals of data and metadata quality are separated from the means of achieving them and ways of measuring them. Existing data and metadata quality dimensions are analysed and placed within the framework. The framework provides researchers and practitioners with a sound, theoretically-based set of quality goals, means and measures which will support further work in the development of data and metadata quality guidelines, evaluation procedures and empirical studies of data and metadata quality in practice.