A Novel Cost Based Model for Data Repairing
Integrity constraint based data repairing is an iterative process consisting of two parts: detect and group errors that violate given integrity constraints (ICs). And modify values inside each group such that the modified database satisfies those ICs. However, most existing automatic solutions treat the process of detecting and grouping errors straightforwardly (e.g., violations of functional dependencies using string equality), while putting more attention on heuristics of modifying values within each group. In this paper, we propose a revised semantics of violations and data consistency a set of ICs. The revised semantics relies on string similarities, in contrast to traditional methods that use syntactic error detection using string equality. Along with the revised semantics, we also propose a new cost model to quantify the cost of data repair by considering distances between strings. We show that the revised semantics provides a significant change for better detecting and grouping errors, which in turn improves both precision and recall of the following data repairing step. We prove that finding minimum-cost repairs in the new model is NP-hard, even for a single FD. We devise efficient algorithms to find approximate repairs. In addition, we develop indices and optimization techniques to improve the efficiency. Experiments show that our approach significantly outperforms existing automatic repair algorithms in both precision and recall.
Premium Development Service
|Voice Conference||Video On Demand||Code Customization|
|24/7 Support||Remote Connectivity||Document Customization|
|Ticketing System||Project on Demand||Zoom/Google Meet Explanation|
|Live Chat Support||Single Point of Contact(SPOC)||Whatsapp Support|
Discover our highlights here! Our highlights provide accurate data to evaluate our standard. We provide an overview of our services which exhibits the following qualities. When it comes to quality, we at ClickMyProject believe in helping our clients to gives you the best-in-class services.