In Oracle9i, Oracle has separated the physical storage of data warehouse data from the logical analysis of OLAP applications. Physically, data can be stored in relational tables, or in Analytic Workspaces (multidimensional storage). Analytic Workspaces make possible all sorts of interesting business intelligence applications, such as collaborative budgeting, collaborative forecasting, predictive analysis, and modeling applications. All of this is now available within the Oracle9i database. With this new freedom comes new challenges in managing these tables and analytic workspaces. How are AWs updated? What is the best storage location for your data? When should the OLAP option be used? What are the major new capabilities in Oracle OLAP 10g and how does this affect the design of a data warehouse? We will discuss exactly that these mysterious Analytic Workspaces are. We will also present best practices and strategies pulled from a decade of experience with these analytic workspaces in their former life, as Express databases as well as multiple projects involving analytic workspaces. Attendees will see how Oracle tools such as Oracle Warehouse Builder, Oracle Enterprise Manager, Analytic Workspace Manager, and OLAP Worksheet can be used to manage the Oracle OLAP environment.
Managing Oracle OLAP — University Class Half-Day
Presented by Chris Claterbos
Browse by Year