You are here:
- > Talk 2: Dr. Kurt Stockinger
"Can SODA (Search over DAta Warehouse) Quench the Thirst of Business Analysts?"
One of the main assets of a bank is data. The ability to search through large piles thereof was particularly challenged in September 2008 when the crash of the US investment bank Lehman Brothers caused a worldwide crisis. In order to reduce the damage, banks around the globe had to act quickly and identify which customers had investment products related to Lehman Brothers. This required close collaboration between IT and business departments to dig into terabyte to petabyte-scale data warehouses to find the respective customers and investment products.
A short coming of most modern enterprise data warehouses is that they are typically very complex and only highly specialized IT experts manage to sieve through the data flood. In this talk we present a prototype system called SODA (Search over DAta Warehouse) that enables non-tech savvy business analysts to explore the data without in-depth IT knowledge in an intuitive and easy way. Our system has been built as a joint research effort between Credit Suisse and ETH Zurich and combines database technology and graph theory with semantic web features. We elaborate on the design and implementation of SODA and show experimental results with both synthetic and real data. The results demonstrate that our approach works well for analyzing real data of a large financial institution with a Google-like keyword search approach.
Dr. Kurt Stockinger, Credit Suisse
Dr. Kurt Stockinger is a data warehouse (DWH) and business intelligence (BI) architect at Credit Suisse, Zurich since fall 2007. He works on designing and prototyping DWH algorithms for a terabyte-scale enterprise warehouse, data security, and DWH/BI