5. A Case Study of ETL for Operational Risks

  1. Ron S. Kenett PhD, BSc Chairman CEO Research Professor Professor Associate Director Editor in Chief President2,3 and
  2. Yossi Raanan PhD, BSc Senior Consultant Strategic Partner Senior Lecturer former dean head chairman director4,5
  1. Valerio Grossi PhD Research Associate and
  2. Andrea Romei PhD Research Associate member

Published Online: 19 AUG 2010

DOI: 10.1002/9780470972571.ch5

Operational Risk Management

Operational Risk Management

How to Cite

Grossi, V. and Romei, A. (2010) A Case Study of ETL for Operational Risks, in Operational Risk Management (eds R. S. Kenett and Y. Raanan), John Wiley & Sons, Ltd, Chichester, UK. doi: 10.1002/9780470972571.ch5

Editor Information

  1. 2

    KPA Ltd, Raanana, Israel; University of Turin, Italy

  2. 3

    NYU-Poly, Center for Risk Engineering, New York, USA

  3. 4

    KPA Ltd, Raanana, Israel

  4. 5

    College of Management, Academic Studies, Rishon Lezion, Israel

Author Information

  1. Department of Computer Science, University of Pisa, Italy

Publication History

  1. Published Online: 19 AUG 2010
  2. Published Print: 22 OCT 2010

ISBN Information

Print ISBN: 9780470747483

Online ISBN: 9780470972571



  • extract, transform and load (ETL);
  • MUSING architecture;
  • operational risk;
  • virtual network operator (VNO)


This chapter presents an application of typical extract, transform and load (ETL) processes used to carry out the analysis of causes of failure by merging the data available from different and heterogeneous sources. It provides an overview of the current state of the art in ETL techniques and includes a brief description of Pentaho, an open source ETL suite adopted in the case study. The chapter describes the scenario of the application, its integration in the MUSING architecture, as well as a detailed description of the data sources available and the data merging flow. It presents several relevant issues of data merging and presents the main ETL tasks related to the data merging case study from a physical point of view. The chapter discusses an application of typical ETL processes to perform operational risk analysis by means of a case study in the context of a virtual network operator (VNO).

Controlled Vocabulary Terms

operational risk