Data Cleaning for XML Electronic Dictionaries via Statistical Anomaly Detection

TL;DR

This paper introduces six statistical anomaly detection systems to automatically identify errors in XML-stored electronic dictionaries, improving data cleaning efficiency through various data signals and evaluations.

Contribution

The paper presents six novel systems for detecting errors in XML electronic dictionaries using diverse statistical signals and inference methods, with comprehensive evaluations.

Findings

Systems effectively detect errors using multiple data signals.

Crowdsourcing and expert annotations validate system usefulness.

Error detection improves data cleaning efficiency.

Abstract

Many important forms of data are stored digitally in XML format. Errors can occur in the textual content of the data in the fields of the XML. Fixing these errors manually is time-consuming and expensive, especially for large amounts of data. There is increasing interest in the research, development, and use of automated techniques for assisting with data cleaning. Electronic dictionaries are an important form of data frequently stored in XML format that frequently have errors introduced through a mixture of manual typographical entry errors and optical character recognition errors. In this paper we describe methods for flagging statistical anomalies as likely errors in electronic dictionaries stored in XML format. We describe six systems based on different sources of information. The systems detect errors using various signals in the data including uncommon characters, text length, character-based language models, word-based language models, tied-field length ratios, and tied-field transliteration models. Four of the systems detect errors based on expectations automatically inferred from content within elements of a single field type. We call these single-field systems. Two of the systems detect errors based on correspondence expectations automatically inferred from content within elements of multiple related field types. We call these tied-field systems. For each system, we provide an intuitive analysis of the type of error that it is successful at detecting. Finally, we describe two larger-scale evaluations using crowdsourcing with Amazon's Mechanical Turk platform and using the annotations of a domain expert. The evaluations consistently show that the systems are useful for improving the efficiency with which errors in XML electronic dictionaries can be detected.