Home // ICCGI 2011, The Sixth International Multi-Conference on Computing in the Global Information Technology // View article

Mining Association Rules Inside a Relational Database – A Case Study

Authors:
Mirela Danubianu
Stefan Gheorghe Pentiuc
Iolanda Tobolcea

Keywords: data mining method, association rules, relational database, SQL , stored-procedures

Abstract:
In the context of the necessity to find new knowledge in data, last decade, data mining has become an area of great interest. Although most data mining systems work with data stored in flat files, sometimes it is beneficial to implement data mining algorithms within a DBMS, in order to use SQL or other facilities provided, to discover patterns in data. In this paper we consider a way to discover association rules from data stored into a relational database. We make also a comparative study of performances obtained by applying the following methods: stored procedures in database or candidate and frequent itemsets generated in SQL using a k-way join and a subquery-based algorithm. This study is used to choose the best solution to implement in the particular case of building a dedicated data mining system for personalized therapy of speech disorders optimization.

Pages: 14 to 19

Copyright: Copyright (c) IARIA, 2011

Publication date: June 19, 2011

Published in: conference

ISSN: 2308-4529

ISBN: 978-1-61208-139-7

Location: Luxembourg City, Luxembourg

Dates: from June 19, 2011 to June 24, 2011