Matches in SemOpenAlex for { <https://semopenalex.org/work/W4366085176> ?p ?o ?g. }
Showing items 1 to 58 of
58
with 100 items per page.
- W4366085176 endingPage "84" @default.
- W4366085176 startingPage "76" @default.
- W4366085176 abstract "Introduction . The banking sector assigns high priority to data storage, as it is a critical aspect of business operations. The volume of data in this area is steadily growing. With the increasing volume of data that needs to be stored, processed and analyzed, it is critically important to select a suitable data storage solution and develop the required architecture. The presented research is aimed at filling the gap in the existing knowledge of the data base management system (DBMS) suitable for the banking sector, as well as to suggest ways for a fault-tolerant data storage cluster. The purpose of the work is to analyze the key DBMS for analytical queries, determine the priorities of the DBMS for the banking sector, and develop a fault-tolerant data storage cluster. To meet the performance and scalability requirements, a data storage solution with a fault-tolerant architecture that meets the requirements of the banking sector has been proposed. Materials and Methods . Domain analysis allowed us to create a set of characteristics that a DBMS for analytical queries (OnLine Analytical processing — OLAP) should correspond to, compare some popular DBMS OLAP, and offer a fault-tolerant cluster configuration written in xml, supported by the ClickHouse DBMS. Automation was done using Ansible Playbook. It was integrated with the Gitlab version control system and Jinja templates. Thus, rapid deployment of the configuration on all nodes of the cluster was achieved. Results . For OLAP databases, criteria were developed and several popular systems were compared. As a result, a reliable cluster configuration that met the requirements of analytical queries has been proposed for the banking industry. To increase the reliability and scalability of the DBMS, the deployment process was automated. Detailed diagrams of the cluster configuration were also provided. Discussion and Conclusions . The compiled criteria for the DBMS OLAP allowed us to determine the need for this solution in the organization. Comparison of popular DBMS can be used by organizations to minimize costs when selecting a solution. The proposed configuration of the data warehouse cluster for analytical queries in the banking sector will improve the reliability of the DBMS and meet the requirements for subsequent scalability. Automation of cluster deployment by the mechanism of templating configuration files in Ansible Playbook provides configuring a ready-made cluster on new servers in minutes." @default.
- W4366085176 created "2023-04-19" @default.
- W4366085176 creator A5004967604 @default.
- W4366085176 creator A5055134916 @default.
- W4366085176 date "2023-04-17" @default.
- W4366085176 modified "2023-10-05" @default.
- W4366085176 title "Data Warehouse Failover Cluster for Analytical Queries in Banking" @default.
- W4366085176 cites W116211684 @default.
- W4366085176 cites W1545087902 @default.
- W4366085176 cites W1565838812 @default.
- W4366085176 cites W1991438431 @default.
- W4366085176 cites W2021668342 @default.
- W4366085176 cites W2037163971 @default.
- W4366085176 cites W2080799914 @default.
- W4366085176 cites W2081307663 @default.
- W4366085176 cites W2084568010 @default.
- W4366085176 cites W2504036839 @default.
- W4366085176 cites W4212931680 @default.
- W4366085176 doi "https://doi.org/10.23947/2687-1653-2023-23-1-76-84" @default.
- W4366085176 hasPublicationYear "2023" @default.
- W4366085176 type Work @default.
- W4366085176 citedByCount "0" @default.
- W4366085176 crossrefType "journal-article" @default.
- W4366085176 hasAuthorship W4366085176A5004967604 @default.
- W4366085176 hasAuthorship W4366085176A5055134916 @default.
- W4366085176 hasBestOaLocation W43660851761 @default.
- W4366085176 hasConcept C109751979 @default.
- W4366085176 hasConcept C135572916 @default.
- W4366085176 hasConcept C201932085 @default.
- W4366085176 hasConcept C41008148 @default.
- W4366085176 hasConcept C48044578 @default.
- W4366085176 hasConcept C77088390 @default.
- W4366085176 hasConceptScore W4366085176C109751979 @default.
- W4366085176 hasConceptScore W4366085176C135572916 @default.
- W4366085176 hasConceptScore W4366085176C201932085 @default.
- W4366085176 hasConceptScore W4366085176C41008148 @default.
- W4366085176 hasConceptScore W4366085176C48044578 @default.
- W4366085176 hasConceptScore W4366085176C77088390 @default.
- W4366085176 hasIssue "1" @default.
- W4366085176 hasLocation W43660851761 @default.
- W4366085176 hasOpenAccess W4366085176 @default.
- W4366085176 hasPrimaryLocation W43660851761 @default.
- W4366085176 hasRelatedWork W1535822977 @default.
- W4366085176 hasRelatedWork W23190051 @default.
- W4366085176 hasRelatedWork W2357522326 @default.
- W4366085176 hasRelatedWork W2363019959 @default.
- W4366085176 hasRelatedWork W2367419170 @default.
- W4366085176 hasRelatedWork W2375394542 @default.
- W4366085176 hasRelatedWork W2377387014 @default.
- W4366085176 hasRelatedWork W2378213774 @default.
- W4366085176 hasRelatedWork W2382180329 @default.
- W4366085176 hasRelatedWork W6138692 @default.
- W4366085176 hasVolume "23" @default.
- W4366085176 isParatext "false" @default.
- W4366085176 isRetracted "false" @default.
- W4366085176 workType "article" @default.