{"id":"https://openalex.org/W4390950816","doi":"https://doi.org/10.30880/jscdm.2022.03.01.005","title":"Analyses the Performance of Data Warehouse Architecture Types","display_name":"Analyses the Performance of Data Warehouse Architecture Types","publication_year":2022,"publication_date":"2022-06-01","ids":{"openalex":"https://openalex.org/W4390950816","doi":"https://doi.org/10.30880/jscdm.2022.03.01.005"},"language":"en","primary_location":{"id":"doi:10.30880/jscdm.2022.03.01.005","doi":"https://doi.org/10.30880/jscdm.2022.03.01.005","is_oa":true,"landing_page_url":"https://doi.org/10.30880/jscdm.2022.03.01.005","pdf_url":"https://publisher.uthm.edu.my/ojs/index.php/jscdm/article/download/9561/4999/72702","source":{"id":"https://openalex.org/S4210211867","display_name":"Journal of Soft Computing and Data Mining","issn_l":"2716-621X","issn":["2716-621X"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310322246","host_organization_name":"Penerbit UTHM","host_organization_lineage":["https://openalex.org/P4310322246"],"host_organization_lineage_names":["Penerbit UTHM"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Soft Computing and Data Mining","raw_type":"journal-article"},"volume":null,"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://publisher.uthm.edu.my/ojs/index.php/jscdm/article/download/9561/4999/72702","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5024585533","display_name":"Karwan Jameel Merceedi","orcid":"https://orcid.org/0000-0002-9360-7893","observed_orcids":["https://orcid.org/0000-0002-9360-7893"]},"institutions":[{"id":"https://openalex.org/I4210124331","display_name":"Duhok Polytechnic University","ror":"https://ror.org/024kjbt21","country_code":"IQ","type":"education","lineage":["https://openalex.org/I4210124331"]}],"countries":["IQ"],"is_corresponding":false,"raw_author_name":"Karwn Jameel Merceedi","raw_affiliation_strings":["Duhuk Polytechnic University, Information Technology Management, Duhok, IRAQ"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Duhuk Polytechnic University, Information Technology Management, Duhok, IRAQ","institution_ids":["https://openalex.org/I4210124331"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5013710779","display_name":"Abdulmajeed Adil Yazdeen","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210124331","display_name":"Duhok Polytechnic University","ror":"https://ror.org/024kjbt21","country_code":"IQ","type":"education","lineage":["https://openalex.org/I4210124331"]}],"countries":["IQ"],"is_corresponding":false,"raw_author_name":"Abdulmajeed Adil Yazdeen","raw_affiliation_strings":["Duhuk Polytechnic University, Information Technology Management, Duhok, IRAQ"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Duhuk Polytechnic University, Information Technology Management, Duhok, IRAQ","institution_ids":["https://openalex.org/I4210124331"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113098074","display_name":"Abass Kh. Ibrahim","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I36162470","display_name":"University of Zakho","ror":"https://ror.org/05sd1pz50","country_code":"IQ","type":"education","lineage":["https://openalex.org/I36162470"]}],"countries":["IQ"],"is_corresponding":false,"raw_author_name":"Abass Kh. Ibrahim","raw_affiliation_strings":["University of Zakho ,","University of Zakho, Petroleum Engineering, Duhok, IRAQ"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Zakho ,","institution_ids":["https://openalex.org/I36162470"]},{"raw_affiliation_string":"University of Zakho, Petroleum Engineering, Duhok, IRAQ","institution_ids":["https://openalex.org/I36162470"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064075589","display_name":"Maiwan Bahjat Abdulrazzaq","orcid":"https://orcid.org/0000-0001-8226-3565","observed_orcids":["https://orcid.org/0000-0001-8226-3565"]},"institutions":[{"id":"https://openalex.org/I36162470","display_name":"University of Zakho","ror":"https://ror.org/05sd1pz50","country_code":"IQ","type":"education","lineage":["https://openalex.org/I36162470"]}],"countries":["IQ"],"is_corresponding":false,"raw_author_name":"Maiwan Bahjat Abdulrazzaq","raw_affiliation_strings":["Petroleum Engineering , Duhok , IRAQ","University of Zakho, Computer Science, Duhok, IRAQ"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Petroleum Engineering , Duhok , IRAQ","institution_ids":[]},{"raw_affiliation_string":"University of Zakho, Computer Science, Duhok, IRAQ","institution_ids":["https://openalex.org/I36162470"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5064854502","display_name":"Mayyadah Ramiz Mahmood","orcid":"https://orcid.org/0000-0002-7803-4097","observed_orcids":["https://orcid.org/0000-0002-7803-4097"]},"institutions":[{"id":"https://openalex.org/I36162470","display_name":"University of Zakho","ror":"https://ror.org/05sd1pz50","country_code":"IQ","type":"education","lineage":["https://openalex.org/I36162470"]}],"countries":["IQ"],"is_corresponding":false,"raw_author_name":"Mayyadah Ramiz Mahmood","raw_affiliation_strings":["University of Zakho, Computer Science, Duhok, IRAQ"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Zakho, Computer Science, Duhok, IRAQ","institution_ids":["https://openalex.org/I36162470"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.1266,"has_fulltext":true,"cited_by_count":13,"citation_normalized_percentile":{"value":0.92034877,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"3","issue":"1","first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9789999723434448,"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"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9789999723434448,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.019300000742077827,"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/T10101","display_name":"Cloud Computing and Resource Management","score":9.999999747378752e-05,"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/data-warehouse-architecture","display_name":"data warehouse architecture","score":0.9779999852180481},{"id":"https://openalex.org/keywords/performance-comparison","display_name":"performance comparison","score":0.6420000195503235},{"id":"https://openalex.org/keywords/decision-support-system","display_name":"decision support system","score":0.6729999780654907},{"id":"https://openalex.org/keywords/etl","display_name":"ETL","score":0.6169999837875366},{"id":"https://openalex.org/keywords/data-extraction-transformation-and-loading","display_name":"data extraction, transformation and loading","score":0.7620000243186951},{"id":"https://openalex.org/keywords/historical-data-storage","display_name":"historical data storage","score":0.7990000247955322},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"online transaction processing","score":0.7200000286102295},{"id":"https://openalex.org/keywords/database-management-systems","display_name":"database management systems","score":0.7039999961853027}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8291294574737549},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7459931969642639},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6766799688339233},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.5558894276618958},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.520715057849884},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.4876333773136139},{"id":"https://openalex.org/C206729178","wikidata":"https://www.wikidata.org/wiki/Q2271896","display_name":"Scheduling (production processes)","level":2,"score":0.45246410369873047},{"id":"https://openalex.org/C94070970","wikidata":"https://www.wikidata.org/wiki/Q638422","display_name":"Data architecture","level":5,"score":0.44985827803611755},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.42065560817718506},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.38888680934906006},{"id":"https://openalex.org/C55356503","wikidata":"https://www.wikidata.org/wiki/Q2136675","display_name":"Reference architecture","level":4,"score":0.22198665142059326},{"id":"https://openalex.org/C35869016","wikidata":"https://www.wikidata.org/wiki/Q846636","display_name":"Software architecture","level":3,"score":0.17256703972816467},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.13768398761749268},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.09377989172935486},{"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/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.30880/jscdm.2022.03.01.005","doi":"https://doi.org/10.30880/jscdm.2022.03.01.005","is_oa":true,"landing_page_url":"https://doi.org/10.30880/jscdm.2022.03.01.005","pdf_url":"https://publisher.uthm.edu.my/ojs/index.php/jscdm/article/download/9561/4999/72702","source":{"id":"https://openalex.org/S4210211867","display_name":"Journal of Soft Computing and Data Mining","issn_l":"2716-621X","issn":["2716-621X"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310322246","host_organization_name":"Penerbit UTHM","host_organization_lineage":["https://openalex.org/P4310322246"],"host_organization_lineage_names":["Penerbit UTHM"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Soft Computing and Data Mining","raw_type":"journal-article"},{"id":"pmh:oai:journal.uthm.edu.my:article/9561","doi":null,"is_oa":true,"landing_page_url":"https://journal.uthm.edu.my/index.php/jscdm/article/view/9561","pdf_url":"https://journal.uthm.edu.my/index.php/jscdm/article/download/9561/4999","source":{"id":"https://openalex.org/S4306401124","display_name":"International Journal of Sustainable Construction Engineering and Technology (Universiti Tun Hussein Onn Malaysia)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I930072361","host_organization_name":"Tun Hussein Onn University of Malaysia","host_organization_lineage":["https://openalex.org/I930072361"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"2716-621X","raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:oai:publisher.uthm.edu.my:article/9561","doi":null,"is_oa":true,"landing_page_url":"http://penerbit.uthm.edu.my/ojs/index.php/jscdm/article/view/9561","pdf_url":null,"source":{"id":"https://openalex.org/S4306401124","display_name":"International Journal of Sustainable Construction Engineering and Technology (Universiti Tun Hussein Onn Malaysia)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I930072361","host_organization_name":"Tun Hussein Onn University of Malaysia","host_organization_lineage":["https://openalex.org/I930072361"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"2716-621X","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.30880/jscdm.2022.03.01.005","doi":"https://doi.org/10.30880/jscdm.2022.03.01.005","is_oa":true,"landing_page_url":"https://doi.org/10.30880/jscdm.2022.03.01.005","pdf_url":"https://publisher.uthm.edu.my/ojs/index.php/jscdm/article/download/9561/4999/72702","source":{"id":"https://openalex.org/S4210211867","display_name":"Journal of Soft Computing and Data Mining","issn_l":"2716-621X","issn":["2716-621X"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310322246","host_organization_name":"Penerbit UTHM","host_organization_lineage":["https://openalex.org/P4310322246"],"host_organization_lineage_names":["Penerbit UTHM"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Soft Computing and Data Mining","raw_type":"journal-article"},"sustainable_development_goals":[],"sustainable_development_goals_aurora":[{"display_name":"Industry, innovation and infrastructure","score":0.6200000047683716,"id":"https://metadata.un.org/sdg/9"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4390950816.pdf","grobid_xml":"https://content.openalex.org/works/W4390950816.grobid-xml"},"referenced_works_count":37,"referenced_works":["https://openalex.org/W2085106021","https://openalex.org/W2234529385","https://openalex.org/W2343415708","https://openalex.org/W2487364358","https://openalex.org/W2565403796","https://openalex.org/W2584003902","https://openalex.org/W2590085425","https://openalex.org/W2602302047","https://openalex.org/W2734602614","https://openalex.org/W2734854752","https://openalex.org/W2735063176","https://openalex.org/W2743496276","https://openalex.org/W2758167683","https://openalex.org/W2789928062","https://openalex.org/W2790077668","https://openalex.org/W2805754290","https://openalex.org/W2807862701","https://openalex.org/W2886800397","https://openalex.org/W2900616909","https://openalex.org/W2908042729","https://openalex.org/W2921414871","https://openalex.org/W2934258137","https://openalex.org/W2946871011","https://openalex.org/W2946924440","https://openalex.org/W2955360505","https://openalex.org/W2977650781","https://openalex.org/W3009363854","https://openalex.org/W3037032595","https://openalex.org/W3043391392","https://openalex.org/W3043594613","https://openalex.org/W3046810235","https://openalex.org/W3082688266","https://openalex.org/W3153430435","https://openalex.org/W3165846814","https://openalex.org/W4236525153","https://openalex.org/W4240144763","https://openalex.org/W4246652936"],"related_works":["https://openalex.org/W7214482581","https://openalex.org/W7128486873","https://openalex.org/W2491657417","https://openalex.org/W4206168757","https://openalex.org/W4396875251","https://openalex.org/W2900186403","https://openalex.org/W2066256061","https://openalex.org/W7098373428","https://openalex.org/W4399567193","https://openalex.org/W176167712"],"abstract_inverted_index":{"The":[0,44,158],"concept":[1],"of":[2,32,73,86,92,112,143,174],"storing":[3],"historical":[4,23],"data":[5,24,39,45,67,145,166,188],"for":[6,22,36,55,97],"retrieving":[7],"them":[8],"when":[9],"needed":[10],"has":[11],"been":[12],"conceived,":[13],"and":[14,51,58,104,109,150,163,170,181],"the":[15,30,48,66,83,89,98,113,141,144,165,171,175,179],"idea":[16],"was":[17],"primitive":[18],"to":[19,25,123,186],"build":[20,187],"repositories":[21],"store":[26],"these":[27,38],"data,":[28],"despite":[29],"use":[31],"a":[33],"specific":[34],"technique":[35],"recovering":[37],"from":[40,167],"various":[41],"storage":[42,68],"modes.":[43],"warehouse":[46,146,189],"is":[47,63],"most":[49],"reliable":[50],"widely":[52],"used":[53,185],"technology":[54],"scheduling,":[56],"forecasting,":[57],"managing":[59],"corporations.":[60],"Also,":[61],"it":[62],"concerned":[64],"with":[65],"facility":[69],"that":[70],"extensive":[71],"collection":[72],"data.":[74],"Data":[75],"warehouses":[76],"are":[77,106],"called":[78],"ancient":[79],"modern":[80],"techniques;":[81],"since":[82],"early":[84],"days":[85],"relational":[87],"databases,":[88],"critical":[90],"component":[91],"decision":[93,129],"support,":[94],"increasing":[95],"focus":[96],"database":[99,115,136],"industry.":[100],"Many":[101],"commercial":[102],"products":[103],"services":[105],"now":[107],"available,":[108],"almost":[110],"all":[111],"primary":[114],"management":[116],"system":[117],"vendors":[118],"provide":[119],"them.":[120],"When":[121],"opposed":[122],"conventional":[124],"online":[125],"transaction":[126],"processing":[127],"applications,":[128],"support":[130],"puts":[131],"slightly":[132],"different":[133,168],"demands":[134],"on":[135],"technology.":[137],"This":[138],"paper":[139],"analyzes":[140],"performance":[142],"architectures":[147],"by":[148],"studying":[149],"comparing":[151],"many":[152],"research":[153],"works":[154],"in":[155],"this":[156],"field.":[157],"study":[159],"involves":[160],"extracting,":[161],"transforming,":[162],"loading":[164],"recourses":[169],"important":[172],"characteristic":[173],"architecture":[176],"types.":[177],"Furthermore,":[178],"tools":[180],"application":[182],"service":[183],"techniques":[184],"architecture.":[190]},"counts_by_year":[{"year":2025,"cited_by_count":6},{"year":2024,"cited_by_count":5},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1}],"updated_date":"2026-10-30T12:39:25.321706","created_date":"2024-01-18T00:00:00"}