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.

Discovering Graph Functional Dependencies

Efficient Discovery of Functional Dependencies with Degrees of Satisfaction.

Scalable Functional Dependencies Discovery from Big Data

Using Conditional Functional Dependency to Discover Abnormal Data in RDF Graphs.

Dynamic Functional Dependency Discovery with Dynamic Hitting Set Enumeration

Efficient Relaxed Functional Dependency Discovery with Minimal Set Cover

OPTIMIZED ALGORITHM OF DISCOVERING FUNCTIONAL DEPENDENCIES WITH DEGREES OF SATISFACTION

EulerFD: an Efficient Double-Cycle Approximation of Functional Dependencies

GGDMiner -- Discovery of Graph Generating Dependencies for Graph Data Profiling

GGDs: Graph Generating Dependencies

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

Mining Functional Dependencies with Degrees of Satisfaction in Databases.

Discovering Multi-Table Functional Dependencies Without Full Join Computation

Efficient Differential Dependency Discovery

Guided conditional functional dependency discovery

Discovering Fuzzy Functional Dependencies as Semantic Knowledge in Large Databases

Discovering Reliable Approximate Functional Dependencies

FuDGE: A Method to Estimate a Functional Differential Graph in a High-Dimensional Setting

Finding a Sparse Connected Spanning Subgraph in a non-Uniform Failure Model

Relaxed Functional Dependency Discovery in Heterogeneous Data Lakes

Properties and Pre-Processing Strategies to Enhance the Discovery of Functional Dependency with Degree of Satisfaction