International Peer-Reviewed Journal•Open Access•ISSN 2456-8880
irejournals@gmail.com•+91-7433024337

Home / Current Issue / Paper 1709984

1709984 Vol 4 · Issue 2 Download Paper

Autonomous Data Warehousing for Financial Institutions: Architectures for Continuous Integration, Scalability, and Regulatory Compliance

Olatunde Gaffar Ayoola Olamilekan Sikiru Mary Otunba Adedoyin Adeola Adenuga

Subject area: Science,Engineering and Technology  ·  Area of research: Autonomous Data

Abstract

Autonomous Data Warehousing (ADW) represents a transformative shift in how financial institutions manage, scale, and secure their data infrastructure. As regulatory requirements become increasingly complex and real-time data analytics becomes critical to competitiveness, traditional data warehouses are proving inadequate in terms of scalability, integration speed, and compliance enforcement. This paper explores the architectural foundations and strategic value of ADW within financial institutions, with a particular focus on continuous integration (CI), scalability, and regulatory compliance. ADW architectures leverage machine learning, self-tuning capabilities, and cloud-native design to automate data ingestion, indexing, query optimization, and security enforcement. Through integrated CI pipelines, these systems enable seamless updates and schema evolution without disrupting operations?essential for supporting agile analytics, digital product development, and cross-functional reporting. Scalability is achieved through elastic compute-storage decoupling, distributed query execution, and resource auto-provisioning, ensuring institutions can handle massive volumes of transactional and unstructured financial data in real-time. Moreover, regulatory compliance?particularly with global standards such as Basel III, GDPR, and anti-money laundering (AML) frameworks?is embedded into the architectural fabric through policy-driven access controls, immutable audit logs, and encryption at rest and in transit. ADW platforms support metadata tagging, data lineage tracking, and automated anomaly detection, all of which enhance audit readiness and reduce compliance risk. The paper argues that the convergence of automation, cloud elasticity, and regulatory intelligence within ADW offers financial institutions a resilient and future-proof data backbone. As financial ecosystems become more decentralized and data-intensive, the adoption of autonomous data warehousing will be critical for institutions seeking to accelerate decision-making, reduce operational risk, and maintain regulatory trust. This architecture not only redefines technical possibilities but also sets a strategic precedent for the future of data-driven finance.

Keywords

Autonomous data, Warehousing, Financial institutions, Architectures, Continuous integration, Scalability, Regulatory compliance

References

[1] Ahmed, U., 2019. The Importance of cross-border regulatory cooperation in an era of digital trade. World Trade Review, 18(S1), pp.S99-S120.

[2] Ajonbadi Adeniyi H., AboabaMojeed-Sanni, B. and Otokiti, B.O., 2015. Sustaining competitive advantage in medium-sized enterprises (MEs) through employee social interaction and helping behaviours. Journal of Small Business and Entrepreneurship, 3(2), pp.1-16.

[3] Ajonbadi, H.A., Lawal, A.A., Badmus, D.A. and Otokiti, B.O., 2014. Financial control and organisational performance of the Nigerian small and medium enterprises (SMEs): A catalyst for economic growth. American Journal of Business, Economics and Management, 2(2), pp.135-143.

[4] Ajonbadi, H.A., Otokiti, B.O. and Adebayo, P., 2016. The efficacy of planning on organisational performance in the Nigeria SMEs. European Journal of Business and Management, 24(3), pp.25-47.

[5] Akinbola, O.A. and Otokiti, B.O., 2012. Effects of lease options as a source of finance on profitability performance of small and medium enterprises (SMEs) in Lagos State, Nigeria. International Journal of Economic Development Research and Investment, 3(3), pp.70-76.

[6] Akinbola, O.A., Otokiti, B.O., Akinbola, O.S. and Sanni, S.A., 2020. Nexus of born global entrepreneurship firms and economic development in Nigeria. Ekonomicko-manazerske spektrum, 14(1), pp.52-64.

