F07 - Data Warehouse Designs for Big Data Performance

Session Number: 169
Track: Big Data and Analytics
Session Type: Podium Presentation
Primary Presenter: Dave Beulke [President - Dave Beulke and Associates]
Time: May 01, 2013 (02:15 PM - 03:15 PM)
Room: Bonaire 5&6

Speaker Bio: David Beulke is an internationally recognized consultant, author and teacher. He is known for his strategic expertise in database performance, data warehouses and internet applications. He provides data management strategies, architectures, advanced designs and systems consulting. He is currently a member of the IBM DB2 Gold Consultant program, an IBM Information Champion, co-author of past IBM z/OS DB2 DBA Certification and Business Intelligence Certification exams, past president of the International DB2 Users Group (IDUG), former columnist for DB2 Magazine former instructor for The Data Warehouse Institute (TDWI) and writes a weekly blog at www.davebeulke.com. Dave helps his clients improve their strategic direction, designs innovative solutions, dramatically improves performance and reduces CPU demand saving clients millions within their mainframe, UNIX and Windows environments.
Audience experience level: Intermediate
Presentation Category: Data Warehousing and Business Intelligence
Presentation Platform: Cross Platform
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, Systems Programmers, IT Managers
Technical areas this presentation will apply to: Data Warehousing and Business Intelligence, Database Performance (DB2 for LUW), Database Performance (DB2 for z/OS)
Objective 1: Billions is Big Data how to handle it.
Objective 2: Designs for Petabyte Tables
Objective 3: MQTs Union All Views and other big data techniques
Objective 4: Monitoring and Maintenance Efficiency
Objective 5: Total Performance considerations - Learn the performance considerations for building high performance SQL access paths and overall data processing efficiency.

Abstract:  Data Warehouse Designs for Performance presents the design architectures, performance implications and advanced temporal topics experienced building a state of the art 22+ billion row data warehouse and business intelligence system. Learn how to design your DW and BI architecture on any of the DB2 platforms, z/OS, LUW or DPF and understand the infrastructure considerations for maximum effectiveness, performance and overall return on investment.
This presentation highlights the Big Data and predictive analytics considerations that have forced DW and BI strategies to evolve. Through this presentation, you will learn about the best performing architectures, the advanced design options, the latest techniques for maximizing performance and getting the fastest return-on-investment from your data warehouse and business intelligence solution.

More Information: http://www.davebeulke.com