| Presentation Title: | Deploying a Dimensional Model on the Oracle Database |
| Speaker: | Mr Stewart Bryson |
| Company: | Rittman Mead Consulting |
| Co-presenter: | |
| Presentation abstract: | So you've been working with the Oracle Database for a while, but now the BI team wants to deploy a new dimensional model for enterprise reporting. While the logical design will determine a portion of the success of the data warehouse, the physical implementation of this model on Oracle may seem confusing to DBA's with little or no experience with a dimensional model. This presentation will address the differences in dimension tables and fact tables, and how those differences affect the proper physical properties of the tables, including: table organization, partitioning, compression, indexing, star transformation, and summary management. |
| Presentation begins: | 04/12/2008 13:00 |
| Presentation duration: | 45 |
| Presentation content level: | 3 (1 = indepth, 5 = strategic overview) |
| Audience experience: | Experienced (2-3 years) |
| Audience function: | DBA's, Designers, Developers |
| Speaker biography: | Stewart Bryson is Founder & President of Transcendent Data, a products and services company headquartered in Atlanta, GA in the US, as well as an Associate Consultant with Rittman Mead Consulting in the UK. Mr. Bryson has 13 years of experience designing, building and supporting complex database systems and data warehouses. His strengths include the Oracle Database and the entire Oracle BI stack, as well as dimensional modeling, ETL development and complete data warehouse delivery. |
| Related topics: | Business Intelligence: Technical/DW and OLAP |
| Hall: | 10a |