[7] Akpan, U.U., Awe, T.E. and Idowu, D., 2019. Types and frequency of fingerprint minutiae in individuals of Igbo and Yoruba ethnic groups of Nigeria. Ruhuna Journal of Science, 10(1).

[8] Akpe, O.E.E., Mgbame, A.C., Ogbuefi, E., Abayomi, A.A. and Adeyelu, O.O., 2020. Bridging the business intelligence gap in small enterprises: A conceptual framework for scalable adoption. IRE Journals, 4 (2), 159–161 [online]

[9] Amos, A.O., Adeniyi, A.O. and Oluwatosin, O.B., 2014. Market based capabilities and results: inference for telecommunication service businesses in Nigeria. European Scientific Journal, 10(7).

[10] Aranda, J., Wood, B.K. and Vidokle, A. eds., 2017. Supercommunity: Diabolical togetherness beyond contemporary art. Verso Books.

[11] Arner, D.W., Zetzsche, D.A., Buckley, R.P. and Barberis, J.N., 2019. The identity challenge in finance: from analogue identity to digitized identification to digital KYC utilities. European business organization law review, 20(1), pp.55-80.

[12] Awe, E.T. and Akpan, U.U., 2017. Cytological study of Allium cepa and Allium sativum.

[13] Bakshi, W.J., 2019. A Comparative Study of Data Warehouse Architectures in Enhancing Enterprise Data Portals through Logical Data Integration Strategies. Educational Administration: Theory and Practice, 25(2), pp.427-432.

[14] Bellatreche, L., 2018. Optimization and tuning in data warehouses. In Encyclopedia of Database Systems (pp. 2619-2628). Springer, New York, NY.

[15] Boobier, T., 2018. Advanced analytics and AI: Impact, implementation, and the future of work. John Wiley & Sons.

[16] Boschert, S., Coughlin, T., Ferraris, M., Flammini, F., Florido, J.G., Gonzalez, A.C., Henz, P., de Kerckhove, D., Rosen, R., Saracco, R. and Singh, A., 2019. Symbiotic autonomous systems. IEEE Digital Reality.

[17] Brousmiche, K.L., Durand, A., Heno, T., Poulain, C., Dalmieres, A. and Hamida, E.B., 2018, July. Hybrid cryptographic protocol for secure vehicle data sharing over a consortium blockchain. In 2018 IEEE international conference on internet of things (iThings) and IEEE green computing and communications (greenCom) and IEEE cyber, physical and social computing (cPSCom) and IEEE smart data (smartData) (pp. 1281-1286). IEEE.

[18] Colombo, A.W., Karnouskos, S., Kaynak, O., Shi, Y. and Yin, S., 2017. Industrial cyberphysical systems: A backbone of the fourth industrial revolution. IEEE Industrial Electronics Magazine, 11(1), pp.6-16.

[19] Desai, D.R. and Kroll, J.A., 2017. Trust but verify: A guide to algorithms and the law. Harv. JL & Tech., 31, p.1.

[20] FAGBORE, O.O., OGEAWUCHI, J.C., ILORI, O., ISIBOR, N.J., ODETUNDE, A. and ADEKUNLE, B.I., 2020. Developing a Conceptual Framework for Financial Data Validation in Private Equity Fund Operations.

[21] Galvez, J.F., Mejuto, J.C. and Simal-Gandara, J., 2018. Future challenges on the use of blockchain for food traceability analysis. TrAC Trends in Analytical Chemistry, 107, pp.222-232.

[22] Gholami, M.F., Daneshgar, F., Beydoun, G. and Rabhi, F., 2017. Challenges in migrating legacy software systems to the cloud—an empirical study. Information Systems, 67, pp.100-113.

[23] ILORI, O., LAWAL, C.I., FRIDAY, S.C., ISIBOR, N.J. and CHUKWUMA-EKE, E.C., 2020. Blockchain-Based Assurance Systems: Opportunities and Limitations in Modern Audit Engagements.

