How to Teach Regulatory Compliant Data Warehouse Engineering?

The steady increase of regulatory reporting requirements for banks increases the demand for compliant data warehouse and reporting systems. Data warehouse designers are forced to work in interdisciplinary teams consisting of accountants and legal experts in order to meet the regulatory requirements. In this paper, we present a teaching concept that simulates a realistic data warehouse development scenario in financial service industries. By applying this teaching concept, students learn how to design compliant data warehouse systems. Implicitly students experience the challenges of interdisciplinary data warehouse engineering teams and conceptual (reference) modeling. The didactical concept, which is based on learning levels, sensitizes students for the usefulness and applicability of conceptual (reference) modeling and was positively evaluated in two elective courses.

[1]  Miklos A. Vasarhelyi,et al.  Essentials of XBRL: Financial Reporting in the 21st Century , 2003 .

[2]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[3]  B. Bloom,et al.  Taxonomy of Educational Objectives. Handbook I: Cognitive Domain , 1966 .

[4]  Barry Devlin,et al.  Data Warehouse: From Architecture to Implementation , 1996 .

[5]  Vojislav B. Misic,et al.  Evaluating the Quality of Reference Models , 2000, ER.

[6]  Matteo Golfarelli,et al.  The Dimensional Fact Model: A Conceptual Model for Data Warehouses , 1998, Int. J. Cooperative Inf. Syst..

[7]  Herbert H. Clark,et al.  Grounding in communication , 1991, Perspectives on socially shared cognition.

[8]  Paul McNamara,et al.  Deontic logic , 2006, Logic and the Modalities in the Twentieth Century.

[9]  Sjaak Brinkkemper,et al.  Meta-Modelling Based Assembly Techniques for Situational Method Engineering , 1999, Inf. Syst..

[10]  Ron Weber,et al.  Research Commentary: Information Systems and Conceptual Modeling - A Research Agenda , 2002, Inf. Syst. Res..

[11]  Barbara Dinter,et al.  Extending the E/R Model for the Multidimensional Paradigm , 1998, ER Workshops.

[12]  Edward A. Boyno.  Extraction, Transformation, and Loading in a Data Warehouse Course , 2003 .

[13]  Peter Loos,et al.  Classification of reference models: a methodology and its application , 2003, Inf. Syst. E Bus. Manag..

[14]  Ralph Kimball,et al.  The Data Warehouse Lifecycle Toolkit , 2009 .

[15]  W. H. Inmon,et al.  Building the data warehouse (2nd ed.) , 1996 .

[16]  Benjamin S. Bloom,et al.  Taxonomy of Educational Objectives: The Classification of Educational Goals. , 1957 .

[17]  Keng Siau,et al.  Evaluation techniques for systems analysis and design modelling methods – a review and comparative analysis , 2011, Inf. Syst. J..

[18]  Ralf Knackstedt,et al.  The Legal Perspective on Business to Government Reporting -- A Conceptual Modeling Approach and Its Application in the Financial Sector , 2012, 2012 45th Hawaii International Conference on System Sciences.

[19]  Mohammad Dadashzadeh.  Teaching Tip: Recursive Joins to Query Data Hierarchies in Microsoft Access , 2007, J. Inf. Syst. Educ..

[20]  Paul Gray,et al.  Teradata University Network: A No Cost Web-Portal for Teaching Database, Data Warehousing, and Data-Related Subjects , 2008, J. Inf. Syst. Educ..