arrow
返回

Online index recommendations for high-dimensional databases using query workloads

delete2008-02-01
delete12
PRE
AI
G
Guadalupe Canahuate
H
Hakan Ferhatosmanoğlu
DOI:10.1109/TKDE.2007.190690delete
delete原文链接
delete原文求助
delete分享
delete收藏
摘要

摘要

En 中文
High-dimensional databases pose a challenge with respect to efficient access. High-dimensional indexes do not work because of the often-cited curse of dimensionality. However, users are usually interested in querying data over a relatively small subset of the entire attribute set at a time. A potential solution is to use lower dimensional indexes that accurately represent the user access patterns. A query response using the physical database design that is developed based on a static snapshot of the query workload may significantly degrade if the query patterns change. To address these issues, we introduce a parameterizable technique to recommend indexes based on index types that are frequently used for high-dimensional data sets and to dynamically adjust indexes as the underlying query workload changes. We incorporate a query pattern change detection mechanism to determine when the access patterns have changed enough to warrant change in the physical database design. By adjusting analysis parameters, we trade off analysis speed against analysis resolution. We perform experiments with a number of data sets, query sets, and parameters to show the effect that varying these characteristics has on analysis results.
Keyword:
index selection
high-dimensional indexing
query access patterns
AI总结

AI总结

对已上传原文的论文进行重点信息的提取,主要内容包括:简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。

期刊

IEEE Transactions on Knowledge and Data Engineering 封面图
IEEE Transactions on Knowledge and Data Engineering
IF:
10.4
论文数:
6.8K
被引数:
3.2W

机构

U
University System of Ohio
学者数:
15.5W
论文数: 13.0W
被引数: 200
引用论文

引用论文

Indenyl and fluorenyl transition element complexes
err1978-10-01
err0
PREAI
errA.N. Nesmeyanov; N.A. Ustynyuk; L.G. Makarova; V.G. Andrianov; Yu.T. Struchkov; Steffen Andrae; Yu.A. Ustynyuk; S.G. Malyugina
err分享
err收藏
Multisystemic inflammatory disease in a borzoi dog
err2008-06-28
err0
PREAI
errM. T. Cheeseman; D. F. Kelly; K. L. Horsfall
err分享
err收藏
Terahertz waveguiding in glass-clad silicon wafers
err2020-02-10
err0
errOAAI
errTrygve Sørgård; Kjell Martin Mølster; Fredrik Laurell; Valdas Pasiskevicius; Ursula J. Gibson; Ulf L. Österberg
err分享
err收藏
Surgical site infection surveillance after open gastrectomy and risk factors for surgical site infection
err2005-01-01
err0
PREAI
errEiko Imai; Masakazu Ueda; Tetsuro Kubota; Masaki Kitajima; Kent Kanao; Koichi Miyaki
err分享
err收藏
Lifetime measurements in an electrostatic ion beam trap using image charge monitoring
err2012-03-21
err0
errOAAI
errIgor Rahinov; Yoni Toker; Oded Heber; Daniel Strasser; Michael Rappaport; Dirk Schwalm; Daniel Zajfman
err分享
err收藏
Maximal Oxygen Intake as an Objective Measure of Cardio-Respiratory Performance
err1955-07-01
err0
PREAI
errHenry Longstreet Taylor; Elsworth Buskirk; Austin Henschel
err分享
err收藏
Social relationships and vulnerability to becoming homeless among poor families.
err1991-01-01
err0
PREAI
errMarybeth Shinn; James R. Knickman; Beth C. Weitzman
err分享
err收藏
学者 查看更多内容