An effective hash-based algorithm for mining association rules
Jong Soo ParkMing-Syan ChenPhilip S. Yu
Introduces the Direct Hashing and Pruning (DHP) algorithm, which substantially speeds up association rule mining by using a hash technique to prune candidate 2-itemsets and progressively reduce transaction database sizes during early iterations.
Modern retail and catalog businesses continuously capture massive volumes of point-of-sale data that contain critical insights into customer purchasing habits. Discovering association rules—such as identifying which products customers routinely buy together—enables strategic decisions regarding product placement, promotional discounting, and catalog design. However, discovering frequent item combinations in massive transaction databases is computationally demanding, as previous techniques suffer from severe processing bottlenecks during initial iterations where the number of evaluated candidate combinations is excessively large.
The main objective of the article is to design and evaluate Direct Hashing and Pruning (DHP), a high-performance algorithm that accelerates the discovery of frequent itemsets in large databases. The article evaluates DHP’s ability to filter out non-viable candidate itemsets during early passes and progressively reduce the transaction database size across successive iterations.
The authors conducted extensive simulation experiments comparing DHP against the leading baseline algorithm, Apriori. The experimental framework evaluated synthetic retail transaction datasets scaling up to 100,000 transactions and up to 10,000 distinct items, testing varying transaction lengths and minimum support thresholds to assess runtime, candidate set sizes, and database reduction rates.
The key findings demonstrate significant performance advantages. First, DHP reduces the number of candidate two-item combinations by orders of magnitude compared to previous approaches by using a direct hash table and bit vector to filter out unlikely candidates before support counting. Second, DHP drastically shrinks the dataset size for later iterations, trimming the transaction database down to approximately 10% of its original file size and 20% of its original transaction count by pass three. Third, overall execution time is cut dramatically; for instance, on standard benchmarks DHP completed processing in 13.91 seconds compared to 39.39 seconds for Apriori—a reduction of nearly 65%. Finally, DHP scales linearly with total database volume and maintains robust performance across varied support thresholds and expanding item catalog sizes.
These findings imply substantial operational efficiency gains and cost reductions for organizations running large-scale analytics. Because the first two iterations traditionally account for roughly 65% of total execution time in baseline approaches, DHP resolves the primary computational bottleneck. The slightly increased memory and processing cost incurred during the initial pass to build the hash table is heavily outweighed by the massive reduction in candidate comparisons and database scanning time in subsequent passes.
Organizations evaluating data mining architectures should adopt direct hashing and progressive pruning strategies to enhance throughput on frequent itemset workloads. When configuring DHP, engineering teams should allocate sufficiently large hash tables—ideally sized between one-quarter of and equal to the total possible pair combinations—to maximize candidate pruning while managing available memory. For later stages where remaining candidate counts become very small, the algorithm should transition away from hashing to standard generation procedures to avoid unnecessary overhead.
The reported results are based on synthetic retail transaction models running on a single workstation environment, representing a potential limitation for unstructured or non-retail transactional workloads. Nevertheless, given the consistent linear scale-up behavior and robust sensitivity analysis across varied transaction configurations, decision-makers can have high confidence in DHP's capability to deliver substantial computational speedups.
- Paper: Fast Algorithms for Mining Association Rules in Large Databases, Rakesh Agrawal et al. (1994). This paper establishes the foundational Apriori framework and candidate generation bottleneck that the source's hash-based algorithm directly aims to optimize.
- Paper: Mining association rules between sets of items in large databases, Rakesh Agrawal et al. (1993). This work introduces the core problem of mining association rules and discovering large itemsets in transaction databases upon which the source builds.
- Paper: Mining frequent patterns without candidate generation, Jiawei Han et al. (2000). This work advances beyond candidate-generation approaches like the source's hash-based method by introducing the FP-growth algorithm to discover frequent patterns without candidate generation.
- Paper: Scalable Algorithms for Association Mining, Mohammed J. Zaki (2000). This paper develops vertical data format algorithms that intersect transaction lists to further improve candidate counting efficiency beyond horizontal hash-based methods.
- Paper: Dynamic itemset counting and implication rules for market basket data, Sergey Brin et al. (1997). This paper introduces Dynamic Itemset Counting to dynamically generate and count candidate itemsets in fewer passes over market basket data.
- Paper: Data Mining: An Overview from a Database Perspective, Ming-Syan Chen et al. (1996). This survey provides a comprehensive database perspective analyzing the progression of association rule mining algorithms, including hash-based and candidate generation improvements.
- Paper: Mining quantitative association rules in large relational tables, Ramakrishnan Srikant et al. (1996). This paper extends association rule discovery from categorical itemsets to quantitative and continuous attributes in relational databases.
- Paper: Integrating Classification and Association Rule Mining, Bing Liu et al. (1998). This work integrates association rule mining with classification techniques by building classifiers based on frequent class association rules.
