[DB Seminar, Fri 9/30 1:10pm, 380 Soda Hall]

----- Forwarded message from Boon Thau Loo <boonloo(at)gmail(dot)com> -----

From: Boon Thau Loo <boonloo(at)gmail(dot)com>
Reply-To: Boon Thau Loo <boonloo(at)gmail(dot)com>
To: dblunch(at)triplerock(dot)CS(dot)Berkeley(dot)EDU
Subject: DB Seminar, Fri 9/30 1:10pm, 380 Soda Hall

Friday, Sept 30, 2005
380 Soda Hall
1:10-2:30 pm

Title: Modeling and Querying Multidimensional Data Sources in Siebel Analytics:
A Federated Relational System
Speaker: Kazi Zaman and Donovan Schneider (Siebel)

Abstract:
Large organizations have a multitude of data sources across the enterprise and
want to obtain business value from all of them. While the majority of these
data sources may be consolidated in an enterprise data warehouse, many business
units have their own data marts where analysis is carried out against data
stored in multidimensional data structures. It is often critical to pose
queries which span both these sources. This is a challenge since these sources
have differing models and query languages (SQL vs MDX). The Siebel Analytics
Server enables this requirement to be fulfilled. In this talk, we describe how
the multidimensional metadata is modeled relationally within Siebel Analytics,
efficient SQL to MDX translation algorithms and the conversion protocols
required to convert a multidimensional result into a relational rowset.


Bios:

Dr. Kazi A. Zaman is a Staff Engineer at Siebel Systems, San Mateo. He received
his bachelors degree in Computer Science & Engineering from IIT Kharagpur in
1995 and subsequently completed his Ph.D. in Computer Science at Columbia
University in 2001. He worked at nQuire, a startup in the area of Business
Intelligence, prior to its acquisition by Siebel Systems. His research
interests are in the areas of query optimization, business intelligence and
analytics, data warehousing and multidimensional databases.

Dr. Donovan A. Schneider is a Senior Architect at Siebel Systems with
responsibility for query optimization, compilation and execution. He received a
Ph.D. in Computer Science from University of Wisconsin-Madison in 1990. After
working at HP-Labs doing industrial research, he joined Red Brick Systems which
was a pioneer in data warehousing. He then joined nQuire Software which was a
startup in the area of Business Intelligence. Siebel Systems acquired nQuire in
2001.

----- End forwarded message -----