A cross-platform data mart synchronization model for high availability in dual-cloud architectures
DOI:
https://doi.org/10.64171/JAES.1.1.70-77Keywords:
Dual-cloud architecture, Data mart synchronization, Change data capture (CDC), High availability, Conflict resolution, Multi-cloud data governanceAbstract
In the evolving landscape of enterprise data management, dual-cloud architectures have become a strategic choice to enhance redundancy, compliance, and vendor flexibility. However, ensuring high availability and consistent data synchronization across heterogeneous cloud platforms poses significant technical challenges, particularly for distributed data marts supporting critical analytical workloads. This paper presents a comprehensive, platform-agnostic synchronization model designed to address these challenges by harmonizing disparate storage engines, replication protocols, and metadata schemes. The proposed layered architecture incorporates real-time Change Data Capture mechanisms, bidirectional synchronization logic, and advanced conflict resolution strategies to maintain near-real-time data consistency. Embedded monitoring, automated recovery workflows, and governance controls further strengthen system reliability and compliance. The model facilitates seamless failover and resilience against cloud-specific outages and regional failures, while optimizing operational efficiency through incremental sync and smart batching. By bridging theoretical foundations with practical implementation considerations, this work advances the state of cross-cloud data mart synchronization and supports modern multi-cloud data strategies. Future research directions include AI-enhanced conflict resolution and empirical validation of synchronization performance, promising to extend the model’s applicability and robustness in dynamic data environments.
References
Schrama A. Managing multi-cloud systems.
Raj P, Raman A, Raj P, Raman A. Multi-cloud management: technologies, tools, and techniques. In: Software-defined cloud centers: Operational and management technologies and tools. 2018. p. 219–40.
Montalbano M. Definition of a microservices-based management and monitoring system for Oracle Cloud [master’s thesis]. Torino: Politecnico di Torino; 2021.
Raj P, et al. High-performance integrated systems, databases, and warehouses for big and fast data analytics. In: High-Performance Big-Data Analytics: Computing Systems and Approaches. 2015. p. 233–74.
Snedaker S. Business continuity and disaster recovery planning for IT professionals. Waltham (MA): Newnes; 2013.
Hiles A. Business continuity management: Global best practices. Brookfield (CT): Rothstein Publishing; 2014.
Bajgorić N, Turulja L, Ibrahimović S, Alagić A. Enhancing business continuity and IT capability: System administration and server operating platforms. Boca Raton (FL): Auerbach Publications; 2020.
Jorrigala V. Business continuity and disaster recovery plan for information security. 2017.
Ramachandran M, Chang V. Towards performance evaluation of cloud service providers for cloud data security. Int J Inf Manag. 2016;36(4):618–25.
Wallace M, Webber L. The disaster recovery handbook: A step-by-step plan to ensure business continuity and protect vital operations, facilities, and assets. New York: Amacom; 2017.
Rosenthal A, Mork P, Li MH, Stanford J, Koester D, Reynolds P. Cloud computing: a new business paradigm for biomedical information sharing. J Biomed Inform. 2010;43(2):342–53.
Birman KP. Guide to reliable distributed systems: building high-assurance applications and cloud-hosted services. New York: Springer; 2012.
Chang V, Ramachandran M. Towards achieving data security with the cloud computing adoption framework. IEEE Trans Serv Comput. 2015;9(1):138–51.
Castano S, De Antonellis V. Global viewing of heterogeneous data sources. IEEE Trans Knowl Data Eng. 2001;13(2):277–97.
Motro A, Anokhin P. Fusionplex: resolution of data inconsistencies in the integration of heterogeneous information sources. Inf Fusion. 2006;7(2):176–96.
Fileto R. Issues on interoperability and integration of heterogeneous geographical data. In: Proc III Brazilian Symp Geoinformatics - GEOINFO. 2001. p. 133–40.
Hull R. Managing semantic heterogeneity in databases: a theoretical perspective. In: Proc 16th ACM SIGACT-SIGMOD-SIGART Symp Principles of Database Systems. 1997. p. 51–61.
George D. Understanding structural and semantic heterogeneity in the context of database schema integration. J Dep Comput UCLAN. 2005;4(1):29–44.
Hakimpour F, Geppert A. Resolving semantic heterogeneity in schema integration. In: Proc Int Conf Formal Ontology in Information Systems. 2001. p. 297–308.
Kim W, Seo J. Classifying schematic and data heterogeneity in multidatabase systems. Computer. 1991;24(12):12–8.
Reddy M, Prasad BE, Reddy P, Gupta A. A methodology for integration of heterogeneous databases. IEEE Trans Knowl Data Eng. 2002;6(6):920–33.
Ifenatuora GP, Awoyemi O, Atobatele FA. Advances in accessible and culturally relevant eLearning strategies for US corporate and government workforce training.
Adewoyin MA, Ogunnowo EO, Fiemotongha JE, Igunma TO, Adeleke AK. Advances in CFD-driven design for fluid-particle separation and filtration systems in engineering applications. 2021.
Jarke M, Lenzerini M, Vassiliou Y, Vassiliadis P. Fundamentals of data warehouses. New York: Springer; 2013.
Bergeron B. 4/Data repositories, data marts, and data. In: Electronic medical records: a guide for clinicians and administrators. 2001. p. 73.
Heinonen J. From classical DW to cloud data warehouse [master’s thesis]. Helsinki: University of Helsinki; 2020 [cited 2025 Jul 8]. Available from: https://helda.helsinki.fi/bitstream/handle/10138/322467/JyrkiHeinonen_Masters_Thesis_V1.0.pdf
Francis JE. A data warehouse architecture for DoD healthcare performance measurements [master’s thesis]. Monterey (CA): Naval Postgraduate School; 1999.
Ravi K, Khandelwal Y, Krishna BS, Ravi V. Analytics in/for cloud—an interdependence: a review. J Netw Comput Appl. 2018;102:17–37.
Ravi K, Khandelwal Y, Shivakrishna B, Ravi V. Analytics in/for cloud—an interdependence. 2017.
Hammer J, Schneider M, Sellis T. Data warehousing at the crossroads. In: Dagstuhl Perspectives Workshop. Dagstuhl; 2004.
Eklund M. Data warehousing in the cloud: analysis of an implementation project. 2018.
Jamjoom A. Transitioning a clinical unit to a data warehouse [master’s thesis]. Surrey (UK): University of Surrey; 2011.
Komi LS, Chianumba EC, Yeboah A, Forkuo DO, Mustapha AY. Advances in community-led digital health strategies for expanding access in rural and underserved populations. 2021.
Onifade AY, Ogeawuchi JC, Abayomi AA, Aderemi O. Advances in CRM-driven marketing intelligence for enhancing conversion rates and lifetime value models.
Mansouri Y, Toosi AN, Buyya R. Data storage management in cloud environments: taxonomy, survey, and future directions. ACM Comput Surv. 2017;50(6):1–51.
Li Z, Zhang Y, Liu Y. Towards a full-stack DevOps environment (platform-as-a-service) for cloud-hosted applications. Tsinghua Sci Technol. 2017;22(1):1–9.
Baras S, Saeed I, Hajjdiab H. Security and privacy of AWS S3 and Azure Blob storage services.
Saeed I, Baras S, Hajjdiab H. Security and privacy of AWS S3 and Azure Blob storage services. In: 2019 IEEE 4th Int Conf Comput Commun Syst (ICCCS). IEEE; 2019. p. 388–94.
Sikeridis D, Papapanagiotou I, Rimal BP, Devetsikiotis M. A comparative taxonomy and survey of public cloud infrastructure vendors. arXiv. 2017. arXiv:1710.01476.
Mansouri Y, Buyya R. Data access management system in Azure Blob Storage and AWS S3 multi-cloud storage environments. In: Handbook of Research on Intrusion Detection Systems. 2020. p. 130–47.
Onifade AY, Dosumu RE, Abayomi AA, Aderemi O. Advances in cross-industry application of predictive marketing intelligence for revenue uplift.
Omoegun G, Fiemotongha JE, Omisola JO, Okenwa OK, Onaghinor O. Advances in ERP-integrated logistics management for reducing delivery delays and enhancing project delivery.
Campbell B. The definitive guide to AWS infrastructure automation.
Hilley D. Cloud computing: a taxonomy of platform and infrastructure-level offerings. Georgia Institute of Technology; 2009. Tech Rep. p. 44–5.
Zburivsky D, Partner L. Designing cloud data platforms. New York: Simon & Schuster; 2021.
Tan J, et al. Choosing a cloud DBMS: architectures and tradeoffs. 2021.
Opara C. Cloud computing in Amazon Web Services, Microsoft Windows Azure, Google App Engine and IBM Cloud platforms: a comparative study [dissertation]. Near East University; 2019.
Foster I, Gannon DB. Cloud computing for science and engineering. Cambridge (MA): MIT Press; 2017.
Okolo FC, Etukudoh EA, Ogunwole O, Osho GO, Basiru JO. Systematic review of cyber threats and resilience strategies across global supply chains and transportation networks. 2021.
Abayomi AA, Ogeawuchi JC, Onifade AY, Aderemi O. Systematic review of marketing attribution techniques for omnichannel customer acquisition models.
Ogunnowo EO, Adewoyin MA, Fiemotongha JE, Igunma TO, Adeleke AK. Systematic review of non-destructive testing methods for predictive failure analysis in mechanical systems. 2020.
Odetunde A, Adekunle BI, Ogeawuchi JC. A systems approach to managing financial compliance and external auditor relationships in growing enterprises. 2021.
Omisola JO, Shiyanbola JO, Osho GO. A systems-based framework for ISO 9000 compliance: applying statistical quality control and continuous improvement tools in US manufacturing. 2020.
Ifenatuora GP, Awoyemi O, Atobatele FA. Advances in instructional design for experiential mobile classrooms in resource-constrained environments.
Onifade AY, Ogeawuchi JC, Abayomi A, Agboola O, George O. Advances in multi-channel attribution modeling for enhancing marketing ROI in emerging economies. Iconic Res Eng J. 2021;5(6):360–76.
Ajayi OO, Chukwurah N, Adebayo AS. Securing 5G network infrastructure from protocol-based attacks and network slicing exploits in advanced telecommunications.
Akpe OE, Ubanadu BC, Daraojimba AI, Agboola OA, Ogbuefi E. A strategic framework for aligning fulfillment speed, customer satisfaction, and warehouse team efficiency.
Omisola JO, Etukudoh EA, Onukwulu EC, Osho GO. Sustainability and efficiency in global supply chain operations using data-driven strategies and advanced business analytics.
Bunmi KA, Adeyemo KS. A review on targeted drug development for breast cancer using innovative active pharmaceutical ingredients (APIs).
Ojika FU, Owobu WO, Abieba OA, Esan OJ, Ubamadu BC, Daraojimba AI. The role of AI in cybersecurity: a cross-industry model for integrating machine learning and data analysis for improved threat detection.
Adeyemo KS, Mbata AO, Balogun OD. The role of cold chain logistics in vaccine distribution: addressing equity and access challenges in Sub-Saharan Africa.
Omisola JO, Shiyanbola JO, Osho GO. A predictive quality assurance model using Lean Six Sigma: integrating FMEA, SPC, and root cause analysis for zero-defect production systems. 2020.
Monebi MA, Alenoghena C, Abolarinwa J. Redefining the directivity value of radial-lines-slot-array antenna for direct broadcast satellite (DBS) service. 2018.
Ajuwon A, Adewuyi A, Nwangele CR, Akintobi AO. Blockchain technology and its role in transforming financial services: the future of smart contracts in lending.
Ajuwon A, Adewuyi A, Oladuji TJ, Akintobi AO. A model for strategic investment in African infrastructure: using AI for due diligence and portfolio optimization.
Adeleke AK, Igunma TO, Nwokediegwu ZS. Modeling advanced numerical control systems to enhance precision in next-generation coordinate measuring machine. Int J Multidiscip Res Growth Eval. 2021;2(1):638–49.
Kufile OT, Otokiti BO, Onifade AY, Ogunwale B, Okolo CH. Modelling attribution-driven budgeting systems for high-intent consumer acquisition.
Ojika FU, Owobu WO, Abieba OA, Esan OJ, Ubamadu BC, Ifesinachi A. Optimizing AI models for cross-functional collaboration: a framework for improving product roadmap execution in agile teams. 2021.
Oluoha O, Odeshina A, Reis O, Okpeke F, Attipoe V, Orieno O. Optimizing business decision-making with advanced data analytics techniques. Iconic Res Eng J. 2022;6(5):184–203.
Gbabo EY, Okenwa OK, Chima PE. Integrating CDM regulations into role-based compliance models for energy infrastructure projects.
Oladuji TJ, Akintobi AO, Nwangele CR, Ajuwon A. A model for leveraging AI and big data to predict and mitigate financial risk in African markets.
Monebi AM, Iliya SZ. An improved mathematical modelling of directivity for radial line slot array antenna. 2020.
Ogeawuchi JC, Uzoka AC, Abayomi A, Agboola O, Gbenle TP, Ajayi OO. Innovations in data modeling and transformation for scalable business intelligence on modern cloud platforms. Iconic Res Eng J. 2021;5(5):406–15.
Osho GO, Omisola JO, Shiyanbola JO. An integrated AI–Power BI model for real-time supply chain visibility and forecasting: a data-intelligence approach to operational excellence. 2020.
Chianumba EC, Forkuo AY, Mustapha AY, Osamika D, Komi LS. Advances in preventive care delivery through WhatsApp, SMS, and IVR messaging in high-need populations.
Nwangele CR, Adewuyi A, Ajuwon A, Akintobi AO. Advances in sustainable investment models: leveraging AI for social impact projects in Africa.
Omisola JO, Chima PE, Okenwa OK, Tokunbo GI. Green financing and investment trends in sustainable LNG projects: a comprehensive review. 2020.
Bassey DB, et al. The impact of Worms and Ladders, an innovative health educational board game on soil-transmitted helminthiasis control in Abeokuta, Southwest Nigeria. PLoS Negl Trop Dis. 2020;14(9):e0008486.
Adewoyin MA, Ogunnowo EO, Fiemotongha JE, Igunma TO, Adeleke AK. Advances in thermofluid simulation for heat transfer optimization in compact mechanical devices. 2020.
Adenuga T, Ayobami AT, Okolo FC. AI-driven workforce forecasting for peak planning and disruption resilience in global logistics and supply networks.
Ajiga DI, Hamza O, Eweje A, Kokogho E, Odio PE. Forecasting IT financial planning trends and analyzing impacts on industry standards.
Omisola JO, Etukudoh EA, Okenwa OK, Olugbemi GIT, Ogu E. Future directions in advanced instrumentation for the oil and gas industry: a conceptual analysis.
Omisola JO, Etukudoh EA, Okenwa OK, Olugbemi GIT, Ogu E. Geomechanical modeling for safe and efficient horizontal well placement: analysis of stress distribution and rock mechanics to optimize well placement and minimize drilling. 2020.
Omisola JO, Etukudoh EA, Okenwa OK, Tokunbo GI. Geosteering: real-time geosteering optimization using deep learning algorithms—integration of deep reinforcement learning in real-time well trajectory adjustment to maximize. 2020.
Sharma A, Adekunle BI, Ogeawuchi JC, Abayomi AA, Onifade O. Governance challenges in cross-border fintech operations: policy, compliance, and cyber risk management in the digital age. 2021.
Oluoha O, Odeshina A, Reis O, Okpeke F, Attipoe V, Orieno O. Development of a compliance-driven identity governance model for enhancing enterprise information security. Iconic Res Eng J. 2021;4(11):310–24.
Idemudia BMOSO, Chima OK, Ezeilo OJ, Ochefu A. Entrepreneurship resilience models in resource-constrained settings: cross-national framework. World. 2579:0544.
Bolarinwa D, Egemba M, Ogundipe M. Developing a predictive analytics model for cost-effective healthcare delivery: a conceptual framework for enhancing patient outcomes and reducing operational costs.
Odetunde A, Adekunle BI, Ogeawuchi JC. Developing integrated internal control and audit systems for insurance and banking sector compliance assurance. 2021.
Komi LS, Chianumba EC, Yeboah A, Forkuo DO, Mustapha AY. A conceptual framework for telehealth integration in conflict zones and post-disaster public health responses. 2021.
Ogunnowo EO, Adewoyin MA, Fiemotongha JE, Igunma TO, Adeleke AK. A conceptual model for simulation-based optimization of HVAC systems using heat flow analytics. 2021.
Gbabo EY, Okenwa OK, Chima PE. Constructing AI-enabled compliance automation models for real-time regulatory reporting in energy systems.
Onifade AY, Ogeawuchi JC, Abayomi AA. Data-driven engagement framework: optimizing client relationships and retention in the aviation sector.
Oluoha OM, Odeshina A, Reis O, Okpeke F, Attipoe V, Orieno OH. Designing advanced digital solutions for privileged access management and continuous compliance monitoring.
Fagbore OO, Ogeawuchi JC, Ilori O, Isibor NJ, Odetunde A, Adekunle BI. Developing a conceptual framework for financial data validation in private equity fund operations. 2020.
Akpe OE, Azubike AA, Abayomi EO, Adeyelu OO. AI-enabled dashboards for micro-enterprise profitability optimization: a pilot implementation study.
Komi LS, Chianumba EC, Forkuo AY, Osamika D, Mustapha AY. A conceptual framework for addressing digital health literacy and access gaps in US underrepresented communities.
Osho GO, Omisola JO, Shiyanbola JO. A conceptual framework for AI-driven predictive optimization in industrial engineering: leveraging machine learning for smart manufacturing decisions. 2020.
Ogunnowo EO. A conceptual framework for digital twin deployment in real-time monitoring of mechanical systems.
Adewoyin MA, Ogunnowo EO, Fiemotongha JE, Igunma TO, Adeleke AK. A conceptual framework for dynamic mechanical analysis in high-performance material selection. 2020.
Onifade AY, Ogeawuchi JC, Abayomi A, Agboola O, Dosumu RE, George OO. A conceptual framework for integrating customer intelligence into regional market expansion strategies. Iconic Res Eng J. 2021;5(2):189–94.
Ifenatuora GP, Awoyemi O, Atobatele FA. A conceptual framework for professional upskilling using accessible animated e-learning modules.
