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 i...

Full description

Saved in:
Bibliographic Details
Main Authors: E. V. Vasilieva, K. S. Solyanov, T. D. Konevtseva
Format: Article
Language:Russian
Published: Government of the Russian Federation, Financial University 2020-06-01
Series:Финансы: теория и практика
Subjects:
Online Access:https://financetp.fa.ru/jour/article/view/1015
Tags: Add Tag
No Tags, Be the first to tag this record!
_version_ 1839575104504201216
author E. V. Vasilieva
K. S. Solyanov
T. D. Konevtseva
author_facet E. V. Vasilieva
K. S. Solyanov
T. D. Konevtseva
author_sort E. V. Vasilieva
collection DOAJ
description 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.
format Article
id doaj-art-a93141dd24ea41a5a8e38f96e2c730a1
institution Matheson Library
issn 2587-5671
2587-7089
language Russian
publishDate 2020-06-01
publisher Government of the Russian Federation, Financial University
record_format Article
series Финансы: теория и практика
spelling doaj-art-a93141dd24ea41a5a8e38f96e2c730a12025-08-04T13:11:08ZrusGovernment of the Russian Federation, Financial UniversityФинансы: теория и практика2587-56712587-70892020-06-0124313214610.26794/2587-5671-2020-24-3-132-146785Adaptive Data Warehouse as the Technological basis of the banking EcosystemE. V. Vasilieva0K. S. Solyanov1T. D. Konevtseva2Financial University under the Government of the Russian FederationGlowbyte Analytical SolutionsPJSC VTB BANKNew 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.https://financetp.fa.ru/jour/article/view/1015client pathbankomnichannelecosystemdata warehousedesignmethodologyinformation systemsdigital services
spellingShingle E. V. Vasilieva
K. S. Solyanov
T. D. Konevtseva
Adaptive Data Warehouse as the Technological basis of the banking Ecosystem
Финансы: теория и практика
client path
bank
omnichannel
ecosystem
data warehouse
design
methodology
information systems
digital services
title Adaptive Data Warehouse as the Technological basis of the banking Ecosystem
title_full Adaptive Data Warehouse as the Technological basis of the banking Ecosystem
title_fullStr Adaptive Data Warehouse as the Technological basis of the banking Ecosystem
title_full_unstemmed Adaptive Data Warehouse as the Technological basis of the banking Ecosystem
title_short Adaptive Data Warehouse as the Technological basis of the banking Ecosystem
title_sort adaptive data warehouse as the technological basis of the banking ecosystem
topic client path
bank
omnichannel
ecosystem
data warehouse
design
methodology
information systems
digital services
url https://financetp.fa.ru/jour/article/view/1015
work_keys_str_mv AT evvasilieva adaptivedatawarehouseasthetechnologicalbasisofthebankingecosystem
AT kssolyanov adaptivedatawarehouseasthetechnologicalbasisofthebankingecosystem
AT tdkonevtseva adaptivedatawarehouseasthetechnologicalbasisofthebankingecosystem