{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,8]],"date-time":"2026-04-08T08:54:15Z","timestamp":1775638455654,"version":"3.50.1"},"publisher-location":"New York, NY, USA","reference-count":52,"publisher":"ACM","license":[{"start":{"date-parts":[[2022,6,10]],"date-time":"2022-06-10T00:00:00Z","timestamp":1654819200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"funder":[{"DOI":"10.13039\/501100001809","name":"National Natural Science Foundation of China","doi-asserted-by":"publisher","award":["62132014,61902242,62172272"],"award-info":[{"award-number":["62132014,61902242,62172272"]}],"id":[{"id":"10.13039\/501100001809","id-type":"DOI","asserted-by":"publisher"}]},{"name":"HighTech Support Program from Shanghai Committee of Science and Technology","award":["20ZR1428100"],"award-info":[{"award-number":["20ZR1428100"]}]}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2022,6,10]]},"DOI":"10.1145\/3514221.3526125","type":"proceedings-article","created":{"date-parts":[[2022,6,12]],"date-time":"2022-06-12T02:33:49Z","timestamp":1655001229000},"page":"94-107","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":28,"title":["WeTune: Automatic Discovery and Verification of Query Rewrite Rules"],"prefix":"10.1145","author":[{"given":"Zhaoguo","family":"Wang","sequence":"first","affiliation":[{"name":"Shanghai Jiao Tong University & Ministry of Education of the People's Republic of China, Shanghai, China"}]},{"given":"Zhou","family":"Zhou","sequence":"additional","affiliation":[{"name":"Shanghai Jiao Tong University & Ministry of Education of the People's Republic of China, Shanghai, China"}]},{"given":"Yicun","family":"Yang","sequence":"additional","affiliation":[{"name":"Shanghai Jiao Tong University & Ministry of Education of the People's Republic of China, Shanghai, China"}]},{"given":"Haoran","family":"Ding","sequence":"additional","affiliation":[{"name":"Shanghai Jiao Tong University & Ministry of Education of the People's Republic of China, Shanghai, China"}]},{"given":"Gansen","family":"Hu","sequence":"additional","affiliation":[{"name":"Shanghai Jiao Tong University & Ministry of Education of the People's Republic of China, Shanghai, China"}]},{"given":"Ding","family":"Ding","sequence":"additional","affiliation":[{"name":"New York University, New York City, NY, USA"}]},{"given":"Chuzhe","family":"Tang","sequence":"additional","affiliation":[{"name":"Shanghai Jiao Tong University & Ministry of Education of the People's Republic of China, Shanghai, China"}]},{"given":"Haibo","family":"Chen","sequence":"additional","affiliation":[{"name":"Shanghai Jiao Tong University & Ministry of Education of the People's Republic of China, Shanghai, China"}]},{"given":"Jinyang","family":"Li","sequence":"additional","affiliation":[{"name":"New York University, New York City, NY, USA"}]}],"member":"320","published-online":{"date-parts":[[2022,6,11]]},"reference":[{"key":"e_1_3_2_2_1_1","unstructured":"Douglas Barbosa Alexandre. 2018. Improve the query performance to find unverified projects. https:\/\/gitlab.com\/gitlab-org\/gitlab\/-\/commit\/11e93a9a4c2ac1b5bd4d32a93a949fc8afbcc449?merge_request_iid=5348."},{"key":"e_1_3_2_2_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/1168919.1168906"},{"key":"e_1_3_2_2_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3190662"},{"key":"e_1_3_2_2_4_1","unstructured":"Andreas Brandl. 2018. Replace OR clause with UNION. https:\/\/gitlab.com\/gitlab-org\/gitlab-foss\/-\/merge_requests\/17088#note_59749778"},{"key":"e_1_3_2_2_5_1","unstructured":"Apache Calcite. 2021. Calcite Test Suite. https:\/\/github.com\/georgia-tech-db\/spes\/blob\/main\/testData\/calcite_tests.json."},{"key":"e_1_3_2_2_6_1","doi-asserted-by":"publisher","DOI":"10.14778\/3007263.3007277"},{"key":"e_1_3_2_2_7_1","volume-title":"Forth Edition","author":"Date Hugh Darwen","year":"2019","unstructured":"Hugh Darwen Chris J Date. 1996. A Guide to the SQL Standard, Forth Edition .Addison-Wesley Professional. https:\/\/www.amazon.com\/Guide-SQL-Standard-4th\/dp\/0201964260"},{"key":"e_1_3_2_2_8_1","doi-asserted-by":"publisher","DOI":"10.14778\/3236187.3236200"},{"key":"e_1_3_2_2_9_1","volume-title":"Proceedings of the 8th Biennial Conference on Innovative Data Systems Research","author":"Chu Shumo","year":"2017","unstructured":"Shumo Chu, Chenglong Wang, Konstantin Weitz, and Alvin Cheung. 2017a. Cosette: An Automated Prover for SQL.. In Proceedings of the 8th Biennial Conference on Innovative Data Systems Research (Chaminade, California, USA) (CIDR '17)."},{"key":"e_1_3_2_2_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/3140587.3062348"},{"key":"e_1_3_2_2_11_1","unstructured":"Spree Commerce. 2021. Spree. https:\/\/github.com\/spree\/spree."},{"key":"e_1_3_2_2_12_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-78800-3_24"},{"key":"e_1_3_2_2_13_1","unstructured":"Diaspora. 2021. Diaspora. https:\/\/github.com\/diaspora\/diaspora."},{"key":"e_1_3_2_2_14_1","unstructured":"Visweswara Sai Prashanth Dintyala Arpit Narechania and Joy Arulraj. to appear. SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patterns. ( to appear)."},{"key":"e_1_3_2_2_15_1","unstructured":"GitLab. 2021. GitLab. https:\/\/gitlab.com\/gitlab-org\/gitlab."},{"key":"e_1_3_2_2_16_1","first-page":"19","article-title":"The cascades framework for query optimization","volume":"18","author":"Graefe Goetz","year":"1995","unstructured":"Goetz Graefe. 1995. The cascades framework for query optimization. IEEE Data Eng. Bull., Vol. 18, 3 (1995), 19--29.","journal-title":"IEEE Data Eng. Bull."},{"key":"e_1_3_2_2_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/38713.38734"},{"key":"e_1_3_2_2_18_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.1993.344061"},{"key":"e_1_3_2_2_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/1265530.1265535"},{"key":"e_1_3_2_2_20_1","doi-asserted-by":"publisher","DOI":"10.14778\/3151113.3151116"},{"key":"e_1_3_2_2_21_1","unstructured":"Adam Hegyi. 2020. Suboptimal Query in Gitlab. https:\/\/gitlab.com\/gitlab-org\/gitlab\/-\/merge_requests\/34364."},{"key":"e_1_3_2_2_22_1","volume-title":"Information technology -- Database languages -- SQL -- Part 1: Framework (SQL\/Framework). Standard","author":"IEC","unstructured":"ISO\/IEC 9075--1:2003 2003. Information technology -- Database languages -- SQL -- Part 1: Framework (SQL\/Framework). Standard. International Organization for Standardization, Geneva, CH."},{"key":"e_1_3_2_2_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/3341301.3359630"},{"key":"e_1_3_2_2_24_1","volume-title":"Proceedings of the 9th Biennial Conference on Innovative Data Systems Research","author":"Kipf Andreas","year":"2019","unstructured":"Andreas Kipf, Thomas Kipf, Bernhard Radke, Viktor Leis, Peter Boncz, and Alfons Kemper. 2019. Learned cardinalities: Estimating correlated joins with deep learning. In Proceedings of the 9th Biennial Conference on Innovative Data Systems Research (Asilomar, California, USA) (CIDR '19)."},{"key":"e_1_3_2_2_25_1","unstructured":"Civilized Discourse Construction Kit. 2021. Discourse. https:\/\/github.com\/discourse\/discourse."},{"key":"e_1_3_2_2_26_1","volume-title":"Learning to optimize join queries with deep reinforcement learning. arXiv preprint arXiv:1808.03196","author":"Krishnan Sanjay","year":"2018","unstructured":"Sanjay Krishnan, Zongheng Yang, Ken Goldberg, Joseph Hellerstein, and Ion Stoica. 2018. Learning to optimize join queries with deep reinforcement learning. arXiv preprint arXiv:1808.03196 (2018)."},{"key":"e_1_3_2_2_27_1","volume-title":"Inderpal Singh Mumick, and Yehoshua Sagiv","author":"Levy Alon Y","year":"1994","unstructured":"Alon Y Levy, Inderpal Singh Mumick, and Yehoshua Sagiv. 1994. Query optimization by predicate move-around. In VLDB. 96--107."},{"key":"e_1_3_2_2_28_1","unstructured":"G. Linden. 2006. Marissa Mayer at Web 2.0. http:\/\/glinden.blogspot.com\/2006\/11\/marissa-mayer-at-web-20.html\/."},{"key":"e_1_3_2_2_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/971701.50204"},{"key":"e_1_3_2_2_30_1","volume-title":"Neo: A learned query optimizer. arXiv preprint arXiv:1904.03711","author":"Marcus Ryan","year":"2019","unstructured":"Ryan Marcus, Parimarjan Negi, Hongzi Mao, Chi Zhang, Mohammad Alizadeh, Tim Kraska, Olga Papaemmanouil, and Nesime Tatbul. 2019. Neo: A learned query optimizer. arXiv preprint arXiv:1904.03711 (2019)."},{"key":"e_1_3_2_2_31_1","doi-asserted-by":"publisher","DOI":"10.1145\/3211954.3211957"},{"key":"e_1_3_2_2_32_1","volume-title":"Proceedings of the 9th Biennial Conference on Innovative Data Systems Research","author":"Marcus Ryan","year":"2019","unstructured":"Ryan Marcus and Olga Papaemmanouil. 2019. Towards a Hands-Free Query Optimizer through Deep Learning. In Proceedings of the 9th Biennial Conference on Innovative Data Systems Research (Asilomar, California, USA) (CIDR '19)."},{"key":"e_1_3_2_2_33_1","doi-asserted-by":"publisher","DOI":"10.1145\/36206.36194"},{"key":"e_1_3_2_2_34_1","doi-asserted-by":"publisher","DOI":"10.1145\/36177.36194"},{"key":"e_1_3_2_2_35_1","unstructured":"Sean McGivern. 2017. Speed up counting approvers when some are specified. https:\/\/gitlab.com\/gitlab-org\/gitlab\/-\/merge_requests\/2196."},{"key":"e_1_3_2_2_36_1","doi-asserted-by":"publisher","DOI":"10.1145\/93605.98734"},{"key":"e_1_3_2_2_37_1","doi-asserted-by":"publisher","DOI":"10.5555\/645918.756653"},{"key":"e_1_3_2_2_38_1","volume-title":"Brett Saiki, Adam Anderson, Adriana Schulz, Dan Grossman, and Zachary Tatlock.","author":"Nandi Chandrakana","year":"2021","unstructured":"Chandrakana Nandi, Max Willsey, Amy Zhu, Yisu Remy Wang, Brett Saiki, Adam Anderson, Adriana Schulz, Dan Grossman, and Zachary Tatlock. 2021. Rewrite Rule Inference Using Equality Saturation. CoRR, Vol. abs\/2108.10436 (2021). showeprint[arXiv]2108.10436 https:\/\/arxiv.org\/abs\/2108.10436"},{"key":"e_1_3_2_2_39_1","unstructured":"Nebulab. 2021. Solidus. https:\/\/github.com\/solidusio\/solidus."},{"key":"e_1_3_2_2_40_1","unstructured":"OpenProject. 2021. OpenProject. https:\/\/github.com\/opf\/openproject."},{"key":"e_1_3_2_2_41_1","unstructured":"Neil Patel. 2018. How Loading Time Affects Your Bottom Line. https:\/\/neilpatel.com\/blog\/speed-is-a-killer\/."},{"key":"e_1_3_2_2_42_1","doi-asserted-by":"publisher","DOI":"10.1145\/130283.130294"},{"key":"e_1_3_2_2_43_1","unstructured":"Redmine. 2021. Redmine. https:\/\/github.com\/redmine\/redmine."},{"key":"e_1_3_2_2_44_1","doi-asserted-by":"publisher","DOI":"10.1145\/233269.233360"},{"key":"e_1_3_2_2_45_1","doi-asserted-by":"publisher","DOI":"10.1145\/233269.233360"},{"key":"e_1_3_2_2_46_1","unstructured":"Joshua Stein. 2021. Lobster. https:\/\/github.com\/lobsters\/lobsters."},{"key":"e_1_3_2_2_47_1","doi-asserted-by":"publisher","DOI":"10.5555\/645927.672349"},{"key":"e_1_3_2_2_48_1","volume-title":"PERF: Avoid `NOT which can get really slow. https:\/\/github.com\/discourse\/discourse\/commit\/28148197d6467cdc7469409f961c00d4e32f4c41.","author":"Tan Guoxiang","year":"2017","unstructured":"Guoxiang Tan. 2017. PERF: Avoid `NOT which can get really slow. https:\/\/github.com\/discourse\/discourse\/commit\/28148197d6467cdc7469409f961c00d4e32f4c41."},{"key":"e_1_3_2_2_49_1","doi-asserted-by":"crossref","unstructured":"Zhaoguo Wang Zhou Zhou et al. 2022. WeTune: Automatic Discovery and Verification of Query Rewrite Rules (The Extended Version). https:\/\/ipads.se.sjtu.edu.cn\/_media\/publications\/wtune_extend.pdf.","DOI":"10.1145\/3514221.3526125"},{"key":"e_1_3_2_2_50_1","volume-title":"SPES: A Two-Stage Query Equivalence Verifier. arXiv preprint arXiv:2004.00481","author":"Zhou Qi","year":"2020","unstructured":"Qi Zhou, Joy Arulraj, Shamkant Navathe, William Harris, and Jinpeng Wu. 2020. SPES: A Two-Stage Query Equivalence Verifier. arXiv preprint arXiv:2004.00481 (2020)."},{"key":"e_1_3_2_2_51_1","doi-asserted-by":"publisher","DOI":"10.14778\/3342263.3342267"},{"key":"e_1_3_2_2_52_1","doi-asserted-by":"publisher","DOI":"10.14778\/3485450.3485456"}],"event":{"name":"SIGMOD\/PODS '22: International Conference on Management of Data","location":"Philadelphia PA USA","acronym":"SIGMOD\/PODS '22","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"]},"container-title":["Proceedings of the 2022 International Conference on Management of Data"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3514221.3526125","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3514221.3526125","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T18:10:07Z","timestamp":1750183807000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3514221.3526125"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,6,10]]},"references-count":52,"alternative-id":["10.1145\/3514221.3526125","10.1145\/3514221"],"URL":"https:\/\/doi.org\/10.1145\/3514221.3526125","relation":{},"subject":[],"published":{"date-parts":[[2022,6,10]]},"assertion":[{"value":"2022-06-11","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}