Articles & Content

Archives

F19 - SQL Performance for a Big Data 22 Billion row data warehouse

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2015



This presentation discusses the design, architecture, performance and complex SQL issues building and reporting within a big data analytics DW system. You will learn through this presentation 30 SQL tuning tips, the real life issues, agile SQL considerations and SQL design solutions for building a data warehouse of 22+ billion rows in six months.

This presentation will help you understand techniques to design and leveraging new SQL techniques for your big data business issues. Also the agile development processes will be detailed showing you how to uncovered complex analytics requirements and design SQL common table expressions CTE and other SQL techniques early in the development cycle. This presentation will help you understand all these SQL experiences that took processes from 37 hours to seconds so you can create a successful big data design and SQL analytic architecture.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.