An Architecture for Query Optimization Using Association Rule Mining

An Architecture for Query Optimization Using Association Rule Mining

Sikha Bagui, Mohammad Islam, Subhash Bagui
Copyright: © 2011 |Volume: 1 |Issue: 4 |Pages: 24
ISSN: 2155-6393|EISSN: 2155-6407|EISBN13: 9781613508305|DOI: 10.4018/ijkbo.2011100103
Cite Article Cite Article

MLA

Bagui, Sikha, et al. "An Architecture for Query Optimization Using Association Rule Mining." IJKBO vol.1, no.4 2011: pp.32-55. http://doi.org/10.4018/ijkbo.2011100103

APA

Bagui, S., Islam, M., & Bagui, S. (2011). An Architecture for Query Optimization Using Association Rule Mining. International Journal of Knowledge-Based Organizations (IJKBO), 1(4), 32-55. http://doi.org/10.4018/ijkbo.2011100103

Chicago

Bagui, Sikha, Mohammad Islam, and Subhash Bagui. "An Architecture for Query Optimization Using Association Rule Mining," International Journal of Knowledge-Based Organizations (IJKBO) 1, no.4: 32-55. http://doi.org/10.4018/ijkbo.2011100103

Export Reference

Mendeley
Favorite Full-Issue Download

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.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.