{"id":"https://openalex.org/W2769372717","doi":"https://doi.org/10.1109/afrcon.2017.8095605","title":"CMCD: A data warehouse modeling framework based on goals and business process models","display_name":"CMCD: A data warehouse modeling framework based on goals and business process models","publication_year":2017,"publication_date":"2017-09-01","ids":{"openalex":"https://openalex.org/W2769372717","doi":"https://doi.org/10.1109/afrcon.2017.8095605","mag":"2769372717"},"language":"en","primary_location":{"id":"doi:10.1109/afrcon.2017.8095605","is_oa":false,"landing_page_url":"https://doi.org/10.1109/afrcon.2017.8095605","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 IEEE AFRICON","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/A5021549929","display_name":"Houda Chakiri","orcid":null},"institutions":[{"id":"https://openalex.org/I81605866","display_name":"Sidi Mohamed Ben Abdellah University","ror":"https://ror.org/04efg9a07","country_code":"MA","type":"education","lineage":["https://openalex.org/I81605866"]}],"countries":["MA"],"is_corresponding":true,"raw_author_name":"Houda Chakiri","raw_affiliation_strings":["Sidi Mohammed Ben Abdellah University, Fez, Morocco"],"affiliations":[{"raw_affiliation_string":"Sidi Mohammed Ben Abdellah University, Fez, Morocco","institution_ids":["https://openalex.org/I81605866"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085525274","display_name":"Mohammed El Mohajir","orcid":"https://orcid.org/0000-0001-6602-0168"},"institutions":[{"id":"https://openalex.org/I81605866","display_name":"Sidi Mohamed Ben Abdellah University","ror":"https://ror.org/04efg9a07","country_code":"MA","type":"education","lineage":["https://openalex.org/I81605866"]}],"countries":["MA"],"is_corresponding":false,"raw_author_name":"Mohammed El Mohajir","raw_affiliation_strings":["Sidi Mohammed Ben Abdellah University, Fez, Morocco"],"affiliations":[{"raw_affiliation_string":"Sidi Mohammed Ben Abdellah University, Fez, Morocco","institution_ids":["https://openalex.org/I81605866"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5025941726","display_name":"Nasser Assem","orcid":null},"institutions":[{"id":"https://openalex.org/I47844","display_name":"Al Akhawayn University","ror":"https://ror.org/03erkev52","country_code":"MA","type":"education","lineage":["https://openalex.org/I47844"]}],"countries":["MA"],"is_corresponding":false,"raw_author_name":"Nasser Assem","raw_affiliation_strings":["Al Akhawayn University in Ifrane, Morocco"],"affiliations":[{"raw_affiliation_string":"Al Akhawayn University in Ifrane, Morocco","institution_ids":["https://openalex.org/I47844"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5021549929"],"corresponding_institution_ids":["https://openalex.org/I81605866"],"apc_list":null,"apc_paid":null,"fwci":0.5851,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.76548569,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":"9","issue":null,"first_page":"923","last_page":"928"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9983999729156494,"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.9983999729156494,"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.9980000257492065,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9976000189781189,"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/data-warehouse","display_name":"Data warehouse","score":0.8086307048797607},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7023482322692871},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5922518968582153},{"id":"https://openalex.org/keywords/process-management","display_name":"Process management","score":0.5615829825401306},{"id":"https://openalex.org/keywords/conceptual-model","display_name":"Conceptual model","score":0.5540795922279358},{"id":"https://openalex.org/keywords/business-process","display_name":"Business process","score":0.5099307298660278},{"id":"https://openalex.org/keywords/business-process-modeling","display_name":"Business process modeling","score":0.4702640473842621},{"id":"https://openalex.org/keywords/goal-modeling","display_name":"Goal modeling","score":0.44472160935401917},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.44402557611465454},{"id":"https://openalex.org/keywords/process-modeling","display_name":"Process modeling","score":0.4278642535209656},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.41182148456573486},{"id":"https://openalex.org/keywords/knowledge-management","display_name":"Knowledge management","score":0.3875368535518646},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.25099867582321167},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2007961869239807},{"id":"https://openalex.org/keywords/work-in-process","display_name":"Work in process","score":0.19150716066360474},{"id":"https://openalex.org/keywords/requirements-analysis","display_name":"Requirements analysis","score":0.16928070783615112},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.1368161141872406},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.12524446845054626},{"id":"https://openalex.org/keywords/operations-management","display_name":"Operations management","score":0.09217983484268188}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8086307048797607},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7023482322692871},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5922518968582153},{"id":"https://openalex.org/C195094911","wikidata":"https://www.wikidata.org/wiki/Q14167904","display_name":"Process management","level":1,"score":0.5615829825401306},{"id":"https://openalex.org/C13606891","wikidata":"https://www.wikidata.org/wiki/Q2623243","display_name":"Conceptual model","level":2,"score":0.5540795922279358},{"id":"https://openalex.org/C85345410","wikidata":"https://www.wikidata.org/wiki/Q851587","display_name":"Business process","level":3,"score":0.5099307298660278},{"id":"https://openalex.org/C207505557","wikidata":"https://www.wikidata.org/wiki/Q4374012","display_name":"Business process modeling","level":4,"score":0.4702640473842621},{"id":"https://openalex.org/C9586889","wikidata":"https://www.wikidata.org/wiki/Q5575167","display_name":"Goal modeling","level":4,"score":0.44472160935401917},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.44402557611465454},{"id":"https://openalex.org/C76956256","wikidata":"https://www.wikidata.org/wiki/Q27610560","display_name":"Process modeling","level":3,"score":0.4278642535209656},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.41182148456573486},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.3875368535518646},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.25099867582321167},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2007961869239807},{"id":"https://openalex.org/C174998907","wikidata":"https://www.wikidata.org/wiki/Q357662","display_name":"Work in process","level":2,"score":0.19150716066360474},{"id":"https://openalex.org/C59488412","wikidata":"https://www.wikidata.org/wiki/Q187147","display_name":"Requirements analysis","level":3,"score":0.16928070783615112},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.1368161141872406},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.12524446845054626},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.09217983484268188},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","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}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/afrcon.2017.8095605","is_oa":false,"landing_page_url":"https://doi.org/10.1109/afrcon.2017.8095605","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 IEEE AFRICON","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.7400000095367432,"display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W22895703","https://openalex.org/W143919613","https://openalex.org/W1785404346","https://openalex.org/W1891916769","https://openalex.org/W1971323001","https://openalex.org/W2032999854","https://openalex.org/W2098614373","https://openalex.org/W2130891285","https://openalex.org/W2569976192","https://openalex.org/W4243742440","https://openalex.org/W6600954116","https://openalex.org/W6605845850"],"related_works":["https://openalex.org/W2369215403","https://openalex.org/W2587054594","https://openalex.org/W1508412218","https://openalex.org/W2030241121","https://openalex.org/W2003588249","https://openalex.org/W1513469429","https://openalex.org/W2955514960","https://openalex.org/W56352555","https://openalex.org/W2353501069","https://openalex.org/W2369543787"],"abstract_inverted_index":{"The":[0],"decision":[1,32],"making":[2],"process":[3],"is":[4,58,81],"mainly":[5,59],"data":[6],"driven,":[7],"which":[8],"makes":[9],"Data":[10,46],"Warehousing":[11],"play":[12],"a":[13,18,42,82,89,101,132,142],"crucial":[14],"role":[15],"in":[16,151],"providing":[17],"reliable":[19],"and":[20,27,31,73,115,139,146],"efficient":[21],"tool":[22],"to":[23,51,61,95,104,121,136,144],"meet":[24,52],"analytical":[25],"needs":[26],"provide":[28],"end":[29],"users":[30],"makers":[33],"with":[34],"useful":[35],"insights.":[36],"However,":[37],"several":[38],"surveys":[39],"show":[40],"that":[41,98],"significant":[43],"percentage":[44],"of":[45,64,88,100,125,141],"Warehouse":[47],"(DW)":[48],"projects":[49],"fail":[50],"their":[53],"business":[54],"goals.":[55],"Indeed,":[56],"it":[57,130],"due":[60],"the":[62,69,74,86,107,123,137],"lack":[63],"any":[65],"formal":[66],"relationship":[67],"between":[68],"Contextual":[70,93],"Requirements":[71],"analysis":[72],"DW":[75,108,143],"conceptual":[76],"modeling":[77,113],"phase.":[78],"This":[79],"work":[80],"first":[83],"step":[84],"towards":[85],"development":[87,138],"CMCD":[90],"framework":[91],"(from":[92],"Model":[94],"Conceptual":[96],"Design)":[97],"consists":[99],"unified":[102],"approach":[103],"automatically":[105],"extract":[106],"multidimensional":[109],"model":[110],"from":[111],"Goal":[112],"frameworks":[114],"Business":[116],"Process":[117],"Diagrams.":[118],"In":[119],"order":[120],"illustrate":[122],"feasibility":[124],"our":[126],"approach,":[127],"we":[128],"implemented":[129],"within":[131],"case":[133],"study":[134],"related":[135],"implementation":[140],"monitor":[145],"assess":[147],"good":[148],"local":[149,153],"governance":[150],"Moroccan":[152],"municipality":[154],"offices.":[155]},"counts_by_year":[{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}