On Friday I finished submitting three papers for this year's UK Oracle User Group conference. In the process of trying to think of some good subjects I came up with the idea of trying to help DBAs understand what is required to support an OLAP environment. There appears to be a huge amount of information aimed at developers and designers but very little information on how to manage analytic workspaces from a DBA's perspective. The aim is look at key topics that matter on a day to day basis and my plan is to try and cover the following topics:
- What is OLAP
- Components of an OLAP data model
- OLAP APIs
- Monitoring and Tuning, Tracing and Debugging
- General Maintenance Issues
I have submitted two other papers covering OLAP/data mining (one of my pet subjects) and creating a data warehouse over the OWB repository for management reporting. These will be extensions to similar presentations I gave whilst working in the US last year. But I will be extending both topics by adding new ideas into the mix.
If you want to attend the UKOUG conference it will be held between 3-6 December at the International Convention Center, Birmingham. For more information follow this link:
If anyone has any OLAP specific DBA scripts, or general hints and tips, they would like to send me I would be most grateful and obviously full recognition will be given in the presentation and the white paper.