[24] Jamil, H.M. and Sadri, F., 2018. Crowd enabled curation and querying of large and noisy text mined protein interaction data. Distributed and Parallel Databases, 36(1), pp.9-45.

[25] Kumar, T.V., 2018. REAL-TIME COMPLIANCE MONITORING IN BANKING OPERATIONS USING AI.

[26] Lauterbach, A., 2019. Artificial intelligence and policy: quo vadis?. Digital Policy, Regulation and Governance, 21(3), pp.238-263.

[27] Lawal, A.A., Ajonbadi, H.A. and Otokiti, B.O., 2014. Leadership and organisational performance in the Nigeria small and medium enterprises (SMEs). American Journal of Business, Economics and Management, 2(5), p.121.

[28] Lawal, A.A., Ajonbadi, H.A. and Otokiti, B.O., 2014. Strategic importance of the Nigerian small and medium enterprises (SMES): Myth or reality. American Journal of Business, Economics and Management, 2(4), pp.94-104.

[29] Mgbame, A.C., Akpe, O.E.E., Abayomi, A.A., Ogbuefi, E., Adeyelu, O.O. and Mgbame, A.C., 2020. Barriers and enablers of BI tool implementation in underserved SME communities. IRE Journals, 3(7), pp.211-223.

[30] NETTO, M.A., TOOSI, A.N., RODRIGUEZ, M.A., LLORENTE, I.M., DI VIMERCATI, S.D.C., SAMARATI, P., MILOJICIC, D., VARELA, C., BAHSOON, R., DE ASSUNCAO, M.D. and RANA, O., 2018. A Manifesto for Future Generation Cloud Computing: Research Directions for the Next Decade.

[31] Ogundipe F, Sampson E, Bakare OI, Oketola O, Folorunso A. Digital Transformation and its Role in Advancing the Sustainable Development Goals (SDGs). transformation. 2019;19:48.

[32] Oni, O., Adeshina, Y.T., Iloeje, K.F. and Olatunji, O.O., ARTIFICIAL INTELLIGENCE MODEL FAIRNESS AUDITOR FOR LOAN SYSTEMS. Journal ID, 8993, p.1162.

[33] ONYEKACHI, O., ONYEKA, I.G., CHUKWU, E.S., EMMANUEL, I.O. and UZOAMAKA, N.E., 2020. Assessment of Heavy Metals; Lead (Pb), Cadmium (Cd) and Mercury (Hg) Concentration in Amaenyi Dumpsite Awka. IRE J., 3, pp.41-53.

[34] Osabuohien, F.O., 2017. Review of the environmental impact of polymer degradation. Communication in Physical Sciences, 2(1).

[35] Osabuohien, F.O., 2019. Green Analytical Methods for Monitoring APIs and Metabolites in Nigerian Wastewater: A Pilot Environmental Risk Study. Communication In Physical Sciences, 4(2), pp.174-186.

[36] Otokiti, B.O. and Akinbola, O.A., 2013. Effects of lease options on the organizational growth of small and medium enterprise (SME’s) in Lagos State, Nigeria. Asian Journal of Business and Management Sciences, 3(4), pp.1-12.

[37] Otokiti, B.O. and Akorede, A.F., 2018. Advancing sustainability through change and innovation: A co-evolutionary perspective. Innovation: Taking creativity to the market. Book of Readings in Honour of Professor SO Otokiti, 1(1), pp.161-167.

[38] Otokiti, B.O., 2012. Mode of entry of multinational corporation and their performance in the Nigeria market (Doctoral dissertation, Covenant University).

[39] Otokiti, B.O., 2017. A study of management practices and organisational performance of selected MNCs in emerging market-A Case of Nigeria. International Journal of Business and Management Invention, 6(6), pp.1-7.

