{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,5]],"date-time":"2026-02-05T05:30:05Z","timestamp":1770269405874,"version":"3.49.0"},"publisher-location":"Cham","reference-count":16,"publisher":"Springer Nature Switzerland","isbn-type":[{"value":"9783031478420","type":"print"},{"value":"9783031478437","type":"electronic"}],"license":[{"start":{"date-parts":[[2023,11,7]],"date-time":"2023-11-07T00:00:00Z","timestamp":1699315200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2023,11,7]],"date-time":"2023-11-07T00:00:00Z","timestamp":1699315200000},"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-47843-7_15","type":"book-chapter","created":{"date-parts":[[2023,11,6]],"date-time":"2023-11-06T21:27:25Z","timestamp":1699306045000},"page":"213-226","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":1,"title":["Why Query Plans Are Different: An Automatic Detection and Inference System"],"prefix":"10.1007","author":[{"ORCID":"https:\/\/orcid.org\/0009-0007-4433-9232","authenticated-orcid":false,"given":"Hai","family":"Lan","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Yuanjia","family":"Zhang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Yu","family":"Dong","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Dongxu","family":"Huang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Liu","family":"Tang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jian","family":"Zhang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2023,11,7]]},"reference":[{"key":"15_CR1","unstructured":"Additional material. https:\/\/github.com\/hailanwhu\/AutoDI\/"},{"key":"15_CR2","unstructured":"Horoscope. https:\/\/github.com\/PingCAP-QE\/horoscope"},{"key":"15_CR3","unstructured":"MySQL. https:\/\/dev.mysql.com\/"},{"key":"15_CR4","unstructured":"PostgreSQL. https:\/\/www.postgresql.org\/"},{"key":"15_CR5","unstructured":"SQL plan management. https:\/\/www.oracle.com\/technetwork\/database\/bi-datawarehousing\/twp-sql-plan-mgmt-19c-5324207.pdf"},{"key":"15_CR6","unstructured":"SQL server compare showplan. https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/compare-execution-plans?view=sql-server-ver15"},{"key":"15_CR7","unstructured":"SQL tuning advisor. https:\/\/docs.oracle.com\/database\/121\/TGSQL\/tgsql_sqltune.htm"},{"key":"15_CR8","unstructured":"SQL tuning advisor. https:\/\/docs.microsoft.com\/en-us\/sql\/tools\/dta\/tutorial-database-engine-tuning-advisor?view=sql-server-ver15"},{"key":"15_CR9","unstructured":"TPC-H. http:\/\/www.tpc.org\/tpch\/"},{"key":"15_CR10","doi-asserted-by":"crossref","unstructured":"Gu, Z., Soliman, M.A., Waas, F.M.: Testing the accuracy of query optimizers. In: DBTest, p. 11 (2012)","DOI":"10.1145\/2304510.2304525"},{"issue":"12","key":"15_CR11","doi-asserted-by":"publisher","first-page":"3072","DOI":"10.14778\/3415478.3415535","volume":"13","author":"D Huang","year":"2020","unstructured":"Huang, D., et al.: TiDB: a raft-based HTAP database. Proc. VLDB Endow. 13(12), 3072\u20133084 (2020)","journal-title":"Proc. VLDB Endow."},{"issue":"3","key":"15_CR12","first-page":"204","volume":"9","author":"V Leis","year":"2015","unstructured":"Leis, V., Gubichev, A., Mirchev, A., Boncz, P.A., Kemper, A., Neumann, T.: How good are query optimizers, really? VLDB 9(3), 204\u2013215 (2015)","journal-title":"VLDB"},{"key":"15_CR13","doi-asserted-by":"crossref","unstructured":"Li, Z., Papaemmanouil, O., Cherniack, M.: OptMark: a toolkit for benchmarking query optimizers. In: CIKM, pp. 2155\u20132160 (2016)","DOI":"10.1145\/2983323.2983658"},{"key":"15_CR14","doi-asserted-by":"crossref","unstructured":"Perron, M., Shang, Z., Kraska, T., Stonebraker, M.: How i learned to stop worrying and love re-optimization. In: ICDE, pp. 1758\u20131761 (2019)","DOI":"10.1109\/ICDE.2019.00191"},{"key":"15_CR15","doi-asserted-by":"crossref","unstructured":"Waas, F.M., Giakoumakis, L., Zhang, S.: Plan space analysis: an early warning system to detect plan regressions in cost-based optimizers. In: DBTest, p. 2 (2011)","DOI":"10.1145\/1988842.1988844"},{"issue":"2","key":"15_CR16","first-page":"1346","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. PVLDB 1(2), 1346\u20131355 (2008)","journal-title":"PVLDB"}],"container-title":["Lecture Notes in Computer Science","Databases Theory and Applications"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-031-47843-7_15","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,11,6]],"date-time":"2023-11-06T21:33:24Z","timestamp":1699306404000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-031-47843-7_15"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,11,7]]},"ISBN":["9783031478420","9783031478437"],"references-count":16,"URL":"https:\/\/doi.org\/10.1007\/978-3-031-47843-7_15","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"value":"0302-9743","type":"print"},{"value":"1611-3349","type":"electronic"}],"subject":[],"published":{"date-parts":[[2023,11,7]]},"assertion":[{"value":"7 November 2023","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"ADC","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Australasian Database Conference","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Melbourne, VIC","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Australia","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2023","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"1 November 2023","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"3 November 2023","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"34","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"adc2023","order":10,"name":"conference_id","label":"Conference ID","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":"Microsoft CMT","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"41","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":"26","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":"0","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":"63% - 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":"3","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":"2.5","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":"No","order":9,"name":"external_reviewers_involved","label":"External Reviewers Involved","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}}]}}