Volume 8 Number 8 (Aug. 2013)
Home > Archive > 2013 > Volume 8 Number 8 (Aug. 2013) >
JSW 2013 Vol.8(8): 1843-1850 ISSN: 1796-217X
doi: 10.4304/jsw.8.8.1843-1850

Research on Frequent Itemsets Mining Algorithm based on Relational Database

Jingyang Wang, Huiyong Wang, Dongwen Zhang, Wanzhen Zhou, Pengpeng Zhang
Hebei University of Science and Technology, Shijiazhuang, China

Abstract—Mining association rules between items is an important research direction of data mining, and the relational database is the most popular database, so mining association rules in the relational database is a very important research direction. At present, neither the Apriori algorithm nor its improvements resolve some problems generating candidate itemset and scanning the transaction set repeatedly, which lead to low efficiency. This paper proposes the frequent itemsets mining algorithm based on relational database based on the study of those important mining association rules algorithms and the storage characteristics of the transaction set and items in the relational database, and presents its concrete implementation and its optimization method. This algorithm combines items in a transaction to generate itemsets and counts the same itemsets in all transactions, which improve the efficiency of execution. Moreover, this algorithm doesn’t produce candidate itemsets, and only scans transaction database once, so promotes considerably efficiency. The result of experiments shows that, the frequent itemsets mining algorithm based on relational database has higher efficiency than the classical Apriori algorithm under certain conditions.

Index Terms—Relational database, frequent itemsets, association rule, Apriori.

[PDF]

Cite: Jingyang Wang, Huiyong Wang, Dongwen Zhang, Wanzhen Zhou, Pengpeng Zhang, "Research on Frequent Itemsets Mining Algorithm based on Relational Database," Journal of Software vol. 8, no. 8, pp. 1843-1850, 2013.

General Information

ISSN: 1796-217X (Online)
Frequency:  Bimonthly (Since 2020)
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Yoyo Y. Zhou
Abstracting/ Indexing: DBLP, EBSCO, Google Scholar, ProQuest, INSPEC(IET), ULRICH's Periodicals Directory, WorldCat, etc
E-mail: jsw@iap.org
  • Apr 26, 2021 News!

    Vol 14, No 4- Vol 14, No 12 has been indexed by IET-(Inspec)     [Click]

  • Jun 22, 2020 News!

    Papers published in JSW Vol 14, No 1- Vol 15 No 4 have been indexed by DBLP     [Click]

  • Sep 13, 2021 News!

    The papers published in Vol 16, No 6 have all received dois from Crossref    [Click]

  • Jan 28, 2021 News!

    [CFP] 2021 the annual meeting of JSW Editorial Board, ICCSM 2021, will be held in Rome, Italy, July 21-23, 2021   [Click]

  • Sep 13, 2021 News!

    Vol 16, No 6 has been published with online version     [Click]