Persistent URL of this record https://hdl.handle.net/1887/3212937
Documents
-
- Download
- Title Pages_Acknowledgements_Contents
-
open access
-
- Download
- Summary in English
-
open access
-
- Download
- Summary in Dutch
-
open access
-
- Download
- Publications_Curriculum Vitae
-
open access
-
- Download
- Propositions
-
open access
In Collections
This item can be found in the following collections:
Progressive Indexes
In this work, we introduce Progressive Indexing, a novel performance-driven indexing technique that focuses on automatic index creation while providing interactive response times to incoming queries. Its design allows queries to have a limited budget to spend on index creation. The indexing budget is automatically tuned to each query before query processing. This allows for systems to provide...Show moreInteractive exploration of large volumes of data is increasingly common, as data scientists attempt to extract interesting information from large opaque data sets. This scenario presents a difficult challenge for traditional database systems, as (1) nothing is known about the query workload in advance, (2) the query workload is constantly changing, and (3) the system must provide interactive responses to the issued queries. This environment is challenging for index creation, as traditional database indexes require upfront creation, hence a priori workload knowledge, to be efficient.
In this work, we introduce Progressive Indexing, a novel performance-driven indexing technique that focuses on automatic index creation while providing interactive response times to incoming queries. Its design allows queries to have a limited budget to spend on index creation. The indexing budget is automatically tuned to each query before query processing. This allows for systems to provide interactive answers to queries during index creation while being robust against various workload patterns and data distributions.
We develop progressive algorithms to index one and multiple dimensions. In addition, we introduce Progressive Merges, a robust algorithm that merges appends into our Progressive Indexes without penalizing single queries.Show less
- All authors
- Timbó Holanda, P.T.
- Supervisor
- Manegold, S.
- Co-supervisor
- Mühleisen, H.; Boncz, P.A.
- Committee
- Plaat, A.; Bäck, T.; Diao, Y.; Idreos, S.; Cunha de Almeida, E.
- Qualification
- Doctor (dr.)
- Awarding Institution
- Leiden Institute of Advanced Computer Science (LIACS) , Faculty of Science , Leiden University
- Date
- 2021-09-21
- Title of host publication
- SIKS Dissertation Series
Publication Series
- Name
- 2021-21