loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Pedro Holanda 1 ; Matheus Nerone 2 ; Eduardo C. de Almeida 2 and Stefan Manegold 1

Affiliations: 1 CWI, Amsterdam and The Netherlands ; 2 UFPR, Curitiba and Brazil

Keyword(s): Multidimensional Range Queries, Database Cracking, Adaptive Indexing, KD-Tree.

Abstract: Workload-aware physical data access structures are crucial to achieve short response time with (exploratory) data analysis tasks as commonly required for Big Data and Data Science applications. Recently proposed techniques such as automatic index advisers (for a priori known static workloads) and query-driven adaptive incremental indexing (for a priori unknown dynamic workloads) form the state-of-the-art to build single-dimensional indexes for single-attribute query predicates. However, similar techniques for more demanding multi-attribute query predicates, which are vital for any data analysis task, have not been proposed, yet. In this paper, we present our on-going work on a new set of workload-adaptive indexing techniques that focus on creating multidimensional indexes. We present our proof-of-concept, the Cracking KD-Tree, an adaptive indexing approach that generates a KD-Tree based on multidimensional range query predicates. It works by incrementally creating partial multidimens ional indexes as a by-product of query processing. The indexes are produced only on those parts of the data that are accessed, and their creation cost is effectively distributed across a stream of queries. Experimental results show that the Cracking KD-Tree is three times faster than creating a full KD-Tree, one order of magnitude faster than executing full scans and two orders of magnitude faster than using uni-dimensional full or adaptive indexes on multiple columns. (More)

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 52.54.103.76

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Holanda, P.; Nerone, M.; Almeida, E. and Manegold, S. (2018). Cracking KD-Tree: The First Multidimensional Adaptive Indexing (Position Paper). In Proceedings of the 7th International Conference on Data Science, Technology and Applications - EDDY; ISBN 978-989-758-318-6; ISSN 2184-285X, SciTePress, pages 393-399. DOI: 10.5220/0006944203930399

@conference{eddy18,
author={Pedro Holanda. and Matheus Nerone. and Eduardo C. de Almeida. and Stefan Manegold.},
title={Cracking KD-Tree: The First Multidimensional Adaptive Indexing (Position Paper)},
booktitle={Proceedings of the 7th International Conference on Data Science, Technology and Applications - EDDY},
year={2018},
pages={393-399},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0006944203930399},
isbn={978-989-758-318-6},
issn={2184-285X},
}

TY - CONF

JO - Proceedings of the 7th International Conference on Data Science, Technology and Applications - EDDY
TI - Cracking KD-Tree: The First Multidimensional Adaptive Indexing (Position Paper)
SN - 978-989-758-318-6
IS - 2184-285X
AU - Holanda, P.
AU - Nerone, M.
AU - Almeida, E.
AU - Manegold, S.
PY - 2018
SP - 393
EP - 399
DO - 10.5220/0006944203930399
PB - SciTePress