Adaptive Data Warehouse as the Technological basis of the banking Ecosystem

New guidelines of omnichannel and ecosystem are emerging driven by modern digital transformation of the banking business. To improve customer experience of interaction with banking services more banks are switching to the omnichannel model. In this model, the customer is able to perform operations in a unified interface using any communication methods, and sees no difference in the processes between off-line and on-line operations. This requires changes in a bank’s IT architecture, whose center is a bank data warehouse. The aim of this study is to show the possibility of developing a method for designing a banking data warehouse so that it can be easily adaptable for new business projects and tasks. The authors used the following research methods: analysis, logical modeling of the identified relationships. They developed an adaptive banking data warehouse designer in the environments of SAP PowerDesigner, StarUML, PL/SQL Developer. The article tackles the approach towards development of an adaptive model of a banking data warehouse, based on the principle of splitting data into components. It makes it possible to set the warehouse contours for specific business tasks, combine elements, and expand the structure of the banking data warehouse in the context of its integration with various external software objects. The article highlights the interaction between the components of the banking data warehouse and business tasks, the list of which can be expanded in the context of various bank projects. The article provides a detailed description of the basic set of components of the adaptive banking data warehouse model. This set may serve as the foundation for designing a banking data warehouse for a specific business task. The article provides the data model and attribute composition of the General Ledger component, the data model of the Plastic Cards, Transactions, Applications, Contractors, etc. components, as well as indicates the relationships between the components. The study presents design features of a new type of the banking data warehouse. The authors concentrate on the technological features of creating a unified front-end omnichannel banking system as a separate task. They conclude that the developed basic set of components and business objects of adaptive banking data warehouse will ensure data integrity and reduce design time.

client path, bank, omnichannel, ecosystem, data warehouse, design, methodology, information systems, digital services

1. Lewrick M., Link P., Leifer L. The design thinking playbook: Mindful digital transformation of teams, products, services, businesses and ecosystems. Hoboken, NJ: John Wiley & Sons; 2018. 352 p. (Russ. ed.: Lewrick M., Link P., Leifer L. Dizain-myshlenie. Ot insaita k novym produktam i rynkam. St. Petersburg: Piter; 320 p.).

2. Going digital: The banking transformation road map. A. T. Kearney & Efma. 2014.

3. Vasil’eva E. V. Design thinking: A little bit about the approach and a lot about the tools for creative thinking, studying client requests and creating ideas. Moscow: RuScience; 2019. 204 р. (In Russ.).

4. Brown T. Change by design: How design thinking transforms organizations and inspires innovation. New York: HarperCollins Publishers; 2009. 272 p.

5. Kelley T., Kelley D. Creative confidence: Unleashing the creative potential within us all. New York: Barnes & Noble; 2013. 304 p.

6. Liedtka J., Ogilvie T. Designing for growth: A design thinking toolkit for managers. New York, Chichester: Columbia University Press; 2011. 248 p.

7. Clark T., Osterwalder A., Pigneur Y. Business model you: A one-page method for reinventing your career. New York: John Wiley & Sons; 2012. 256 p.

8. Ries E. The lean startup: How today’s entrepreneurs use continuous innovation to create radically successful businesses. New York: Crown Business; 2013. 336 p.

9. Blank S. The four steps to the epiphany: Successful strategies for products that win. Berks County: K & S Ranch; 2014. 276 p.

10. Goldhill J. The age of omnichannel banking. Transform. URL: http://www.transformuk.com/wp-content/uploads/2015/03/Transform-UK-The-Age-of-Omnichannel-Banking-Report.pdf (accessed on 10.02.2020).

11. Karpuzcu T. Impact of e-services on customer satisfaction. Saarbrücken: LAP Lambert Academic Publishing; 2011. 124 p.

12. Ramadan S. Omnichannel marketing: The roadmap to create and implement omnichannel strategy for your business. Charleston, SC: CreateSpace Independent Publ. Platform; 2016. 66 p.

13. Malhotra J. S. Multi-channel optical communication. Saarbrücken: Scholars’ Press; 2014. 220 p.

14. Skinner C. Digital bank: Strategies to launch or become a digital bank. Singapore: Marshall Cavendish Int. (Asia) Pte Ltd.; 2014. 300 p. (Russ. ed.: Skinner C. Tsifrovoy bank. Kak sozdat’ tsifrovoy bank ili stat’ im. Moscow: Mann, Ivanov and Ferber; 2014. 320 p.).

15. Inmon W. H. Building the data warehouse. New York: John Wiley & Sons Inc.; 2002. 428 p.

16. Poppendick M., Poppendieck T. Implementing lean software development: From concept to cash. Upper Saddle River, NJ: Addison-Wesley; 2006. 304 p. (Russ. ed.: Poppendick M., Poppendieck T. Berezhlivoe proizvodstvo programmnogo obespecheniya: ot idei do pribyli. Moscow: Williams; 2010. 256 p.).

17. Giorgini P., Rizzi S., Garzetti M. GRAnD: A goal-oriented approach to requirement analysis in data warehouses. Decision Support Systems. 2008;45(1):4–21. DOI: 10.1016/j.dss.2006.12.001

18. King B. Breaking banks: The innovators, rogues, and strategists rebooting banking. Singapore: John Wiley & Sons; 2014. 288 p.

19. Arican A. Multichannel marketing: Metrics and methods for on and offline success. Indianapolis, IN: Wiley Publishing; 2008. 312 p.

20. Sommerville I. Software engineering. 6 th ed. Reading, MA: Addison-Wesley; 2000. 720 p. (Russ. ed.: Sommerville I. Inzheneriya programmnogo obespecheniya. Moscow: Williams; 2002. 624 p.).

21. Meyer B. On to components. Computer. 1999;32(1):139–143. DOI: 10.1109/2.738312

22. Gamma E., Helm R., Johnson R., Vlissides J. Design patterns: Elements of reusable object-oriented software. Reading, MA: Addison-Wesley Professional; 1994. 395 p. (Russ. ed.: Gamma E., Helm R., Johnson R., Vlissides J. Priemy ob”ektno-orientirovannogo proektirovaniya. Patterny proektirovaniya. St. Petersburg: Piter; 2001. 368 p.).

23. Alexander C, Ishikawa S. at al. A pattern language: Towns, buildings, construction. New York: Oxford University Press; 1977. 1171 p. (Center for Environmental Structure Series. Vol. 2).

24. Evlanov L. G., Kutuzov V.A. Expert evaluation in management. Moscow: Ekonomika; 1978. 133 p. (In Russ.).