Popuri Srinivasarao, Aravapalli Rama Satish^*

Computer Systems Science and Engineering, Vol.47, No.2, pp. 1527-1547, 2023, DOI:10.32604/csse.2023.038951

Abstract Responding to complex analytical queries in the data warehouse (DW) is one of the most challenging tasks that require prompt attention. The problem of materialized view (MV) selection relies on selecting the most optimal views that can respond to more queries simultaneously. This work introduces a combined approach in which the constraint handling process is combined with metaheuristics to select the most optimal subset of DW views from DWs. The proposed work initially refines the solution to enable a feasible selection of views using the ensemble constraint handling technique (ECHT). The constraints such as self-adaptive penalty, epsilon (ε)-parameter and stochastic… More >

Musawwer Khan¹, Islam Ali¹, Shahzada Khurram², Salman Naseer³, Shafiq Ahmad⁴, Ahmed T. Soliman⁴, Akber Abid Gardezi⁵, Muhammad Shafiq^6,*, Jin-Ghoo Choi⁶

CMC-Computers, Materials & Continua, Vol.74, No.2, pp. 3849-3863, 2023, DOI:10.32604/cmc.2023.027387

Abstract The effectiveness of the Business Intelligence (BI) system mainly depends on the quality of knowledge it produces. The decision-making process is hindered, and the user’s trust is lost, if the knowledge offered is undesired or of poor quality. A Data Warehouse (DW) is a huge collection of data gathered from many sources and an important part of any BI solution to assist management in making better decisions. The Extract, Transform, and Load (ETL) process is the backbone of a DW system, and it is responsible for moving data from source systems into the DW system. The more mature the ETL… More >

Alex Rudniy^*

CMC-Computers, Materials & Continua, Vol.71, No.1, pp. 979-992, 2022, DOI:10.32604/cmc.2022.016676

Abstract This paper describes the process of design and construction of a data warehouse (“DW”) for an online learning platform using three prominent technologies, Microsoft SQL Server, MongoDB and Apache Hive. The three systems are evaluated for corpus construction and descriptive analytics. The case also demonstrates the value of evidence-centered design principles for data warehouse design that is sustainable enough to adapt to the demands of handling big data in a variety of contexts. Additionally, the paper addresses maintainability-performance tradeoff, storage considerations and accessibility of big data corpora. In this NSF-sponsored work, the data were processed, transformed, and stored in the… More >

Abid Sohail^1,*, Dhanapal Durai Dominic², Mohammad Hijji³, Muhammad Arif Butt⁴

CMC-Computers, Materials & Continua, Vol.69, No.1, pp. 1141-1157, 2021, DOI:10.32604/cmc.2021.018023

Abstract Enterprises are continuously aiming at improving the execution of processes to achieve a competitive edge. One of the established ways of improving process performance is to assign the most appropriate resources to each task of the process. However, evaluations of business process improvement approaches have established that a method that can guide decision-makers to identify the most appropriate resources for a task of process improvement in a structured way, is missing. It is because the relationship between resources and tasks is less understood and advancement in business process intelligence is also ignored. To address this problem an integrated resource classification… More >

Abid Sohail^1,*, Khurram Shahzad², P. D. D. Dominic³, Muhammad Arif Butt², Muhammad Arif⁴, Muhammad Imran Tariq⁵

CMC-Computers, Materials & Continua, Vol.67, No.1, pp. 303-319, 2021, DOI:10.32604/cmc.2021.014201

Abstract Business process improvement is a systematic approach used by several organizations to continuously improve their quality of service. Integral to that is analyzing the current performance of each task of the process and assigning the most appropriate resources to each task. In continuation of our previous work, we categorize resources into human and non-human resources. For instance, in the healthcare domain, human resources include doctors, nurses, and other associated staff responsible for the execution of healthcare activities; whereas the non-human resources include surgical and other equipment needed for execution. In this study, we contend that the two types of resources… More >