High-Availability Databases in Global Banking : Ensuring Continuous Operations and Data Integrity

Uday Kumar Manne

doi:10.32628/CSEIT24105109

Authors

Uday Kumar Manne Adobe Inc., USA Author

DOI:

https://doi.org/10.32628/CSEIT24105109

Keywords:

High-Availability Databases, Financial Data Integrity, Active-Active Configuration, Synchronous Replication, AI-driven Database Management

Abstract

This comprehensive article explores the critical role of high-availability (HA) database systems in global banking operations, focusing on their impact on continuous service delivery, data integrity, and regulatory compliance. The article examines the challenges faced by financial institutions in maintaining reliable database systems, including the risks of downtime, data inconsistencies, and the complexities of managing distributed systems across multiple jurisdictions. It provides an in-depth analysis of various HA database architectures, comparing active-active and active-passive configurations, and discussing replication mechanisms and clustering strategies. Through case studies of real-world implementations in trading and core banking systems, the research highlights best practices and common challenges in deploying HA solutions. The article also investigates the broader implications of HA databases on operational resilience and regulatory adherence, particularly in the context of SOX and Basel III requirements. Looking ahead, the article explores emerging trends in HA database technology, including cloud-based solutions, the potential of blockchain for enhancing data integrity, and the role of artificial intelligence in improving system reliability. By synthesizing technical insights with practical applications, this research offers valuable guidance for financial institutions seeking to enhance their database infrastructure to meet the demands of an increasingly digital and interconnected global financial system.

Downloads

Download data is not yet available.

References

M. T. Özsu and P. Valduriez, "Principles of Distributed Database Systems, Fourth Edition," Springer, 2020. [Online]. Available: https://doi.org/10.1007/978-3-030-26253-2 DOI: https://doi.org/10.1007/978-3-030-26253-2

Ponemon Institute, "Cost of Data Center Outages," 2016. [Online]. Available: https://www.vertiv.com/globalassets/documents/reports/2016-cost-of-data-center-outages-11-11_51190_1.pdf

UK Parliament, "IT failures in the Financial Services Sector," 2019. [Online]. Available: https://publications.parliament.uk/pa/cm201919/cmselect/cmtreasy/224/224.pdf

Basel Committee on Banking Supervision, "Principles for the Sound Management of Operational Risk," 2011. [Online]. Available: https://www.bis.org/publ/bcbs195.pdf

Visa Inc., "Visa Fact Sheet," 2021. [Online]. Available:https://usa.visa.com/dam/VCOM/download/corporate/media/VisaInc_factsheet_11012015%20%28002%29.pdf

P. Jogalekar and M. Woodside, "Evaluating the scalability of distributed systems," in IEEE Transactions on Parallel and Distributed Systems, vol. 11, no. 6, pp. 589-603, June 2000, doi: 10.1109/71.862209. [Online]. Available: https://ieeexplore.ieee.org/abstract/document/862209 DOI: https://doi.org/10.1109/71.862209

S. Sakr and A. Liu, "SLA-Based and Consumer-Centric Dynamic Provisioning for Cloud Databases," IEEE Cloud Computing, vol. 2, no. 3, pp. 48-58, 2015. [Online]. Available: https://ieeexplore.ieee.org/document/6253526

A. A. Cárdenas, P. K. Manadhata, and S. P. Rajan, "Big Data Analytics for Security," IEEE Security & Privacy, vol. 11, no. 6, pp. 74-76, 2013. [Online]. Available: https://ieeexplore.ieee.org/document/6682971 DOI: https://doi.org/10.1109/MSP.2013.138

Hugo Bruneliere, Vittoriano Muttillo, Romina Eramo, Luca Berardinelli, Abel Gómez, Alessandra Bagnato, Andrey Sadovykh, Antonio Cicchetti, AIDOaRt: AI-augmented Automation for DevOps, a model-based framework for continuous development in Cyber–Physical Systems, Microprocessors and Microsystems, Volume 94, 2022, 104672, ISSN 0141-9331, https://doi.org/10.1016/j.micpro.2022.104672 DOI: https://doi.org/10.1016/j.micpro.2022.104672