Automatic indexing for MongoDB
Loading...
Author (Corporation)
Publication date
2023
Typ of student thesis
Course of study
Collections
Type
04B - Conference paper
Editor (Corporation)
Supervisor
Parent work
New trends in database and information systems. ADBIS 2023 short Papers, doctoral consortium and workshops: AIDMA, DOING, K-Gals, MADEISD, PeRS, Barcelona, Spain, September 4–7, 2023, roceedings
Special issue
DOI of the original publication
Link
Series
Series number
Volume
Issue / Number
Pages / Duration
535–543
Patent number
Publisher / Publishing institution
Springer
Place of publication / Event location
Cham
Edition
Version
Programming language
Assignee
Practice partner / Client
Abstract
We present a new method for automated index suggestion for MongoDB, based solely on the queries (called aggregation pipelines), without requiring data or usage information. The solution handles complex aggregations and is suitable for both cloud and standalone databases. We validated the algorithm on TPC-H and showed that all suggested indexes were used. We report on the performance and provide hints for further development of an automated method of index selection. Our algorithm is, to the best of our knowledge, the first query-based solution for automated indexing in MongoDB.
Keywords
Subject (DDC)
Event
27th European Conference on Advances in Databases and Information Systems (ADBIS 2023)
Exhibition start date
Exhibition end date
Conference start date
04.09.2023
Conference end date
07.09.2023
Date of the last check
ISBN
978-3-031-42940-8
978-3-031-42941-5
978-3-031-42941-5
ISSN
Language
English
Created during FHNW affiliation
Yes
Strategic action fields FHNW
Publication status
Published
Review
Peer review of the complete publication
Open access category
Closed
License
Citation
Espona, L., Vichalkovski, A., Steingartner, W., & Pustulka, E. (2023). Automatic indexing for MongoDB. In A. Abelló, P. Vassiliadis, O. Romero, R. Wrembel, F. Bugiotti, J. Gamper, G. Vargas Solar, & E. Zumpano (Eds.), New trends in database and information systems. ADBIS 2023 short Papers, doctoral consortium and workshops: AIDMA, DOING, K-Gals, MADEISD, PeRS, Barcelona, Spain, September 4–7, 2023, roceedings (pp. 535–543). Springer. https://doi.org/10.1007/978-3-031-42941-5_46