{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,26]],"date-time":"2025-03-26T03:18:57Z","timestamp":1742959137580,"version":"3.40.3"},"publisher-location":"Cham","reference-count":32,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783031124228"},{"type":"electronic","value":"9783031124235"}],"license":[{"start":{"date-parts":[[2022,1,1]],"date-time":"2022-01-01T00:00:00Z","timestamp":1640995200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2022,1,1]],"date-time":"2022-01-01T00:00:00Z","timestamp":1640995200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2022]]},"DOI":"10.1007\/978-3-031-12423-5_11","type":"book-chapter","created":{"date-parts":[[2022,7,28]],"date-time":"2022-07-28T17:03:28Z","timestamp":1659027808000},"page":"139-152","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":1,"title":["A Divergent Index Advisor Using Deep Reinforcement Learning"],"prefix":"10.1007","author":[{"given":"Zahra","family":"Sadri","sequence":"first","affiliation":[]},{"given":"Le","family":"Gruenwald","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2022,7,29]]},"reference":[{"key":"11_CR1","unstructured":"Abadi, M., et al.: TensorFlow: a system for large-scale machine learning. In: 12th USENIX Symposium on Operating Systems Design and Implementation (OSDI 16), pp. 265\u2013283 (2016)"},{"key":"11_CR2","doi-asserted-by":"crossref","unstructured":"Agrawal, S., Chaudhuri, S., Kollar, L., Marathe, A., Narasayya, V., Syamala, M.: Database tuning advisor for Microsoft SQL server 2005. In: Proceedings of the 2005 ACM SIGMOD International Conference on Management of Data (SIGMOD), pp. 930\u2013932 (2005)","DOI":"10.1145\/1066157.1066292"},{"key":"11_CR3","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"253","DOI":"10.1007\/978-3-319-22849-5_18","volume-title":"Database and Expert Systems Applications","author":"D Basu","year":"2015","unstructured":"Basu, D., et al.: Cost-model oblivious database tuning with reinforcement learning. In: Chen, Q., Hameurlain, A., Toumani, F., Wagner, R., Decker, H. (eds.) DEXA 2015. LNCS, vol. 9261, pp. 253\u2013268. Springer, Cham (2015). https:\/\/doi.org\/10.1007\/978-3-319-22849-5_18"},{"key":"11_CR4","unstructured":"Agarap, A.F.: Deep learning using rectified linear units (ReLU). arXiv preprint arXiv:1803.08375 (2018)"},{"issue":"2","key":"11_CR5","doi-asserted-by":"publisher","first-page":"367","DOI":"10.1145\/276305.276337","volume":"27","author":"S Chaudhuri","year":"1998","unstructured":"Chaudhuri, S., Narasayya, V.: AutoAdmin \u201cwhat-if\u201d index analysis utility. ACM SIGMOD Rec. 27(2), 367\u2013378 (1998)","journal-title":"ACM SIGMOD Rec."},{"key":"11_CR6","unstructured":"CloudLab. https:\/\/www.cloudlab.us\/"},{"issue":"4","key":"11_CR7","doi-asserted-by":"publisher","first-page":"440","DOI":"10.1145\/320289.320296","volume":"3","author":"D Comer","year":"1978","unstructured":"Comer, D.: The difficulty of optimum index selection. ACM Trans. Database Syst. (TODS) 3(4), 440\u2013445 (1978)","journal-title":"ACM Trans. Database Syst. (TODS)"},{"key":"11_CR8","doi-asserted-by":"crossref","unstructured":"Consens, M.P., Ioannidou, K., LeFevre, J., Polyzotis, N.: Divergent physical design tuning for replicated databases. In: Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data, pp. 49\u201360 (2012)","DOI":"10.1145\/2213836.2213843"},{"key":"11_CR9","first-page":"362","volume":"4","author":"D Dash","year":"2011","unstructured":"Dash, D., Polyzotis, N., Ailamaki, A.: CoPhy: a scalable, portable, and interactive index advisor for large workloads. PVLDB 4, 362\u2013372 (2011)","journal-title":"PVLDB"},{"key":"11_CR10","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, pp. 1241\u20131258 (2019)","DOI":"10.1145\/3299869.3324957"},{"key":"11_CR11","doi-asserted-by":"crossref","unstructured":"Durand, G.C., et al.: GridFormation: towards self-driven online data partitioning using reinforcement learning. In: Proceedings of the First International Workshop on Exploiting Artificial Intelligence Techniques for Data Management, pp. 1\u20137 (2018)","DOI":"10.1145\/3211954.3211956"},{"key":"11_CR12","doi-asserted-by":"crossref","unstructured":"Hilprecht, B., Binnig, C., R\u00f6hm, U.: Learning a partitioning advisor for cloud databases. In: Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data (SIGMOD), pp. 143\u2013157 (2020)","DOI":"10.1145\/3318464.3389704"},{"key":"11_CR13","unstructured":"Keras. https:\/\/keras.io\/"},{"key":"11_CR14","unstructured":"Krishnan, S., Yang, Z., Goldberg, K., Hellerstein, J.M., Stoica, I.: Learning to optimize join queries with deep reinforcement learning. CoRR arXiv preprint arXiv:1808.03196 (2018)"},{"key":"11_CR15","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, pp. 2105\u20132108 (2020)","DOI":"10.1145\/3340531.3412106"},{"issue":"12","key":"11_CR16","doi-asserted-by":"publisher","first-page":"3028","DOI":"10.14778\/3476311.3476380","volume":"14","author":"G Li","year":"2021","unstructured":"Li, G., et al.: openGauss: an autonomous database system. Proc. VLDB Endow. 14(12), 3028\u20133042 (2021)","journal-title":"Proc. VLDB Endow."},{"issue":"12","key":"11_CR17","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(12), 2118\u20132130 (2019)","journal-title":"Proc. VLDB Endow."},{"key":"11_CR18","doi-asserted-by":"crossref","unstructured":"Ma, L., Van Aken, D., Hefny, A., 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, pp. 631\u2013645 (2018)","DOI":"10.1145\/3183713.3196908"},{"key":"11_CR19","doi-asserted-by":"crossref","unstructured":"Marcus, R., Papaemmanouil, O.: Deep reinforcement learning for join order enumeration. In: Proceedings of the First International Workshop on Exploiting Artificial Intelligence Techniques for Data Management, pp. 1\u20134 (2018)","DOI":"10.1145\/3211954.3211957"},{"issue":"7540","key":"11_CR20","doi-asserted-by":"publisher","first-page":"529","DOI":"10.1038\/nature14236","volume":"518","author":"V Mnih","year":"2015","unstructured":"Mnih, V., et al.: Human-level control through deep reinforcement learning. Nature 518(7540), 529\u2013533 (2015)","journal-title":"Nature"},{"issue":"8","key":"11_CR21","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., et al.: SMARTIX: a database indexing agent based on reinforcement learning. Appl. Intell. 50(8), 2575\u20132588 (2020). https:\/\/doi.org\/10.1007\/s10489-020-01674-8","journal-title":"Appl. Intell."},{"key":"11_CR22","unstructured":"Papadomanolakis, S., Dash, D., Ailamaki, A.: Efficient use of the query optimizer for automated physical design. In: Proceedings of the 33rd International Conference on Very Large Data Bases, pp. 1093\u20131104 (2007)"},{"key":"11_CR23","doi-asserted-by":"crossref","unstructured":"Perera, R.M., Oetomo, B., Rubinstein, B.I., Borovica-Gajic, R.: DBA bandits: self-driving index tuning under ad-hoc, analytical workloads with safety guarantees. In: IEEE 37th International Conference on Data Engineering (ICDE), pp. 600\u2013611 (2021)","DOI":"10.1109\/ICDE51399.2021.00058"},{"key":"11_CR24","doi-asserted-by":"crossref","unstructured":"Tran, Q.T., Jimenez, I., Wang, R., Polyzotis, N., Ailamaki, A.: RITA: an index-tuning advisor for replicated databases. In: Proceedings of the 27th International Conference on Scientific and Statistical Database Management, pp. 1\u201312 (2015)","DOI":"10.1145\/2791347.2791376"},{"key":"11_CR25","unstructured":"Schaarschmidt, M., Kuhnle, A., Ellis, B., Fricke, K., Gessert, F., Yoneki, E.: LIFT: reinforcement learning in computer systems by learning from demonstrations. arXiv preprint arXiv:1808.07903 (2018)"},{"key":"11_CR26","doi-asserted-by":"crossref","unstructured":"Schnaitter, K., Abiteboul, S., Milo, T., Polyzotis, N.: On-line index selection for shifting workloads. In: IEEE 23rd International Conference on Data Engineering Workshop, pp. 459\u2013468 (2007)","DOI":"10.1109\/ICDEW.2007.4401029"},{"key":"11_CR27","volume-title":"Reinforcement Learning: An Introduction","author":"RS Sutton","year":"2018","unstructured":"Sutton, R.S., Barto, A.G.: Reinforcement Learning: An Introduction. MIT Press, Cambridge (2018)"},{"key":"11_CR28","unstructured":"TPC: TPC-H benchmark. http:\/\/www.tpc.org\/tpch\/"},{"key":"11_CR29","unstructured":"TPC: TPC-DS benchmark. http:\/\/www.tpc.org\/tpcds\/"},{"key":"11_CR30","doi-asserted-by":"crossref","unstructured":"Sadri, Z., Gruenwald, L., Leal, E.: Online index selection using deep reinforcement learning for a cluster database. In: 2020 IEEE 36th International Conference on Data Engineering Workshops (ICDEW), pp. 158\u2013161 (2020)","DOI":"10.1109\/ICDEW49219.2020.00035"},{"key":"11_CR31","doi-asserted-by":"crossref","unstructured":"Sadri, Z., Gruenwald, L., Lead, E.: DRLindex: deep reinforcement learning index advisor for a cluster database. In: Proceedings of the 24th Symposium on International Database Engineering & Applications, pp. 1\u20138 (2020)","DOI":"10.1145\/3410566.3410603"},{"key":"11_CR32","doi-asserted-by":"crossref","unstructured":"Zhang, J., et al.: An end-to-end automatic cloud database tuning system using deep reinforcement learning. In: Proceedings of the 2019 International Conference on Management of Data, pp. 415\u2013432 (2019)","DOI":"10.1145\/3299869.3300085"}],"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-12423-5_11","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,9,30]],"date-time":"2024-09-30T03:14:56Z","timestamp":1727666096000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-031-12423-5_11"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022]]},"ISBN":["9783031124228","9783031124235"],"references-count":32,"URL":"https:\/\/doi.org\/10.1007\/978-3-031-12423-5_11","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2022]]},"assertion":[{"value":"29 July 2022","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":"Vienna","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Austria","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2022","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"22 August 2022","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"24 August 2022","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"33","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"dexa2022","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"http:\/\/www.dexa.org\/dexa2022","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":"EasyChair","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"120","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":"43","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":"20","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":"36% - 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":"5","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":"Mixed review process- Single and double blind","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)"}}]}}