Automatic indexing for MongoDB
| dc.contributor.author | Espona, Lucía | |
| dc.contributor.author | Vichalkovski, Anton | |
| dc.contributor.author | Steingartner, William | |
| dc.contributor.author | Pustulka, Elzbieta | |
| dc.contributor.editor | Abelló, Alberto | |
| dc.contributor.editor | Vassiliadis, Panos | |
| dc.contributor.editor | Romero, Oscar | |
| dc.contributor.editor | Wrembel, Robert | |
| dc.contributor.editor | Bugiotti, Francesca | |
| dc.contributor.editor | Gamper, Johann | |
| dc.contributor.editor | Vargas Solar, Genoveva | |
| dc.contributor.editor | Zumpano, Ester | |
| dc.date.accessioned | 2024-04-17T13:25:55Z | |
| dc.date.available | 2024-04-17T13:25:55Z | |
| dc.date.issued | 2023 | |
| dc.description.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. | |
| dc.event | 27th European Conference on Advances in Databases and Information Systems (ADBIS 2023) | |
| dc.event.end | 2023-09-07 | |
| dc.event.start | 2023-09-04 | |
| dc.identifier.doi | https://doi.org/10.1007/978-3-031-42941-5_46 | |
| dc.identifier.isbn | 978-3-031-42940-8 | |
| dc.identifier.isbn | 978-3-031-42941-5 | |
| dc.identifier.uri | https://irf.fhnw.ch/handle/11654/43460 | |
| dc.language.iso | en | |
| dc.publisher | Springer | |
| dc.relation.ispartof | 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 | |
| dc.spatial | Cham | |
| dc.subject.ddc | 330 - Wirtschaft | |
| dc.title | Automatic indexing for MongoDB | |
| dc.type | 04B - Beitrag Konferenzschrift | |
| dspace.entity.type | Publication | |
| fhnw.InventedHere | Yes | |
| fhnw.ReviewType | Anonymous ex ante peer review of a complete publication | |
| fhnw.affiliation.hochschule | Hochschule für Wirtschaft FHNW | de_CH |
| fhnw.affiliation.institut | Institut für Wirtschaftsinformatik | de_CH |
| fhnw.openAccessCategory | Closed | |
| fhnw.pagination | 535–543 | |
| fhnw.publicationState | Published | |
| relation.isAuthorOfPublication | 3e7f2a0a-692e-4652-b305-7a7e19e011de | |
| relation.isAuthorOfPublication.latestForDiscovery | 3e7f2a0a-692e-4652-b305-7a7e19e011de |
Dateien
Lizenzbündel
1 - 1 von 1
Kein Vorschaubild vorhanden
- Name:
- license.txt
- Größe:
- 1.36 KB
- Format:
- Item-specific license agreed upon to submission
- Beschreibung: