Efficient Differential Dependency Discovery
Shulei Kuang, Honghui Yang, Zijing Tan, Shuai Ma
Abstract
Differential dependencies (DDs) are proposed to specify constraints on the differences between values, where the semantics of difference can be "similar", "dissimilar" and beyond. DDs subsume functional dependencies (FDs), and find valuable applications in tasks such as violation detection, duplicate identification, and quantitative data cleaning, among others. In this paper we present an efficient DD discovery method for finding hidden DDs from data. We encode differences between values in a novel structure called the "diff-set", and present a set of techniques for constructing the diff-set, discovering valid DDs with set cover enumeration of the diff-set, and eliminating non-minimal DDs. Our extensive experimental evaluation verifies that our method outperforms the existing DD discovery method up to orders of magnitude. Furthermore, our method is adapted to discover an important subclass of DDs, known as relaxed FDs (RFDs), and is also up to orders of magnitude faster than the state-of-the-art RFD discovery method.
Ask about this paper
Your agent reads all of it.
Lune indexed this paper to the last equation, along with the top-tier papers that cite it. Ask a question and the answer quotes them.
Your agent calls
Luneget_paper_fulltext
Free to start. No credit card required.
Terminal
Install the CLIlune papers fulltext 4aeba2f7-a8ac-43b6-862d-418438dd0bceCited by top-tier papers1
Ask how each one uses itBuilds on11
- Discovery of Approximate (and Exact) Denial ConstraintsEduardo H. M. Pena, Eduardo C. de Almeida, Felix NaumannVLDB 2020 · 79 citations
- Approximate Denial ConstraintsEster Livshits, Alireza Heidari, Ihab F. Ilyas, Benny KimelfeldVLDB 2020 · 60 citations
- Pattern Functional Dependencies for Data CleaningAbdulhakim Ali Qahtan, Nan Tang, Mourad Ouzzani, Yang Cao et al.VLDB 2020 · 42 citations
- Fast Algorithms for Denial Constraint DiscoveryEduardo H. M. Pena, Fábio Porto, Felix NaumannVLDB 2023 · 23 citations
- Fast Incremental Discovery of Pointwise Order DependenciesZijing Tan, Ai Ran, Shuai Ma, Sheng QinVLDB 2020 · 22 citations
Related papers
- Efficient Relaxed Functional Dependency Discovery with Minimal Set CoverXiaoou Ding, Yida Liu, Hongzhi Wang, Chen Wang et al.ICDE 2024 · 7 citations
- Dynamic Functional Dependency Discovery with Dynamic Hitting Set EnumerationRenjie Xiao, Yong'an Yuan, Zijing Tan, Shuai Ma et al.ICDE 2022 · 8 citations
- Discovering Functional Dependencies through Hitting Set EnumerationTobias Bleifuß, Thorsten Papenbrock, Thomas Bläsius, Martin Schirneck et al.SIGMOD 2024 · 9 citations
- IndiBits: Incremental Discovery of Relaxed Functional Dependencies using Bitwise SimilarityBernardo Breve, Loredana Caruccio, Stefano Cirillo, Vincenzo Deufemia et al.ICDE 2023 · 7 citations
- Representative Functional DependenciesQiongqiong Lin, Jingyan Sai, Jiazheng Song, Jinfei Liu et al.ICDE 2026
