Modelling of Data Warehouse Dimensions for AML Systems

• Autorzy: Jerzy Korczak , Błażej Oleszkiewicz
• Języki publikacji: EN

Abstrakty

EN

In this article the three main models of data warehouse dimensions (two classical models and hierarchical, based on hierarchical tables) will be evaluated within the context of the use in Anti- -Money Laundering systems. The main focus will be given to a new extension of the Analytical SQL Server: hierarchical tables and vector types used to identify elements in hierarchical tables. A number of examples of time dimension modelling and of Cartesian products computing OLAP will also be presented. (original abstract)

Słowa kluczowe

PL

Hurtownie danych; Modelowanie zjawisk czasowo-przestrzennych; Język programowania SQL; Hierarchiczna struktura organizacyjna

EN

Data warehouse; Modeling of time-space; SQL Programming Language; Hierarchical organizational structure

• Czasopismo: Prace Naukowe Uniwersytetu Ekonomicznego we Wrocławiu
• Rocznik: 2009
• Numer: nr 85 Advanced Information Technologies for Management - AITM 2009
• Strony: 146-159

Twórcy

autor

Jerzy Korczak

• Wrocław University of Economics, Poland

autor

Błażej Oleszkiewicz

• Wrocław University of Economics, Poland

Bibliografia

• Act (2000), Act of 16th November, 2000, on preventing introducing into financial turnover properties derived from illegal or undisclosed sources and on counter-financing of terrorism, Dz.U.03.153.1505.
• Adamson C. (2006), Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance, Wiley, Indianapolis.
• Directive (2005), Directive 2005/60/EC of the European Parliament and the Council of October 26, 2005. Commission Directive 2006/70/EC of August 1, 2006 laying down implementing measures for Directive 2005/60/EC of the European Parliament and the Council.
• Inmon W.H. (2005), Building the Data Warehouse, Wiley, Indianapolis.
• Kimball R., Ross M. (2002), The Data Warehouse Toolkit: The Complete Guide to Dimensional Modelling, Wiley, Indianapolis.
• Korczak J., Mcrchelski W., Oleszkiewicz B. (2008), A New Technological Approach to Money Laundering Discovery using Analytical SQL Server, [in:] Advanced Information Technologies for Management AITM2008, Eds. J. Korczak, H. Dudycz, M. Dyczkowski, Research Papers of the Wroclaw University of Economics No. 35, Publishing House of the University of Wroclaw, Wroclaw.
• Szirtes T. (2007), Applied Dimensional Analysis and Modeling, Elsevier, Burlington.
• The Forty Recommendations of the Financial Action Task Force on Money Laundering (FATF-GAFI), http://www.fatf-gafi.org/