{"id":"https://openalex.org/W4409965697","doi":"https://doi.org/10.3390/info16050368","title":"Exploring Large Language Models\u2019 Ability to Describe Entity-Relationship Schema-Based Conceptual Data Models","display_name":"Exploring Large Language Models\u2019 Ability to Describe Entity-Relationship Schema-Based Conceptual Data Models","publication_year":2025,"publication_date":"2025-04-29","ids":{"openalex":"https://openalex.org/W4409965697","doi":"https://doi.org/10.3390/info16050368"},"language":"en","primary_location":{"id":"doi:10.3390/info16050368","is_oa":true,"landing_page_url":"https://doi.org/10.3390/info16050368","pdf_url":"https://www.mdpi.com/2078-2489/16/5/368/pdf?version=1745990344","source":{"id":"https://openalex.org/S4210219776","display_name":"Information","issn_l":"2078-2489","issn":["2078-2489"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.mdpi.com/2078-2489/16/5/368/pdf?version=1745990344","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5035320570","display_name":"Andrea Avignone","orcid":"https://orcid.org/0000-0001-7003-129X"},"institutions":[{"id":"https://openalex.org/I177477856","display_name":"Politecnico di Torino","ror":"https://ror.org/00bgk9508","country_code":"IT","type":"education","lineage":["https://openalex.org/I177477856"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Andrea Avignone","raw_affiliation_strings":["Department of Control and Computer Engineering, Politecnico di Torino, 10129 Torino, Italy"],"raw_orcid":"https://orcid.org/0000-0001-7003-129X","affiliations":[{"raw_affiliation_string":"Department of Control and Computer Engineering, Politecnico di Torino, 10129 Torino, Italy","institution_ids":["https://openalex.org/I177477856"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5117388130","display_name":"Alessia Tierno","orcid":null},"institutions":[{"id":"https://openalex.org/I177477856","display_name":"Politecnico di Torino","ror":"https://ror.org/00bgk9508","country_code":"IT","type":"education","lineage":["https://openalex.org/I177477856"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Alessia Tierno","raw_affiliation_strings":["Department of Control and Computer Engineering, Politecnico di Torino, 10129 Torino, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Control and Computer Engineering, Politecnico di Torino, 10129 Torino, Italy","institution_ids":["https://openalex.org/I177477856"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061948214","display_name":"Alessandro Fiori","orcid":"https://orcid.org/0000-0003-3819-2696"},"institutions":[{"id":"https://openalex.org/I177477856","display_name":"Politecnico di Torino","ror":"https://ror.org/00bgk9508","country_code":"IT","type":"education","lineage":["https://openalex.org/I177477856"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Alessandro Fiori","raw_affiliation_strings":["Department of Control and Computer Engineering, Politecnico di Torino, 10129 Torino, Italy"],"raw_orcid":"https://orcid.org/0000-0003-3819-2696","affiliations":[{"raw_affiliation_string":"Department of Control and Computer Engineering, Politecnico di Torino, 10129 Torino, Italy","institution_ids":["https://openalex.org/I177477856"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5091589252","display_name":"Silvia Chiusano","orcid":"https://orcid.org/0000-0002-5740-5004"},"institutions":[{"id":"https://openalex.org/I177477856","display_name":"Politecnico di Torino","ror":"https://ror.org/00bgk9508","country_code":"IT","type":"education","lineage":["https://openalex.org/I177477856"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Silvia Chiusano","raw_affiliation_strings":["Department of Control and Computer Engineering, Politecnico di Torino, 10129 Torino, Italy"],"raw_orcid":"https://orcid.org/0000-0002-5740-5004","affiliations":[{"raw_affiliation_string":"Department of Control and Computer Engineering, Politecnico di Torino, 10129 Torino, Italy","institution_ids":["https://openalex.org/I177477856"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5035320570"],"corresponding_institution_ids":["https://openalex.org/I177477856"],"apc_list":{"value":1600,"currency":"CHF","value_usd":1782},"apc_paid":{"value":1600,"currency":"CHF","value_usd":1782},"fwci":8.551,"has_fulltext":true,"cited_by_count":7,"citation_normalized_percentile":{"value":0.97226782,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":97,"max":99},"biblio":{"volume":"16","issue":"5","first_page":"368","last_page":"368"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9997000098228455,"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/T10028","display_name":"Topic Modeling","score":0.9997000098228455,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.9984999895095825,"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/T11719","display_name":"Data Quality and Management","score":0.9923999905586243,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6660811901092529},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.5725640654563904},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5512802600860596},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.47059357166290283},{"id":"https://openalex.org/keywords/conceptual-model","display_name":"Conceptual model","score":0.4475473165512085},{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.4245561957359314},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2733686566352844},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.25770193338394165},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.1596945822238922},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.15029194951057434},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.13712751865386963},{"id":"https://openalex.org/keywords/cognitive-psychology","display_name":"Cognitive psychology","score":0.12401816248893738}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6660811901092529},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.5725640654563904},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5512802600860596},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.47059357166290283},{"id":"https://openalex.org/C13606891","wikidata":"https://www.wikidata.org/wiki/Q2623243","display_name":"Conceptual model","level":2,"score":0.4475473165512085},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.4245561957359314},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2733686566352844},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.25770193338394165},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.1596945822238922},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.15029194951057434},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.13712751865386963},{"id":"https://openalex.org/C180747234","wikidata":"https://www.wikidata.org/wiki/Q23373","display_name":"Cognitive psychology","level":1,"score":0.12401816248893738},{"id":"https://openalex.org/C100660578","wikidata":"https://www.wikidata.org/wiki/Q18733","display_name":"Recall","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.3390/info16050368","is_oa":true,"landing_page_url":"https://doi.org/10.3390/info16050368","pdf_url":"https://www.mdpi.com/2078-2489/16/5/368/pdf?version=1745990344","source":{"id":"https://openalex.org/S4210219776","display_name":"Information","issn_l":"2078-2489","issn":["2078-2489"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:93486bd208564c099ad75d9be00d018f","is_oa":true,"landing_page_url":"https://doaj.org/article/93486bd208564c099ad75d9be00d018f","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Information, Vol 16, Iss 5, p 368 (2025)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.3390/info16050368","is_oa":true,"landing_page_url":"https://doi.org/10.3390/info16050368","pdf_url":"https://www.mdpi.com/2078-2489/16/5/368/pdf?version=1745990344","source":{"id":"https://openalex.org/S4210219776","display_name":"Information","issn_l":"2078-2489","issn":["2078-2489"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G4508289328","display_name":null,"funder_award_id":"PE00000013","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G7248538987","display_name":null,"funder_award_id":"1555 11/10/2022","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"}],"funders":[{"id":"https://openalex.org/F4320320300","display_name":"European Commission","ror":"https://ror.org/00k4n6c32"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4409965697.pdf","grobid_xml":"https://content.openalex.org/works/W4409965697.grobid-xml"},"referenced_works_count":28,"referenced_works":["https://openalex.org/W2058373514","https://openalex.org/W2945102109","https://openalex.org/W2963993485","https://openalex.org/W3009251324","https://openalex.org/W3058517477","https://openalex.org/W3092288641","https://openalex.org/W3116194881","https://openalex.org/W3116342879","https://openalex.org/W3160638507","https://openalex.org/W4221143046","https://openalex.org/W4294631187","https://openalex.org/W4317716303","https://openalex.org/W4367059011","https://openalex.org/W4385567149","https://openalex.org/W4388623591","https://openalex.org/W4389495228","https://openalex.org/W4392248492","https://openalex.org/W4394567450","https://openalex.org/W4398183782","https://openalex.org/W4401719166","https://openalex.org/W4402352296","https://openalex.org/W4402586225","https://openalex.org/W4402665833","https://openalex.org/W4405796591","https://openalex.org/W4406738283","https://openalex.org/W6778883912","https://openalex.org/W6838865847","https://openalex.org/W6852294214"],"related_works":["https://openalex.org/W629399385","https://openalex.org/W4248994601","https://openalex.org/W2061516774","https://openalex.org/W2160577815","https://openalex.org/W39310976","https://openalex.org/W1985157031","https://openalex.org/W2360992999","https://openalex.org/W101905311","https://openalex.org/W2007556552","https://openalex.org/W2048137832"],"abstract_inverted_index":{"In":[0],"the":[1,41,64,80,96,100,109,115,120,159,162,167],"field":[2],"of":[3,35,66,98,161],"databases,":[4],"Large":[5],"Language":[6],"Models":[7],"(LLMs)":[8],"have":[9,137],"recently":[10],"been":[11,138],"studied":[12],"for":[13,23,84],"generating":[14,104],"SQL":[15],"queries":[16],"from":[17],"textual":[18],"descriptions,":[19],"while":[20],"their":[21,59],"use":[22],"conceptual":[24,33,75],"or":[25,87],"logical":[26],"data":[27,44,76],"modeling":[28],"remains":[29],"less":[30],"explored.":[31],"The":[32],"design":[34],"relational":[36,56],"databases":[37],"commonly":[38],"relies":[39],"on":[40,79],"entity-relationship":[42],"(ER)":[43],"model,":[45],"where":[46],"translation":[47],"rules":[48],"enable":[49],"mapping":[50],"an":[51,131],"ER":[52,81,101,133],"schema":[53,102],"into":[54],"corresponding":[55],"tables":[57],"with":[58,89,122],"constraints.":[60],"Our":[61],"study":[62],"investigates":[63],"capability":[65],"LLMs":[67,92,136],"to":[68,129,157],"describe":[69],"in":[70],"natural":[71],"language":[72],"a":[73],"database":[74],"model":[77],"based":[78],"schema.":[82,134],"Whether":[83],"documentation,":[85],"onboarding,":[86],"communication":[88],"non-technical":[90],"stakeholders,":[91],"can":[93],"significantly":[94],"improve":[95],"process":[97],"explaining":[99],"by":[103],"accurate":[105],"descriptions":[106,164],"about":[107],"how":[108],"components":[110],"interact":[111],"as":[112,114],"well":[113],"represented":[116],"information.":[117],"To":[118],"guide":[119],"LLM":[121],"challenging":[123],"constructs,":[124],"specific":[125],"hints":[126],"are":[127,155],"defined":[128],"provide":[130],"enriched":[132],"Different":[135],"explored":[139],"(ChatGPT":[140],"3.5":[141],"and":[142,148,165],"4,":[143],"Llama2,":[144],"Gemini,":[145],"Mistral":[146],"7B)":[147],"different":[149,168],"metrics":[150],"(F1":[151],"score,":[152],"ROUGE,":[153],"perplexity)":[154],"used":[156],"assess":[158],"quality":[160],"generated":[163],"compare":[166],"LLMs.":[169]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":4}],"updated_date":"2026-07-31T08:31:51.225901","created_date":"2025-10-10T00:00:00"}