{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,26]],"date-time":"2025-03-26T01:55:25Z","timestamp":1742954125769,"version":"3.40.3"},"publisher-location":"Cham","reference-count":14,"publisher":"Springer Nature Switzerland","isbn-type":[{"type":"print","value":"9783031471117"},{"type":"electronic","value":"9783031471124"}],"license":[{"start":{"date-parts":[[2023,1,1]],"date-time":"2023-01-01T00:00:00Z","timestamp":1672531200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2023,1,1]],"date-time":"2023-01-01T00:00:00Z","timestamp":1672531200000},"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":[[2023]]},"DOI":"10.1007\/978-3-031-47112-4_8","type":"book-chapter","created":{"date-parts":[[2023,10,26]],"date-time":"2023-10-26T05:01:54Z","timestamp":1698296514000},"page":"85-94","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Using Knowledge Graphs to\u00a0Generate SQL Queries from\u00a0Textual Specifications"],"prefix":"10.1007","author":[{"ORCID":"https:\/\/orcid.org\/0000-0003-1778-9194","authenticated-orcid":false,"given":"Robson A.","family":"Camp\u00ealo","sequence":"first","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0001-5032-2233","authenticated-orcid":false,"given":"Alberto H. F.","family":"Laender","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0002-8992-495X","authenticated-orcid":false,"given":"Altigran S.","family":"da Silva","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2023,10,26]]},"reference":[{"key":"8_CR1","doi-asserted-by":"publisher","unstructured":"Affolter, K., Stockinger, K., Bernstein, A.: A comparative survey of recent natural language interfaces for databases. VLDB J. 793\u2013919 (2019). https:\/\/doi.org\/10.48550\/arXiv.1906.08990","DOI":"10.48550\/arXiv.1906.08990"},{"key":"8_CR2","doi-asserted-by":"publisher","unstructured":"Baik, C., Jagadish, H.V., Li, Y.: Bridging the semantic gap with SQL query logs in natural language interfaces to databases. In: Proceedings of the IEEE 35th International Conference on Data Engineering (ICDE), pp. 374\u2013385 (2019). https:\/\/doi.org\/10.48550\/arXiv.1902.00031","DOI":"10.48550\/arXiv.1902.00031"},{"key":"8_CR3","doi-asserted-by":"publisher","unstructured":"Basik, F., et al.: DBPal: a learned NL-interface for databases. In: Proceedings of the 2018 International Conference on Management of Data, pp. 1765\u20131768 (2018). https:\/\/doi.org\/10.1145\/3183713.3193562","DOI":"10.1145\/3183713.3193562"},{"key":"8_CR4","doi-asserted-by":"publisher","unstructured":"Hogan, A., et al.: Knowledge graphs. ACM Comput. Surv. (Csur) 1\u201337 (2021). https:\/\/doi.org\/10.1145\/3447772","DOI":"10.1145\/3447772"},{"key":"8_CR5","doi-asserted-by":"publisher","unstructured":"Kim, H., So, B., Han, W., Lee, H.: Natural language to SQL: where are we today?. Proc. VLDB Endow. 13(10), 1737\u20131750 (2020). https:\/\/doi.org\/10.14778\/3401960.3401970","DOI":"10.14778\/3401960.3401970"},{"key":"8_CR6","unstructured":"Liu, A., Hu, X., Wen, L., Yu, Philip, S.: A Comprehensive evaluation of ChatGPT\u2019s zero-shot Text-to-SQL capability. arXiv preprint arXiv:2303.13547 (2023). https:\/\/doi.org\/10.48550\/arXiv.2303.13547"},{"issue":"1","key":"8_CR7","doi-asserted-by":"publisher","first-page":"73","DOI":"10.14778\/2735461.2735468","volume":"8","author":"F Li","year":"2014","unstructured":"Li, F., Jagadish, H.V.: Constructing an interactive natural language interface for relational databases. Proc. VLDB Endow. 8(1), 73\u201384 (2014)","journal-title":"Proc. VLDB Endow."},{"key":"8_CR8","doi-asserted-by":"publisher","unstructured":"Quamar, A., Efthymiou, V., Lei, C., \u00d6zcan, F.: Natural language interfaces to data. Found. Trends Databases 319\u2013414 (2022). https:\/\/doi.org\/10.48550\/arXiv.2212.13074","DOI":"10.48550\/arXiv.2212.13074"},{"issue":"12","key":"8_CR9","doi-asserted-by":"publisher","first-page":"1209","DOI":"10.14778\/2994509.2994536","volume":"9","author":"D Saha","year":"2016","unstructured":"Saha, D., Floratou, A., Sankaranarayanan, K., Minhas, U.F., Mittal, A.R., \u00d6zcan, F.: ATHENA: an ontology-driven system for natural language querying over relational data stores. Proc. VLDB Endow. 9(12), 1209\u20131220 (2016). https:\/\/doi.org\/10.14778\/2994509.2994536","journal-title":"Proc. VLDB Endow."},{"issue":"12","key":"8_CR10","doi-asserted-by":"publisher","first-page":"2747","DOI":"10.14778\/3407790.3407858","volume":"13","author":"J Sen","year":"2020","unstructured":"Sen, J., et al.: Athena++: natural language querying for complex nested SQL queries. Proc. VLDB Endow. 13(12), 2747\u20132759 (2020). https:\/\/doi.org\/10.14778\/3407790.3407858","journal-title":"Proc. VLDB Endow."},{"key":"8_CR11","doi-asserted-by":"publisher","unstructured":"Yaghmazadeh, N., Wang, Y., Dillig, I., Dillig, T.,: SQLizer: query synthesis from natural language. Proc. ACM Program. Lang. 1(OOPSLA), 1\u201326 (2017). https:\/\/doi.org\/10.1145\/3133887","DOI":"10.1145\/3133887"},{"key":"8_CR12","doi-asserted-by":"publisher","unstructured":"Yu, T., et al.: Spider: a large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-SQL task. arXiv: $$\\text{Computation}$$ and Language (2018). https:\/\/doi.org\/10.18653\/v1\/D18-1425","DOI":"10.18653\/v1\/D18-1425"},{"key":"8_CR13","doi-asserted-by":"publisher","unstructured":"Yu, T., Li, Z., Zhang, Z., Zhang, R., Radev, D.: TypeSQL Knowledge-based type-aware neural text-to-SQL generation. arXiv preprint (2018). https:\/\/doi.org\/10.48550\/arXiv.1804.09769","DOI":"10.48550\/arXiv.1804.09769"},{"key":"8_CR14","doi-asserted-by":"publisher","unstructured":"Xu, X., Liu, C., Song, D.: SQLNet generating structured queries from natural language without reinforcement learning. arXiv preprint (2017). https:\/\/doi.org\/10.48550\/arXiv.1711.04436","DOI":"10.48550\/arXiv.1711.04436"}],"container-title":["Lecture Notes in Computer Science","Advances in Conceptual Modeling"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-031-47112-4_8","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,3,13]],"date-time":"2024-03-13T16:13:33Z","timestamp":1710346413000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-031-47112-4_8"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023]]},"ISBN":["9783031471117","9783031471124"],"references-count":14,"URL":"https:\/\/doi.org\/10.1007\/978-3-031-47112-4_8","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2023]]},"assertion":[{"value":"26 October 2023","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"ER","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"International Conference on Conceptual Modeling","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Lisbon","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Portugal","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":"6 November 2023","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"9 November 2023","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"42","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"er2023","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/er2023.inesc-id.pt\/","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":"Easy Chair (Familiarity)","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"117","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":"21","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":"18% - 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.09+1","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":"3.47+3.55","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":"Yes","order":9,"name":"external_reviewers_involved","label":"External Reviewers Involved","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"Yes, additional reviewers listed in preface (subreviewers supervised by PC members)","order":10,"name":"additional_info_on_review_process","label":"Additional Info on Review Process","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}}]}}