ORACLE DEVELOPERS FORUM:<br>ORACLE DEVELOPERS FORUM

by Mikael Leif Angberg, Eric Grancher (CERN)

Monday 15 Oct 2001, 10:00 → 11:30 Europe/Zurich

IT Auditorium (CERN)

10:00 Building a financial data warehouse with Oracle - Michael Leif Angberg - AS/IDS Within the CERN organization there are almost 1000 budget holders, located at CERN as well as at any of the 500 institutes around the world that CERN collaborates with. In order to develop a financial decision support system for this type of community one must of course take into account a vast range of requirements, but they can be accurately summarized with the following 3 words: - Versatility - Speed - Availability An application meeting these requirements is currently being developed at CERN, using Data Warehousing concepts offered by Oracle, as well as Oracles J2EE platform. The building of the data warehouse, optimized for analytical querying, makes use of Materialized Views, Partitioned tables and adapted Query Rewrite to achieve a high level of versatility on the database side. The business logic/middle tier is implemented using a framework similar to the component-like EJB specification. (This presentation is part of EOUG 2001 conference) 10:45 - Coffee break 11:00 - Oracle Servers Configuration Update - Eric Grancher - IT/DB

Organiser(s): Pedro Martel / EST Division

more information more information