{"id":"https://openalex.org/W7155221636","doi":"https://doi.org/10.1007/978-3-032-16708-8_19","title":"Generating Patient Cohorts from\u00a0Electronic Health Records Using Two-Step Retrieval-Augmented Text-to-SQL Generation","display_name":"Generating Patient Cohorts from\u00a0Electronic Health Records Using Two-Step Retrieval-Augmented Text-to-SQL Generation","publication_year":2026,"publication_date":"2026-01-01","ids":{"openalex":"https://openalex.org/W7155221636","doi":"https://doi.org/10.1007/978-3-032-16708-8_19"},"language":"en","primary_location":{"id":"doi:10.1007/978-3-032-16708-8_19","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-032-16708-8_19","pdf_url":null,"source":{"id":"https://openalex.org/S2764900261","display_name":"Communications in computer and information science","issn_l":"1865-0929","issn":["1865-0929","1865-0937"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Communications in Computer and Information Science","raw_type":"book-chapter"},"type":"book-chapter","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5022031291","display_name":"Angelo Ziletti","orcid":"https://orcid.org/0000-0002-2978-6305"},"institutions":[{"id":"https://openalex.org/I67348948","display_name":"Bayer (Germany)","ror":"https://ror.org/04hmn8g73","country_code":"DE","type":"company","lineage":["https://openalex.org/I67348948"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Angelo Ziletti","raw_affiliation_strings":["Bayer AG, Leverkusen, Germany"],"raw_orcid":"https://orcid.org/0000-0002-2978-6305","affiliations":[{"raw_affiliation_string":"Bayer AG, Leverkusen, Germany","institution_ids":["https://openalex.org/I67348948"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5094170140","display_name":"Leonardo D'Ambrosi","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Leonardo D\u2019Ambrosi","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5022031291"],"corresponding_institution_ids":["https://openalex.org/I67348948"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.96857975,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"231","last_page":"242"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13702","display_name":"Machine Learning in Healthcare","score":0.8432999849319458,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13702","display_name":"Machine Learning in Healthcare","score":0.8432999849319458,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.03959999978542328,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10350","display_name":"Electronic Health Records Systems","score":0.026599999517202377,"subfield":{"id":"https://openalex.org/subfields/3605","display_name":"Health Information Management"},"field":{"id":"https://openalex.org/fields/36","display_name":"Health Professions"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/health-records","display_name":"Health records","score":0.7208999991416931},{"id":"https://openalex.org/keywords/electronic-health-record","display_name":"Electronic health record","score":0.546999990940094},{"id":"https://openalex.org/keywords/medical-record","display_name":"Medical record","score":0.4415000081062317},{"id":"https://openalex.org/keywords/electronic-records","display_name":"Electronic records","score":0.41290000081062317},{"id":"https://openalex.org/keywords/patient-record","display_name":"Patient record","score":0.36970001459121704},{"id":"https://openalex.org/keywords/medline","display_name":"MEDLINE","score":0.34470000863075256}],"concepts":[{"id":"https://openalex.org/C3019952477","wikidata":"https://www.wikidata.org/wiki/Q1324077","display_name":"Health records","level":3,"score":0.7208999991416931},{"id":"https://openalex.org/C3020144179","wikidata":"https://www.wikidata.org/wiki/Q10871684","display_name":"Electronic health record","level":3,"score":0.546999990940094},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.5302000045776367},{"id":"https://openalex.org/C195910791","wikidata":"https://www.wikidata.org/wiki/Q1324077","display_name":"Medical record","level":2,"score":0.4415000081062317},{"id":"https://openalex.org/C2987381348","wikidata":"https://www.wikidata.org/wiki/Q517656","display_name":"Electronic records","level":2,"score":0.41290000081062317},{"id":"https://openalex.org/C545542383","wikidata":"https://www.wikidata.org/wiki/Q2751242","display_name":"Medical emergency","level":1,"score":0.4027000069618225},{"id":"https://openalex.org/C512399662","wikidata":"https://www.wikidata.org/wiki/Q3505712","display_name":"Family medicine","level":1,"score":0.3921000063419342},{"id":"https://openalex.org/C2993731853","wikidata":"https://www.wikidata.org/wiki/Q1324077","display_name":"Patient record","level":2,"score":0.36970001459121704},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","level":2,"score":0.34470000863075256},{"id":"https://openalex.org/C2992987738","wikidata":"https://www.wikidata.org/wiki/Q1630451","display_name":"Hospital records","level":2,"score":0.3269999921321869},{"id":"https://openalex.org/C3018822202","wikidata":"https://www.wikidata.org/wiki/Q1324077","display_name":"Patient data","level":2,"score":0.3111000061035156},{"id":"https://openalex.org/C187212893","wikidata":"https://www.wikidata.org/wiki/Q123028","display_name":"Pediatrics","level":1,"score":0.2736000120639801},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2655999958515167},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.25619998574256897},{"id":"https://openalex.org/C3017977704","wikidata":"https://www.wikidata.org/wiki/Q18745135","display_name":"Health data","level":3,"score":0.2540999948978424}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-3-032-16708-8_19","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-032-16708-8_19","pdf_url":null,"source":{"id":"https://openalex.org/S2764900261","display_name":"Communications in computer and information science","issn_l":"1865-0929","issn":["1865-0929","1865-0937"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Communications in Computer and Information Science","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education","score":0.6243890523910522}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W2140302476","https://openalex.org/W2509884321","https://openalex.org/W2560688864","https://openalex.org/W2911661483","https://openalex.org/W2958057146","https://openalex.org/W3022196370","https://openalex.org/W3119523053","https://openalex.org/W3170549803","https://openalex.org/W4287887081","https://openalex.org/W4385573531","https://openalex.org/W4385574140","https://openalex.org/W4385623874","https://openalex.org/W4389519829","https://openalex.org/W4389523875","https://openalex.org/W4389523899","https://openalex.org/W4390578581","https://openalex.org/W4394782455","https://openalex.org/W4396529913","https://openalex.org/W4396571402","https://openalex.org/W4401043289","https://openalex.org/W7133205963","https://openalex.org/W7133216094"],"related_works":[],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2026-04-24T06:01:54.638496","created_date":"2026-04-23T00:00:00"}