{"id":"https://openalex.org/W2953652248","doi":"https://doi.org/10.23919/iconac.2018.8749017","title":"Integrated Architecture of Data Warehouse with Business Intelligence Technologies","display_name":"Integrated Architecture of Data Warehouse with Business Intelligence Technologies","publication_year":2018,"publication_date":"2018-09-01","ids":{"openalex":"https://openalex.org/W2953652248","doi":"https://doi.org/10.23919/iconac.2018.8749017","mag":"2953652248"},"language":"en","primary_location":{"id":"doi:10.23919/iconac.2018.8749017","is_oa":false,"landing_page_url":"https://doi.org/10.23919/iconac.2018.8749017","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2018 24th International Conference on Automation and Computing (ICAC)","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/A5055635027","display_name":"Ch Anwar Ul Hassan","orcid":"https://orcid.org/0000-0002-9952-8854"},"institutions":[{"id":"https://openalex.org/I16076960","display_name":"COMSATS University Islamabad","ror":"https://ror.org/00nqqvk19","country_code":"PK","type":"education","lineage":["https://openalex.org/I16076960"]}],"countries":["PK"],"is_corresponding":true,"raw_author_name":"Ch Anwar Ul Hassan","raw_affiliation_strings":["Department of Computer Science, COMSATS Institute of Information technology, Islamabad, Pakistan"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, COMSATS Institute of Information technology, Islamabad, Pakistan","institution_ids":["https://openalex.org/I16076960"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070900497","display_name":"Rizwana Irfan","orcid":null},"institutions":[{"id":"https://openalex.org/I16076960","display_name":"COMSATS University Islamabad","ror":"https://ror.org/00nqqvk19","country_code":"PK","type":"education","lineage":["https://openalex.org/I16076960"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"Rizwana Irfan","raw_affiliation_strings":["Department of Computer Science, COMSATS Institute of Information technology, Islamabad, Pakistan"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, COMSATS Institute of Information technology, Islamabad, Pakistan","institution_ids":["https://openalex.org/I16076960"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5022535739","display_name":"Munam Ali Shah","orcid":"https://orcid.org/0000-0002-4037-3405"},"institutions":[{"id":"https://openalex.org/I16076960","display_name":"COMSATS University Islamabad","ror":"https://ror.org/00nqqvk19","country_code":"PK","type":"education","lineage":["https://openalex.org/I16076960"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"Munam Ali Shah","raw_affiliation_strings":["Department of Computer Science, COMSATS Institute of Information technology, Islamabad, Pakistan"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, COMSATS Institute of Information technology, Islamabad, Pakistan","institution_ids":["https://openalex.org/I16076960"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5055635027"],"corresponding_institution_ids":["https://openalex.org/I16076960"],"apc_list":null,"apc_paid":null,"fwci":2.5874,"has_fulltext":false,"cited_by_count":15,"citation_normalized_percentile":{"value":0.9076453,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"6"},"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.9987000226974487,"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.9987000226974487,"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.998199999332428,"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/T11719","display_name":"Data Quality and Management","score":0.9979000091552734,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.9070510864257812},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"Business intelligence","score":0.8137389421463013},{"id":"https://openalex.org/keywords/dashboard","display_name":"Dashboard","score":0.7692952752113342},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7571766376495361},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.7054638862609863},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.6026169061660767},{"id":"https://openalex.org/keywords/decision-support-system","display_name":"Decision support system","score":0.5237340927124023},{"id":"https://openalex.org/keywords/business-process","display_name":"Business process","score":0.46710124611854553},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4396893084049225},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.43218812346458435},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.41715484857559204},{"id":"https://openalex.org/keywords/data-architecture","display_name":"Data architecture","score":0.41139352321624756},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3548261523246765},{"id":"https://openalex.org/keywords/knowledge-management","display_name":"Knowledge management","score":0.3520655632019043},{"id":"https://openalex.org/keywords/process-management","display_name":"Process management","score":0.3456040024757385},{"id":"https://openalex.org/keywords/software-architecture","display_name":"Software architecture","score":0.1548924744129181},{"id":"https://openalex.org/keywords/reference-architecture","display_name":"Reference architecture","score":0.1425004005432129},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.13795828819274902},{"id":"https://openalex.org/keywords/work-in-process","display_name":"Work in process","score":0.13419103622436523}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.9070510864257812},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.8137389421463013},{"id":"https://openalex.org/C33499554","wikidata":"https://www.wikidata.org/wiki/Q1417134","display_name":"Dashboard","level":2,"score":0.7692952752113342},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7571766376495361},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.7054638862609863},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.6026169061660767},{"id":"https://openalex.org/C107327155","wikidata":"https://www.wikidata.org/wiki/Q330268","display_name":"Decision support system","level":2,"score":0.5237340927124023},{"id":"https://openalex.org/C85345410","wikidata":"https://www.wikidata.org/wiki/Q851587","display_name":"Business process","level":3,"score":0.46710124611854553},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4396893084049225},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.43218812346458435},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.41715484857559204},{"id":"https://openalex.org/C94070970","wikidata":"https://www.wikidata.org/wiki/Q638422","display_name":"Data architecture","level":5,"score":0.41139352321624756},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3548261523246765},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.3520655632019043},{"id":"https://openalex.org/C195094911","wikidata":"https://www.wikidata.org/wiki/Q14167904","display_name":"Process management","level":1,"score":0.3456040024757385},{"id":"https://openalex.org/C35869016","wikidata":"https://www.wikidata.org/wiki/Q846636","display_name":"Software architecture","level":3,"score":0.1548924744129181},{"id":"https://openalex.org/C55356503","wikidata":"https://www.wikidata.org/wiki/Q2136675","display_name":"Reference architecture","level":4,"score":0.1425004005432129},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.13795828819274902},{"id":"https://openalex.org/C174998907","wikidata":"https://www.wikidata.org/wiki/Q357662","display_name":"Work in process","level":2,"score":0.13419103622436523},{"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/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"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/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","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/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.23919/iconac.2018.8749017","is_oa":false,"landing_page_url":"https://doi.org/10.23919/iconac.2018.8749017","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2018 24th International Conference on Automation and Computing (ICAC)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":29,"referenced_works":["https://openalex.org/W10162726","https://openalex.org/W578677613","https://openalex.org/W1995711707","https://openalex.org/W2036006888","https://openalex.org/W2109523013","https://openalex.org/W2183783194","https://openalex.org/W2187534539","https://openalex.org/W2267544776","https://openalex.org/W2338572656","https://openalex.org/W2401543523","https://openalex.org/W2438261314","https://openalex.org/W2464900023","https://openalex.org/W2511992115","https://openalex.org/W2559967977","https://openalex.org/W2584003902","https://openalex.org/W2592469568","https://openalex.org/W2593613647","https://openalex.org/W2611838892","https://openalex.org/W2617290843","https://openalex.org/W2734854752","https://openalex.org/W2734950381","https://openalex.org/W2773910439","https://openalex.org/W2920037937","https://openalex.org/W2966080379","https://openalex.org/W4295138889","https://openalex.org/W6685897890","https://openalex.org/W6733096293","https://openalex.org/W6766836992","https://openalex.org/W6990694143"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W6138692","https://openalex.org/W2363019959","https://openalex.org/W1535822977","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W208715492","https://openalex.org/W23190051","https://openalex.org/W2953652248"],"abstract_inverted_index":{"Business":[0],"Intelligence":[1],"(BI)":[2],"is":[3,67,75,86],"the":[4,19,24,40,55],"process":[5],"to":[6,17,51,89],"extract":[7],"information":[8,16,72],"from":[9,14],"data":[10,30,56,94],"then":[11],"get":[12],"knowledge":[13],"that":[15,74],"take":[18],"decisions.":[20],"This":[21],"paper":[22],"shows":[23],"effectiveness":[25],"of":[26,65,71],"BI":[27,108],"technologies":[28],"with":[29],"warehouse,":[31],"for":[32,58],"decision":[33,61],"making.":[34,62],"In":[35],"this":[36],"paper,":[37],"we":[38],"deploy":[39],"Integrated":[41],"Proposed":[42],"Architecture":[43,82],"(IPA)":[44],"on":[45],"W":[46],"category":[47],"hospital":[48],"in":[49,69],"order":[50],"manage":[52],"and":[53,60,103],"monitor":[54],"effectively":[57],"analysis":[59,73],"The":[63,84],"accuracy":[64],"IPA":[66,85],"93%":[68],"term":[70],"6%":[76],"better":[77],"than":[78],"Traditional":[79],"Data":[80],"warehouse":[81],"(TDA).":[83],"also":[87],"able":[88],"support":[90],"dashboard":[91],"management,":[92],"multidimensional":[93],"model,":[95],"perform":[96,100],"online":[97],"analytical":[98],"processing,":[99],"user":[101],"authentication":[102],"generate":[104],"dynamic":[105],"reports":[106],"via":[107],"technologies.":[109]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":8}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}