Research Article
Identifying Possible Financial Frauds using SQL Row Pattern Recognition
|
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
|
| Volume 184 - Issue 35 |
| Published: Nov 2022 |
| Authors: Dušan Petković |
10.5120/ijca2022922446
|
Dušan Petković . Identifying Possible Financial Frauds using SQL Row Pattern Recognition. International Journal of Computer Applications. 184, 35 (Nov 2022), 31-34. DOI=10.5120/ijca2022922446
@article{ 10.5120/ijca2022922446,
author = { Dušan Petković },
title = { Identifying Possible Financial Frauds using SQL Row Pattern Recognition },
journal = { International Journal of Computer Applications },
year = { 2022 },
volume = { 184 },
number = { 35 },
pages = { 31-34 },
doi = { 10.5120/ijca2022922446 },
publisher = { Foundation of Computer Science (FCS), NY, USA }
}
%0 Journal Article
%D 2022
%A Dušan Petković
%T Identifying Possible Financial Frauds using SQL Row Pattern Recognition%T
%J International Journal of Computer Applications
%V 184
%N 35
%P 31-34
%R 10.5120/ijca2022922446
%I Foundation of Computer Science (FCS), NY, USA
Abstract
In 2016, the SQL standardization committee finished the work concerning a feature called Row Pattern Recognition. The specification, which was published in the same year, describes the common search for patterns inside the tables’ rows as well as the search inside an existing window frame. In this paper we discuss how this feature can be used to identify suspicious transactions in relation to customers’ bank accounts. Several examples are usedto show the way how transfers to and from one account can be traced, and how possible irregularities can be detected. This paper has two main goals. First, to show strength and conciseness of the SQL specification of this feature. Second, to show a way how to implement complex problems in a particular business area.
References
- ISO/IEC TR 19075-5:2016 Information technology -- Database languages -- SQL Technical Reports -- Part 5: Row Pattern Recognition in SQL, https://standards.iteh.ai/catalog/standards/ iso/2521dd59-7047-4938-a25a-2617fde630df/iso-iec-tr-19075-5-2016, last access 2022/08/08.
- Ben-Gan, I. T-SQL Window Functions, McGraw-Hill, 2019, ASIN: B07Z5BB6W1.
- Petković, D. - Die Unterstützung von SQL/OLAP im SQL-Standard und in relationalen Datenbanksystemen – Teil 2 (in German) , Datenbank Spektrum, 2007, Vol. 7(1), p. 44-52.
- Michels, J.;Hare, K.; Kulkarni, K.; Liu. Z.H.– The New and Improved SQL:2016 Standard, SIGMOD Record, Vol. 47, No.2, 2018, http://dx.doi.org/10.1145/3299887.3299897.
- Petković, D. – Specification of Row Pattern Recognition in SQL Standard and its Implementation, Datenbank Spektrum, 2022, Vol. 22, p.163-74.
- Oracle 12c, MATCH_RECOGNIZE, https://docs.oracle.com/cd/E28280_01/apirefs.1111/e12048/pattern_recog.htm#CQLLR1531, last access 2022/09/01.
Index Terms
Keywords