{"id":"https://openalex.org/W1640728818","doi":"https://doi.org/10.1109/notere.2015.7293499","title":"Ontological approach for Data WareHouse design","display_name":"Ontological approach for Data WareHouse design","publication_year":2015,"publication_date":"2015-07-01","ids":{"openalex":"https://openalex.org/W1640728818","doi":"https://doi.org/10.1109/notere.2015.7293499","mag":"1640728818"},"language":"en","primary_location":{"id":"doi:10.1109/notere.2015.7293499","is_oa":false,"landing_page_url":"https://doi.org/10.1109/notere.2015.7293499","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 International Conference on Protocol Engineering (ICPE) and International Conference on New Technologies of Distributed Systems (NTDS)","raw_type":"proceedings-article"},"type":"preprint","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/A5106488246","display_name":"Bouchra Aadil","orcid":null},"institutions":[{"id":"https://openalex.org/I99297268","display_name":"University of Hassan II Casablanca","ror":"https://ror.org/001q4kn48","country_code":"MA","type":"education","lineage":["https://openalex.org/I99297268"]}],"countries":["MA"],"is_corresponding":false,"raw_author_name":"Bouchra Aadil","raw_affiliation_strings":["Faculte des sciences, Univ. Hassan II, Casablanca, Maroc","Univ. Hassan II, Facult\u00e9 des sciences, LIAD, 5366, Casablanca, Maroc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculte des sciences, Univ. Hassan II, Casablanca, Maroc","institution_ids":["https://openalex.org/I99297268"]},{"raw_affiliation_string":"Univ. Hassan II, Facult\u00e9 des sciences, LIAD, 5366, Casablanca, Maroc","institution_ids":["https://openalex.org/I99297268"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023581697","display_name":"Abderrahim Ait Wakrime","orcid":"https://orcid.org/0000-0001-9215-6309"},"institutions":[{"id":"https://openalex.org/I12449238","display_name":"Universit\u00e9 d'Orl\u00e9ans","ror":"https://ror.org/014zrew76","country_code":"FR","type":"education","lineage":["https://openalex.org/I12449238"]},{"id":"https://openalex.org/I4210129154","display_name":"Centre Val de Loire","ror":"https://ror.org/03ntmtb29","country_code":"FR","type":"facility","lineage":["https://openalex.org/I4210088668","https://openalex.org/I4210129154"]},{"id":"https://openalex.org/I4210143826","display_name":"Institut National des Sciences Appliqu\u00e9es Centre Val de Loire","ror":"https://ror.org/03y0qc033","country_code":"FR","type":"education","lineage":["https://openalex.org/I4210143826"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Abderrahim Ait Wakrime","raw_affiliation_strings":["Univ. Orleans, INSA Centre Val de Loire, Orl\u00e9ans, France","Univ. Orl\u00e9ans, INSA Centre Val de Loire, LIFO, EA 4022, F-45067, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Univ. Orleans, INSA Centre Val de Loire, Orl\u00e9ans, France","institution_ids":["https://openalex.org/I4210129154","https://openalex.org/I4210143826"]},{"raw_affiliation_string":"Univ. Orl\u00e9ans, INSA Centre Val de Loire, LIFO, EA 4022, F-45067, France","institution_ids":["https://openalex.org/I4210129154","https://openalex.org/I4210143826","https://openalex.org/I12449238"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5081684717","display_name":"Larbi Kzaz","orcid":"https://orcid.org/0000-0003-0019-4784"},"institutions":[{"id":"https://openalex.org/I4210143075","display_name":"Institut Sup\u00e9rieur de Commerce et d'Administration des Entreprises","ror":"https://ror.org/05cedyx57","country_code":"MA","type":"education","lineage":["https://openalex.org/I4210143075"]}],"countries":["MA"],"is_corresponding":false,"raw_author_name":"Larbi Kzaz","raw_affiliation_strings":["Institut superieur de commerce et d'administration des entreprises, Casablanca, Maroc","Institut sup\u00e9rieur de commerce et d'administration des entreprises, Casablanca, Maroc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institut superieur de commerce et d'administration des entreprises, Casablanca, Maroc","institution_ids":["https://openalex.org/I4210143075"]},{"raw_affiliation_string":"Institut sup\u00e9rieur de commerce et d'administration des entreprises, Casablanca, Maroc","institution_ids":["https://openalex.org/I4210143075"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5084610671","display_name":"Abderrahim Sekkaki","orcid":"https://orcid.org/0000-0001-5466-4804"},"institutions":[{"id":"https://openalex.org/I99297268","display_name":"University of Hassan II Casablanca","ror":"https://ror.org/001q4kn48","country_code":"MA","type":"education","lineage":["https://openalex.org/I99297268"]}],"countries":["MA"],"is_corresponding":false,"raw_author_name":"Abderrahim Sekkaki","raw_affiliation_strings":["Faculte des sciences, Univ. Hassan II, Casablanca, Maroc","Univ. Hassan II, Facult\u00e9 des sciences, LIAD, 5366, Casablanca, Maroc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculte des sciences, Univ. Hassan II, Casablanca, Maroc","institution_ids":["https://openalex.org/I99297268"]},{"raw_affiliation_string":"Univ. Hassan II, Facult\u00e9 des sciences, LIAD, 5366, Casablanca, Maroc","institution_ids":["https://openalex.org/I99297268"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.4452,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.75997202,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":"5","issue":null,"first_page":"1","last_page":"7"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9948999881744385,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9933000206947327,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7773787975311279},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.776701807975769},{"id":"https://openalex.org/keywords/ontology","display_name":"Ontology","score":0.7541579008102417},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5402601957321167},{"id":"https://openalex.org/keywords/field","display_name":"Field (mathematics)","score":0.5019180774688721},{"id":"https://openalex.org/keywords/ontology-engineering","display_name":"Ontology engineering","score":0.4694152772426605},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4555938243865967},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.45183029770851135},{"id":"https://openalex.org/keywords/process-ontology","display_name":"Process ontology","score":0.4377897083759308},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.43451520800590515},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.41191619634628296},{"id":"https://openalex.org/keywords/knowledge-management","display_name":"Knowledge management","score":0.38512396812438965},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3535999655723572},{"id":"https://openalex.org/keywords/process-management","display_name":"Process management","score":0.3474685549736023},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.312241792678833},{"id":"https://openalex.org/keywords/systems-engineering","display_name":"Systems engineering","score":0.2049589455127716},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.11199906468391418},{"id":"https://openalex.org/keywords/domain-knowledge","display_name":"Domain knowledge","score":0.11156195402145386}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7773787975311279},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.776701807975769},{"id":"https://openalex.org/C25810664","wikidata":"https://www.wikidata.org/wiki/Q44325","display_name":"Ontology","level":2,"score":0.7541579008102417},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5402601957321167},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.5019180774688721},{"id":"https://openalex.org/C2778820784","wikidata":"https://www.wikidata.org/wiki/Q1027508","display_name":"Ontology engineering","level":4,"score":0.4694152772426605},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4555938243865967},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.45183029770851135},{"id":"https://openalex.org/C137003198","wikidata":"https://www.wikidata.org/wiki/Q7247296","display_name":"Process ontology","level":3,"score":0.4377897083759308},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.43451520800590515},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.41191619634628296},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.38512396812438965},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3535999655723572},{"id":"https://openalex.org/C195094911","wikidata":"https://www.wikidata.org/wiki/Q14167904","display_name":"Process management","level":1,"score":0.3474685549736023},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.312241792678833},{"id":"https://openalex.org/C201995342","wikidata":"https://www.wikidata.org/wiki/Q682496","display_name":"Systems engineering","level":1,"score":0.2049589455127716},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.11199906468391418},{"id":"https://openalex.org/C207685749","wikidata":"https://www.wikidata.org/wiki/Q2088941","display_name":"Domain knowledge","level":2,"score":0.11156195402145386},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","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/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/notere.2015.7293499","is_oa":false,"landing_page_url":"https://doi.org/10.1109/notere.2015.7293499","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 International Conference on Protocol Engineering (ICPE) and International Conference on New Technologies of Distributed Systems (NTDS)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Sustainable cities and communities","id":"https://metadata.un.org/sdg/11","score":0.44999998807907104}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":38,"referenced_works":["https://openalex.org/W56165858","https://openalex.org/W56549917","https://openalex.org/W120683693","https://openalex.org/W171148199","https://openalex.org/W336975910","https://openalex.org/W1495859460","https://openalex.org/W1550039497","https://openalex.org/W1568351876","https://openalex.org/W1969722313","https://openalex.org/W1976507515","https://openalex.org/W1982600306","https://openalex.org/W1988156201","https://openalex.org/W2017782374","https://openalex.org/W2027614922","https://openalex.org/W2052884373","https://openalex.org/W2071058905","https://openalex.org/W2096551070","https://openalex.org/W2108971776","https://openalex.org/W2133109597","https://openalex.org/W2137079713","https://openalex.org/W2143814287","https://openalex.org/W2146674759","https://openalex.org/W2169877238","https://openalex.org/W2186205285","https://openalex.org/W2343295540","https://openalex.org/W2404784718","https://openalex.org/W2407821120","https://openalex.org/W3101661027","https://openalex.org/W4214715179","https://openalex.org/W4391422229","https://openalex.org/W6602288731","https://openalex.org/W6602301714","https://openalex.org/W6604885419","https://openalex.org/W6606962908","https://openalex.org/W6674704728","https://openalex.org/W6713830704","https://openalex.org/W6714297923","https://openalex.org/W6861760492"],"related_works":["https://openalex.org/W4251889114","https://openalex.org/W99134822","https://openalex.org/W1129276663","https://openalex.org/W2490467340","https://openalex.org/W176267515","https://openalex.org/W4255991504","https://openalex.org/W1605751596","https://openalex.org/W3091964813","https://openalex.org/W1576659514","https://openalex.org/W149627178"],"abstract_inverted_index":{"Waste":[0],"management":[1,144],"is":[2,15,75,82,108,121],"a":[3,52,58],"major":[4],"concern":[5],"of":[6,29,34,91],"the":[7,49,68,89,94,117,125,129,138],"various":[8],"policy":[9],"makers,":[10],"economic":[11],"and":[12,25,78,110,132],"social.":[13],"It":[14,81],"present":[16],"each":[17],"time":[18,51],"he":[19],"comes":[20],"to":[21,60,72,137,150],"launching":[22],"development":[23,28],"projects":[24],"/":[26],"or":[27],"urban":[30],"infrastructure.":[31],"The":[32,104,142],"implementation":[33],"Data":[35,62,97],"Warehousing":[36],"assisting":[37],"in":[38,41],"decision":[39],"making":[40],"this":[42],"context,":[43],"proves":[44],"very":[45,53],"useful,":[46],"but":[47],"at":[48],"same":[50],"complex":[54],"task.":[55],"We":[56],"provide":[57],"solution":[59,66],"support":[61],"Warehouse":[63,98],"design.":[64],"Our":[65,96],"combines":[67],"two":[69,102],"classical":[70],"approaches":[71],"design,":[73],"it":[74],"both":[76],"oriented":[77],"need-oriented":[79],"data.":[80],"based":[83],"on":[84,93],"ontology":[85,135],"representation":[86],"languages":[87],"an":[88,134],"results":[90],"work":[92],"alignment.":[95],"design":[99],"process":[100],"has":[101],"stages.":[103],"first":[105,130],"one":[106],"which":[107],"interactive":[109],"semi-automatic,":[111],"transforms":[112],"user":[113],"requirements":[114],"into":[115],"ontologies,":[116],"second":[118],"step":[119,131],"that":[120],"fully":[122],"automatic,":[123],"aligns":[124],"resulting":[126],"ontologies":[127],"from":[128],"produces":[133],"associated":[136],"multidimensional":[139],"data":[140],"model.":[141],"waste":[143],"field":[145],"will":[146],"be":[147],"our":[148,152],"guideline":[149],"illustrate":[151],"approach.":[153]},"counts_by_year":[{"year":2019,"cited_by_count":1},{"year":2016,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}