Automatic indexing for MongoDB

dc.contributor.authorEspona, Lucía
dc.contributor.authorVichalkovski, Anton
dc.contributor.authorSteingartner, William
dc.contributor.authorPustulka, Elzbieta
dc.contributor.editorAbelló, Alberto
dc.contributor.editorVassiliadis, Panos
dc.contributor.editorRomero, Oscar
dc.contributor.editorWrembel, Robert
dc.contributor.editorBugiotti, Francesca
dc.contributor.editorGamper, Johann
dc.contributor.editorVargas Solar, Genoveva
dc.contributor.editorZumpano, Ester
dc.date.accessioned2024-04-17T13:25:55Z
dc.date.available2024-04-17T13:25:55Z
dc.date.issued2023
dc.description.abstractWe 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.
dc.event27th European Conference on Advances in Databases and Information Systems (ADBIS 2023)
dc.event.end2023-09-07
dc.event.start2023-09-04
dc.identifier.doihttps://doi.org/10.1007/978-3-031-42941-5_46
dc.identifier.isbn978-3-031-42940-8
dc.identifier.isbn978-3-031-42941-5
dc.identifier.urihttps://irf.fhnw.ch/handle/11654/43460
dc.language.isoen
dc.publisherSpringer
dc.relation.ispartofNew 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
dc.spatialCham
dc.subject.ddc330 - Wirtschaft
dc.titleAutomatic indexing for MongoDB
dc.type04B - Beitrag Konferenzschrift
dspace.entity.typePublication
fhnw.InventedHereYes
fhnw.ReviewTypeAnonymous ex ante peer review of a complete publication
fhnw.affiliation.hochschuleHochschule für Wirtschaftde_CH
fhnw.affiliation.institutInstitut für Wirtschaftsinformatikde_CH
fhnw.openAccessCategoryClosed
fhnw.pagination535–543
fhnw.publicationStatePublished
relation.isAuthorOfPublication3e7f2a0a-692e-4652-b305-7a7e19e011de
relation.isAuthorOfPublication.latestForDiscovery3e7f2a0a-692e-4652-b305-7a7e19e011de
Dateien
Lizenzbündel
Gerade angezeigt 1 - 1 von 1
Lade...
Vorschaubild
Name:
license.txt
Größe:
1.36 KB
Format:
Item-specific license agreed upon to submission
Beschreibung: