Selectivity Estimation Using Frequent Itemset Mining빈발항목 마이닝을 이용한 선택도 측정
- Other Titles
- 빈발항목 마이닝을 이용한 선택도 측정
- Authors
- Eom, Boyun; Jermaine, Christopher; Lee, Choonhwa
- Issue Date
- Feb-2015
- Publisher
- 한국지식정보기술학회
- Keywords
- Query optimization; Correlated data; Database management system; Frequent itemsets
- Citation
- 한국지식정보기술학회 논문지, v.10, no.2, pp.69 - 78
- Indexed
- KCI
- Journal Title
- 한국지식정보기술학회 논문지
- Volume
- 10
- Number
- 2
- Start Page
- 69
- End Page
- 78
- URI
- https://scholarworks.bwise.kr/hanyang/handle/2021.sw.hanyang/157845
- ISSN
- 1975-7700
- Abstract
- In query processing, query optimization is an important function of a database management system since overall query execution time can be significantly affected by the quality of the plan chosen by the query optimizer. Under cost-based optimization, a query optimizer estimates the cost for every possible query plans based on the underlying data distribution in synopses of database relations. The most common synopses in commercial databases have been histograms. However, when there is correlation among datum, one-dimensional histograms can provide poor estimation quality. Motivated by this, we propose a new approach to perform more accurate selectivity estimation, even for correlated data. To deal with the correlation that may exist among datum, we adopt well-known techniques in data mining and extract attribute values that occur together frequently using frequent itemsets mining. Through experimentation, we found that our approach is effective in modeling correlations and that this method approximates intermediate relations more accurately. In fact, it gives precise estimates, particularly for the correlated data.
- Files in This Item
-
Go to Link
- Appears in
Collections - 서울 공과대학 > 서울 컴퓨터소프트웨어학부 > 1. Journal Articles
![qrcode](https://api.qrserver.com/v1/create-qr-code/?size=55x55&data=https://scholarworks.bwise.kr/hanyang/handle/2021.sw.hanyang/157845)
Items in ScholarWorks are protected by copyright, with all rights reserved, unless otherwise indicated.