{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,27]],"date-time":"2025-03-27T15:15:32Z","timestamp":1743088532285,"version":"3.40.3"},"publisher-location":"Cham","reference-count":35,"publisher":"Springer Nature Switzerland","isbn-type":[{"type":"print","value":"9783031398469"},{"type":"electronic","value":"9783031398476"}],"license":[{"start":{"date-parts":[[2023,1,1]],"date-time":"2023-01-01T00:00:00Z","timestamp":1672531200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2023,1,1]],"date-time":"2023-01-01T00:00:00Z","timestamp":1672531200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2023]]},"DOI":"10.1007\/978-3-031-39847-6_14","type":"book-chapter","created":{"date-parts":[[2023,8,17]],"date-time":"2023-08-17T17:02:46Z","timestamp":1692291766000},"page":"197-212","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":1,"title":["Enhancing Online Index Tuning with\u00a0a\u00a0Learned Tuning Diagnostic"],"prefix":"10.1007","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-6020-6284","authenticated-orcid":false,"given":"Haitian","family":"Hang","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-8799-6020","authenticated-orcid":false,"given":"Jianling","family":"Sun","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2023,8,18]]},"reference":[{"key":"14_CR1","unstructured":"HypoPG - Hypothetical Indexes for PostgreSQL. https:\/\/github.com\/HypoPG\/hypopg"},{"key":"14_CR2","unstructured":"TPC-DS benchmark. www.tpc.org\/tpcds"},{"key":"14_CR3","unstructured":"TPC-H benchmark. www.tpc.org\/tpch"},{"key":"14_CR4","doi-asserted-by":"crossref","unstructured":"Agrawal, S., Chu, E., Narasayya, V.R.: Automatic physical design tuning: workload as a sequence. In: Proceedings of the 2006 ACM SIGMOD International Conference on Management of Data (2006)","DOI":"10.1145\/1142473.1142549"},{"key":"14_CR5","doi-asserted-by":"crossref","unstructured":"Bruno, N., Chaudhuri, S.: Automatic physical database tuning: a relaxation-based approach. In: ACM SIGMOD Conference (2005)","DOI":"10.1145\/1066157.1066184"},{"key":"14_CR6","unstructured":"Bruno, N., Chaudhuri, S.: To tune or not to tune?: a lightweight physical design alerter. In: Very Large Data Bases Conference (2006)"},{"key":"14_CR7","doi-asserted-by":"crossref","unstructured":"Bruno, N., Chaudhuri, S.: An online approach to physical design tuning. In: 2007 IEEE 23rd International Conference on Data Engineering, pp. 826\u2013835 (2007)","DOI":"10.1109\/ICDE.2007.367928"},{"key":"14_CR8","doi-asserted-by":"crossref","unstructured":"Chaudhuri, S., Narasayya, V.: AutoAdmin \u201cwhat-if\u201d index analysis utility. ACM SIGMOD Rec. 27(2), 367\u2013378 (1998)","DOI":"10.1145\/276305.276337"},{"key":"14_CR9","unstructured":"Chaudhuri, S., Narasayya, V.R.: An efficient cost-driven index selection tool for Microsoft SQL server. In: Very Large Data Bases Conference (1997)"},{"key":"14_CR10","doi-asserted-by":"crossref","unstructured":"Choenni, S., Blanken, H.M., Chang, T.: Index selection in relational databases. In: Proceedings of ICCI 1993: 5th International Conference on Computing and Information, pp. 491\u2013496 (1993)","DOI":"10.1109\/ICCI.1993.315323"},{"key":"14_CR11","doi-asserted-by":"crossref","unstructured":"Dash, D., Polyzotis, N., Ailamaki, A.: Cophy: a scalable, portable, and interactive index advisor for large workloads. arXiv abs\/1104.3214 (2011)","DOI":"10.14778\/1978665.1978668"},{"key":"14_CR12","doi-asserted-by":"crossref","unstructured":"Deep, S., Gruenheid, A., Koutris, P., Naughton, J.F., Viglas, S.: Comprehensive and efficient workload compression. arXiv abs\/2011.05549 (2020)","DOI":"10.14778\/3430915.3430931"},{"key":"14_CR13","doi-asserted-by":"crossref","unstructured":"Ding, B., Das, S., Marcus, R., Wu, W., Chaudhuri, S., Narasayya, V.R.: AI meets AI: leveraging query executions to improve index recommendations. In: Proceedings of the 2019 International Conference on Management of Data (2019)","DOI":"10.1145\/3299869.3324957"},{"key":"14_CR14","doi-asserted-by":"publisher","first-page":"706","DOI":"10.1016\/j.ins.2022.08.051","volume":"612","author":"J Gao","year":"2022","unstructured":"Gao, J., Zhao, N., Wang, N., Hao, S., Wu, H.: Automatic index selection with learned cost estimator. Inf. Sci. 612, 706\u2013723 (2022)","journal-title":"Inf. Sci."},{"key":"14_CR15","doi-asserted-by":"publisher","first-page":"2361","DOI":"10.14778\/3551793.3551799","volume":"15","author":"B Hilprecht","year":"2022","unstructured":"Hilprecht, B., Binnig, C.: Zero-shot cost models for out-of-the-box learned cost prediction. Proc. VLDB Endow. 15, 2361\u20132374 (2022)","journal-title":"Proc. VLDB Endow."},{"key":"14_CR16","unstructured":"Jain, S., Howe, B., Yan, J., Cruanes, T.: Query2vec: an evaluation of NLP techniques for generalized workload analytics. arXiv, Databases (2018)"},{"key":"14_CR17","unstructured":"Kipf, A., Kipf, T., Radke, B., Leis, V., Boncz, P.A., Kemper, A.: Learned cardinalities: estimating correlated joins with deep learning. arXiv abs\/1809.00677 (2018)"},{"key":"14_CR18","doi-asserted-by":"publisher","first-page":"2382","DOI":"10.14778\/3407790.3407832","volume":"13","author":"J Kossmann","year":"2020","unstructured":"Kossmann, J., Halfpap, S., Jankrift, M., Schlosser, R.: Magic mirror in my hand, which is the best in the land? Proc. VLDB Endow. 13, 2382\u20132395 (2020)","journal-title":"Proc. VLDB Endow."},{"key":"14_CR19","unstructured":"Kossmann, J., Kastius, A., Schlosser, R.: SWIRL: selection of workload-aware indexes using reinforcement learning. In: International Conference on Extending Database Technology (2022)"},{"key":"14_CR20","doi-asserted-by":"crossref","unstructured":"Lan, H., Bao, Z., Peng, Y.: An index advisor using deep reinforcement learning. In: Proceedings of the 29th ACM International Conference on Information & Knowledge Management (2020)","DOI":"10.1145\/3340531.3412106"},{"key":"14_CR21","doi-asserted-by":"publisher","first-page":"2118","DOI":"10.14778\/3352063.3352129","volume":"12","author":"G Li","year":"2019","unstructured":"Li, G., Zhou, X., Li, S., Gao, B.: Qtune: a query-aware database tuning system with deep reinforcement learning. Proc. VLDB Endow. 12, 2118\u20132130 (2019)","journal-title":"Proc. VLDB Endow."},{"key":"14_CR22","doi-asserted-by":"publisher","first-page":"2575","DOI":"10.1007\/s10489-020-01674-8","volume":"50","author":"GP Licks","year":"2020","unstructured":"Licks, G.P., Couto, J.C., de F\u00e1tima Miehe, P., de Paris, R., Ruiz, D.D., Meneguzzi, F.: SmartIX: a database indexing agent based on reinforcement learning. Appl. Intell. 50, 2575\u20132588 (2020)","journal-title":"Appl. Intell."},{"key":"14_CR23","doi-asserted-by":"crossref","unstructured":"Ma, L., Aken, D.V., Hefny, A.S., Mezerhane, G., Pavlo, A., Gordon, G.J.: Query-based workload forecasting for self-driving database management systems. In: Proceedings of the 2018 International Conference on Management of Data (2018)","DOI":"10.1145\/3183713.3196908"},{"key":"14_CR24","doi-asserted-by":"publisher","first-page":"923","DOI":"10.14778\/3503585.3503600","volume":"15","author":"D Paul","year":"2021","unstructured":"Paul, D., Cao, J., Li, F., Srikumar, V.: Database workload characterization with query plan encoders. Proc. VLDB Endow. 15, 923\u2013935 (2021)","journal-title":"Proc. VLDB Endow."},{"key":"14_CR25","doi-asserted-by":"crossref","unstructured":"Sadri, Z., Gruenwald, L., Leal, E.: DRLindex: deep reinforcement learning index advisor for a cluster database. In: Proceedings of the 24th Symposium on International Database Engineering & Applications (2020)","DOI":"10.1145\/3410566.3410603"},{"key":"14_CR26","doi-asserted-by":"crossref","unstructured":"Schlichtkrull, M., Kipf, T., Bloem, P., van den Berg, R., Titov, I., Welling, M.: Modeling relational data with graph convolutional networks. In: Extended Semantic Web Conference (2017)","DOI":"10.1007\/978-3-319-93417-4_38"},{"key":"14_CR27","doi-asserted-by":"crossref","unstructured":"Schlosser, R., Kossmann, J., Boissier, M.: Efficient scalable multi-attribute index selection using recursive strategies. In: 2019 IEEE 35th International Conference on Data Engineering (ICDE), pp. 1238\u20131249 (2019)","DOI":"10.1109\/ICDE.2019.00113"},{"key":"14_CR28","doi-asserted-by":"crossref","unstructured":"Schnaitter, K., Abiteboul, S., Milo, T., Polyzotis, N.: On-line index selection for shifting workloads. In: 2007 IEEE 23rd International Conference on Data Engineering Workshop, pp. 459\u2013468 (2007)","DOI":"10.1109\/ICDEW.2007.4401029"},{"key":"14_CR29","unstructured":"Sharma, A.K., Schuhknecht, F.M., Dittrich, J.: The case for automatic database administration using deep reinforcement learning. arXiv abs\/1801.05643 (2018)"},{"key":"14_CR30","unstructured":"Sun, J., Li, G.: An end-to-end learning-based cost estimator. arXiv abs\/1906.02560 (2019)"},{"key":"14_CR31","unstructured":"Surajit, C., Narasayya, V.R.: Anytime algorithm of database tuning advisor for Microsoft SQL server (2020)"},{"key":"14_CR32","doi-asserted-by":"crossref","unstructured":"Tang, X., Wu, S., Song, M., Ying, S., Li, F.Y., Chen, G.: PreQR: pre-training representation for SQL understanding. In: Proceedings of the 2022 International Conference on Management of Data (2022)","DOI":"10.1145\/3514221.3517878"},{"key":"14_CR33","doi-asserted-by":"crossref","unstructured":"Valavala, M., Alhamdani, W.: Automatic database index tuning using machine learning. In: 2021 6th International Conference on Inventive Computation Technologies (ICICT), pp. 523\u2013530. IEEE (2021)","DOI":"10.1109\/ICICT50816.2021.9358646"},{"key":"14_CR34","doi-asserted-by":"crossref","unstructured":"Wu, W., et al.: Budget-aware index tuning with reinforcement learning. In: Proceedings of the 2022 International Conference on Management of Data (2022)","DOI":"10.1145\/3514221.3526128"},{"key":"14_CR35","doi-asserted-by":"publisher","first-page":"20","DOI":"10.1016\/j.ins.2021.01.003","volume":"561","author":"Y Yan","year":"2021","unstructured":"Yan, Y., Yao, S., Wang, H., Gao, M.: Index selection for NoSQL database with deep reinforcement learning. Inf. Sci. 561, 20\u201330 (2021)","journal-title":"Inf. Sci."}],"container-title":["Lecture Notes in Computer Science","Database and Expert Systems Applications"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-031-39847-6_14","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,10,26]],"date-time":"2024-10-26T08:59:18Z","timestamp":1729933158000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-031-39847-6_14"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023]]},"ISBN":["9783031398469","9783031398476"],"references-count":35,"URL":"https:\/\/doi.org\/10.1007\/978-3-031-39847-6_14","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2023]]},"assertion":[{"value":"18 August 2023","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"DEXA","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"International Conference on Database and Expert Systems Applications","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Penang","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Malaysia","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2023","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"28 August 2023","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"30 August 2023","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"34","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"dexa2023","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/www.dexa.org\/dexa2023","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Single-blind","order":1,"name":"type","label":"Type","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"EquinOCS","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"155","order":3,"name":"number_of_submissions_sent_for_review","label":"Number of Submissions Sent for Review","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"49","order":4,"name":"number_of_full_papers_accepted","label":"Number of Full Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"35","order":5,"name":"number_of_short_papers_accepted","label":"Number of Short Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"32% - The value is computed by the equation \"Number of Full Papers Accepted \/ Number of Submissions Sent for Review * 100\" and then rounded to a whole number.","order":6,"name":"acceptance_rate_of_full_papers","label":"Acceptance Rate of Full Papers","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"3","order":7,"name":"average_number_of_reviews_per_paper","label":"Average Number of Reviews per Paper","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"4","order":8,"name":"average_number_of_papers_per_reviewer","label":"Average Number of Papers per Reviewer","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"Yes","order":9,"name":"external_reviewers_involved","label":"External Reviewers Involved","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"For the workshops 7 full and 3 short papers have been accepted from 20 submissions","order":10,"name":"additional_info_on_review_process","label":"Additional Info on Review Process","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}}]}}