SQL BI Optimization Strategies in Finance and Banking
Integrated Journal for Research in Arts and Humanities · 2021
DOI: 10.55544/ijrah.1.1.15 ↗Kurz gefasst
Fachartikel in der Zeitschrift Integrated Journal for Research in Arts and Humanities, 2021. Verfasst von Sai Krishna Shiramshetty. Die Arbeit wurde bisher 13-mal zitiert (Crossref) und nennt 125 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY-NC-ND 4.0).
Abstract (Originalsprache)
To this end, this paper examines the best practice in making the finance and banking industry SQL BI more efficient and effective in terms of query execution and real-time analysis. Techniques such as Indexing, partitioning, query rewriting, parallel processing, in memory tables are explained practical to large financial data sets. These strategies were identified to enhance techniques such as transaction monitoring, customer analysis, financial reporting, and risk management since their execution duration is time-consuming. The paper will also focus on the role of the optimized SQL queries in the decision-making process and the issues, seen when seeking constant performance in financially volatile demonstrative systems.
Zitieren
APA
Shiramshetty, S. K. (2021). SQL BI Optimization Strategies in Finance and Banking. Integrated Journal for Research in Arts and Humanities. https://doi.org/10.55544/ijrah.1.1.15
Vancouver
Shiramshetty SK. SQL BI Optimization Strategies in Finance and Banking. Integrated Journal for Research in Arts and Humanities. 2021. doi:10.55544/ijrah.1.1.15
BibTeX
@article{Shiramshetty2021,
author = {Shiramshetty, Sai Krishna},
title = {SQL BI Optimization Strategies in Finance and Banking},
journal = {Integrated Journal for Research in Arts and Humanities},
year = {2021},
doi = {10.55544/ijrah.1.1.15}
}
EUVIMED