Loading…
Back To Schedule
Thursday, October 7 • 4:00pm - 5:00pm
Speed Dating with a Date Dimension Table

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Are your apps killing CPU time doing DATE processing? A recent customer benchmark shared with us took a 20 second routine down to milliseconds through the date dimension table technique. The date dimension table also provides huge benefits to reporting/dashboarding applications that heavily use dates for prompts, date ranges, date calculations, and other date attributes. Simplify and speed up date processing with the date dimension table!

Learning Objectives:
1. How to simply work with problematic legacy date fields_x000D_ 2. Learn about methods to extend/enhance your applications and reports with additional date attributes._x000D_ 3. Add weather information, seasons, or moon phases to your data!

Speakers
avatar for Doug Mack

Doug Mack

Consultant LAB Services, IBM
Doug Mack is a DB2 for i Analytics Consultant in IBM’s Power Systems Lab Services organization, employed by IBM in the United States. Doug currently leads the Analytics team for the DB2 for i Lab Services team delivering Query/400 modernization, DB2 Web Query, Data Warehouse design... Read More →


Thursday October 7, 2021 4:00pm - 5:00pm CDT
Breakout 3 Online
  Database
  • Session Level All