[40] Otokiti, B.O., 2017. Social media and business growth of women entrepreneurs in Ilorin metropolis. International Journal of Entrepreneurship, Business and Management, 1(2), pp.50-65.

[41] Otokiti, B.O., 2018. Business regulation and control in Nigeria. Book of readings in honour of Professor SO Otokiti, 1(2), pp.201-215.

[42] Paik, H.Y., Xu, X., Bandara, H.D., Lee, S.U. and Lo, S.K., 2019. Analysis of data management in blockchain-based systems: From architecture to governance. Ieee Access, 7, pp.186091-186107.

[43] Palanivel, K., 2019. Machine Learning Architecture to Financial Service Organizations [J]. International Journal of Computer Sciences and Engineering, 7(11), pp.85-104.

[44] Pektaş, A. and Acarman, T., 2017. Classification of malware families based on runtime behaviors. Journal of information security and applications, 37, pp.91-100.

[45] Pramanik, H.S., Kirtania, M. and Pani, A.K., 2019. Essence of digital transformation—Manifestations at large financial institutions from North America. Future Generation Computer Systems, 95, pp.323-343.

[46] Raj, P. and Raman, A., 2018. Software-defined Cloud Centers. Springer.

[47] Ravi, V. and Kamaruddin, S., 2017, November. Big data analytics enabled smart financial services: opportunities and challenges. In International conference on big data analytics (pp. 15-39). Cham: Springer International Publishing.

[48] Rejeb, A., Keogh, J.G. and Treiblmaier, H., 2019. Leveraging the internet of things and blockchain technology in supply chain management. Future Internet, 11(7), p.161.

[49] Ronthal, A.M., Edjlali, R. and Greenwald, R., 2018. Magic Quadrant for Data Management Solutions for Analytics. Gartner, Inc. ID: G00326691, pp.1-39.

[50] Sarkar, A. and Shah, A., 2018. Learning AWS: Design, build, and deploy responsive applications using AWS Cloud components. Packt Publishing Ltd.

[51] Schmidt, R., Ulanova, D., Wick, L.Y., Bode, H.B. and Garbeva, P., 2019. Microbe-driven chemical ecology: past, present and future. The ISME journal, 13(11), pp.2656-2663.

[52] Scholl, H.J. and Bolívar, M.P.R., 2019. Regulation as both enabler of technology use and global competitive tool: The Gibraltar case. Government Information Quarterly, 36(3), pp.601-613.

[53] Shahin, M., Babar, M.A. and Zhu, L., 2017. Continuous integration, delivery and deployment: a systematic review on approaches, tools, challenges and practices. IEEE access, 5, pp.3909-3943.

[54] Shyam, V., Friend, L., Whiteaker, B., Bense, N., Dowdall, J., Boktor, B., Johny, M., Reyes, I., Naser, A., Sakhamuri, N. and Kravets, V., 2019. PeTaL (periodic table of life) and physiomimetics. Designs, 3(3), p.43.

[55] Stonebraker, M., Madden, S., Abadi, D.J., Harizopoulos, S., Hachem, N. and Helland, P., 2018. The end of an architectural era: it's time for a complete rewrite. In Making Databases Work: the Pragmatic Wisdom of Michael Stonebraker (pp. 463-489).

[56] Swan, M., 2018. Blockchain for business: Next-generation enterprise artificial intelligence systems. In Advances in computers (Vol. 111, pp. 121-162). Elsevier.

[57] Todd, L.M., 2017. Sexual Treason in Germany during the First World War (p. 107123). New York, NY: Palgrave Macmillan.

[58] Wirtz, B.W. and Müller, W.M., 2019. An integrated artificial intelligence framework for public management. Public Management Review, 21(7), pp.1076-1100.

[59] Yeoh, P., 2017. Regulatory issues in blockchain technology. Journal of Financial Regulation and Compliance, 25(2), pp.196-208.

[60] Youpa, D.G., Baweja, J.A., Vargheese, D.R., Nelson, L.C. and Reed, S.C., 2018. Tier 1 and Tier 3 eAdjudication business rule validation.

