Schema Width Bounds the Benefit of Editable Keys for Plurality-Based Functional-Dependency Checks

A plurality-based functional-dependency check accepts a target's dependent value when it is the unique plurality among rows that agree with the target on a determinant. We study the minimum number of context-cell edits that makes every listed check accept a protected, initially rejected target, and ask how much cheaper this becomes when determinant (key) cells may change as well as dependent cells. For a family F of determinants sharing one dependent attribute, let w(F) be the size of a largest inclusion antichain among the determinants that contain a common key. We prove that the fixed-key optimum is at most w(F) times the editable-key optimum, and that every family has a binary table attaining exactly this factor. Hence the two optima agree on every such table if and only if F is laminar. With at least k+1 dependent values the factor is also attained at editable-key optimum k, whereas for a binary dependent attribute and two overlapping determinants the optima differ by at most one edit. The upper bound uses a margin-capped exchange that replaces each key edit by at most one dependent-cell flip per inclusion chain. The classification concerns the listed checks, not logical FD equivalence, and laminarity does not make optimization easy: acceptance within a budget remains NP-complete for singleton determinants. For the reverse direction we give an exact formula. Exhaustive finite checks of the main theorems cover 81,893 rejected table/family pairs. On Beers, Flights and Rayyan, all nine check families of our own earlier benchmark experiment are laminar, which explains, post hoc, why the accepting gain it predicted from editable keys could not occur.

Authors

Publication Details

Journal
Zenodo (CERN European Organization for Nuclear Research)
Published
2026-11-11
DOI
https://doi.org/10.5281/zenodo.24124619
Primary Topic
Advanced Database Systems and Queries
Type
preprint
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
preprint

Schema Width Bounds the Benefit of Editable Keys for Plurality-Based Functional-Dependency Checks

Vu Bao Minh Tran
Zenodo (CERN European Organization for Nuclear Research)
Advanced Database Systems and Queries
preprint

Schema Width Bounds the Benefit of Editable Keys for Plurality-Based Functional-Dependency Checks

Vu Bao Minh Tran
preprint en

Abstract

A plurality-based functional-dependency check accepts a target's dependent value when it is the unique plurality among rows that agree with the target on a determinant. We study the minimum number of context-cell edits that makes every listed check accept a protected, initially rejected target, and ask how much cheaper this becomes when determinant (key) cells may change as well as dependent cells. For a family F of determinants sharing one dependent attribute, let w(F) be the size of a largest inclusion antichain among the determinants that contain a common key. We prove that the fixed-key optimum is at most w(F) times the editable-key optimum, and that every family has a binary table attaining exactly this factor. Hence the two optima agree on every such table if and only if F is laminar. With at least k+1 dependent values the factor is also attained at editable-key optimum k, whereas for a binary dependent attribute and two overlapping determinants the optima differ by at most one edit. The upper bound uses a margin-capped exchange that replaces each key edit by at most one dependent-cell flip per inclusion chain. The classification concerns the listed checks, not logical FD equivalence, and laminarity does not make optimization easy: acceptance within a budget remains NP-complete for singleton determinants. For the reverse direction we give an exact formula. Exhaustive finite checks of the main theorems cover 81,893 rejected table/family pairs. On Beers, Flights and Rayyan, all nine check families of our own earlier benchmark experiment are laminar, which explains, post hoc, why the accepting gain it predicted from editable keys could not occur.

Zenodo (CERN European Organization for Nuclear Research)
Advanced Database Systems and Queries
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon