Abstract:Functional dependencies (FDs) play a very important role in many data management tasks such as schema normalization, data cleaning, and query optimization. Meanwhile, there are ever-increasing application demands for efficient FD discovery on large-scale datasets. Unfortunately, due to huge runtime and memory overhead, the existing single-machine FD discovery algorithms are inefficient for large-scale datasets. Recently, distributed data-parallel computing has become the de facto standard for large-scale data processing. However, it is challenging to design an efficient distributed FD discovery algorithm. In this paper, we present SmartFD, which is an efficient and scalable algorithm for distributed FD discovery. First, we propose a novel attribute sorting-based algorithm framework. Next, to discover all the FDs grouped by a given attribute, we propose an efficient distributed algorithm Attribute-centric Functional Dependency Discovery (AFDD). In AFDD, we design an Fast Sampling and Early Aggregation (FSEA) mechanism to improve the efficiency of distributed sampling and propose a memory-efficient index-based method for distributed FD validation. Moreover, AFDD employs an attribute-parallel method to accelerate the pruning-and-generation of candidate FDs. Furthermore, we propose an adaptive switching strategy between distributed sampling and distributed validation based on the unified time-based efficiency metric. Also, we employ a distributed probing based method to make the switching strategy more accurate. Experimental results on Apache Spark reveal that SmartFD outperforms the state-of-the-art single-machine algorithm HyFD and the existing distributed algorithm HFDD with 3.2 & x00D7;-44.9 & x00D7; and 2.5 & x00D7;-455.7 & x00D7; speedup respectively. Moreover, SmartFD achieves good row scalability and column scalability. Additionally, SmartFD has sub-linear node scalability.

Efficient Differential Dependency Discovery

Differential dependencies: Reasoning and discovery

Data dependencies in the presence of difference

Dynamic Functional Dependency Discovery with Dynamic Hitting Set Enumeration

Efficient Relaxed Functional Dependency Discovery with Minimal Set Cover

Efficient Determination of Distance Thresholds for Differential Dependencies

Discovering Approximate Functional Dependencies from Distributed Big Data.

EulerFD: an Efficient Double-Cycle Approximation of Functional Dependencies

Functional Dependencies Discovering in Distributed Big Data

Statistical Log Differencing

Efficient Discovery of Functional Dependencies with Degrees of Satisfaction.

TSDDISCOVER: Discovering Data Dependency for Time Series Data

Efficient Discovery of Functional Dependencies on Massive Data

Scalable Functional Dependencies Discovery from Big Data

OPTIMIZED ALGORITHM OF DISCOVERING FUNCTIONAL DEPENDENCIES WITH DEGREES OF SATISFACTION

DAFDiscover: Robust Mining Algorithm for Dynamic Approximate Functional Dependencies on Dirty Data

Coping with data dependencies of multi-dimensional array references

Inconsistency Detection in Distributed Big Data

Efficient and Scalable Functional Dependency Discovery on Distributed Data-Parallel Platforms.

Efficient Set-Based Order Dependency Discovery with a Level-Wise Hybrid Strategy

DDN2.0: R and Python packages for differential dependency network analysis of biological systems