EUVIMEDEUVIMED entdecken
Open Access · CC BY-NC-ND 4.0

SQL BI Optimization Strategies in Finance and Banking

Sai Krishna Shiramshetty

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

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →