Home / Current Issue / Paper 1725090
A Theoretical Framework for Zero-Downtime Multi-Subnet Availability Group Architectures in Mission-Critical Clinical Review Estates
Subject area: Biological & Medical Sciences · Area of research: Medical Sciences
Abstract
Clinical review estates, the database platforms behind clinical trial adjudication, pharmacovigilance and diagnostic review, must remain available, accurate and secure at all times, yet there is little theory to guide how they should be built across multiple data centres. This paper develops a theoretical framework for zero-downtime multi-subnet SQL Server Availability Group architectures in such settings. Drawing on a synthesis of 120 international and regional sources published up to 2019, it defines zero-downtime from the point of view of the clinical user and models how design choices affect availability, data loss and security. The analysis shows that separating replicas into independent failure domains matters more than adding replicas, that the way client applications reconnect is often the main cause of extended outages, and that every replica must carry the same security controls to remain compliant with health data regulation. The framework offers architects, auditors and researchers a practical basis for designing and assessing resilient clinical data platforms.
Keywords
Always on Availability Groups, clinical data security, disaster recovery, high availability, multi-subnet failover, quorum, regulatory compliance, Windows Server Failover Clustering
References
[1] Abadi, D. (2012). Consistency tradeoffs in modern distributed database system design: CAP is only part of the story. Computer, 45(2), 37–42.
[2] Abdulrazaq, K., Yusuf, H. D., Osinem, H. E., & Eribenne, F. (2019). A model for improving infection detection accuracy through integrated laboratory information systems. Iconic Research and Engineering Journals, 3(6), 650-675. https://doi.org/10.64388/IREV3I6-1723089
[3] Adaramola, T. S., Fadero, S., & Gideon, E. N. (2018). Predictive maintenance and condition monitoring in critical power and energy infrastructure. Iconic Research and Engineering Journals, 2(5), 454-477. https://doi.org/10.64388/IREV2I5-1722489
[4] Adeyelu, O. O. (2018). A predictive compliance monitoring framework for detecting systemic safety risks through aviation consumer complaint data. Iconic Research and Engineering Journals, 1(8), 250-276. https://doi.org/10.64388/IREV1I8-1718478
[5] Adeyelu, O. O. (2019). An adaptive safety management system implementation model for aerodromes in developing economy contexts. Iconic Research and Engineering Journals, 3(4), 628-654. https://doi.org/10.64388/IREV3I4-1718479
[6] Agbabiaka, J., Okonkwo, C. S., Ogunwole, O., Mayo, W., & Okeke, O. T. (2019). Supply chain risk management model for EPC and gas processing projects. Iconic Research and Engineering Journals, 3(2), 968-980. https://doi.org/10.64388/IREV3I2-1713124
[7] Agboada, P., Ezeako, R., Okoli, I. E., & Uzondu, C. S. (2018). Digital transformation in operations management: A review of advances in automation, analytics, and process redesign. International Journal of Engineering Technology Research & Management, 2(11), 109-134.
[8] Agboada, P., Ezeako, R., Okoli, I. E., & Uzondu, C. S. (2019). Standard operating procedures as change infrastructure: A conceptual framework for sustaining operational improvement. Iconic Research and Engineering Journals, 3(6), 706-730. https://doi.org/10.64388/IREV3I6-1723313
[9] Ahmed, K. S., & Odejobi, O. D. (2018a). Conceptual framework for scalable and secure cloud architectures for enterprise messaging. IRE Journals, 2(1), 1-15.
[10] Ahmed, K. S., & Odejobi, O. D. (2018b). Resource allocation model for energy-efficient virtual machine placement in data centers. IRE Journals, 2(3), 1-10.
[11] Ahmed, K. S., Odejobi, O. D., & Oshoba, T. O. (2019). Algorithmic model for constraint satisfaction in cloud network resource allocation. IRE Journals, 2(12), 516-532.
[12] Akeju, B., Edivri, J., Ogbole, J. I., Okoruwa, P. O., Fadayomi, O., & Abolaji, T. O. (2018). Conceptual model for insider threat classification and risk modeling in complex digital systems. Iconic Research and Engineering Journals, 1(9), 476-492. https://doi.org/10.64388/IREV1I9-1713778
[13] Akomolafe, O., & Agu, M. U. (2018). A conceptual model for enhancing internal audit quality through technology-enabled risk assessment frameworks. Iconic Research and Engineering Journals, 1(9), 458-475.
[14] Akomolafe, O., & Agu, M. U. (2019a). A conceptual framework for developing risk-based internal control models in the insurance and banking sectors. Iconic Research and Engineering Journals, 2(8), 335-354.
[15] Akomolafe, O., & Agu, M. U. (2019b). A review of data-driven risk evaluation models for emerging market financial institutions. Iconic Research and Engineering Journals, 3(6), 433-448.
[16] Akomolafe, O., & Agu, M. U. (2019c). Advances in financial resilience through integrated governance and compliance strategies. Iconic Research and Engineering Journals, 2(10), 607-620.
[17] Alquraan, A., Takruri, H., Alfatafta, M., & Al-Kiswany, S. (2018). An analysis of network-partitioning failures in cloud systems. In Proceedings of the 13th USENIX Symposium on Operating Systems Design and Implementation (pp. 51–68). USENIX Association.
[18] Aminu-Ibrahim, A. Y., Ogbete, J. C., & Ambali, K. B. (2018). Developing sustainable diagnostic laboratory infrastructure models for emerging and resource constrained health systems. Iconic Research and Engineering Journals, 1(8), 118-132. https://doi.org/10.64388/IREV1I8-1713586
[19] Aminu-Ibrahim, A. Y., Ogbete, J. C., & Ambali, K. B. (2019). Capital project delivery models for high risk healthcare infrastructure in developing national health systems. Iconic Research and Engineering Journals, 2(10), 626-649. https://doi.org/10.64388/IREV2I10-1713588
[20] Aneke, O. B., & Adesemoye, A. C. (2019). Toward an integrated conceptual framework for traceability and chain-of-custody integrity in pharmaceutical distribution. Iconic Research and Engineering Journals, 3(4), 655-672.
[21] Anichukwueze, C. C., Osuji, V. C., & Oguntegbe, E. E. (2019). Global marketing law and consumer protection challenges: A strategic framework for multinational compliance. IRE Journals, 3(6), 325-333.
[22] Antonopoulos, P., Byrne, P., Chen, W., Diaconu, C., Kodandaramaih, R. T., Kodavalla, H., Purnananda, P., Radu, A.-L., Ravella, C. S., & Venkataramanappa, G. M. (2019). Constant time recovery in Azure SQL Database. Proceedings of the VLDB Endowment, 12(12), 2143–2154. https://doi.org/10.14778/3352063.3352131
[23] Anyanwu, K. C. E. (2019). Developing a maturity model for standardizing IT support operations across geographically distributed multi-office organizations. Iconic Research and Engineering Journals, 3(5), 580-598.
[24] Asibor, E., & Isong, D. E. (2019). Risk-based process engineering framework for strengthening reliability across complex natural gas infrastructure systems. Iconic Research and Engineering Journals, 3(2), 1020-1060. https://doi.org/10.64388/IREV3I2-1723153
[25] Avižienis, A., Laprie, J.-C., Randell, B., & Landwehr, C. (2004). Basic concepts and taxonomy of dependable and secure computing. IEEE Transactions on Dependable and Secure Computing, 1(1), 11–33.
[26] Badmus, O., Dosunmu, A. A., & Ozowara, D. E. (2018). A systematic review of CI/CD pipeline strategies in Salesforce DevOps: Tools, practices, and deployment outcomes. Iconic Research and Engineering Journals, 2(6).
[27] Badmus, O., Dosunmu, A. A., & Ozowara, D. E. (2019a). A conceptual model for ETL design and data integration in Salesforce-centric enterprise architectures. Iconic Research and Engineering Journals, 3(5).
[28] Badmus, O., Dosunmu, A. A., & Ozowara, D. E. (2019b). A governance framework for Salesforce platform management in regulated healthcare environments. Iconic Research and Engineering Journals, 3(6).
[29] Bailis, P., & Kingsbury, K. (2014). The network is reliable. Communications of the ACM, 57(9), 48–55.
[30] Basiri, A., Behnam, N., de Rooij, R., Hochstein, L., Kosewski, L., Reynolds, J., & Rosenthal, C. (2016). Chaos engineering. IEEE Software, 33(3), 35–41.
[31] Bernstein, P. A., Hadzilacos, V., & Goodman, N. (1987). Concurrency control and recovery in database systems. Reading, MA: Addison-Wesley.
[32] Bertino, E., & Sandhu, R. (2005). Database security: Concepts, approaches, and challenges. IEEE Transactions on Dependable and Secure Computing, 2(1), 2–19.
[33] Beyer, B., Jones, C., Petoff, J., & Murphy, N. R. (Eds.). (2016). Site reliability engineering: How Google runs production systems. O'Reilly Media.
[34] Bola-Sadipe, D., Aliliele, C., & Eboh, E. E. (2019). Conceptual model for strategic accounting systems strengthening financial transparency and regulatory compliance. IRE Journals, 3(6), 535-564. https://doi.org/10.64388/IREV3I6-1715327
[35] Brewer, E. (2012). CAP twelve years later: How the "rules" have changed. Computer, 45(2), 23–29.
[36] Brewer, E. A. (2000). Towards robust distributed systems. Keynote at the 19th ACM Symposium on Principles of Distributed Computing (PODC), Portland, OR.
[37] Burrows, M. (2006). The Chubby lock service for loosely-coupled distributed systems. In Proceedings of the 7th USENIX Symposium on Operating Systems Design and Implementation (pp. 335–350). USENIX Association.
[38] Chandra, T. D., & Toueg, S. (1996). Unreliable failure detectors for reliable distributed systems. Journal of the ACM, 43(2), 225–267.
[39] Coventry, L., & Branley, D. (2018). Cybersecurity in healthcare: A narrative review of trends, threats and ways forward. Maturitas, 113, 48–52.
[40] DeCandia, G., Hastorun, D., Jampani, M., Kakulapati, G., Lakshman, A., Pilchin, A., Sivasubramanian, S., Vosshall, P., & Vogels, W. (2007). Dynamo: Amazon's highly available key-value store. In Proceedings of the 21st ACM Symposium on Operating Systems Principles (pp. 205–220). ACM.
[41] Dierks, T., & Rescorla, E. (2008). The Transport Layer Security (TLS) protocol version 1.2 (RFC 5246). Internet Engineering Task Force.
[42] Dogbatsey, E. A., Ebhojie, O., & Oyeleye, A. O. (2019). Reconciliation control and financial workflow redesign in emerging market organizations: A conceptual framework. Zenodo. https://doi.org/10.5281/zenodo.20447103
[43] Dosunmu, A. A., & Ogundele, P. O. (2019). Security audit and enterprise risk assessment frameworks for resilient information systems. Iconic Research and Engineering Journals, 3(5), 434-447. https://doi.org/10.64388/IREV3I5-1713225
[44] Dwork, C., Lynch, N., & Stockmeyer, L. (1988). Consensus in the presence of partial synchrony. Journal of the ACM, 35(2), 288–323.
[45] Ekemezie, U. C., Ohunyon, G., & Sydney, E. (2018). Evaluating IDSR implementation in Benue State, Nigeria: DHIS2 data quality and surveillance capacity. Iconic Research and Engineering Journals, 2(6).
[46] European Parliament and Council. (2016). Regulation (EU) 2016/679 (General Data Protection Regulation). Official Journal of the European Union, L 119, 1–88.
[47] Fadayomi, O., Abolaji, T. O., Edivri, J., Ogbole, J. I., Okoruwa, P. O., & Akeju, B. (2019). Risk-based cybersecurity assurance and data availability: Limitations, advances and future research opportunities. Iconic Research and Engineering Journals, 2(12), 602-617. https://doi.org/10.64388/IREV2I12-1713779
[48] Fernández-Alemán, J. L., Señor, I. C., Lozoya, P. Á. O., & Toval, A. (2013). Security and privacy in electronic health records: A systematic literature review. Journal of Biomedical Informatics, 46(3), 541–562.
[49] Fischer, M. J., Lynch, N. A., & Paterson, M. S. (1985). Impossibility of distributed consensus with one faulty process. Journal of the ACM, 32(2), 374–382.
[50] Ford, D., Labelle, F., Popovici, F. I., Stokely, M., Truong, V.-A., Barroso, L., Grimes, C., & Quinlan, S. (2010). Availability in globally distributed storage systems. In Proceedings of the 9th USENIX Symposium on Operating Systems Design and Implementation (pp. 61–74). USENIX Association.
[51] Gideon, E. N., Adaramola, T. S., & Fadero, S. (2019). Reliability engineering and failure analysis in complex engineering systems. Iconic Research and Engineering Journals, 2(11), 703-727. https://doi.org/10.64388/IREV2I11-1722490
[52] Gilbert, S., & Lynch, N. (2002). Brewer's conjecture and the feasibility of consistent, available, partition-tolerant web services. ACM SIGACT News, 33(2), 51–59.
[53] Gill, P., Jain, N., & Nagappan, N. (2011). Understanding network failures in data centers: Measurement, analysis, and implications. In Proceedings of the ACM SIGCOMM 2011 Conference (pp. 350–361). ACM.
[54] Gray, C., & Cheriton, D. (1989). Leases: An efficient fault-tolerant mechanism for distributed file cache consistency. In Proceedings of the 12th ACM Symposium on Operating Systems Principles (pp. 202–210). ACM.
[55] Gray, J. (1986). Why do computers stop and what can be done about it? In Proceedings of the 5th Symposium on Reliability in Distributed Software and Database Systems (pp. 3–12). IEEE Computer Society.
[56] Gray, J., & Reuter, A. (1993). Transaction processing: Concepts and techniques. San Mateo, CA: Morgan Kaufmann.
[57] Gray, J., Helland, P., O'Neil, P., & Shasha, D. (1996). The dangers of replication and a solution. In Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data (pp. 173–182). ACM.
[58] Gunawi, H. S., Hao, M., Suminto, R. O., Laksono, A., Satria, A. D., Adityatama, J., & Eliazar, K. J. (2016). Why does the cloud stop computing? Lessons from hundreds of service outages. In Proceedings of the Seventh ACM Symposium on Cloud Computing (pp. 1–16). ACM.
[59] Huang, P., Guo, C., Zhou, L., Lorch, J. R., Dang, Y., Chintalapati, M., & Yao, R. (2017). Gray failure: The Achilles' heel of cloud-scale systems. In Proceedings of the 16th Workshop on Hot Topics in Operating Systems (pp. 150–155). ACM.
[60] Ilodigwe, L., & Adesemoye, A. C. (2019a). A critical review of health insurance financing mechanisms and provider payment reform strategies for balancing coverage expansion and financial protection in emerging markets. International Journal of Health and Pharmaceutical Research, 5(2), 31-55. https://doi.org/10.56201/ijhpr.vol.5.no2.2019.pg31.55
[61] Ilodigwe, L., & Adesemoye, A. C. (2019b). From molecules to health systems: A conceptual model explaining why scientific innovation fails to improve patient outcomes without effective healthcare delivery infrastructure. International Journal of Health and Pharmaceutical Research, 5(2), 56-79. https://doi.org/10.56201/ijhpr.vol.5.no2.2019.pg56.79
[62] International Council for Harmonisation. (2016). Integrated addendum to ICH E6(R1): Guideline for good clinical practice E6(R2). ICH.
[63] International Organization for Standardization. (2012). Societal security: Business continuity management systems: Requirements (ISO 22301:2012). ISO.
[64] International Organization for Standardization. (2013). Information technology: Security techniques: Information security management systems: Requirements (ISO/IEC 27001:2013). ISO.
[65] Kilbridge, P. (2003). Computer crash: Lessons from a system failure. New England Journal of Medicine, 348(10), 881–882.
[66] Kruse, C. S., Frederick, B., Jacobson, T., & Monticone, D. K. (2017). Cybersecurity in healthcare: A systematic review of modern threats and trends. Technology and Health Care, 25(1), 1–10.
[67] Ladapo, O. O., Dosunmu, A. A., Jooda, D., & Abolaji, T. O. (2018). Lessons learned from offline assessment of security-critical systems: The case of Microsoft Active Directory. Iconic Research and Engineering Journals, 2(6), 277-299. https://doi.org/10.64388/IREV2I6-1717205
[68] Ladapo, O. O., Jooda, D., Dosunmu, A. A., & Abolaji, T. O. (2019). Implementation of Active Directory for efficient management of enterprise networks. Iconic Research and Engineering Journals, 3(4), 608-627. https://doi.org/10.64388/IREV3I4-1717206
[69] Lamport, L. (1978). Time, clocks, and the ordering of events in a distributed system. Communications of the ACM, 21(7), 558–565.
[70] Lamport, L. (1998). The part-time parliament. ACM Transactions on Computer Systems, 16(2), 133–169.
[71] Lamport, L. (2001). Paxos made simple. ACM SIGACT News, 32(4), 51–58.
[72] Lamport, L., Shostak, R., & Pease, M. (1982). The Byzantine generals problem. ACM Transactions on Programming Languages and Systems, 4(3), 382–401.
[73] Larsen, E., Fong, A., Wernz, C., & Ratwani, R. M. (2018). Implications of electronic health record downtime: An analysis of patient safety event reports. Journal of the American Medical Informatics Association, 25(2), 187–191. https://doi.org/10.1093/jamia/ocx057
[74] Lawal, O. A., & Oduleye, T. E. (2019). Conceptualizing data driven executive decision systems for strategic financial planning. Iconic Research and Engineering Journals, 3(3).
[75] Liu, V., Musen, M. A., & Chou, T. (2015). Data breaches of protected health information in the United States. JAMA, 313(14), 1471–1473.
[76] Marcus, E., & Stern, H. (2003). Blueprints for high availability (2nd ed.). Wiley.
[77] Martin, G., Martin, P., Hankin, C., Darzi, A., & Kinross, J. (2017). Cybersecurity and healthcare: How safe are we? BMJ, 358, j3179. https://doi.org/10.1136/bmj.j3179
[78] Mbonu, I. S., Aliliele, C., Iwuanyanwu, U., & Oluoha, O. M. (2018). A conceptual framework for legal and ethical risk modeling in enterprise data protection governance systems. Iconic Research and Engineering Journals, 2(2), 207-226. https://doi.org/10.64388/IREV2I2-1714911
[79] Mbonu, I. S., Aliliele, C., Uzoka, E., & Oluoha, O. M. (2019). A review of comparative data protection regulations and secure cloud implementation strategies across jurisdictions. Iconic Research and Engineering Journals, 2(9), 482-501. https://doi.org/10.64388/IREV2I9-1714912
[80] Mbonu, I. S., Iwuanyanwu, U., Uzoka, E., & Oluoha, O. M. (2019). Advances in enterprise log analytics and automated incident response architectures using Python and SIEM platforms. Iconic Research and Engineering Journals, 3(2), 1000-1019. https://doi.org/10.64388/IREV3I2-1714915
[81] Microsoft. (2019a). Accelerated database recovery. SQL Server documentation. Redmond, WA: Microsoft Corporation.
[82] Microsoft. (2019b). Always On availability groups: A high-availability and disaster-recovery solution. SQL Server documentation. Redmond, WA: Microsoft Corporation.
[83] Microsoft. (2019c). Configure a multi-subnet Always On availability group and listener. SQL Server documentation. Redmond, WA: Microsoft Corporation.
[84] Mockapetris, P. (1987). Domain names: Implementation and specification (RFC 1035). Internet Engineering Task Force.
[85] Mohan, C., Haderle, D., Lindsay, B., Pirahesh, H., & Schwarz, P. (1992). ARIES: A transaction recovery method supporting fine-granularity locking and partial rollbacks using write-ahead logging. ACM Transactions on Database Systems, 17(1), 94–162.
[86] Mosleh, A., Rasmuson, D. M., & Marshall, F. M. (1998). Guidelines on modeling common-cause failures in probabilistic risk assessment (NUREG/CR-5485). U.S. Nuclear Regulatory Commission.
[87] National Institute of Standards and Technology. (2008). An introductory resource guide for implementing the HIPAA Security Rule (NIST SP 800-66 Rev. 1). Gaithersburg, MD: NIST.
[88] National Institute of Standards and Technology. (2013). Security and privacy controls for federal information systems and organizations (NIST SP 800-53 Rev. 4). Gaithersburg, MD: NIST.
[89] Nwangwu, C. V., Duvbiama-Owasanoye, O. A., & Onwumere, A. (2018). A framework for operational integrity in high-risk drilling: Balancing productivity and safety compliance. Iconic Research and Engineering Journals, 2(5), 436-453.
[90] Obetta, P. C. (2018). A risk-based inspection concept for fitness-for-service assessment of ageing pressure vessels on offshore joint venture facilities. Iconic Research and Engineering Journals, 2(5), 497-520. https://doi.org/10.64388/IREV2I5-1722578
[91] Obetta, P. C. (2019). Reliability and integrity management of fired heaters, boilers and furnaces in upstream oil and gas: A review. Iconic Research and Engineering Journals, 3(5), 599-626. https://doi.org/10.64388/IREV3I5-1722580
[92] Obetta, P. C., & Ninduwezuor-Ehiobu, N. (2018). A condition-based maintenance concept for CALM buoy bearings and swivels to improve offshore crude export availability. Iconic Research and Engineering Journals, 2(6), 385-410. https://doi.org/10.64388/IREV2I6-1722579
[93] Obetta, P. C., & Ninduwezuor-Ehiobu, N. (2019). Integrity assurance of FSO turret mooring systems: A review of inspection, monitoring and life-extension strategies. Iconic Research and Engineering Journals, 3(6), 599-629. https://doi.org/10.64388/IREV3I6-1722581
[94] Obriki, O. D., & Arumosoye, O. M. (2018). Conceptual modeling of data-driven occupational safety risk control in large-scale energy infrastructure projects. Iconic Research and Engineering Journals, 1(7), 169-189. https://doi.org/10.64388/IREV1I7-1714414
[95] Odejobi, O. D., & Ahmed, K. S. (2018). Performance evaluation model for multi-tenant Microsoft 365 deployments under high concurrency. IRE Journals, 1(11), 92-107.
[96] Odejobi, O. D., Hammed, N. I., & Ahmed, K. S. (2019). Approximation complexity model for cloud-based database optimization problems. IRE Journals, 2(9), 1-10.
[97] Ogbete, J. C., Aminu-Ibrahim, A. Y., & Ambali, K. B. (2018). Optimizing laboratory spatial planning strategies to improve diagnostic accuracy, safety, and clinical throughput. Iconic Research and Engineering Journals, 2(1), 87-113. https://doi.org/10.64388/IREV1I7-1713587
[98] Ogbete, J. C., Aminu-Ibrahim, A. Y., & Ambali, K. B. (2019). Regulatory compliant design systems for molecular and pathology laboratories in highly controlled environments. Iconic Research and Engineering Journals, 3(4), 607-631. https://doi.org/10.64388/IREV3I4-1713589
[99] Okonkwo, C. S., Ogunwole, O., & Okeke, O. T. (2018). Model for inventory availability and plant uptime improvement in energy facilities. Iconic Research and Engineering Journals, 2(4), 160-172. https://doi.org/10.64388/IREV2I4-1713120
[100] Ongaro, D., & Ousterhout, J. (2014). In search of an understandable consensus algorithm. In Proceedings of the 2014 USENIX Annual Technical Conference (pp. 305–319).
[101] Oshoba, T. O., Hammed, N. I., & Odejobi, O. D. (2019). Secure identity and access management model for distributed and federated systems. IRE Journals, 3(4), 550-567.
[102] Popa, R. A., Redfield, C. M. S., Zeldovich, N., & Balakrishnan, H. (2011). CryptDB: Protecting confidentiality with encrypted query processing. In Proceedings of the 23rd ACM Symposium on Operating Systems Principles (pp. 85–100). ACM.
[103] Rausand, M., & Høyland, A. (2004). System reliability theory: Models, statistical methods, and applications (2nd ed.). Wiley.
[104] Reason, J. (1990). Human error. Cambridge University Press.
[105] Saltzer, J. H., & Schroeder, M. D. (1975). The protection of information in computer systems. Proceedings of the IEEE, 63(9), 1278–1308.
[106] Sandhu, R. S., Coyne, E. J., Feinstein, H. L., & Youman, C. E. (1996). Role-based access control models. Computer, 29(2), 38–47.
[107] Schneider, F. B. (1990). Implementing fault-tolerant services using the state machine approach: A tutorial. ACM Computing Surveys, 22(4), 299–319.
[108] Schroeder, B., & Gibson, G. A. (2007). Disk failures in the real world: What does an MTTF of 1,000,000 hours mean to you? In Proceedings of the 5th USENIX Conference on File and Storage Technologies (pp. 1–16). USENIX Association.
[109] Sittig, D. F., & Singh, H. (2010). A new sociotechnical model for studying health information technology in complex adaptive healthcare systems. Quality and Safety in Health Care, 19(Suppl. 3), i68–i74.
[110] Swanson, M., Bowen, P., Phillips, A. W., Gallup, D., & Lynes, D. (2010). Contingency planning guide for federal information systems (NIST Special Publication 800-34 Rev. 1). National Institute of Standards and Technology.
[111] Trivedi, K. S. (2002). Probability and statistics with reliability, queuing, and computer science applications (2nd ed.). Wiley.
[112] U.S. Department of Health and Human Services. (2013). HIPAA Security Rule, 45 CFR Part 160 and Subparts A and C of Part 164.
[113] U.S. Food and Drug Administration. (1997). Electronic records; electronic signatures (21 CFR Part 11). Federal Register, 62(54), 13430–13466.
[114] U.S. Food and Drug Administration. (2003). Guidance for industry: Part 11, electronic records; electronic signatures, scope and application. Silver Spring, MD: FDA.
[115] Unamma, U. M.-L., Okwesa, I. J., Iwuanyanwu, U., & Ajiga, D. (2018). An offline-first design framework for digital learning in low-connectivity environments. Iconic Research and Engineering Journals, 2(3), 192-211. https://doi.org/10.64388/IREV2I3-1722627
[116] Vogels, W. (2009). Eventually consistent. Communications of the ACM, 52(1), 40–44.
[117] Wang, Y., Coiera, E., Gallego, B., Concha, O. P., Ong, M.-S., Tsafnat, G., Roffe, D., Jones, G., & Magrabi, F. (2016). Measuring the effects of computer downtime on hospital pathology processes. Journal of Biomedical Informatics, 59, 308–315.
[118] Wiesmann, M., Pedone, F., Schiper, A., Kemme, B., & Alonso, G. (2000). Understanding replication in databases and distributed systems. In Proceedings of the 20th IEEE International Conference on Distributed Computing Systems (pp. 464–474). IEEE.
[119] Yuan, D., Luo, Y., Zhuang, X., Rodrigues, G. R., Zhao, X., Zhang, Y., Jain, P. U., & Stumm, M. (2014). Simple testing can prevent most critical failures: An analysis of production failures in distributed data-intensive systems. In Proceedings of the 11th USENIX Symposium on Operating Systems Design and Implementation (pp. 249–265). USENIX Association.
[120] Yusuf, H. D., & Abdulrazaq, K. (2018). A conceptual framework for strengthening diagnostic quality systems in resource-limited clinical laboratories. Iconic Research and Engineering Journals, 1(11), 145-179. https://doi.org/10.64388/IREV1I11-1723090
How to cite this paper
@article{1725090,
author = {Evans Ighodalo, Ayinoluwa Kolawole, Emmanuel Chukwuma Okeke, Oluranti Ogundapo},
title = {A Theoretical Framework for Zero-Downtime Multi-Subnet Availability Group Architectures in Mission-Critical Clinical Review Estates},
journal = {Iconic Research And Engineering Journals},
year = {2019},
volume = {3},
number = {4},
pages = {695-711},
issn = {2456-8880},
url = {https://www.irejournals.com/formatedpaper/1725090.pdf},
abstract = {Clinical review estates, the database platforms behind clinical trial adjudication, pharmacovigilance and diagnostic review, must remain available, accurate and secure at all times, yet there is little theory to guide how they should be built across multiple data centres. This paper develops a theoretical framework for zero-downtime multi-subnet SQL Server Availability Group architectures in such settings. Drawing on a synthesis of 120 international and regional sources published up to 2019, it defines zero-downtime from the point of view of the clinical user and models how design choices affect availability, data loss and security. The analysis shows that separating replicas into independent failure domains matters more than adding replicas, that the way client applications reconnect is often the main cause of extended outages, and that every replica must carry the same security controls to remain compliant with health data regulation. The framework offers architects, auditors and researchers a practical basis for designing and assessing resilient clinical data platforms.},
keywords = {Always on Availability Groups, clinical data security, disaster recovery, high availability, multi-subnet failover, quorum, regulatory compliance, Windows Server Failover Clustering},
month = {October},
}