How to cite this paper

Olatunde Gaffar, Ayoola Olamilekan Sikiru, Mary Otunba, Adedoyin Adeola Adenuga "Autonomous Data Warehousing for Financial Institutions: Architectures for Continuous Integration, Scalability, and Regulatory Compliance" Iconic Research And Engineering Journals Volume 4 Issue 2 2020 Page 332-347
Olatunde Gaffar, Ayoola Olamilekan Sikiru, Mary Otunba, Adedoyin Adeola Adenuga "Autonomous Data Warehousing for Financial Institutions: Architectures for Continuous Integration, Scalability, and Regulatory Compliance" Iconic Research And Engineering Journals, vol. 4, no. 2, Aug. 2020
Olatunde Gaffar, Ayoola Olamilekan Sikiru, Mary Otunba, Adedoyin Adeola Adenuga (2020). Autonomous Data Warehousing for Financial Institutions: Architectures for Continuous Integration, Scalability, and Regulatory Compliance. Iconic Research And Engineering Journals, 4(2).
Olatunde Gaffar, Ayoola Olamilekan Sikiru, Mary Otunba, Adedoyin Adeola Adenuga "Autonomous Data Warehousing for Financial Institutions: Architectures for Continuous Integration, Scalability, and Regulatory Compliance" Iconic Research And Engineering Journals, vol. 4, no. 2, Aug. 2020.
@article{1709984,
      author = {Olatunde Gaffar, Ayoola Olamilekan Sikiru, Mary Otunba, Adedoyin Adeola Adenuga},
      title = {Autonomous Data Warehousing for Financial Institutions: Architectures for Continuous Integration, Scalability, and Regulatory Compliance},
      journal = {Iconic Research And Engineering Journals},
      year = {2020},
      volume = {4},
      number = {2},
      pages = {332-347},
      issn = {2456-8880},
      url = {https://www.irejournals.com/formatedpaper/1709984.pdf},
      abstract = {Autonomous Data Warehousing (ADW) represents a transformative shift in how financial institutions manage, scale, and secure their data infrastructure. As regulatory requirements become increasingly complex and real-time data analytics becomes critical to competitiveness, traditional data warehouses are proving inadequate in terms of scalability, integration speed, and compliance enforcement. This paper explores the architectural foundations and strategic value of ADW within financial institutions, with a particular focus on continuous integration (CI), scalability, and regulatory compliance. ADW architectures leverage machine learning, self-tuning capabilities, and cloud-native design to automate data ingestion, indexing, query optimization, and security enforcement. Through integrated CI pipelines, these systems enable seamless updates and schema evolution without disrupting operations?essential for supporting agile analytics, digital product development, and cross-functional reporting. Scalability is achieved through elastic compute-storage decoupling, distributed query execution, and resource auto-provisioning, ensuring institutions can handle massive volumes of transactional and unstructured financial data in real-time. Moreover, regulatory compliance?particularly with global standards such as Basel III, GDPR, and anti-money laundering (AML) frameworks?is embedded into the architectural fabric through policy-driven access controls, immutable audit logs, and encryption at rest and in transit. ADW platforms support metadata tagging, data lineage tracking, and automated anomaly detection, all of which enhance audit readiness and reduce compliance risk. The paper argues that the convergence of automation, cloud elasticity, and regulatory intelligence within ADW offers financial institutions a resilient and future-proof data backbone. As financial ecosystems become more decentralized and data-intensive, the adoption of autonomous data warehousing will be critical for institutions seeking to accelerate decision-making, reduce operational risk, and maintain regulatory trust. This architecture not only redefines technical possibilities but also sets a strategic precedent for the future of data-driven finance.},
      keywords = {Autonomous data, Warehousing, Financial institutions, Architectures,  Continuous integration, Scalability, Regulatory compliance},
      month = {August},
  }