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.

A fuzzy grouping mechanism for distributed interactive simulation.

Fuzzy DR Algorithm for Data Distribution Management

Flow Distribution Strategy in Heterogeneous Networks Based on Satisfaction.

An Effective Aggregation Method in Distributed Virtual Environments

A fuzzy dead reckoning algorithm for distributed interactive applications

A clustering algorithm for distributed time-series data

A Distributed Resource Scheduling Based on Fuzzy Cognitive Map for Dynamic Grid Computation Systems

A Fully Distributed Collection Technology for Mass Simulation Data

Progressive online aggregation in a distributed stream system

Distributed Information Theoretic Clustering

A clustering-based method for large-scale group decision making in the hesitant fuzzy set environment

A Distributed Social-Aware Clustering Approach in D2D Multicast Communications.

Distributed Aggregated Collaborative Simulation

Transfer Collaborative Fuzzy Clustering in Distributed Peer-to-Peer Networks

Distributed Hash table-based distributed subspace clustering algorithm

Effective Data Distribution And Reallocation Strategies For Fast Query Response In Distributed Query-Intensive Data Environments

Distributed Data Stream Clustering: A Fast EM-based Approach

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

A Parallel Matching Algorithm Based on Order Relation for HLA Data Distribution Management

Utility Based Query Dissemination in Spatial Data Grid

Designing Distributed Fuzzy Rule-Based Models