Index selection: A query pattern mining approach

Event Name/Location

Montreal, QC, Canada / October 1-4, 2013

Presentation Date

10-1-2013

Document Type

Conference Proceeding

Presenter(s)

Junping Sun, Nova Southeastern UniversityFollow
Jiman Hong, Soongsil University

Proceedings Title

Proceedings of ACM 2013 Research in Adaptive and Convergent Systems

ISBN

978-1-4503-2348-2

Description

Indexing technique has been used extensively in order to facilitate and optimize query processing in various data retrieval and storage systems. Although an index technique can be used to reduce searching cost in both horizontal and vertical dimensions, it incurs both storage and maintenance costs. Index selection has been an active research subject, and various index selection methods have been given in literature. This paper will present a framework to mine frequent query patterns to select most frequently used access paths as candidates for index selection, and a Bayesian based method will be used to select index fields from the candidate set.

DOI

10.1145/2513228.2513253

First Page

100

Last Page

106

Comments

Conference Website: https://sites.google.com/site/acmracs2013/

NSUWorks Citation

Sun, Junping and Hong, Jiman, "Index selection: A query pattern mining approach" (2013). CCE Faculty Proceedings, Presentations, Speeches and Lectures. 67.
https://nsuworks.nova.edu/gscis_facpres/67