{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,3]],"date-time":"2026-03-03T16:13:13Z","timestamp":1772554393070,"version":"3.50.1"},"reference-count":32,"publisher":"Springer Science and Business Media LLC","issue":"5","license":[{"start":{"date-parts":[[2023,6,12]],"date-time":"2023-06-12T00:00:00Z","timestamp":1686528000000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2023,6,12]],"date-time":"2023-06-12T00:00:00Z","timestamp":1686528000000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"}],"funder":[{"name":"China National Science Foundation","award":["62072230"],"award-info":[{"award-number":["62072230"]}]},{"DOI":"10.13039\/501100011246","name":"State Key Laboratory of Novel Software Technology","doi-asserted-by":"publisher","award":["KFKT2021B33"],"award-info":[{"award-number":["KFKT2021B33"]}],"id":[{"id":"10.13039\/501100011246","id-type":"DOI","asserted-by":"publisher"}]},{"name":"Jiangsu Province Science and Technology Key Program","award":["BE2021729"],"award-info":[{"award-number":["BE2021729"]}]},{"DOI":"10.13039\/501100012248","name":"Collaborative Innovation Center for Modern Science and Technology and Industrial Development of Jiangxi Traditional Medicine","doi-asserted-by":"publisher","award":["Grant number"],"award-info":[{"award-number":["Grant number"]}],"id":[{"id":"10.13039\/501100012248","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["World Wide Web"],"published-print":{"date-parts":[[2023,9]]},"DOI":"10.1007\/s11280-023-01156-0","type":"journal-article","created":{"date-parts":[[2023,6,12]],"date-time":"2023-06-12T03:10:48Z","timestamp":1686539448000},"page":"3093-3118","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":2,"title":["Coral: federated query join order optimization based on deep reinforcement learning"],"prefix":"10.1007","volume":"26","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-1565-9997","authenticated-orcid":false,"given":"Rong","family":"Gu","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Yi","family":"Zhang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Liangliang","family":"Yin","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Lingyi","family":"Song","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Wenjie","family":"Huang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Chunfeng","family":"Yuan","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zhaokang","family":"Wang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Guanghui","family":"Zhu","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Yihua","family":"Huang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2023,6,12]]},"reference":[{"key":"1156_CR1","unstructured":"Clickhouse. https:\/\/clickhouse.tech (2021). Accessed 20 Sep 2021"},{"key":"1156_CR2","unstructured":"Elasticsearch. https:\/\/www.elastic.co (2021). Accessed 20 Sep 2021"},{"key":"1156_CR3","unstructured":"Shamgunov, N.: The MemsQL in-memory database system. In: Proceedings of the 2nd International Workshop on In Memory Data Management and Analytics (IMDM \u201914), p. 106 (2014)"},{"key":"1156_CR4","unstructured":"Flink. https:\/\/flink.apache.org (2021). Accessed 21 Sep 2021"},{"key":"1156_CR5","unstructured":"The dzone guide to data persistence. https:\/\/dzone.com\/guides\/data-persistence-2 (2021). Accessed 21 Sep 2021"},{"key":"1156_CR6","doi-asserted-by":"crossref","unstructured":"Xu, L., Cole, R.L., Ting, D.: Learning to optimize federated queries. In: Proceedings of the 2nd ACM International Workshop on Exploiting Artificial Intelligence Techniques for Data Management (aiMD\u201919), pp. 1\u20137 (2019)","DOI":"10.1145\/3329859.3329873"},{"key":"1156_CR7","doi-asserted-by":"crossref","unstructured":"Giannakouris, V., Papailiou, N., Tsoumakos, D., Koziris, N.: MuSQLE: Distributed SQL query execution over multiple engine environments. In: Proceedings of the 4th IEEE International Conference on Big Data (BigData \u201916), pp. 452\u2013461 (2016)","DOI":"10.1109\/BigData.2016.7840636"},{"issue":"2","key":"1156_CR8","doi-asserted-by":"publisher","first-page":"11","DOI":"10.1145\/2814710.2814713","volume":"44","author":"J Duggan","year":"2015","unstructured":"Duggan, J., Elmore, A.J., Stonebraker, M., Balazinska, M., Howe, B., Kepner, J., Madden, S., Maier, D., Mattson, T., Zdonik, S.B.: The BigDAWG polystore system. ACM SIGMOD Record 44(2), 11\u201316 (2015)","journal-title":"ACM SIGMOD Record"},{"key":"1156_CR9","doi-asserted-by":"crossref","unstructured":"LeFevre, J., Sankaranarayanan, J., Hacig\u00fcm\u00fcs, H., Tatemura, J., Polyzotis, N., Carey, M.J.: MISO: souping up big data query processing with a multistore system. In: Proceedings of the 33rd ACM International Conference on Management of Data (SIGMOD \u201914), pp. 1591\u20131602 (2014)","DOI":"10.1145\/2588555.2588568"},{"key":"1156_CR10","doi-asserted-by":"crossref","unstructured":"Vogt, M., Stiemer, A., Schuldt, H.: ICARUS: Towards a multistore database system. In: Proceedings of the 5th IEEE International Conference on Big Data (BigData \u201917), pp. 2490\u20132499 (2017)","DOI":"10.1109\/BigData.2017.8258207"},{"key":"1156_CR11","unstructured":"Ying. Research and implementation on cross-platform unified big data SQL query system. Master\u2019s thesis, Nanjing University (2019)"},{"key":"1156_CR12","doi-asserted-by":"crossref","unstructured":"Begoli, E., Camacho-Rodr\u00edguez, J., Hyde, J., Mior, M.J., Lemire, D.: Apache calcite: A foundational framework for optimized query processing over heterogeneous data sources. In: Proceedings of the 37th ACM International Conference on Management of Data (SIGMOD \u201918), pp. 221\u2013230 (2018)","DOI":"10.1145\/3183713.3190662"},{"key":"1156_CR13","unstructured":"Postgresql. https:\/\/www.postgresql.org (2021). Accessed 3 Oct 2021"},{"key":"1156_CR14","unstructured":"Apache spark. http:\/\/spark.apache.org (2021). Accessed 3 Oct 2021"},{"key":"1156_CR15","unstructured":"Prestodb. https:\/\/prestodb.github.io\/ (2021). Accessed 3 Oct 2021"},{"key":"1156_CR16","unstructured":"Kostas, T., Sellis, T., Jensen, C.S.: A reinforcement learning approach for adaptive query processing. Technical Report (2008)"},{"key":"1156_CR17","doi-asserted-by":"crossref","unstructured":"Marcus, R., Papaemmanouil, O.: Deep reinforcement learning for join order enumeration. In: Proceedings of the 1st ACM International Workshop on Exploiting Artificial Intelligence Techniques for Data Management (aiMD \u201918), pp. 3:1\u20133:4 (2018)","DOI":"10.1145\/3211954.3211957"},{"key":"1156_CR18","unstructured":"Krishnan, S., Yang, Z., Goldberg, K., Hellerstein, J.M., Stoica, I.: Learning to optimize join queries with deep reinforcement learning. arXiv:1808.03196 (2018)"},{"key":"1156_CR19","doi-asserted-by":"publisher","first-page":"316","DOI":"10.1016\/j.asoc.2018.08.037","volume":"73","author":"H Shi","year":"2018","unstructured":"Shi, H., Liu, S., Wu, H., Li, R., Liu, S., Kwok, N., Peng, Y.: Oscillatory particle swarm optimizer. Appl. Soft Comput. 73, 316\u2013327 (2018)","journal-title":"Appl. Soft Comput."},{"issue":"1","key":"1156_CR20","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1186\/s13638-018-1254-7","volume":"2018","author":"C Ying","year":"2018","unstructured":"Ying, C., Ying, C., Ban, C.: A performance optimization strategy based on degree of parallelism and allocation fitness. EURASIP J. Wirel. Commun. Netw. 2018(1), 1\u20138 (2018)","journal-title":"EURASIP J. Wirel. Commun. Netw."},{"issue":"6","key":"1156_CR21","doi-asserted-by":"publisher","first-page":"3055","DOI":"10.1007\/s11280-020-00820-z","volume":"23","author":"W Yan","year":"2020","unstructured":"Yan, W., Li, G., Wu, Z., Wang, S., Yu, P.S.: Extracting diverse-shapelets for early classification on time series. World Wide Web 23(6), 3055\u20133081 (2020)","journal-title":"World Wide Web"},{"issue":"1","key":"1156_CR22","doi-asserted-by":"publisher","first-page":"69","DOI":"10.1007\/s11042-010-0528-9","volume":"54","author":"Z Wu","year":"2011","unstructured":"Wu, Z., Cao, Z., Wang, Y.: Multimedia selection operation placement. Multimed. Tools Appl. 54(1), 69\u201396 (2011)","journal-title":"Multimed. Tools Appl."},{"key":"1156_CR23","doi-asserted-by":"publisher","first-page":"106952","DOI":"10.1016\/j.knosys.2021.106952","volume":"220","author":"Z Wu","year":"2021","unstructured":"Wu, Z., Shen, S., Zhou, H., Li, H., Lu, Z., Zou, D.: An effective approach for the protection of user commodity viewing privacy in e-commerce website. Knowl.-Based Syst. 220, 106952 (2021)","journal-title":"Knowl.-Based Syst."},{"issue":"1","key":"1156_CR24","doi-asserted-by":"publisher","first-page":"25","DOI":"10.1007\/s11280-020-00830-x","volume":"24","author":"Z Wu","year":"2021","unstructured":"Wu, Z., Li, G., Shen, S., Lian, X., Chen, E., Xu, G.: Constructing dummy query sequences to protect location privacy and query privacy in location-based services. World Wide Web 24(1), 25\u201349 (2021)","journal-title":"World Wide Web"},{"key":"1156_CR25","doi-asserted-by":"publisher","first-page":"105679","DOI":"10.1016\/j.knosys.2020.105679","volume":"195","author":"Z Wu","year":"2020","unstructured":"Wu, Z., Shen, S., Lian, X., Su, X., Chen, E.: A dummy-based user privacy protection approach for text information retrieval. Knowl.-Based Syst. 195, 105679 (2020)","journal-title":"Knowl.-Based Syst."},{"key":"1156_CR26","doi-asserted-by":"crossref","unstructured":"Yu, X., Li, G., Chai, C., Tang, N.: Reinforcement learning with tree-LSTM for join order selection. In: Proceedings of the 36th IEEE International Conference on Data Engineering (ICDE \u201920), pp. 1297\u20131308 (2020)","DOI":"10.1109\/ICDE48307.2020.00116"},{"issue":"7540","key":"1156_CR27","doi-asserted-by":"publisher","first-page":"529","DOI":"10.1038\/nature14236","volume":"518","author":"V Mnih","year":"2015","unstructured":"Mnih, V., Kavukcuoglu, K., Silver, D., Rusu, A.A., Veness, J., Bellemare, M.G., Graves, A., Riedmiller, M.A., Fidjeland, A., Ostrovski, G., Petersen, S., Beattie, C., Sadik, A., Antonoglou, I., King, H., Kumaran, D., Wierstra, D., Legg, S., Hassabis, D.: Human-level control through deep reinforcement learning. Nature 518(7540), 529\u2013533 (2015)","journal-title":"Nature"},{"key":"1156_CR28","unstructured":"Graefe, G.: Rule-Based Query Optimization in Extensible Database Systems. PhD thesis, University of Wisconsin-Madison (1987)"},{"issue":"3","key":"1156_CR29","first-page":"19","volume":"18","author":"G Goetz","year":"1995","unstructured":"Goetz, G.: The cascades framework for query optimization. IEEE Database Eng. Bull. 18(3), 19\u201329 (1995)","journal-title":"IEEE Database Eng. Bull."},{"key":"1156_CR30","doi-asserted-by":"crossref","unstructured":"Goldstein, J., Larson, P.\u00c5.: Optimizing queries using materialized views: A practical, scalable solution. In: Proceedings of the 20th ACM International Conference on Management of Data (SIGMOD \u201901), pp. 331\u2013342 (2001)","DOI":"10.1145\/376284.375706"},{"key":"1156_CR31","unstructured":"Tpc-h \u2013 homepage. http:\/\/www.tpc.org\/tpch\/ (2021). Accessed 5 Oct 2021"},{"issue":"3\/4","key":"1156_CR32","doi-asserted-by":"publisher","first-page":"591","DOI":"10.2307\/2333709","volume":"52","author":"SS Shapiro","year":"1965","unstructured":"Shapiro, S.S., Wilk, M.B.: An analysis of variance test for normality (complete samples). Biometrika 52(3\/4), 591\u2013611 (1965)","journal-title":"Biometrika"}],"container-title":["World Wide Web"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s11280-023-01156-0.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s11280-023-01156-0\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s11280-023-01156-0.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,10,11]],"date-time":"2023-10-11T04:22:44Z","timestamp":1696998164000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s11280-023-01156-0"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,6,12]]},"references-count":32,"journal-issue":{"issue":"5","published-print":{"date-parts":[[2023,9]]}},"alternative-id":["1156"],"URL":"https:\/\/doi.org\/10.1007\/s11280-023-01156-0","relation":{},"ISSN":["1386-145X","1573-1413"],"issn-type":[{"value":"1386-145X","type":"print"},{"value":"1573-1413","type":"electronic"}],"subject":[],"published":{"date-parts":[[2023,6,12]]},"assertion":[{"value":"12 October 2021","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"16 November 2022","order":2,"name":"revised","label":"Revised","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"21 February 2023","order":3,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"12 June 2023","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 no relevant financial or non-financial interests to disclose.","order":2,"name":"Ethics","group":{"name":"EthicsHeading","label":"Conflicts of interest"}}]}}