{"id":"https://openalex.org/W4309116469","doi":"https://doi.org/10.1007/s10115-022-01788-0","title":"Logical design of multi-model data warehouses","display_name":"Logical design of multi-model data warehouses","publication_year":2022,"publication_date":"2022-11-15","ids":{"openalex":"https://openalex.org/W4309116469","doi":"https://doi.org/10.1007/s10115-022-01788-0"},"language":"en","primary_location":{"id":"doi:10.1007/s10115-022-01788-0","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10115-022-01788-0","pdf_url":null,"source":{"id":"https://openalex.org/S81770430","display_name":"Knowledge and Information Systems","issn_l":"0219-1377","issn":["0219-1377","0219-3116"],"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":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Knowledge and Information Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.1007/s10115-022-01788-0","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5022668631","display_name":"Sandro Bimonte","orcid":"https://orcid.org/0000-0003-1727-6954"},"institutions":[{"id":"https://openalex.org/I198244214","display_name":"Universit\u00e9 Clermont Auvergne","ror":"https://ror.org/01a8ajp46","country_code":"FR","type":"education","lineage":["https://openalex.org/I198244214"]},{"id":"https://openalex.org/I4210088668","display_name":"Institut National de Recherche pour l'Agriculture, l'Alimentation et l'Environnement","ror":"https://ror.org/003vg9w96","country_code":"FR","type":"government","lineage":["https://openalex.org/I4210088668"]}],"countries":["FR"],"is_corresponding":true,"raw_author_name":"Sandro Bimonte","raw_affiliation_strings":["INRAE - TSCF, University of Clermont Auvergne, Aubiere, France","UR TSCF - Technologies et syst\u00e8mes d'information pour les agrosyst\u00e8mes (9 avenue Blaise Pascal CS 20085 F-63178 Aubi\u00e8re ; Domaine des Palaquins, F-03150 Montoldre - France)"],"affiliations":[{"raw_affiliation_string":"INRAE - TSCF, University of Clermont Auvergne, Aubiere, France","institution_ids":["https://openalex.org/I198244214","https://openalex.org/I4210088668"]},{"raw_affiliation_string":"UR TSCF - Technologies et syst\u00e8mes d'information pour les agrosyst\u00e8mes (9 avenue Blaise Pascal CS 20085 F-63178 Aubi\u00e8re ; Domaine des Palaquins, F-03150 Montoldre - France)","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042827875","display_name":"Enrico Gallinucci","orcid":"https://orcid.org/0000-0002-0931-4255"},"institutions":[{"id":"https://openalex.org/I9360294","display_name":"University of Bologna","ror":"https://ror.org/01111rn36","country_code":"IT","type":"education","lineage":["https://openalex.org/I9360294"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Enrico Gallinucci","raw_affiliation_strings":["DISI, University of Bologna, Bologna, 40136, Italy","DISI - Department of Computer Science and Engineering [Bologna] (Universit\u00e0 di Bologna Dipartimento di Informatica - Scienza e Ingegneria Mura Anteo Zamboni, 7 40126 Bologna Italiy - Italy)","UNIBO - Alma Mater Studiorum Universit\u00e0 di Bologna = University of Bologna (Via Zamboni, 33 - 40126 Bologna - Italy)"],"affiliations":[{"raw_affiliation_string":"DISI, University of Bologna, Bologna, 40136, Italy","institution_ids":["https://openalex.org/I9360294"]},{"raw_affiliation_string":"DISI - Department of Computer Science and Engineering [Bologna] (Universit\u00e0 di Bologna Dipartimento di Informatica - Scienza e Ingegneria Mura Anteo Zamboni, 7 40126 Bologna Italiy - Italy)","institution_ids":["https://openalex.org/I9360294"]},{"raw_affiliation_string":"UNIBO - Alma Mater Studiorum Universit\u00e0 di Bologna = University of Bologna (Via Zamboni, 33 - 40126 Bologna - Italy)","institution_ids":["https://openalex.org/I9360294"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069793706","display_name":"Patrick Marcel","orcid":"https://orcid.org/0000-0003-3171-1174"},"institutions":[{"id":"https://openalex.org/I110017253","display_name":"Universit\u00e9 de Tours","ror":"https://ror.org/02wwzvj46","country_code":"FR","type":"education","lineage":["https://openalex.org/I110017253"]},{"id":"https://openalex.org/I4210136805","display_name":"Laboratoire d'Informatique Fondamentale et Appliqu\u00e9e de Tours","ror":"https://ror.org/03r938j26","country_code":"FR","type":"facility","lineage":["https://openalex.org/I110017253","https://openalex.org/I4210136805"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Patrick Marcel","raw_affiliation_strings":["LIFAT Laboratory, University of Tours, Tours, France","UT - Universit\u00e9 de Tours (60 rue du Plat d'\u00c9tain, 37020 Tours cedex 1  - France)","LIFAT - Laboratoire d'Informatique Fondamentale et Appliqu\u00e9e de Tours (64, Avenue Jean Portalis, 37200 Tours - France)"],"affiliations":[{"raw_affiliation_string":"LIFAT Laboratory, University of Tours, Tours, France","institution_ids":["https://openalex.org/I4210136805","https://openalex.org/I110017253"]},{"raw_affiliation_string":"UT - Universit\u00e9 de Tours (60 rue du Plat d'\u00c9tain, 37020 Tours cedex 1  - France)","institution_ids":["https://openalex.org/I110017253"]},{"raw_affiliation_string":"LIFAT - Laboratoire d'Informatique Fondamentale et Appliqu\u00e9e de Tours (64, Avenue Jean Portalis, 37200 Tours - France)","institution_ids":["https://openalex.org/I4210136805"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5009924329","display_name":"Stefano Rizzi","orcid":"https://orcid.org/0000-0002-4617-217X"},"institutions":[{"id":"https://openalex.org/I9360294","display_name":"University of Bologna","ror":"https://ror.org/01111rn36","country_code":"IT","type":"education","lineage":["https://openalex.org/I9360294"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Stefano Rizzi","raw_affiliation_strings":["DISI, University of Bologna, Bologna, 40136, Italy","UNIBO - Alma Mater Studiorum Universit\u00e0 di Bologna = University of Bologna (Via Zamboni, 33 - 40126 Bologna - Italy)","DISI - Department of Computer Science and Engineering [Bologna] (Universit\u00e0 di Bologna Dipartimento di Informatica - Scienza e Ingegneria Mura Anteo Zamboni, 7 40126 Bologna Italiy - Italy)"],"affiliations":[{"raw_affiliation_string":"DISI, University of Bologna, Bologna, 40136, Italy","institution_ids":["https://openalex.org/I9360294"]},{"raw_affiliation_string":"UNIBO - Alma Mater Studiorum Universit\u00e0 di Bologna = University of Bologna (Via Zamboni, 33 - 40126 Bologna - Italy)","institution_ids":["https://openalex.org/I9360294"]},{"raw_affiliation_string":"DISI - Department of Computer Science and Engineering [Bologna] (Universit\u00e0 di Bologna Dipartimento di Informatica - Scienza e Ingegneria Mura Anteo Zamboni, 7 40126 Bologna Italiy - Italy)","institution_ids":["https://openalex.org/I9360294"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5022668631"],"corresponding_institution_ids":["https://openalex.org/I198244214","https://openalex.org/I4210088668"],"apc_list":{"value":2290,"currency":"EUR","value_usd":2890},"apc_paid":{"value":2290,"currency":"EUR","value_usd":2890},"fwci":2.1291,"has_fulltext":true,"cited_by_count":15,"citation_normalized_percentile":{"value":0.87806265,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":98,"max":99},"biblio":{"volume":"65","issue":"3","first_page":"1067","last_page":"1103"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998999834060669,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998999834060669,"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"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9994000196456909,"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/T11106","display_name":"Data Management and Algorithms","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/online-analytical-processing","display_name":"Online analytical processing","score":0.8512272238731384},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8261657357215881},{"id":"https://openalex.org/keywords/logical-data-model","display_name":"Logical data model","score":0.8074253797531128},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8035832643508911},{"id":"https://openalex.org/keywords/data-model","display_name":"Data model (GIS)","score":0.5397897362709045},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5001599788665771},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4775436818599701},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.468395471572876},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.4674067795276642},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4573485553264618},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.4470958113670349},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.41798219084739685},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4057922661304474},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4005031883716583},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1531238853931427},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.12086477875709534}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.8512272238731384},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8261657357215881},{"id":"https://openalex.org/C203702819","wikidata":"https://www.wikidata.org/wiki/Q17146953","display_name":"Logical data model","level":3,"score":0.8074253797531128},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8035832643508911},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.5397897362709045},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5001599788665771},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4775436818599701},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.468395471572876},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.4674067795276642},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4573485553264618},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.4470958113670349},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.41798219084739685},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4057922661304474},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4005031883716583},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1531238853931427},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12086477875709534},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1007/s10115-022-01788-0","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10115-022-01788-0","pdf_url":null,"source":{"id":"https://openalex.org/S81770430","display_name":"Knowledge and Information Systems","issn_l":"0219-1377","issn":["0219-1377","0219-3116"],"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":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Knowledge and Information Systems","raw_type":"journal-article"},{"id":"pmh:oai:HAL:hal-04072544v1","is_oa":true,"landing_page_url":"https://hal.inrae.fr/hal-04072544","pdf_url":"https://hal.inrae.fr/hal-04072544/document","source":{"id":"https://openalex.org/S4406922466","display_name":"SPIRE - Sciences Po Institutional REpository","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":"Knowledge and Information Systems (KAIS), 2023, 65 (3), pp.1067-1103. ⟨10.1007/s10115-022-01788-0⟩","raw_type":"Journal articles"},{"id":"pmh:oai:cris.unibo.it:11585/915602","is_oa":true,"landing_page_url":"https://link.springer.com/article/10.1007/s10115-022-01788-0","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10115-022-01788-0.pdf","source":{"id":"https://openalex.org/S4306402579","display_name":"Archivio istituzionale della ricerca (Alma Mater Studiorum Universit\u00e0 di Bologna)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210117483","host_organization_name":"Istituto di Ematologia di Bologna","host_organization_lineage":["https://openalex.org/I4210117483"],"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":"","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.1007/s10115-022-01788-0","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10115-022-01788-0","pdf_url":null,"source":{"id":"https://openalex.org/S81770430","display_name":"Knowledge and Information Systems","issn_l":"0219-1377","issn":["0219-1377","0219-3116"],"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":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Knowledge and Information Systems","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G5212034770","display_name":null,"funder_award_id":"ANR-20-PCPA-0002","funder_id":"https://openalex.org/F4320320883","funder_display_name":"Agence Nationale de la Recherche"},{"id":"https://openalex.org/G7882066261","display_name":null,"funder_award_id":"20-PCPA-0002","funder_id":"https://openalex.org/F4320320883","funder_display_name":"Agence Nationale de la Recherche"}],"funders":[{"id":"https://openalex.org/F4320320883","display_name":"Agence Nationale de la Recherche","ror":"https://ror.org/00rbzpz17"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":35,"referenced_works":["https://openalex.org/W37539912","https://openalex.org/W57116089","https://openalex.org/W1576208511","https://openalex.org/W1578512165","https://openalex.org/W1971509121","https://openalex.org/W1988952716","https://openalex.org/W2124582661","https://openalex.org/W2124967786","https://openalex.org/W2146138848","https://openalex.org/W2168849769","https://openalex.org/W2277810561","https://openalex.org/W2296255490","https://openalex.org/W2392135823","https://openalex.org/W2435931733","https://openalex.org/W2507499672","https://openalex.org/W2511992115","https://openalex.org/W2518094867","https://openalex.org/W2523955029","https://openalex.org/W2547173573","https://openalex.org/W2741674363","https://openalex.org/W2769536418","https://openalex.org/W2911731033","https://openalex.org/W2917247870","https://openalex.org/W2947405220","https://openalex.org/W2967970042","https://openalex.org/W2982059824","https://openalex.org/W2982629221","https://openalex.org/W2982676286","https://openalex.org/W2993529020","https://openalex.org/W2996147033","https://openalex.org/W3031095837","https://openalex.org/W3105473355","https://openalex.org/W3122656612","https://openalex.org/W3128828942","https://openalex.org/W3198225051"],"related_works":["https://openalex.org/W4297044271","https://openalex.org/W2366328410","https://openalex.org/W216498800","https://openalex.org/W3113909106","https://openalex.org/W2390641883","https://openalex.org/W3085938636","https://openalex.org/W2365424496","https://openalex.org/W3117242199","https://openalex.org/W2008120802","https://openalex.org/W2356642811"],"abstract_inverted_index":{"Abstract":[0],"Multi-model":[1],"DBMSs,":[2],"which":[3],"support":[4],"different":[5],"data":[6,20,29,100],"models":[7],"with":[8],"a":[9,68,90,147,161],"fully":[10],"integrated":[11],"backend,":[12],"have":[13],"been":[14],"shown":[15],"to":[16,19,31,88],"be":[17,45],"beneficial":[18],"warehouses":[21,101],"and":[22,80,117,128,130,144,151],"OLAP":[23],"systems.":[24],"Indeed,":[25,66],"they":[26],"can":[27,106],"store":[28],"according":[30],"the":[32,37,48,59,75,95,104,108],"multidimensional":[33,135,169],"model":[34,124],"and,":[35],"at":[36],"same":[38],"time,":[39],"let":[40],"each":[41,123,132],"of":[42,61,78,84,92,98,134,149,168],"its":[43],"elements":[44],"represented":[46],"through":[47],"most":[49],"appropriate":[50],"model.":[51],"An":[52],"open":[53],"challenge":[54],"in":[55,67],"this":[56,85,120],"context":[57],"is":[58,87],"lack":[60],"methods":[62],"for":[63,74,94,122,131],"logical":[64,76,96],"design.":[65],"multi-model":[69,99],"context,":[70],"several":[71],"alternatives":[72],"emerge":[73],"representation":[77],"dimensions":[79],"facts.":[81],"The":[82,154],"goal":[83],"paper":[86],"devise":[89],"set":[91,148],"guidelines":[93,156],"design":[97],"so":[102],"that":[103,164],"designer":[105],"achieve":[107],"best":[109],"trade-off":[110],"between":[111],"features":[112],"such":[113],"as":[114],"querying,":[115],"storage,":[116],"ETL.":[118],"To":[119],"end,":[121],"considered":[125],"(relational,":[126],"document-based,":[127],"graph-based)":[129],"type":[133],"element":[136],"(e.g.,":[137],"non-strict":[138],"hierarchy)":[139],"we":[140],"propose":[141],"some":[142],"solutions":[143],"carry":[145],"out":[146],"intra-model":[150],"inter-model":[152],"comparisons.":[153],"resulting":[155],"are":[157],"then":[158],"tested":[159],"on":[160],"case":[162],"study":[163],"shows":[165],"all":[166],"types":[167],"elements.":[170]},"counts_by_year":[{"year":2024,"cited_by_count":8},{"year":2023,"cited_by_count":7}],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}