Identifying Possible Financial Frauds using SQL Row Pattern Recognition
Dušan Petković · International Journal of Computer Applications · 2022
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.