This study has been conducted at Topicus Finance in Deventer where I’ve worked for around Eight months. I’d love to thank Topicus Finance for the chance to do this motivating and demanding project. A special thanks to my supervisors, for the technical assistance, feedback and for giving helpful tips throughout my research.
Contents: Generic model for audit trails
1 INTRODUCTION
1.1 CONTEXT
1.2 PROBLEM STATEMENT
1.3 RESEARCH QUESTIONS
1.4 APPROACH AND OUTLINE
2 BASIC CONCEPTS
2.1 AUDIT TRAIL
2.2 PROVENANCE
2.2.1 Workflow provenance
2.2.2 Data provenance
2.2.3 Provenance and archiving
2.3 MODELLING PURPOSES
2.4 MODELING AND LOGGING
2.5 APPROACHES FOR AUDIT TRAIL ANALYSIS
2.5.1 Fraud in administrative ERP systems
2.5.2 Rule-based system for universal audit trail analysis
2.6 DOMAIN OF MORTGAGES
2.6.1 Organization
2.6.2 Process
3 DATA WAREHOUSE ARCHITECTURES
3.1 APPROACH
3.2 NORMALIZED DATABASE
3.3 OLAP
3.4 FLUIDDB
3.5 INFOBRIGHT
3.5.1 Layers
3.5.2 Data Manipulation Language
3.5.3 Example of query handling
3.6 ARCHITECTURE COMPARISON
3.7 CONCLUSION
4 DATA WAREHOUSE DESIGN
4.1 APPROACH
4.2 AUDIT TRAIL LOG ANALYSIS
4.3 DATA WAREHOUSE CONVERSION
4.3.1 Conversion rules and exceptions
4.3.2 Data warehouse schema
4.4 TEST CONVERSION RESULTS
4.5 DISCUSSION
4.6 CONCLUSION
5 AUDIT TRAIL QUESTION MODEL
5.1 APPROACH
5.2 GENERIC MODEL
5.3 POSSIBLE AUDIT TRAIL QUESTIONS
5.4 QUESTION LANGUAGE
5.5 LABELING
5.6 QUESTION META MODEL
5.7 CONCLUSION
6 AUDIT TRAIL ARCHITECTURE
6.1 ARCHITECTURE
6.2 QUESTION PARSER
6.3 LABELBASE
6.4 LABEL RESOLVER
6.5 DATABASE LAYER
6.6 POST PROCESSING LAYER
6.7 POSSIBILITIES AND LIMITATIONS BEYOND REQUIREMENTS
6.8 CONCLUSION
7 PROTOTYPE
7.1 APPROACH
7.2 REQUIREMENTS
7.3 DESIGN
7.4 IMPLEMENTATION…
Towards a generic model for audit trails downloads
Source: University of Twente
Download URL 2: Visit Now