{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,26]],"date-time":"2025-03-26T06:57:13Z","timestamp":1742972233539,"version":"3.40.3"},"publisher-location":"Cham","reference-count":28,"publisher":"Springer Nature Switzerland","isbn-type":[{"type":"print","value":"9783031683114"},{"type":"electronic","value":"9783031683121"}],"license":[{"start":{"date-parts":[[2024,1,1]],"date-time":"2024-01-01T00:00:00Z","timestamp":1704067200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2024,1,1]],"date-time":"2024-01-01T00:00:00Z","timestamp":1704067200000},"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":[[2024]]},"DOI":"10.1007\/978-3-031-68312-1_15","type":"book-chapter","created":{"date-parts":[[2024,8,16]],"date-time":"2024-08-16T18:01:59Z","timestamp":1723831319000},"page":"185-200","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Unlocking the\u00a0Power of\u00a0Diversity in\u00a0Index Tuning for\u00a0Cluster Databases"],"prefix":"10.1007","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-6020-6284","authenticated-orcid":false,"given":"Haitian","family":"Hang","sequence":"first","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0001-8611-0283","authenticated-orcid":false,"given":"Xiu","family":"Tang","sequence":"additional","affiliation":[]},{"given":"Bo","family":"Zhou","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0001-8799-6020","authenticated-orcid":false,"given":"Jianling","family":"Sun","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2024,8,17]]},"reference":[{"key":"15_CR1","unstructured":"HypoPG - hypothetical indexes for PostgreSQL. https:\/\/github.com\/HypoPG\/hypopg"},{"key":"15_CR2","unstructured":"PostgreSQL. https:\/\/www.postgresql.org"},{"key":"15_CR3","unstructured":"TPC-H benchmark. www.tpc.org\/tpch"},{"key":"15_CR4","unstructured":"TPC-H benchmark. www.tpc.org\/tpcds"},{"key":"15_CR5","unstructured":"Agrawal, S., Chaudhuri, S., Narasayya, V.R.: Automated selection of materialized views and indexes in SQL databases. In: VLDB, vol.\u00a02000, pp. 496\u2013505 (2000)"},{"key":"15_CR6","unstructured":"Chaudhuri, S., Narasayya, V.: Anytime algorithm of database tuning advisor for Microsoft SQL server (2020)"},{"key":"15_CR7","unstructured":"Chaudhuri, S., Narasayya, V.R.: An efficient, cost-driven index selection tool for Microsoft SQL server. In: VLDB, vol.\u00a097, pp. 146\u2013155. Citeseer (1997)"},{"key":"15_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":"15_CR9","doi-asserted-by":"crossref","unstructured":"Dageville, B., Das, D., Dias, K., Yagoub, K., Zait, M., Ziauddin, M.: Automatic SQL tuning in oracle 10g. In: Proceedings of the Thirtieth International Conference on Very Large Data Bases, vol. 30, pp. 1098\u20131109 (2004)","DOI":"10.1016\/B978-012088469-8\/50096-6"},{"key":"15_CR10","doi-asserted-by":"crossref","unstructured":"Dash, D., Polyzotis, N., Ailamaki, A.: CoPhy: a scalable, portable, and interactive index advisor for large workloads. arXiv preprint arXiv:1104.3214 (2011)","DOI":"10.14778\/1978665.1978668"},{"key":"15_CR11","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"303","DOI":"10.1007\/978-3-319-64203-1_22","volume-title":"Euro-Par 2017: Parallel Processing","author":"L Dong","year":"2017","unstructured":"Dong, L., Liu, W., Li, R., Zhang, T., Zhao, W.: Replica-aware partitioning design in parallel database systems. In: Rivera, F.F., Pena, T.F., Cabaleiro, J.C. (eds.) Euro-Par 2017. LNCS, vol. 10417, pp. 303\u2013316. Springer, Cham (2017). https:\/\/doi.org\/10.1007\/978-3-319-64203-1_22"},{"key":"15_CR12","unstructured":"Jain, S., Howe, B., Yan, J., Cruanes, T.: Query2vec: an evaluation of NLP techniques for generalized workload analytics. arXiv preprint arXiv:1801.05613 (2018)"},{"key":"15_CR13","doi-asserted-by":"crossref","unstructured":"Jindal, A., Quian\u00e9-Ruiz, J.A., Dittrich, J.: Trojan data layouts: right shoes for a running elephant. In: Proceedings of the 2nd ACM Symposium on Cloud Computing, pp. 1\u201314 (2011)","DOI":"10.1145\/2038916.2038937"},{"issue":"12","key":"15_CR14","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? An experimental evaluation of index selection algorithms. Proc. VLDB Endow. 13(12), 2382\u20132395 (2020)","journal-title":"Proc. VLDB Endow."},{"key":"15_CR15","unstructured":"Kossmann, J., Kastius, A., Schlosser, R.: SWIRL: selection of workload-aware indexes using reinforcement learning. In: EDBT, vol.\u00a02, p. 155-2 (2022)"},{"issue":"12","key":"15_CR16","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":"15_CR17","doi-asserted-by":"crossref","unstructured":"Paul, D., Cao, J., Li, F., Srikumar, V.: Database workload characterization with query plan encoders. arXiv preprint arXiv:2105.12287 (2021)","DOI":"10.14778\/3503585.3503600"},{"key":"15_CR18","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"20","DOI":"10.1007\/978-3-030-59410-7_2","volume-title":"Database Systems for Advanced Applications","author":"J Qiao","year":"2020","unstructured":"Qiao, J., et al.: Heterogeneous replicas for multi-dimensional data management. In: Nah, Y., Cui, B., Lee, S.-W., Yu, J.X., Moon, Y.-S., Whang, S.E. (eds.) DASFAA 2020. LNCS, vol. 12112, pp. 20\u201336. Springer, Cham (2020). https:\/\/doi.org\/10.1007\/978-3-030-59410-7_2"},{"issue":"2","key":"15_CR19","doi-asserted-by":"publisher","first-page":"89","DOI":"10.1007\/s00778-003-0093-1","volume":"12","author":"R Ramamurthy","year":"2003","unstructured":"Ramamurthy, R., DeWitt, D.J., Su, Q.: A case for fractured mirrors. VLDB J. 12(2), 89\u2013101 (2003)","journal-title":"VLDB J."},{"key":"15_CR20","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"139","DOI":"10.1007\/978-3-031-12423-5_11","volume-title":"Database and Expert Systems Applications","author":"Z Sadri","year":"2022","unstructured":"Sadri, Z., Gruenwald, L.: A divergent index advisor using deep reinforcement learning. In: Strauss, C., Cuzzocrea, A., Kotsis, G., Tjoa, A.M., Khalil, I. (eds.) DEXA 2022. LNCS, vol. 13426, pp. 139\u2013152. Springer, Cham (2022). https:\/\/doi.org\/10.1007\/978-3-031-12423-5_11"},{"key":"15_CR21","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. IEEE (2020)","DOI":"10.1109\/ICDEW49219.2020.00035"},{"key":"15_CR22","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. IEEE (2019)","DOI":"10.1109\/ICDE.2019.00113"},{"key":"15_CR23","doi-asserted-by":"crossref","unstructured":"Siddiqui, T., Jo, S., Wu, W., Wang, C., Narasayya, V., Chaudhuri, S.: ISUM: efficiently compressing large and complex workloads for scalable index tuning. In: Proceedings of the 2022 International Conference on Management of Data, pp. 660\u2013673 (2022)","DOI":"10.1145\/3514221.3526152"},{"key":"15_CR24","unstructured":"Sivathanu, M., et al.: $$\\{$$INSTalytics$$\\}$$: cluster filesystem co-design for big-data analytics. In: 17th USENIX Conference on File and Storage Technologies (FAST 2019), pp. 235\u2013248 (2019)"},{"key":"15_CR25","doi-asserted-by":"crossref","unstructured":"Tang, X., Wu, S., Song, M., Ying, S., Li, F., Chen, G.: PreQR: pre-training representation for SQL understanding. In: Proceedings of the 2022 International Conference on Management of Data, pp. 204\u2013216 (2022)","DOI":"10.1145\/3514221.3517878"},{"key":"15_CR26","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":"15_CR27","doi-asserted-by":"crossref","unstructured":"Xu, C., Tang, B., Yiu, M.L.: Diversified caching for replicated web search engines. In: 2015 IEEE 31st International Conference on Data Engineering, pp. 207\u2013218. IEEE (2015)","DOI":"10.1109\/ICDE.2015.7113285"},{"key":"15_CR28","doi-asserted-by":"crossref","unstructured":"Zilio, D.C., et al.: DB2 design advisor: integrated automatic physical database design. In: Proceedings of the Thirtieth International Conference on Very Large Data Bases, vol. 30, pp. 1087\u20131097 (2004)","DOI":"10.1016\/B978-012088469-8\/50095-4"}],"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-68312-1_15","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,11,26]],"date-time":"2024-11-26T20:00:09Z","timestamp":1732651209000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-031-68312-1_15"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024]]},"ISBN":["9783031683114","9783031683121"],"references-count":28,"URL":"https:\/\/doi.org\/10.1007\/978-3-031-68312-1_15","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2024]]},"assertion":[{"value":"17 August 2024","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":"Naples","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Italy","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2024","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"26 August 2024","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"28 August 2024","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"35","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"dexa2024","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/www.dexa.org\/dexa2024\/","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}