SMIX live - A self-managing index infrastructure for dynamic workloads

Research output: Contribution to book/Conference proceedings/Anthology/ReportConference contributionContributedpeer-review

Contributors

Abstract

As databases accumulate growing amounts of data at an increasing rate, adaptive indexing becomes more and more important. At the same time, applications and their use get more agile and flexible, resulting in less steady and less predictable workload characteristics. Being inert and coarse-grained, state-of-the-art index tuning techniques become less useful in such environments. Especially the full-column indexing paradigm results in lot of indexed but never queried data and prohibitively high memory and maintenance costs. In our demonstration, we present Self-Managing Indexes, a novel, adaptive, fine-grained, autonomous indexing infrastructure. In its core, our approach builds on a novel access path that automatically collects useful index information, discards useless index information, and competes with its kind for resources to host its index information. Compared to existing technologies for adaptive indexing, we are able to dynamically grow and shrink our indexes, instead of incrementally enhancing the index granularity. In the demonstration, we visualize performance and system measures for different scenarios and allow the user to interactively change several system parameters.

Details

Original languageEnglish
Title of host publication2012 IEEE 28th International Conference on Data Engineering
PublisherIEEE
Pages1225-1228
Number of pages4
ISBN (electronic)978-0-7695-4747-3
ISBN (print)978-1-4673-0042-1
Publication statusPublished - 2012
Peer-reviewedYes

Publication series

Series International Conference on Data Engineering (ICDE)
ISSN1084-4627

Conference

TitleIEEE 28th International Conference on Data Engineering, ICDE 2012
Duration1 - 5 April 2012
CityArlington, VA
CountryUnited States of America

External IDs

ORCID /0000-0001-8107-2775/work/199215569

Keywords

Research priority areas of TU Dresden

DFG Classification of Subject Areas according to Review Boards

Subject groups, research areas, subject areas according to Destatis