CERN Computing Seminar

The Data Warehouse Challenge at Credit Suisse - Prepared for the Next Lehman Case?

by Dr Kurt Stockinger (Credit Suisse)

Europe/Zurich
IT Auditorium (CERN)

IT Auditorium

CERN

Description

One of the most essential items of a bank is data - it should be stored securely and should never be lost. This data contains information about customers (private and corporate), banking products (such as options, futures and derivatives), stock information, trading information as well as market research data. The amount of data that is stored in Credit Suisse's enterprise data warehouse is close to 0.5 petabytes.

In this talk the speaker will explain two different strategies of how Credit Suisse handles these challenges, namely via a high availability architecture and via semantic data warehouse search. The first half of the talk shows results from a detailed proof of concept based on the new features of Oracle 11g Active Data Guard to replicate data between two distributed data centers along Lake Zurich. The second half of the talk focuses on a joint research project with ETH Zurich where we combine technologies from three areas (databases, search and semantic web) to tackle the Lehman Case, i.e. to quickly identify all bank products related to the crashed Lehman investment bank. The main goal of this research project is to enable intuitive, self-service business intelligence (BI) for business analysts to explore a multi-terabyte enterprise warehouse without requiring in-depth IT knowledge.

About the speaker

Dr. Kurt Stockinger is a data warehouse (DWH) architect at Credit Suisse, Zurich since fall 2007. He currently works on designing and prototyping DWH algorithms for a terabyte-scale enterprise warehouse with focus on (bi-) temporal database techniques. Prior to joining Credit Suisse, Kurt worked for 4 years at Berkeley Lab, University of California performing research on multi-dimensional indexing and query methods for large-scale scientific data as well as high-performance visual analytics (query-driven visualization on modern supercomputers). From 2000 to 2002 Kurt was heading the Replica Optimization Team of the EU Data Grid Project at CERN. In 2008 he received an R&D 100 Technology Award together with three colleagues from Berkeley Lab for his research on FastBit – a multi-dimensional bitmap index engine that was applied for query acceleration in the areas of high-energy physics, astrophysics, and combustion simulation as well as computer network traffic analysis.


Organised by: F.Donno and Miguel Angel Marquina - IT Department
CERN Computing Seminars and Colloquia

More information