No Detail Found!

Characterization and Forecasting the Workload of DRLAB Medical Database Server Based on the Shift-Wise and Machine Learning Approaches

Author(s)
Saleem Razzak Qureshi Institute of Mathematics and Computer Science, University of Sindh Jamshoro, Jamshoro 76080, Pakistan,
Aftab Ahmed Chandio Institute of Mathematics and Computer Science, University of Sindh Jamshoro, Jamshoro 76080, Pakistan
Qamar-ul-Nisa Chandio Government Degree Boys College Qasimabad, Education & Literacy Department, Government of Sindh, Hyderabad 71000, Pakistan
Abstract
The fundamental process to understand systems' workload is to analyze its impact and outlining workload characterization for better understanding, it enables systems' owners and policy makers to make decisions regarding policy management in order to improve system performance. Digital healthcare system is being modernized very fast at global level, especially medical laboratories require more advancements to match with standardization therefore efficient workload management of medical servers is needed to ensure reliable performance and scalability. This research focuses on workload characterization of medical database web servers, specifically within Diagnostic and Research Laboratory (DRLAB) at Liaquat University of Medical and Health Sciences (LUMHS), Jamshoro, Sindh, Pakistan. The laboratory runs completely on ICTbased infrastructure. It offers lots of end-users to connect with, like patients, lab technicians, doctors, administrative staff, IT persons, and office workers, which raises concerns about systems' scalability as end-users' requests vary throughout the day. To assess the load of end-users on servers' performance the approach is being used in this study is to analyze server access log data collected over sevenday period (4th to10th September 2020), comprising over 160,000 requests. We broke down the information into four six-hour shifts: midnight (12:01 AM to 6:00 AM), morning (6:01 AM to 12:00 PM), noon (12:01 PM to 6:00 PM), and evening (6:01 PM to 12:00 AM). In this way, the status of different time intervals in aspect to rush time may be observed. Furthermore, based of four observations, the machine learning Regression analysis techniques applied to comparatively analysis. Moreover, the results will be helpful to scheme up the database performance policy. The policy makers/stakeholders mitigate the issue by figuring out the analyzed data/statistics for the future planning.
Publication Details
Page(s) 100-119
DOI DOI not available
Published Journal: The Sciencetech, Volume: 7, Issue: 1, Year: 2026

Request the full text from PASTIC

Keywords
machine learning, Medical Lab, ICT, LUMHS, Database Workload, COVID, regression analysis, Characterization
References
Bitincka L.,Ganapathi A.,Sorkin S.,Zhang S. .2010 .Optimizing data analysis with a semi-structured time series database. In Workshop on Managing Systems via Log Analysis and Machine Learning Techniques (SLAML 10)., : .
Calzarossa M. C.,Massari L.,Tessera D. .2016 .Workload characterization: A survey revisited. ACM Computing Surveys (CSUR), 48(3) : 1-43.
Chandio A. A.,Zhang F.,Memon T. D. .2014 .Study on LBS for characterization and analysis of big data benchmarks. , 33(4) : 432-440.
Eldin A. A.,Rezaie A.,Mehta A.,Razroev A.,de Sjöstedt-de Luna S. S.,Seleznjev O.,Elmroth E. .2014 .How will your workload look like in 6 years? analyzing wikimedia's workload. In 2014 IEEE international conference on cloud engineering, : 349-354.
Garner S. R. .1995 .Weka: The waikato environment for knowledge analysis. In Proceedings of the New Zealand computer science research students conference, : 57-64.
Jarkad P. M. P.,Bhonsle M. .2015 .Improved Web Prediction Algorithm Using Web Log Data. International Journal of Innovative Research in Computer and Communication Engineering, 3(5) : .
Jhatial S.,Chandio A. .2023 .Analysis of Academic Web Server Traffic and Workload Characterization for Performance Evaluation. , 55(02) : 45-55.
Karmani P.,Chandio A. A.,Korejo I. A.,Chandio M. S. .2018 .October). A review of machine learning for healthcare informatics specifically tuberculosis disease diagnostics. In International conference on intelligent technologies and applications, : 50-61.
Khattak E.,Ullah H.,Khan I.,Ali M. T.,Jan L. .2025 .. Analyzing Twitter Data for Depression Signs Based on Machine Learning Techniques. The Sciencetech, 6(4) : 166-186.
Korkmaz M.,Karsten M.,Salem K.,Salihoglu S. .2018 .Workload-aware CPU performance scaling for transactional database systems. In Proceedings of the 2018 International Conference on Management of Data, : 291-306.
Li Y.,Beaubouef T. .2010 .Data mining: concepts, background and methods of integrating uncertainty in data mining. CCSC: SC Student E-Journal, 3 : 2-7.
Raza B.,Sher A.,Afzal S.,Malik A. K.,Anjum A.,Kumar Y. J.,Faheem M. .2019 .Autonomic workload performance tuning in large-scale data repositories. Knowledge and Information Systems, 61(1) : 27-63.
Rossi A.,Visentin A.,Carraro D.,Prestwich S.,Brown K. N. .2025 .Forecasting workload in cloud computing: towards uncertaintyaware predictions and transfer learning. Cluster computing, 28(4) : 258.
Samad H.,Hanizan S. H.,Din R.,Murad R.,Tahir A. .2018 .Performance evaluation of web application server based on request bit per second and transfer rate parameters. In Journal of Physics: Conference Series, 1 : 012007.
Saverimoutou A.,Mathieu B.,Vaton S. .2019 .Influence of internet protocols and CDN on web browsing. In 2019 10th IFIP International Conference on New Technologies, Mobility and Security (NTMS), : 1-5.
Shishira S. R.,Kandasamy A.,Chandrasekaran K. .2017 .Workload characterization: Survey of current approaches and research challenges. In Proceedings of the 7th international conference on computer and communication technology, : 151-156.
Song Y. D.,Mahanti A.,Networking (M&N) A. .2019 .Comparison of mobile and fixed device workloads in an academic web server. , : 1-6.
Summers J.,Brecht T.,Eager D.,Gutarin A. .2016 .September). Characterizing the workload of a Netflix streaming video server. In 2016 IEEE International Symposium on Workload Characterization (IISWC), : 1-12.
Xu H.,Li Z.,Chu C.,Chen Y.,Yang Y.,Lu H.,Stavrou A. .2018 .Detecting and characterizing web bot traffic in a large ecommerce marketplace. In European Symposium on Research in Computer Security, : 143-163.
Yu Z.,Xiong W.,Eeckhout L.,Bei Z.,Mendelson A.,Xu C. .2017 .Mia: Metric importance analysis for big data workload characterization. IEEE Transactions on Parallel and Distributed Systems, 29(6) : 1371-1384.
Zhang M.,Martin P.,Powley W.,Chen J. .2017 .Workload management in database management systems: A taxonomy. IEEE transactions on knowledge and data engineering, 30(7) : 1386-1402.
0

Citations

0

Downloads

7

Views