Fall 2011 Quarterly Meeting
When: October 27th, 2011 8:30a.m-3:45p.m
Where: Macmillan Auditorium located at 9320 Excelsior Blvd, Hopkins, MN 55343.
| 8:30 - 9:00 | Registration and Networking |
| 9:00 - 9:45 | Welcoming Remarks - Seth Miller, Lelanie Moll, Matt Kalal |
| 9:45 - 10:45 | Brent Hames - Signo Inc., "OBIEE Performance Tuning" |
|
Abstract: Brent will discuss OBIEE Performance Tuning. His suggested technique to consistently achieve peak dashboard performance is to leverage OBIEE aggregate aware functionality. Trying to maximize performance with indexes, hints, and partitioning can be hit or miss given the limitless amounts of user input variations with OBIEE. Segregated IT environments make performance tuning across OS, disk subsystems, and databases virtually impossible. Implementing aggregated tables (or materialized views) and OBIEE aggregate aware functionality reduces the need for advanced performance tuning simply by reducing the quantity of data being queried (i.e. less physical I/O). Aggregate tables also traditionally offer the benefit of consistent load times for predictable batch scheduling windows. Brent will present some examples from his work experience to prove the effectiveness of this technique. ONYX Training Company (www.onyxtraining.com) is pleased to present Brent Hames of Signo Inc. (www.signoinc.net). Brent is independent contractor specializing in custom Oracle Business Intelligence (OBIEE) implementations. He is also a great communicator and excellent instructor for OBIEE classes that ONYX offers. He has worked extensively across UDB, Oracle, SQL Server, and Sybase database platforms as a developer and administrator. He has 17 years of experience working in Information Technology at premier companies in the Twin Cities. Please see our public schedule for public OBIEE classes. http://www.onyxtraining.com/public/
|
|
| 10:45 - 11:00 | Break |
| 11:00 - 12:00 | Gary Hanson - Traust Consulting, "Simplifying Best Practices into BI Development" |
|
Abstract: This presentation will dive into how best practices, simplified, will support and serve BI development efforts by taking you through several actual ‘real world’ experiences and lessons learned. First, a definition is provided describing the term best practices as it relates to DW/BI development and then, highlight a number of key Best Practices. Next, the presentation will illustrate several actual experiences reflecting how these best practices support the development of analytic solutions.
|
|
| 12:00 - 1:00 | Lunch |
| 1:00 - 2:00 | Terry Koch - Oracle, "How to get the best out of your Advanced Compression Investment" |
|
Abstract: Even with Storage being considered as “cheap”, I/O Operations in the database is the most expensive operation in a Data Warehouse environment. Oracle Advanced Compression can not only reduce your storage requirements, but also boost performance. Terry will share tips on how to optimize your deployment and pitfalls to avoid.
|
|
| 2:00 - 2:15 | Break |
| 2:15 - 2:45 | Brock Frank - Oracle, "Hybrid Columnar Compression" |
|
Abstract: Traditionally, data has been organized within a database block in a ‘row’ format, where all column data for a particular row is stored sequentially within a single database block. An alternative approach is to store data in a ‘columnar’ format, where data is organized and stored by column. Oracle’s Hybrid Columnar Compression (HCC) utilizes a combination of both row and columnar methods for storing data. This hybrid approach achieves the compression benefits of columnar storage, while avoiding the performance shortfalls of a pure columnar format. |
|
| 2:45-3:45 | Ravi Ananthanarayana - Rolta/TUSC, "Rule Based Data Reconciliation" |
|
Abstract: RBDR is an approach using PL/SQL/non-conforming dimensional model for data warehousing.
|
Our Resources
