{"id":"https://openalex.org/W2810444424","doi":"https://doi.org/10.1109/codit.2018.8394889","title":"Ontologies and Relational Databases Meta-Schema Design: a Three-Level Unified Lifecycle","display_name":"Ontologies and Relational Databases Meta-Schema Design: a Three-Level Unified Lifecycle","publication_year":2018,"publication_date":"2018-04-01","ids":{"openalex":"https://openalex.org/W2810444424","doi":"https://doi.org/10.1109/codit.2018.8394889","mag":"2810444424"},"language":"en","primary_location":{"id":"doi:10.1109/codit.2018.8394889","is_oa":false,"landing_page_url":"https://doi.org/10.1109/codit.2018.8394889","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2018 5th International Conference on Control, Decision and Information Technologies (CoDIT)","raw_type":"proceedings-article"},"type":"article","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/A5039620350","display_name":"Oumar Sy","orcid":null},"institutions":[{"id":"https://openalex.org/I112713213","display_name":"Universit\u00e9 Gaston Berger","ror":"https://ror.org/01jp0tk64","country_code":"SN","type":"education","lineage":["https://openalex.org/I112713213"]}],"countries":["SN"],"is_corresponding":true,"raw_author_name":"Oumar Sy","raw_affiliation_strings":["Section d'Informatique U.F.R SAT, Universit\u00e9 Gaston Berger, Saint-Louis, S\u00e9n\u00e9gal"],"affiliations":[{"raw_affiliation_string":"Section d'Informatique U.F.R SAT, Universit\u00e9 Gaston Berger, Saint-Louis, S\u00e9n\u00e9gal","institution_ids":["https://openalex.org/I112713213"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041239977","display_name":"Denio Duarte","orcid":"https://orcid.org/0000-0003-4936-4748"},"institutions":[{"id":"https://openalex.org/I3130004620","display_name":"Universidade Federal da Fronteira Sul","ror":"https://ror.org/03z9wm572","country_code":"BR","type":"education","lineage":["https://openalex.org/I3130004620"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Denio Duarte","raw_affiliation_strings":["LAD - Ci\u00eancia da Computa\u00e7\u00e3o, Universidade Federal da Fronteria Sul, Chapec\u00f3, Brazil"],"affiliations":[{"raw_affiliation_string":"LAD - Ci\u00eancia da Computa\u00e7\u00e3o, Universidade Federal da Fronteria Sul, Chapec\u00f3, Brazil","institution_ids":["https://openalex.org/I3130004620"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5073892181","display_name":"Guilherme Dal Bianco","orcid":"https://orcid.org/0000-0001-8753-765X"},"institutions":[{"id":"https://openalex.org/I3130004620","display_name":"Universidade Federal da Fronteira Sul","ror":"https://ror.org/03z9wm572","country_code":"BR","type":"education","lineage":["https://openalex.org/I3130004620"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Guilherme Dal Bianco","raw_affiliation_strings":["LAD - Ci\u00eancia da Computa\u00e7\u00e3o, Universidade Federal da Fronteria Sul, Chapec\u00f3, Brazil"],"affiliations":[{"raw_affiliation_string":"LAD - Ci\u00eancia da Computa\u00e7\u00e3o, Universidade Federal da Fronteria Sul, Chapec\u00f3, Brazil","institution_ids":["https://openalex.org/I3130004620"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5039620350"],"corresponding_institution_ids":["https://openalex.org/I112713213"],"apc_list":null,"apc_paid":null,"fwci":0.3258,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.66682033,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"518","last_page":"523"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9998999834060669,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9998999834060669,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9990000128746033,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9932000041007996,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8019630908966064},{"id":"https://openalex.org/keywords/ontology","display_name":"Ontology","score":0.5945261716842651},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5765208005905151},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5628364682197571},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.5615642070770264},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.5453199744224548},{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.45865604281425476},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.42985260486602783},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4054604768753052},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3791211247444153},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3345431685447693},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.3303726613521576},{"id":"https://openalex.org/keywords/knowledge-management","display_name":"Knowledge management","score":0.32269853353500366}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8019630908966064},{"id":"https://openalex.org/C25810664","wikidata":"https://www.wikidata.org/wiki/Q44325","display_name":"Ontology","level":2,"score":0.5945261716842651},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5765208005905151},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5628364682197571},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.5615642070770264},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.5453199744224548},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.45865604281425476},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.42985260486602783},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4054604768753052},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3791211247444153},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3345431685447693},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.3303726613521576},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.32269853353500366},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"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/C138496976","wikidata":"https://www.wikidata.org/wiki/Q175002","display_name":"Developmental psychology","level":1,"score":0.0},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/codit.2018.8394889","is_oa":false,"landing_page_url":"https://doi.org/10.1109/codit.2018.8394889","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2018 5th International Conference on Control, Decision and Information Technologies (CoDIT)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Responsible consumption and production","score":0.4099999964237213,"id":"https://metadata.un.org/sdg/12"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W2736728","https://openalex.org/W153886719","https://openalex.org/W173647602","https://openalex.org/W814530071","https://openalex.org/W1518949134","https://openalex.org/W1533737886","https://openalex.org/W1556809471","https://openalex.org/W2027614922","https://openalex.org/W2042037135","https://openalex.org/W2086832220","https://openalex.org/W2101528069","https://openalex.org/W2120603005","https://openalex.org/W2153832848","https://openalex.org/W2208222201"],"related_works":["https://openalex.org/W2591891926","https://openalex.org/W290184810","https://openalex.org/W2007556552","https://openalex.org/W2208604","https://openalex.org/W1501673548","https://openalex.org/W2092382494","https://openalex.org/W2955692919","https://openalex.org/W2091588998","https://openalex.org/W2077777521","https://openalex.org/W1998046157"],"abstract_inverted_index":{"To":[0,39],"integrate":[1],"ontologies":[2],"and":[3,37,45],"relational":[4,75],"databases,":[5],"in":[6],"this":[7,40],"paper,":[8],"we":[9],"propose":[10],"to":[11,25,57,66],"build":[12],"a":[13,31],"common":[14],"meta-schema":[15],"upon":[16],"an":[17],"overall":[18],"unified":[19],"lifecycle.":[20],"Our":[21],"key":[22],"idea":[23],"is":[24,30,65],"consider":[26],"that":[27,68],"the":[28,34,42,46,51,58,63,82],"database":[29],"model":[32],"for":[33],"domain":[35],"ontology,":[36],"conversely.":[38],"end,":[41],"ontology-based":[43],"knowledge":[44],"business-entities":[47],"are":[48],"merged":[49],"with":[50],"same":[52],"conceptual":[53],"abstractions":[54],"principles,":[55],"according":[56],"three-level":[59],"ANSI/SPARC":[60],"architecture.":[61],"Finally,":[62],"goal":[64],"show":[67],"ontologies'":[69],"features":[70],"can":[71],"be":[72],"managed":[73],"by":[74],"databases.":[76],"A":[77],"case":[78],"of":[79,84],"study":[80],"outlines":[81],"applicability":[83],"our":[85],"approach.":[86]},"counts_by_year":[{"year":2020,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}