Efficient processing of substring match queries with inverted variable-length gram indexes
- Authors
- Kim, Younghoon; Park, Hyoungmin; Shim, Kyuseok; Woo, Kyoung-Gu
- Issue Date
- Sep-2013
- Publisher
- Elsevier BV
- Keywords
- Database management; Query processing; Substring matching; q-Gram index; Variable-length gram
- Citation
- Information Sciences, v.244, pp 119 - 141
- Pages
- 23
- Indexed
- SCI
SCIE
SCOPUS
- Journal Title
- Information Sciences
- Volume
- 244
- Start Page
- 119
- End Page
- 141
- URI
- https://scholarworks.bwise.kr/erica/handle/2021.sw.erica/27096
- DOI
- 10.1016/j.ins.2013.04.037
- ISSN
- 0020-0255
1872-6291
- Abstract
- With the widespread use of the internet, text-based data sources have become ubiquitous and the demand for effective support of string matching queries continues to increase. The relational query language SQL supports LIKE clauses for string data to handle substring matching queries. Due to the popularity of such substring matching queries, there have been many studies on designing efficient indexes to support the LIKE clause in SQL Among them, the indexes based on q-grams with fixed or variable sizes have been studied extensively. In this paper, we show that the optimal processing of substring matching queries with inverted variable-length gram indexes should be decided judiciously. However, the search space of finding the optimal variable-length gram set among those available is exponential with the number of grams. To reduce the search space, we present effective pruning strategies which do not sacrifice optimality. Based on the cost estimation, we propose the optimal algorithms to find the best plan with the minimum cost for substring matching queries using these pruning strategies. We also provide the approximate algorithms to overcome the exponential nature of search space to find an optimal query plan. Our performance study confirms that the proposed techniques improve query execution time for substring matching significantly compared to the running time of the traditional algorithms. (C) 2013 Elsevier Inc. All rights reserved.
- Files in This Item
-
Go to Link
- Appears in
Collections - COLLEGE OF COMPUTING > DEPARTMENT OF ARTIFICIAL INTELLIGENCE > 1. Journal Articles
![qrcode](https://api.qrserver.com/v1/create-qr-code/?size=55x55&data=https://scholarworks.bwise.kr/erica/handle/2021.sw.erica/27096)
Items in ScholarWorks are protected by copyright, with all rights reserved, unless otherwise indicated.