Repair Diversification for Functional Dependency Violations
In practice, data are often found to violate functional dependencies, and are hence inconsistent. To resolve such violations, data are to be restored to a consistent state, known as “repair”, while the number of possible repairs may be exponential. Previous works either consider optimal repair computation, to find one single repair that is (nearly) optimal w.r.t. some cost model, or discuss repair sampling, to randomly generate a repair from the space of all possible repairs.
This paper makes a first effort to investigate repair diversification problem, which aims at generating a set of repairs by minimizing their costs and maximizing their diversity. There are several motivating scenarios where diversifying repairs is desirable. For example, in the recently proposed interactive repairing approach, repair diversification techniques can be employed to generate some representative repairs that are likely to occur (small cost), and at the same time, that are dissimilar to each other (high diversity).Repair diversification significantly differs from optimal repair computing and repair sampling in its framework and techniques. (1) Based on two natural diversification objectives, we formulate two versions of repair diversification problem, both modeled as bi-criteria optimization problem, and prove the complexity of their related decision problems. (2) We develop algorithms for diversification problems. These algorithms embed repair computation into the framework of diversification, and hence find desirable repairs without searching the whole repair space. (3) We conduct extensive performance studies, to verify the effectiveness and efficiency of our algorithms.
KeywordsEquivalence Class Repair Cost Small Cost Input List Consistent Query Answer
Unable to display preview. Download preview PDF.
- 1.Arenas, M., Bertossi, L., Chomicki, J.: Consistent query answers in inconsistent databases. In: PODS (1999)Google Scholar
- 2.Bertossi, L.: Database repairing and consistent query answering. Morgan & Claypool Publishers (2011)Google Scholar
- 3.Bohannon, P., Fan, W., Flaster, M., Rastogi, R.: A cost based model and effective heuristic for repairing constraints by value modification. In: SIGMOD (2005)Google Scholar
- 4.Beskales, G., Ilyas, I., Golab, L.: Sampling the repairs of functional dependency violations under dard constraints. VLDB (2010)Google Scholar
- 5.Cong, G., Fan, W., Geerts, F., Jia, X., Ma, S.: Improving data quality: Consistency and accuracy. VLDB (2007)Google Scholar
- 6.Chu, X., Ilyas, I., Papotti, P.: Holistic data cleaning: Putting violations into context. ICDE (2013)Google Scholar
- 7.Dallachiesa, M., Ebaid, A., Eldawy, A., Elmagarmid, A., Ilyas, I., Ouzzani, M., Tang, N.: NADEEF: A commodity data cleaning system. SIGMOD (2013)Google Scholar
- 9.Fan, W., Geerts, F.: Foundations of data quality management. Morgan & Claypool Publishers (2012)Google Scholar
- 10.Fan, W., Li, J., Ma, S., Tang, N., Yu, W.: Towards certain fixes with editing rules and master data. VLDB (2010)Google Scholar
- 11.Gollapudi, S., Sharma, A.: An axiomatic approach for result diversification. WWW (2009)Google Scholar
- 13.Kolahi, S., Lakshmanan, L.: On approximating optimum repairs for functional dependency violations. ICDT (2009)Google Scholar
- 15.Yakout, M., Elmagarmid, A., Neville, J., Ouzzani, M., Ilyas, I.: Guided data repair. VLDB (2011)Google Scholar