{"id":"https://openalex.org/W4311858218","doi":"https://doi.org/10.3389/fcomp.2022.1020168","title":"Preserving conceptual model semantics in the forward engineering of relational schemas","display_name":"Preserving conceptual model semantics in the forward engineering of relational schemas","publication_year":2022,"publication_date":"2022-12-08","ids":{"openalex":"https://openalex.org/W4311858218","doi":"https://doi.org/10.3389/fcomp.2022.1020168"},"language":"en","primary_location":{"id":"doi:10.3389/fcomp.2022.1020168","is_oa":true,"landing_page_url":"https://doi.org/10.3389/fcomp.2022.1020168","pdf_url":"https://www.frontiersin.org/articles/10.3389/fcomp.2022.1020168/pdf","source":{"id":"https://openalex.org/S4210211086","display_name":"Frontiers in Computer Science","issn_l":"2624-9898","issn":["2624-9898"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320527","host_organization_name":"Frontiers Media","host_organization_lineage":["https://openalex.org/P4310320527"],"host_organization_lineage_names":["Frontiers Media"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in Computer Science","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.frontiersin.org/articles/10.3389/fcomp.2022.1020168/pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5085622638","display_name":"Gustavo L. Guidoni","orcid":null},"institutions":[{"id":"https://openalex.org/I51235708","display_name":"Universidade Federal do Esp\u00edrito Santo","ror":"https://ror.org/05sxf4h28","country_code":"BR","type":"education","lineage":["https://openalex.org/I51235708"]},{"id":"https://openalex.org/I4210116025","display_name":"Centro Universit\u00e1rio do Esp\u00edrito Santo","ror":"https://ror.org/02cs5nk10","country_code":"BR","type":"education","lineage":["https://openalex.org/I4210116025"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Gustavo L. Guidoni","raw_affiliation_strings":["Federal Institute of Esp\u00edrito Santo, Colatina Campus, Colatina, Brazil","Ontology and Conceptual Modeling Research Group (NEMO), Federal University of Esp\u00edrito Santo, Vit\u00f3ria, Brazil"],"affiliations":[{"raw_affiliation_string":"Federal Institute of Esp\u00edrito Santo, Colatina Campus, Colatina, Brazil","institution_ids":["https://openalex.org/I4210116025"]},{"raw_affiliation_string":"Ontology and Conceptual Modeling Research Group (NEMO), Federal University of Esp\u00edrito Santo, Vit\u00f3ria, Brazil","institution_ids":["https://openalex.org/I51235708"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063817933","display_name":"Jo\u00e3o Paulo A. Almeida","orcid":"https://orcid.org/0000-0002-9819-3781"},"institutions":[{"id":"https://openalex.org/I51235708","display_name":"Universidade Federal do Esp\u00edrito Santo","ror":"https://ror.org/05sxf4h28","country_code":"BR","type":"education","lineage":["https://openalex.org/I51235708"]}],"countries":["BR"],"is_corresponding":true,"raw_author_name":"Jo\u00e3o Paulo A. Almeida","raw_affiliation_strings":["Ontology and Conceptual Modeling Research Group (NEMO), Federal University of Esp\u00edrito Santo, Vit\u00f3ria, Brazil"],"affiliations":[{"raw_affiliation_string":"Ontology and Conceptual Modeling Research Group (NEMO), Federal University of Esp\u00edrito Santo, Vit\u00f3ria, Brazil","institution_ids":["https://openalex.org/I51235708"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5065297243","display_name":"Giancarlo Guizzardi","orcid":"https://orcid.org/0000-0002-3452-553X"},"institutions":[{"id":"https://openalex.org/I94624287","display_name":"University of Twente","ror":"https://ror.org/006hf6230","country_code":"NL","type":"education","lineage":["https://openalex.org/I94624287"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Giancarlo Guizzardi","raw_affiliation_strings":["Services and Cybersecurity Group, University of Twente, Enschede, Netherlands"],"affiliations":[{"raw_affiliation_string":"Services and Cybersecurity Group, University of Twente, Enschede, Netherlands","institution_ids":["https://openalex.org/I94624287"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5063817933"],"corresponding_institution_ids":["https://openalex.org/I51235708"],"apc_list":{"value":1150,"currency":"USD","value_usd":1150},"apc_paid":{"value":1150,"currency":"USD","value_usd":1150},"fwci":0.3183,"has_fulltext":true,"cited_by_count":1,"citation_normalized_percentile":{"value":0.65062175,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":"4","issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11450","display_name":"Model-Driven Software Engineering Techniques","score":0.9991999864578247,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T10703","display_name":"Business Process Modeling and Analysis","score":0.9980999827384949,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"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.7289938926696777},{"id":"https://openalex.org/keywords/model-transformation","display_name":"Model transformation","score":0.5605103969573975},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5391692519187927},{"id":"https://openalex.org/keywords/unified-modeling-language","display_name":"Unified Modeling Language","score":0.48415905237197876},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.4408799111843109},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.43589380383491516},{"id":"https://openalex.org/keywords/transformation","display_name":"Transformation (genetics)","score":0.4226107597351074},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.4159310758113861},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.41078630089759827},{"id":"https://openalex.org/keywords/class-hierarchy","display_name":"Class hierarchy","score":0.41072189807891846},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.397682785987854},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3941369652748108},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.26298099756240845},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.2294122874736786},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.18936601281166077},{"id":"https://openalex.org/keywords/object-oriented-programming","display_name":"Object-oriented programming","score":0.17687755823135376},{"id":"https://openalex.org/keywords/linguistics","display_name":"Linguistics","score":0.09425276517868042}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7289938926696777},{"id":"https://openalex.org/C2779791154","wikidata":"https://www.wikidata.org/wiki/Q258040","display_name":"Model transformation","level":3,"score":0.5605103969573975},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5391692519187927},{"id":"https://openalex.org/C145644426","wikidata":"https://www.wikidata.org/wiki/Q169411","display_name":"Unified Modeling Language","level":3,"score":0.48415905237197876},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.4408799111843109},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.43589380383491516},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.4226107597351074},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.4159310758113861},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.41078630089759827},{"id":"https://openalex.org/C2781289151","wikidata":"https://www.wikidata.org/wiki/Q2903989","display_name":"Class hierarchy","level":3,"score":0.41072189807891846},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.397682785987854},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3941369652748108},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.26298099756240845},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2294122874736786},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.18936601281166077},{"id":"https://openalex.org/C73752529","wikidata":"https://www.wikidata.org/wiki/Q79872","display_name":"Object-oriented programming","level":2,"score":0.17687755823135376},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.09425276517868042},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C100660578","wikidata":"https://www.wikidata.org/wiki/Q18733","display_name":"Recall","level":2,"score":0.0},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.3389/fcomp.2022.1020168","is_oa":true,"landing_page_url":"https://doi.org/10.3389/fcomp.2022.1020168","pdf_url":"https://www.frontiersin.org/articles/10.3389/fcomp.2022.1020168/pdf","source":{"id":"https://openalex.org/S4210211086","display_name":"Frontiers in Computer Science","issn_l":"2624-9898","issn":["2624-9898"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320527","host_organization_name":"Frontiers Media","host_organization_lineage":["https://openalex.org/P4310320527"],"host_organization_lineage_names":["Frontiers Media"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in Computer Science","raw_type":"journal-article"},{"id":"pmh:oai:ris.utwente.nl:publications/a92283ed-2ef7-4577-b4be-acc73a2b3db9","is_oa":true,"landing_page_url":"https://research.utwente.nl/en/publications/a92283ed-2ef7-4577-b4be-acc73a2b3db9","pdf_url":"https://ris.utwente.nl/ws/files/301075472/fcomp_04_1020168.pdf","source":{"id":"https://openalex.org/S4406922991","display_name":"University of Twente Research Information","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","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Guidoni, G L, Almeide, J P A & Guizzardi, G 2022, 'Preserving conceptual model semantics in the forward engineering of relational schemas', Frontiers in Computer Science, vol. 4. https://doi.org/10.3389/fcomp.2022.1020168","raw_type":"info:eu-repo/semantics/publishedVersion"},{"id":"pmh:oai:doaj.org/article:a4a78a15d15642e88ab5a3d207f4a044","is_oa":true,"landing_page_url":"https://doaj.org/article/a4a78a15d15642e88ab5a3d207f4a044","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Frontiers in Computer Science, Vol 4 (2022)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.3389/fcomp.2022.1020168","is_oa":true,"landing_page_url":"https://doi.org/10.3389/fcomp.2022.1020168","pdf_url":"https://www.frontiersin.org/articles/10.3389/fcomp.2022.1020168/pdf","source":{"id":"https://openalex.org/S4210211086","display_name":"Frontiers in Computer Science","issn_l":"2624-9898","issn":["2624-9898"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320527","host_organization_name":"Frontiers Media","host_organization_lineage":["https://openalex.org/P4310320527"],"host_organization_lineage_names":["Frontiers Media"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in Computer Science","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G3601516360","display_name":null,"funder_award_id":"Brazil","funder_id":"https://openalex.org/F4320322025","funder_display_name":"Conselho Nacional de Desenvolvimento Cient\u00edfico e Tecnol\u00f3gico"},{"id":"https://openalex.org/G4042541380","display_name":null,"funder_award_id":"23038.028816/2016-41","funder_id":"https://openalex.org/F4320321091","funder_display_name":"Coordena\u00e7\u00e3o de Aperfei\u00e7oamento de Pessoal de N\u00edvel Superior"},{"id":"https://openalex.org/G4498765857","display_name":null,"funder_award_id":"407235/2017-5","funder_id":"https://openalex.org/F4320322025","funder_display_name":"Conselho Nacional de Desenvolvimento Cient\u00edfico e Tecnol\u00f3gico"},{"id":"https://openalex.org/G642471327","display_name":null,"funder_award_id":"313687/2020-0","funder_id":"https://openalex.org/F4320322025","funder_display_name":"Conselho Nacional de Desenvolvimento Cient\u00edfico e Tecnol\u00f3gico"}],"funders":[{"id":"https://openalex.org/F4320321091","display_name":"Coordena\u00e7\u00e3o de Aperfei\u00e7oamento de Pessoal de N\u00edvel Superior","ror":"https://ror.org/00x0ma614"},{"id":"https://openalex.org/F4320322025","display_name":"Conselho Nacional de Desenvolvimento Cient\u00edfico e Tecnol\u00f3gico","ror":"https://ror.org/03swz6y49"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4311858218.pdf","grobid_xml":"https://content.openalex.org/works/W4311858218.grobid-xml"},"referenced_works_count":43,"referenced_works":["https://openalex.org/W105055379","https://openalex.org/W1482134990","https://openalex.org/W1495629237","https://openalex.org/W1509087931","https://openalex.org/W1564594068","https://openalex.org/W1616316822","https://openalex.org/W1967291753","https://openalex.org/W1982731949","https://openalex.org/W1985585837","https://openalex.org/W1996131467","https://openalex.org/W2060849841","https://openalex.org/W2087884275","https://openalex.org/W2091803577","https://openalex.org/W2113827629","https://openalex.org/W2137105308","https://openalex.org/W2164938362","https://openalex.org/W2299775049","https://openalex.org/W2524766217","https://openalex.org/W2556922129","https://openalex.org/W2559158530","https://openalex.org/W2787379525","https://openalex.org/W2794355565","https://openalex.org/W3161906559","https://openalex.org/W4286779051","https://openalex.org/W6603244533","https://openalex.org/W6629168442","https://openalex.org/W6630141714","https://openalex.org/W6631806096","https://openalex.org/W6633550922","https://openalex.org/W6634060246","https://openalex.org/W6636609317","https://openalex.org/W6638491564","https://openalex.org/W6648913422","https://openalex.org/W6671400743","https://openalex.org/W6682626388","https://openalex.org/W6685335215","https://openalex.org/W6688089508","https://openalex.org/W6737072525","https://openalex.org/W6755114976","https://openalex.org/W6769257125","https://openalex.org/W6784600945","https://openalex.org/W6802864343","https://openalex.org/W7038569529"],"related_works":["https://openalex.org/W2164325773","https://openalex.org/W1988219071","https://openalex.org/W1980059732","https://openalex.org/W4376487525","https://openalex.org/W2944176638","https://openalex.org/W2076627162","https://openalex.org/W1534770425","https://openalex.org/W2025827964","https://openalex.org/W18357144","https://openalex.org/W2414890876"],"abstract_inverted_index":{"Forward":[0],"engineering":[1,91],"relational":[2,53],"schemas":[3],"based":[4],"on":[5,47,55,172],"conceptual":[6,44,74],"models":[7,178],"(in":[8],"languages":[9,46],"such":[10],"as":[11,101,162],"UML":[12],"and":[13,28,51,114],"ER)":[14],"is":[15,62,76,152],"an":[16,181],"established":[17],"practice,":[18],"with":[19,95],"several":[20],"automated":[21,149],"transformation":[22,80,127,150,168],"approaches":[23],"discussed":[24],"in":[25,30,78,107,180],"the":[26,37,40,48,52,56,64,69,72,79,96,110,125,156,160,167],"literature":[27],"implemented":[29,100],"production":[31],"tools.":[32],"These":[33],"transformations":[34],"must":[35],"bridge":[36],"gap":[38],"between":[39],"primitives":[41],"offered":[42],"by":[43,89],"modeling":[45],"one":[49,133,137,142],"hand":[50],"model":[54,75,183],"other.":[57],"As":[58],"a":[59],"result,":[60],"it":[61],"often":[63],"case":[65],"that":[66,154],"some":[67],"of":[68,71,109,112,116,124,159,174],"semantics":[70],"source":[73],"lost":[77],"process.":[81,169],"In":[82],"this":[83,87,175],"paper,":[84],"we":[85],"address":[86],"problem":[88],"forward":[90],"additional":[92],"constraints":[93],"along":[94],"transformed":[97],"schema":[98],"(ultimately":[99],"triggers).":[102],"We":[103,170],"formulate":[104],"our":[105,120],"approach":[106,121],"terms":[108],"operations":[111,161],"\u201cflattening\u201d":[113],"\u201clifting\u201d":[115],"classes":[117],"to":[118],"make":[119],"largely":[122],"independent":[123],"particular":[126],"strategy":[128],"(one":[129],"table":[130,134,138,143],"per":[131,135,139,144],"hierarchy,":[132],"class,":[136,141,146],"concrete":[140],"leaf":[145],"etc.).":[147],"An":[148],"tool":[151,176],"provided":[153],"traces":[155],"cumulative":[157],"consequences":[158],"they":[163],"are":[164],"applied":[165],"throughout":[166],"report":[171],"tests":[173],"using":[177],"published":[179],"open":[182],"repository.":[184]},"counts_by_year":[{"year":2024,"cited_by_count":1}],"updated_date":"2026-03-17T17:19:04.345684","created_date":"2025-10-10T00:00:00"}