An Architecture for Query Optimization Using Association Rule Mining

Sikha Bagui, Mohammad Islam and Subhash Bagui
Additional contact information
Sikha Bagui: University of West Florida, USA
Mohammad Islam: University of West Florida, USA
Subhash Bagui: University of West Florida, USA

International Journal of Knowledge-Based Organizations (IJKBO), 2011, vol. 1, issue 4, 32-55

Abstract: This research presents a way to identify attribute-value relationships already existing in a database by using association rule mining to optimize query processing. Once relationships have been determined, these relationships can be used as a basis for creating temporary structures like views to optimize query operations. This paper presents an architecture that shows how table partitions in the form of views, created based on association rules, can be used to optimize queries. The results of this study were statistically significant.

Date: 2011
References: Add references at CitEc
Citations:

Downloads: (external link)
http://services.igi-global.com/resolvedoi/resolve. ... 018/ijkbo.2011100103 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:igg:jkbo00:v:1:y:2011:i:4:p:32-55

Access Statistics for this article

International Journal of Knowledge-Based Organizations (IJKBO) is currently edited by John Wang

More articles in International Journal of Knowledge-Based Organizations (IJKBO) from IGI Global
Bibliographic data for series maintained by Journal Editor ().