{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,31]],"date-time":"2025-03-31T04:16:36Z","timestamp":1743394596759,"version":"3.40.3"},"reference-count":36,"publisher":"Springer Science and Business Media LLC","issue":"2","license":[{"start":{"date-parts":[[2024,11,26]],"date-time":"2024-11-26T00:00:00Z","timestamp":1732579200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2024,11,26]],"date-time":"2024-11-26T00:00:00Z","timestamp":1732579200000},"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":["Cluster Comput"],"published-print":{"date-parts":[[2025,4]]},"DOI":"10.1007\/s10586-024-04853-1","type":"journal-article","created":{"date-parts":[[2024,11,26]],"date-time":"2024-11-26T19:09:32Z","timestamp":1732648172000},"update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Investigating the effects of SQL hints on diverse storage devices through empirical analysis"],"prefix":"10.1007","volume":"28","author":[{"given":"Changjong","family":"Kim","sequence":"first","affiliation":[]},{"given":"Yongseok","family":"Son","sequence":"additional","affiliation":[]},{"given":"Sunggon","family":"Kim","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2024,11,26]]},"reference":[{"unstructured":"Oracle Database. Oracle. https:\/\/www.oracle.com\/","key":"4853_CR1"},{"unstructured":"Mysql. Mysql. https:\/\/www.mysql.com\/","key":"4853_CR2"},{"unstructured":"PostgreSQL. PostgreSQL. https:\/\/www.postgresql.org\/","key":"4853_CR3"},{"unstructured":"MongoDB. MongoDB. https:\/\/www.mongodb.com\/","key":"4853_CR4"},{"issue":"3","key":"4853_CR5","doi-asserted-by":"crossref","first-page":"307","DOI":"10.14778\/3368289.3368296","volume":"13","author":"J Sun","year":"2019","unstructured":"Sun, J., Li, G.: An end-to-end learning-based cost estimator. Proc. VLDB Endow. 13(3), 307\u2013319 (2019)","journal-title":"Proc. VLDB Endow."},{"unstructured":"Xu, X., Zhao, Z., Zhang, T., Kang, R., Sun, L., Chen, J.: Coool: A learning-to-rank approach for sql hint recommendations. arXiv preprint arXiv:2304.04407 (2023)","key":"4853_CR6"},{"doi-asserted-by":"crossref","unstructured":"Do, J., Zhang, D., Patel, J.M., DeWitt, D.J., Naughton, J.F., Halverson, A.: Turbocharging dbms buffer pool using ssds. In: Proceedings of the 2011 ACM SIGMOD International Conference on Management of Data, pp. 1113\u20131124 (2011)","key":"4853_CR7","DOI":"10.1145\/1989323.1989442"},{"key":"4853_CR8","doi-asserted-by":"crossref","first-page":"229","DOI":"10.1007\/s007780050026","volume":"5","author":"G Antoshenkov","year":"1996","unstructured":"Antoshenkov, G., Ziauddin, M.: Query processing and optimization in oracle rdb. VLDB J. 5, 229\u2013237 (1996)","journal-title":"VLDB J."},{"issue":"2","key":"4853_CR9","doi-asserted-by":"crossref","first-page":"1346","DOI":"10.14778\/1454159.1454175","volume":"1","author":"M Ziauddin","year":"2008","unstructured":"Ziauddin, M., Das, D., Su, H., Zhu, Y., Yagoub, K.: Optimizer plan change management: improved stability and performance in oracle 11g. Proc. VLDB Endow. 1(2), 1346\u20131355 (2008)","journal-title":"Proc. VLDB Endow."},{"issue":"12","key":"4853_CR10","doi-asserted-by":"crossref","first-page":"1813","DOI":"10.14778\/3137765.3137785","volume":"10","author":"S Chakkappen","year":"2017","unstructured":"Chakkappen, S., Budalakoti, S., Krishnamachari, R., Valluri, S.R., Wood, A., Zait, M.: Adaptive statistics in oracle 12c. Proc. VLDB Endow. 10(12), 1813\u20131824 (2017)","journal-title":"Proc. VLDB Endow."},{"issue":"2","key":"4853_CR11","doi-asserted-by":"crossref","first-page":"1366","DOI":"10.14778\/1687553.1687563","volume":"2","author":"S Bellamkonda","year":"2009","unstructured":"Bellamkonda, S., Ahmed, R., Witkowski, A., Amor, A., Zait, M., Lin, C.-C.: Enhanced subquery optimizations in oracle. Proc. VLDB Endow. 2(2), 1366\u20131377 (2009)","journal-title":"Proc. VLDB Endow."},{"doi-asserted-by":"crossref","unstructured":"Kwanglat, P., Natwichai, J.: Query transformation for exact cardinality computing. In: 2011 3rd International Conference on Computer Research and Development, vol. 4, pp. 514\u2013518 (2011). IEEE","key":"4853_CR12","DOI":"10.1109\/ICCRD.2011.5763896"},{"unstructured":"Ahmed, R., Lee, A., Witkowski, A., Das, D., Su, H., Zait, M., Cruanes, T.: Cost-based query transformation in oracle. In: VLDB, vol. 6, pp. 1026\u20131036 (2006)","key":"4853_CR13"},{"issue":"3","key":"4853_CR14","doi-asserted-by":"crossref","first-page":"204","DOI":"10.14778\/2850583.2850594","volume":"9","author":"V Leis","year":"2015","unstructured":"Leis, V., Gubichev, A., Mirchev, A., Boncz, P., Kemper, A., Neumann, T.: How good are query optimizers, really? Proc. VLDB Endow. 9(3), 204\u2013215 (2015)","journal-title":"Proc. VLDB Endow."},{"issue":"12","key":"4853_CR15","doi-asserted-by":"crossref","first-page":"2493","DOI":"10.1016\/j.ins.2006.12.015","volume":"177","author":"D Taniar","year":"2007","unstructured":"Taniar, D., Khaw, H.Y., Tjioe, H.C., Pardede, E.: The use of hints in sql-nested query optimization. Inform.\u00a0Sci. 177(12), 2493\u20132521 (2007)","journal-title":"Inform.\u00a0Sci."},{"doi-asserted-by":"crossref","unstructured":"Pasupuleti, K.K., Das, D., Valluri, S.R., Zait, M.: Observability of sql hints in oracle. In: Proceedings of the 31st ACM International Conference on Information & Knowledge Management, pp. 3441\u20133450 (2022)","key":"4853_CR16","DOI":"10.1145\/3511808.3557124"},{"unstructured":"[Whitepaper] Seagate Baracuda 2TB. Seagate. https:\/\/www.seagate.com\/www-content\/datasheets\/pdfs\/3-5-barracudaDS1900-11-1806GB-en_GB.pdf","key":"4853_CR17"},{"unstructured":"[Whitepaper] Samsung 870 Evo. Samsung. https:\/\/semiconductor.samsung.com\/consumer-storage\/internal-ssd\/870evo\/","key":"4853_CR18"},{"unstructured":"[Whitepaper] Micron Crucial MX500 250GB. Micron. https:\/\/www.crucial.com\/ssd\/mx500\/ct250mx500ssd1","key":"4853_CR19"},{"unstructured":"[Whitepaper] KIOXIA EXCERIA 480GB. KIOXIA. https:\/\/apac.kioxia.com\/en-apac\/personal\/ssd\/exceria-sata-ssd.html","key":"4853_CR20"},{"unstructured":"[Whitepaper] Samsung PM1733. Samsung Electronics. https:\/\/semiconductor.samsung.com\/ssd\/enterprise-ssd\/pm1733-pm1735\/","key":"4853_CR21"},{"unstructured":"Sivaraman, K.: Parallel Query Processing (2011)","key":"4853_CR22"},{"doi-asserted-by":"crossref","unstructured":"Cruanes, T., Dageville, B., Ghosh, B.: Parallel sql execution in oracle 10g. In: Proceedings of the 2004 ACM SIGMOD International Conference on Management of Data, pp. 850\u2013854 (2004)","key":"4853_CR23","DOI":"10.1145\/1007568.1007666"},{"issue":"11","key":"4853_CR24","doi-asserted-by":"crossref","first-page":"1102","DOI":"10.14778\/2536222.2536235","volume":"6","author":"S Bellamkonda","year":"2013","unstructured":"Bellamkonda, S., Li, H.-G., Jagtap, U., Zhu, Y., Liang, V., Cruanes, T.: Adaptive and big data scale parallel execution in oracle. Proc. VLDB Endow. 6(11), 1102\u20131113 (2013)","journal-title":"Proc. VLDB Endow."},{"issue":"6","key":"4853_CR25","doi-asserted-by":"crossref","first-page":"1141","DOI":"10.1109\/TC.2012.60","volume":"62","author":"Y Hu","year":"2012","unstructured":"Hu, Y., Jiang, H., Feng, D., Tian, L., Luo, H., Ren, C.: Exploring and exploiting the multilevel parallelism inside ssds for improved performance and endurance. IEEE Trans. Comput. 62(6), 1141\u20131155 (2012)","journal-title":"IEEE Trans. Comput."},{"issue":"1","key":"4853_CR26","doi-asserted-by":"crossref","first-page":"168","DOI":"10.1109\/TCAD.2017.2693281","volume":"37","author":"C Gao","year":"2017","unstructured":"Gao, C., Shi, L., Ji, C., Di, Y., Wu, K., Xue, C.J., Sha, E.H.-M.: Exploiting parallelism for access conflict minimization in flash-based solid state drives. IEEE Trans. Comput. Aided Des. Integrated Circuits Syst. 37(1), 168\u2013181 (2017)","journal-title":"IEEE Trans. Comput. Aided Des. Integrated Circuits Syst."},{"issue":"9","key":"4853_CR27","doi-asserted-by":"crossref","first-page":"2185","DOI":"10.1109\/TPDS.2020.2987894","volume":"31","author":"C Gao","year":"2020","unstructured":"Gao, C., Shi, L., Liu, K., Xue, C.J., Yang, J., Zhang, Y.: Boosting the performance of ssds via fully exploiting the plane level parallelism. IEEE Trans. Parallel Distrib. Syst. 31(9), 2185\u20132200 (2020)","journal-title":"IEEE Trans. Parallel Distrib. Syst."},{"issue":"9","key":"4853_CR28","doi-asserted-by":"crossref","first-page":"1640","DOI":"10.14778\/3461535.3461552","volume":"14","author":"X Wang","year":"2021","unstructured":"Wang, X., Qu, C., Wu, W., Wang, J., Zhou, Q.: Are we ready for learned cardinality estimation? Proc. VLDB Endow. 14(9), 1640\u20131654 (2021)","journal-title":"Proc. VLDB Endow."},{"doi-asserted-by":"crossref","unstructured":"Siddiqui, T., Jindal, A., Qiao, S., Patel, H., Le, W.: Cost models for big data query processing: Learning, retrofitting, and our findings. In: Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data, pp. 99\u2013113 (2020)","key":"4853_CR29","DOI":"10.1145\/3318464.3380584"},{"doi-asserted-by":"crossref","unstructured":"Marcus, R., Negi, P., Mao, H., Tatbul, N., Alizadeh, M., Kraska, T.: Bao: Making learned query optimization practical. In: Proceedings of the 2021 International Conference on Management of Data, pp. 1275\u20131288 (2021)","key":"4853_CR30","DOI":"10.1145\/3448016.3452838"},{"doi-asserted-by":"crossref","unstructured":"Chen, Z., Gehrke, J., Korn, F.: Query optimization in compressed database systems. In: Proceedings of the 2001 ACM SIGMOD International Conference on Management of Data, pp. 271\u2013282 (2001)","key":"4853_CR31","DOI":"10.1145\/375663.375692"},{"doi-asserted-by":"publisher","unstructured":"Mitrovski, J., Djinevski, L., Gusev, M., Arsenovski, S.: Tpc-h benchmark q3, q6 and q12 sequential, openmp parallel and cuda parallel implementation. In: 2021 44th International Convention on Information, Communication and Electronic Technology (MIPRO), pp. 938\u2013943 (2021). https:\/\/doi.org\/10.23919\/MIPRO52101.2021.9597197","key":"4853_CR32","DOI":"10.23919\/MIPRO52101.2021.9597197"},{"issue":"12","key":"4853_CR33","doi-asserted-by":"publisher","first-page":"4057","DOI":"10.1109\/TPDS.2022.3177811","volume":"33","author":"J Liu","year":"2022","unstructured":"Liu, J., Zhang, F., Li, H., Wang, D., Wan, W., Fang, X., Zhai, J., Du, X.: Exploring query processing on cpu-gpu integrated edge device. IEEE Trans. Parallel Distrib. Syst. 33(12), 4057\u20134070 (2022). https:\/\/doi.org\/10.1109\/TPDS.2022.3177811","journal-title":"IEEE Trans. Parallel Distrib. Syst."},{"doi-asserted-by":"crossref","unstructured":"Lee, S.-W., Moon, B.: Design of flash-based dbms: an in-page logging approach. In: Proceedings of the 2007 ACM SIGMOD International Conference on Management of Data, pp. 55\u201366 (2007)","key":"4853_CR34","DOI":"10.1145\/1247480.1247488"},{"issue":"2","key":"4853_CR35","doi-asserted-by":"crossref","first-page":"1318","DOI":"10.14778\/1687553.1687557","volume":"2","author":"M Canim","year":"2009","unstructured":"Canim, M., Mihaila, G.A., Bhattacharjee, B., Ross, K.A., Lang, C.A.: An object placement advisor for db2 using solid state storage. Proc. VLDB Endow. 2(2), 1318\u20131329 (2009)","journal-title":"Proc. VLDB Endow."},{"issue":"7","key":"4853_CR36","doi-asserted-by":"crossref","first-page":"1712","DOI":"10.14778\/3587136.3587145","volume":"16","author":"H He","year":"2023","unstructured":"He, H., Xu, E., Li, S., Jia, Z., Zheng, S., Yu, Y., Ma, J., Liao, X.: When database meets new storage devices: understanding and exposing performance mismatches via configurations. Proc. VLDB Endow. 16(7), 1712\u20131725 (2023)","journal-title":"Proc. VLDB Endow."}],"container-title":["Cluster Computing"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10586-024-04853-1.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s10586-024-04853-1\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10586-024-04853-1.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,3,30]],"date-time":"2025-03-30T16:35:33Z","timestamp":1743352533000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s10586-024-04853-1"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,11,26]]},"references-count":36,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2025,4]]}},"alternative-id":["4853"],"URL":"https:\/\/doi.org\/10.1007\/s10586-024-04853-1","relation":{},"ISSN":["1386-7857","1573-7543"],"issn-type":[{"type":"print","value":"1386-7857"},{"type":"electronic","value":"1573-7543"}],"subject":[],"published":{"date-parts":[[2024,11,26]]},"assertion":[{"value":"30 June 2024","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"14 October 2024","order":2,"name":"revised","label":"Revised","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"22 October 2024","order":3,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"26 November 2024","order":4,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}},{"order":1,"name":"Ethics","group":{"name":"EthicsHeading","label":"Declarations"}},{"value":"The authors have not disclosed any competing interests.","order":2,"name":"Ethics","group":{"name":"EthicsHeading","label":"Competing interests"}}],"article-number":"107"}}