Skip to main content

The Cost of Representation by Subset Repairs

Publication ,  Journal Article
Liu, Y; Shen, F; Ghosh, K; Gilad, A; Kimelfeld, B; Roy, S
Published in: Proceedings of the VLDB Endowment
January 1, 2025

Datasets may include errors, and specifically violations of integrity constraints, for various reasons. Standard techniques for "minimal cost" database repairing resolve these violations by aiming for a minimum change in the data, and in the process, may sway representations of different sub-populations. For instance, the repair may end up deleting more females than males, or more tuples from a certain age group or race, due to varying levels of inconsistency in different sub-populations. Such repaired data can mislead consumers when used for analytics, and can lead to biased decisions for downstream machine learning tasks. We study the "cost of representation" in subset repairs for functional dependencies. In simple terms, we target the question of how many additional tuples have to be deleted if we want to satisfy not only the integrity constraints but also representation constraints for given sub-populations. We study the complexity of this problem and compare it with the complexity of optimal subset repairs without representations. While the problem is NP-hard in general, we give polynomial-time algorithms for special cases, and efficient heuristics for general cases. We perform a suite of experiments that show the effectiveness of our algorithms in computing or approximating the cost of representation.

Duke Scholars

Published In

Proceedings of the VLDB Endowment

DOI

EISSN

2150-8097

Publication Date

January 1, 2025

Volume

18

Issue

2

Start / End Page

475 / 487

Related Subject Headings

  • 4605 Data management and data science
  • 0807 Library and Information Studies
  • 0806 Information Systems
  • 0802 Computation Theory and Mathematics
 

Citation

APA
Chicago
ICMJE
MLA
NLM
Liu, Y., Shen, F., Ghosh, K., Gilad, A., Kimelfeld, B., & Roy, S. (2025). The Cost of Representation by Subset Repairs. Proceedings of the VLDB Endowment, 18(2), 475–487. https://doi.org/10.14778/3705829.3705860
Liu, Y., F. Shen, K. Ghosh, A. Gilad, B. Kimelfeld, and S. Roy. “The Cost of Representation by Subset Repairs.” Proceedings of the VLDB Endowment 18, no. 2 (January 1, 2025): 475–87. https://doi.org/10.14778/3705829.3705860.
Liu Y, Shen F, Ghosh K, Gilad A, Kimelfeld B, Roy S. The Cost of Representation by Subset Repairs. Proceedings of the VLDB Endowment. 2025 Jan 1;18(2):475–87.
Liu, Y., et al. “The Cost of Representation by Subset Repairs.” Proceedings of the VLDB Endowment, vol. 18, no. 2, Jan. 2025, pp. 475–87. Scopus, doi:10.14778/3705829.3705860.
Liu Y, Shen F, Ghosh K, Gilad A, Kimelfeld B, Roy S. The Cost of Representation by Subset Repairs. Proceedings of the VLDB Endowment. 2025 Jan 1;18(2):475–487.

Published In

Proceedings of the VLDB Endowment

DOI

EISSN

2150-8097

Publication Date

January 1, 2025

Volume

18

Issue

2

Start / End Page

475 / 487

Related Subject Headings

  • 4605 Data management and data science
  • 0807 Library and Information Studies
  • 0806 Information Systems
  • 0802 Computation Theory and Mathematics