{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,27]],"date-time":"2025-03-27T03:05:14Z","timestamp":1743044714648,"version":"3.40.3"},"publisher-location":"Singapore","reference-count":19,"publisher":"Springer Nature Singapore","isbn-type":[{"type":"print","value":"9789819708437"},{"type":"electronic","value":"9789819708444"}],"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-981-97-0844-4_4","type":"book-chapter","created":{"date-parts":[[2024,2,21]],"date-time":"2024-02-21T06:02:43Z","timestamp":1708495363000},"page":"45-58","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Query Reverse Engineering of\u00a0Pre-deleted Uncorrelated Operators"],"prefix":"10.1007","author":[{"ORCID":"https:\/\/orcid.org\/0009-0004-6380-8135","authenticated-orcid":false,"given":"Quansheng","family":"Dou","sequence":"first","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0009-0009-2053-8696","authenticated-orcid":false,"given":"Huixian","family":"Wang","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0002-8521-9786","authenticated-orcid":false,"given":"Huanling","family":"Tang","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0009-0004-3771-336X","authenticated-orcid":false,"given":"Hao","family":"Pan","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0001-6315-0055","authenticated-orcid":false,"given":"Shun","family":"Zhang","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2024,2,22]]},"reference":[{"key":"4_CR1","unstructured":"Brancas, R., Terra-Neves, M., Ventura, M., Manquinho, V., Martins, R.: CUBES: a parallel synthesizer for SQL using examples. arXiv preprint arXiv:2203.04995 (2022)"},{"key":"4_CR2","unstructured":"Catalfamo, W., Censuales, S.: Schema query reverse engineering"},{"issue":"4","key":"4_CR3","doi-asserted-by":"publisher","first-page":"420","DOI":"10.1145\/3296979.3192382","volume":"53","author":"Y Feng","year":"2018","unstructured":"Feng, Y., Martins, R., Bastani, O., Dillig, I.: Program synthesis using conflict-driven learning. ACM SIGPLAN Not. 53(4), 420\u2013435 (2018)","journal-title":"ACM SIGPLAN Not."},{"issue":"6","key":"4_CR4","doi-asserted-by":"publisher","first-page":"422","DOI":"10.1145\/3140587.3062351","volume":"52","author":"Y Feng","year":"2017","unstructured":"Feng, Y., Martins, R., Van Geffen, J., Dillig, I., Chaudhuri, S.: Component-based synthesis of table consolidation and transformation tasks from examples. ACM SIGPLAN Not. 52(6), 422\u2013436 (2017)","journal-title":"ACM SIGPLAN Not."},{"key":"4_CR5","doi-asserted-by":"crossref","unstructured":"Huang, P.S., Wang, C., Singh, R., Yih, W.T., He, X.: Natural language to structured query generation via meta-learning. arXiv preprint arXiv:1803.02400 (2018)","DOI":"10.18653\/v1\/N18-2115"},{"issue":"13","key":"4_CR6","doi-asserted-by":"publisher","first-page":"2158","DOI":"10.14778\/2831360.2831369","volume":"8","author":"H Li","year":"2015","unstructured":"Li, H., Chan, C.Y., Maier, D.: Query from examples: an iterative, data-driven approach to query construction. Proc. VLDB Endow. 8(13), 2158\u20132169 (2015)","journal-title":"Proc. VLDB Endow."},{"issue":"12","key":"4_CR7","doi-asserted-by":"publisher","first-page":"1914","DOI":"10.14778\/3352063.3352098","volume":"12","author":"R Martins","year":"2019","unstructured":"Martins, R., Chen, J., Chen, Y., Feng, Y., Dillig, I.: Trinity: an extensible synthesis framework for data science. Proc. VLDB Endow. 12(12), 1914\u20131917 (2019)","journal-title":"Proc. VLDB Endow."},{"key":"4_CR8","unstructured":"Meiying, L.: Techniques for efficient query reverse engineering. Ph.D. thesis, National University of Singapore (Singapore) (2022)"},{"issue":"12","key":"4_CR9","doi-asserted-by":"publisher","first-page":"2853","DOI":"10.14778\/3415478.3415492","volume":"13","author":"P Orvalho","year":"2020","unstructured":"Orvalho, P., Terra-Neves, M., Ventura, M., Martins, R., Manquinho, V.: SQUARES: a SQL synthesizer using query reverse engineering. Proc. VLDB Endow. 13(12), 2853\u20132856 (2020)","journal-title":"Proc. VLDB Endow."},{"key":"4_CR10","doi-asserted-by":"crossref","unstructured":"Takenouchi, K., Ishio, T., Okada, J., Sakata, Y.: PATSQL: efficient synthesis of SQL queries from example tables with quick inference of projected columns. arXiv preprint arXiv:2010.05807 (2020)","DOI":"10.14778\/3476249.3476253"},{"issue":"11","key":"4_CR11","doi-asserted-by":"publisher","first-page":"1394","DOI":"10.14778\/3137628.3137648","volume":"10","author":"WC Tan","year":"2017","unstructured":"Tan, W.C., Zhang, M., Elmeleegy, H., Srivastava, D.: Reverse engineering aggregation queries. Proc. VLDB Endow. 10(11), 1394\u20131405 (2017)","journal-title":"Proc. VLDB Endow."},{"key":"4_CR12","doi-asserted-by":"crossref","unstructured":"Tran, Q.T., Chan, C.Y., Parthasarathy, S.: Query by output. In: Proceedings of the 2009 ACM SIGMOD International Conference on Management of Data, pp. 535\u2013548 (2009)","DOI":"10.1145\/1559845.1559902"},{"issue":"5","key":"4_CR13","doi-asserted-by":"publisher","first-page":"721","DOI":"10.1007\/s00778-013-0349-3","volume":"23","author":"QT Tran","year":"2014","unstructured":"Tran, Q.T., Chan, C.Y., Parthasarathy, S.: Query reverse engineering. VLDB J. 23(5), 721\u2013746 (2014)","journal-title":"VLDB J."},{"key":"4_CR14","doi-asserted-by":"crossref","unstructured":"Wang, B., Shin, R., Liu, X., Polozov, O., Richardson, M.: RAT-SQL: relation-aware schema encoding and linking for text-to-SQL parsers. arXiv preprint arXiv:1911.04942 (2019)","DOI":"10.18653\/v1\/2020.acl-main.677"},{"key":"4_CR15","doi-asserted-by":"crossref","unstructured":"Wang, C., Cheung, A., Bodik, R.: Interactive query synthesis from input-output examples. In: Proceedings of the 2017 ACM International Conference on Management of Data, pp. 1631\u20131634 (2017)","DOI":"10.1145\/3035918.3058738"},{"key":"4_CR16","doi-asserted-by":"crossref","unstructured":"Wang, C., Cheung, A., Bodik, R.: Synthesizing highly expressive SQL queries from input-output examples. In: Proceedings of the 38th ACM SIGPLAN Conference on Programming Language Design and Implementation, pp. 452\u2013466 (2017)","DOI":"10.1145\/3062341.3062365"},{"key":"4_CR17","doi-asserted-by":"crossref","unstructured":"Yu, T., et al.: SyntaxSQLNet: syntax tree networks for complex and cross-domaintext-to-SQL task. arXiv preprint arXiv:1810.05237 (2018)","DOI":"10.18653\/v1\/D18-1193"},{"key":"4_CR18","doi-asserted-by":"crossref","unstructured":"Zhang, S., Sun, Y.: Automatically synthesizing SQL queries from input-output examples. In: 2013 28th IEEE\/ACM International Conference on Automated Software Engineering (ASE), pp. 224\u2013234. IEEE (2013)","DOI":"10.1109\/ASE.2013.6693082"},{"key":"4_CR19","doi-asserted-by":"crossref","unstructured":"Zloof, M.M.: Query-by-example: the invocation and definition of tables and forms. In: Proceedings of the 1st International Conference on Very Large Data Bases, pp. 1\u201324 (1975)","DOI":"10.1145\/1282480.1282482"}],"container-title":["Communications in Computer and Information Science","Data Mining and Big Data"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-981-97-0844-4_4","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,2,21]],"date-time":"2024-02-21T06:11:31Z","timestamp":1708495891000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-981-97-0844-4_4"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024]]},"ISBN":["9789819708437","9789819708444"],"references-count":19,"URL":"https:\/\/doi.org\/10.1007\/978-981-97-0844-4_4","relation":{},"ISSN":["1865-0929","1865-0937"],"issn-type":[{"type":"print","value":"1865-0929"},{"type":"electronic","value":"1865-0937"}],"subject":[],"published":{"date-parts":[[2024]]},"assertion":[{"value":"22 February 2024","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"DMBD","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"International Conference on Data Mining and Big Data","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Sanya","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"China","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":"9 December 2023","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"12 December 2023","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"dmbd2023","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"http:\/\/www.iasei.org\/dmbd2023\/","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Double-blind","order":1,"name":"type","label":"Type","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"Easychair","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"79","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":"38","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":"29","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":"48% - 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":"2.5","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":"Yes","order":9,"name":"external_reviewers_involved","label":"External Reviewers Involved","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}}]}}