DocumentCode :
2741998
Title :
Research on Multi-dimensional Association Rules Mining in Distributed Environments Based on Advanced SQL Query
Author :
Zhang, Lei ; Qiao, Mei ; Zhang, Degan
Author_Institution :
Tianjin Key Lab. of Intell. Comput. & Novel Software Technol., Tianjin Univ. of Technol., Tianjin, China
Volume :
2
fYear :
2009
fDate :
14-16 Aug. 2009
Firstpage :
108
Lastpage :
112
Abstract :
This paper proposes the MDMA (multi-dimensional distributed mining association rules) algorithm based on advanced SQL query. The algorithm works on star-style structure networks. It uses CUBE operator in new standard SQL and combines with SQL powerful query function. So there is no need for the proposed algorithm to conduct a great deal of iterations to generate frequent itemsets in the process of mining association rules. Therefore, no matter what the number of the site in the distributed environments and the scale of the local database in the local site is, the algorithm always needs only two times of scanning the database and only three times of network communications to generate all the global frequent itemsets. Consequently, this algorithm has the merits of light network traffic, low time cost, better scalability and more simplicity.
Keywords :
SQL; data mining; distributed processing; query languages; query processing; CUBE operator; advanced SQL query; distributed environments; global frequent itemsets; light network traffic; multidimensional association rules mining; network communications; star-style structure networks; Association rules; Computer vision; Costs; Data mining; Distributed databases; Educational technology; Fuzzy systems; Itemsets; Paper technology; Telecommunication traffic;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Fuzzy Systems and Knowledge Discovery, 2009. FSKD '09. Sixth International Conference on
Conference_Location :
Tianjin
Print_ISBN :
978-0-7695-3735-1
Type :
conf
DOI :
10.1109/FSKD.2009.622
Filename :
5358653
Link To Document :
بازگشت